hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15680) Incorrect results when hive.optimize.index.filter=true and same ORC table is referenced twice in query
Date Wed, 01 Feb 2017 02:26:51 GMT

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

Sergey Shelukhin commented on HIVE-15680:
-----------------------------------------

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)

Mime
View raw message