Anthony Hsu created HIVE-18802:
----------------------------------

             Summary: 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


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)

Reply via email to