[HIVE-12594] X lock on partition should not conflict with S lock on DB

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 2.1.2, 2.2.0
• Component/s: Transactions
• Target Version/s: 2.1.2, 2.2.0
• Assignee: Eugene Koifman
• Reporter: Eugene Koifman
• Created: 04/Dec/15 16:04
• Updated: 26/Jul/17 03:30
• Resolved: 05/Jan/17 21:29

Description

S lock on DB is acquired when creating a new table in that DB to make sure the DB is not dropped at the same time

This should not conflict with operations such as rebuild index which takes an Exclusive lock on a partition. See also HIVE-10242

Issue Links

• is related to: HIVE-13980 create table as select should acquire X lock on target table
• relates to: HIVE-10242 ACID: insert overwrite prevents create table command