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

["Sergey Shelukhin (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-15680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15847891#comment-15847891 ] 

Sergey Shelukhin edited comment on HIVE-15680 at 2/1/17 2:26 AM:
-----------------------------------------------------------------

Submitted an addendum patch .04 there. You can try your patch with that patch to see if that makes tests pass here. Not sure why it triggers that path though... hopefully it doesn't somehow break projection. Although in this case it's a text table.


was (Author: sershe):
Submitted a patch there. You can try your patch with that patch to see if that makes tests pass here. Not sure why it triggers that path though... hopefully it doesn't somehow break projection. Although in this case it's a text table.

> 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
>         Attachments: HIVE-15680.1.patch, HIVE-15680.2.patch, HIVE-15680.3.patch, HIVE-15680.4.patch, HIVE-15680.5.patch, HIVE-15680.6.patch
>
>
> 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.15#6346)