[HIVE-10483] insert overwrite partition deadlocks on itself with DbTxnManager

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: Query Planning, Query Processor, Transactions
• Assignee: Eugene Koifman
• Reporter: Eugene Koifman
• Created: 24/Apr/15 20:54
• Updated: 01/Oct/19 22:07
• Resolved: 29/Apr/15 03:13

Description

insert overwrite table ta partition(part=xxxx) select xxx from tb join ta where part=xxxx

It seems like the Shared conflicts with the Exclusive lock for Insert Overwrite even though both are part of the same txn.
More precisely insert overwrite requires X lock on partition and the read side needs an S lock on the query.

A simpler case is
insert overwrite table ta partition(part=xxxx) select * from ta

Issue Links

• is duplicated by: HIVE-7483 hive insert overwrite table select from self dead lock
• is related to: HIVE-15077 Acid LockManager is unfair