Anthony Hsu created HIVE-15680: ---------------------------------- Summary: Incorrect results when hive.optimize.index.filter=true and same ORC table is referenced twice in query Key: HIVE-15680 URL: https://issues.apache.org/jira/browse/HIVE-15680 Project: Hive Issue Type: Bug Affects Versions: 1.1.0, 2.2.0 Reporter: Anthony Hsu Assignee: Anthony Hsu
To repro: {noformat} set hive.optimize.index.filter=true; create table test_table(number int) stored as ORC; -- Two insertions will create two files, with one stripe each insert into table test_table VALUES (1); insert into table test_table VALUES (2); -- This should and does return 2 records select * from test_table; -- These should and do each return 1 record select * from test_table where number = 1; select * from test_table where number = 2; -- This should return 2 records but only returns 1 record select * from test_table where number = 1 union all select * from test_table where number = 2; {noformat} What's happening is only the last predicate is being pushed down. -- This message was sent by Atlassian JIRA (v6.3.4#6332)