[HIVE-17562] ACID 1.0 + ETL strategy should treat empty compacted files as uncovered deltas

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.0
• Fix Version/s: 2.2.1, 2.3.1, 2.4.0
• Component/s: Transactions
• Target Version/s: 2.4.0
• Assignee: Prasanth Jayachandran
• Reporter: Prasanth Jayachandran
• Created: 20/Sep/17 00:34
• Updated: 24/Oct/17 21:57
• Resolved: 27/Sep/17 19:58

Description

In branch-2, with ACID 1.0, following sequence will result in incorrect results
1) Set split strategy to ETL
2) Insert some rows
3) Delete all rows
4) Alter table compact MAJOR
5) Insert some rows
6) Select * query will not return any rows that is written at last (step 5)

The reason for that, compaction essentially voids the first insert in step 2. Now when ETL split strategy is chosen, there will not be any stripes in the base files. So no split gets generated and any subsequent deltas gets ignored.

Issue Links

• is superceded by: HIVE-17705 HIVE-17562 is returning incorrect results
• links to: RB