[HIVE-18748] Rename table impacts the ACID behavior as table names are not updated in meta-tables.

• Type: Sub-task
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.1.0
• Component/s: HiveServer2, Transactions
• Labels: ACID DDL
• Target Version/s: 3.1.0
• Assignee: Eugene Koifman
• Reporter: Sankar Hariappan
• Created: 20/Feb/18 08:32
• Updated: 31/Jul/18 01:32
• Resolved: 29/May/18 17:48

Description

ACID implementation uses metatables such as TXN_COMPONENTS, COMPLETED_TXN_COMPONENTS, COMPACTION_QUEUE, COMPLETED_COMPCTION_QUEUE etc to manage ACID operations.

Per table write ID implementation (HIVE-18192) introduces couple of metatables such as NEXT_WRITE_ID and TXN_TO_WRITE_ID to manage write ids allocated per table.

Now, when we rename any tables, it is necessary to update the corresponding table names in these metatables as well. Otherwise, ACID table operations won't work properly.

Since, this change is significant and have other side-effects, we propose to disable rename tables on ACID tables until a fix is figured out.

Issue Links

• duplicates: HIVE-19122 Transactional tables can't handle 'rename' table
• is related to: HIVE-18192 Introduce WriteID per table rather than using global transaction ID
• is related to: HIVE-19735 Transactional table: rename partition
• relates to: HIVE-19688 Make catalogs updatable
• relates to: HIVE-19569 alter table db1.t1 rename db2.t2 generates MetaStoreEventListener.onDropTable()
• links to: RB