hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2792) SUBSTR(CAST(<string> AS BINARY)) produces unexpected results
Date Thu, 09 Feb 2012 02:29:59 GMT

    [ https://issues.apache.org/jira/browse/HIVE-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204200#comment-13204200
] 

Carl Steinbach commented on HIVE-2792:
--------------------------------------

{noformat}
SELECT
  value,
  SUBSTR(value, 4, 5),
  SUBSTR(CAST(value AS BINARY), 4, 5)
FROM src
ORDER BY value;
...
val_0	_0	039    <-- Third column of the first three rows should be the same, right?
val_0	_0	096    
val_0	_0	073
val_10	_10	105
val_100	_100	100
val_100	_100	100
val_103	_103	103
val_103	_103	103
val_104	_104	104
val_104	_104	104
val_105	_105	105
val_11	_11	116
val_111	_111	111
val_113	_113	113
val_113	_113	113
val_114	_114	114
val_116	_116	116
val_118	_118	118
val_118	_118	118
val_119	_119	119
val_119	_119	119
val_119	_119	119
val_12	_12	124
val_12	_12	124
...
{noformat}

                
> SUBSTR(CAST(<string> AS BINARY)) produces unexpected results
> ------------------------------------------------------------
>
>                 Key: HIVE-2792
>                 URL: https://issues.apache.org/jira/browse/HIVE-2792
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>            Reporter: Carl Steinbach
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message