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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Assignee: Unassigned
• Reporter: Anthony Hsu
• Created: 26/Feb/18 05:36
• Updated: 28/Feb/18 19:34

Description

While investigating HIVE-18695, I noticed incorrect results returned by the following Accumulo query:

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;

The expected output is

1 1
2 2

but the actual output is

1  0
1  1
1  2
1  3
2  0
2  1
2  2
2  3

Issue Links

• is related to: HIVE-18695 fix TestAccumuloCliDriver.testCliDriver[accumulo_queries]
• relates to: HIVE-15680 Incorrect results when hive.optimize.index.filter=true and same ORC table is referenced twice in query