[HIVE-22593] Dynamically partitioned MM (insert-only ACID) tables don't compact automatically

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Target Version/s: 4.0.0
• Assignee: Karen Coppage
• Reporter: Karen Coppage
• Created: 06/Dec/19 16:24
• Updated: 17/Nov/22 08:50
• Resolved: 09/Jan/20 13:45

Description

Dynamic partitions of MM tables aren't entered into the HMS table TXN_COMPONENTS. On inserting into such tables we see this line in the HMS log:

Expected to move at least one record from txn_components to completed_txn_components when committing txn!

(This is not the case for non-partitioned MM tables.)

Since the partitions aren't entered into COMPLETED_TXN_COMPONENTS, they aren't considered for automatic compaction.

Probably the culprit is org.apache.hadoop.hive.ql.metadata.Hive#loadDynamicPartitions which has an isAcid parameter that is always false regarding MM tables, and also because MM tables' "write type" is AcidUtils.Operation.NOT_ACID and not INSERT.