[HIVE-8872] Hive view of HBase range scan intermittently returns incorrect data.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.1
• Fix Version/s: 1.1.0
• Component/s: HBase Handler
• Assignee: Yongzhi Chen
• Reporter: Yongzhi Chen
• Created: 14/Nov/14 15:32
• Updated: 21/May/15 16:54
• Resolved: 19/Nov/14 00:39

Description

This need running in cluster:
1. Create a hive external table pointing to a hbase table.
2. Create views to the hive table(for example 30 views), each view looks like following with different range check:

CREATE VIEW hview_nn AS SELECT * FROM hivehbasetable WHERE (pk >='pk_nn_0' AND pk <= pk_nn_A')

3. Create same number of hive new tables as views.
4. then runs several queries in parallel (30 threads):
INSERT OVERWRITE TABLE hivenewtable_nn SELECT * FROM hview_nn //nn is from 01 to 30
5 After insert, check the hivenewtables, some values are not right.

Issue Links

• is related to: HBASE-12492 Hive view of HBase range scan intermittently returns incorrect data
• is related to: HIVE-8897 Remove HIVE-8872 when HBASE-12492 is fixed