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)