[HIVE-17166] Break Locks On Timeout

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2.2, 2.1.1, 3.0.0
• Component/s: HiveServer2
• Assignee: Unassigned
• Reporter: David Mollitor
• Created: 25/Jul/17 15:22
• Updated: 30/Jul/21 21:46

Description

Hive supports table and partition locks by utilizing ZooKeeper to keep track. There are several configurations related to this, including: hive.lock.sleep.between.retries and hive.lock.numretries.

I'd lile to propose a new boolean configuration that, when set, would alter the behavior of a lock timeout failure. Instead of failing the query with an error, the configuration would direct Hive to break the lock and allow the query try to obtain a new one and proceed.

This is useful in cases where locks are leaked and erroneously left behind. Such scenarios create permanent blocking on future queries. This break-lock mechanism would alleviate this issue.

Issue Links

• is related to: HIVE-14799 Query operation are not thread safe during its cancellation