[HIVE-18750] Exchange partition should be disabled on ACID/Insert-only tables with per table write ID.

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: HiveServer2, Transactions
• Labels: ACID DDL TODOC3.0 pull-request-available
• Assignee: Sankar Hariappan
• Reporter: Sankar Hariappan
• Created: 20/Feb/18 08:48
• Updated: 11/Jul/18 23:10
• Resolved: 01/Mar/18 05:26

Description

Per table write id implementation (HIVE-18192) have introduced write ID per table and used write ID to name the delta/base files and also as primary key for each row.

Now, exchange partition have to move delta/base files across tables without changing the write ID which causes incorrect results. 

Also, this exchange partition feature is there to support the use-case of atomic updates. But with ACID updates, we shall support atomic-updates and hence it makes sense to not support exchange partition for ACID and MM tables.

The qtest file mm_exchangepartition.q test results to be updated after this change.

Issue Links

• is related to: HIVE-18192 Introduce WriteID per table rather than using global transaction ID
• supercedes: HIVE-18132 Acid Table: Exchange Partition
• links to: GitHub Pull Request #314