[jira] [Created] (HIVE-15680) Incorrect results when hive.optimize.index.filter=true and same ORC table is referenced twice in query

["Anthony Hsu (JIRA)" <ji...@apache.org>]

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)