Zoltan Haindrich created HIVE-21310:
---------------------------------------

             Summary: 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



{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)

Reply via email to