[jira] [Commented] (HIVE-18802) Incorrect results when referencing same Accumulo table multiple times in one query

["Zoltan Haindrich (JIRA)" <ji...@apache.org>]

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

Zoltan Haindrich commented on HIVE-18802:
-----------------------------------------

HIVE-18695 disabled ppd for {{accumulo-handler/src/test/queries/positive/accumulo_queries.q}}, I think this ticket will fix the problem behind that :)

> Incorrect results when referencing same Accumulo table multiple times in one query
> ----------------------------------------------------------------------------------
>
>                 Key: HIVE-18802
>                 URL: https://issues.apache.org/jira/browse/HIVE-18802
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.0.0
>            Reporter: Anthony Hsu
>            Priority: Major
>
> While investigating HIVE-18695, I noticed incorrect results returned by the following Accumulo query:
> {code:java}
> DROP TABLE accumulo_test;
> CREATE TABLE accumulo_test(key int, value int)
> STORED BY 'org.apache.hadoop.hive.accumulo.AccumuloStorageHandler'
> WITH SERDEPROPERTIES ("accumulo.columns.mapping" = ":rowID,cf:string")
> TBLPROPERTIES ("accumulo.table.name" = "accumulo_table_0");
> INSERT OVERWRITE TABLE accumulo_test VALUES (0,0), (1,1), (2,2), (3,3);
> SELECT * from accumulo_test where key == 1 union all select * from accumulo_test where key == 2;{code}
> The expected output is
> {code:java}
> 1 1
> 2 2{code}
> but the actual output is
> {code:java}
> 1  0
> 1  1
> 1  2
> 1  3
> 2  0
> 2  1
> 2  2
> 2  3
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)