[
https://issues.apache.org/jira/browse/HIVE-21310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zoltan Haindrich resolved HIVE-21310.
-------------------------------------
Resolution: Duplicate
duplicate of HIVE-21316 ; testcase will be added in that ticket
> Hashcode of a varchar column is incorrect if its folded
> -------------------------------------------------------
>
> Key: HIVE-21310
> URL: https://issues.apache.org/jira/browse/HIVE-21310
> Project: Hive
> Issue Type: Bug
> Reporter: Zoltan Haindrich
> Priority: Major
>
> {code:sql}
> create table t (a varchar(10));
> insert into t values('bee'),('xxx');
> -- select t0.v,t1.v from
> select assert_true(t0.v = t1.v) from
> (select hash(a) as v from t where a='bee') as t0
> join (select hash(a) as v from t where a='bee' or a='xbee') as t1 on
> (true);
> {code}
> the assertion fails because: {{97410 != 127201}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
