[jira] [Commented] (HIVE-8488) hash() doesn't match between string and char/varchar

["Jason Dere (JIRA)" <ji...@apache.org>]

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

Jason Dere commented on HIVE-8488:
----------------------------------

hash() uses ObjectInspectorUtils.hashCode(), which has special case handling for Text so that the hashcode matches String.hashCode(). This special case handling should have been done for char/varchar as well.
Note that fixing this will break existing behavior of hash() for char/varchar.

> hash() doesn't match between string and char/varchar
> ----------------------------------------------------
>
>                 Key: HIVE-8488
>                 URL: https://issues.apache.org/jira/browse/HIVE-8488
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>            Reporter: Jason Dere
>            Assignee: Jason Dere
>
> {noformat}
> hive> select * from tab1;
> OK
> val_484	val_484	val_484
> hive> select hash(c1), hash(c2), hash(c3) from tab1;
> OK
> 230901778	1973712113	1973712113
> {noformat}
> This may throw off users expecting string/varchar/char types to be fairly interchangeable.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)