Namit Jain created HIVE-4149: -------------------------------- Summary: wrong results big outer joins with array of ints Key: HIVE-4149 URL: https://issues.apache.org/jira/browse/HIVE-4149 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Attachments: hive.4149.1.patch
Consider the following query: create table tinyA(a bigint, b bigint) stored as textfile; create table tinyB(a bigint, bList array<int>) stored as textfile; load data local inpath '../data/files/tiny_a' into table tinyA; load data local inpath '../data/files/tiny_b' into table tinyB; select * from tinyA; select * from tinyB; select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a; The results are wrong -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira