You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carl Steinbach (Commented) (JIRA)" <ji...@apache.org> on 2012/02/09 03:29:59 UTC
[jira] [Commented] (HIVE-2792) SUBSTR(CAST( AS BINARY))
produces unexpected results
[ 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