View transaction locks introduction

As a Hive administrator, you can get troubleshooting information about locks on a table, partition, or schema.

Hive transactions, enabled by default, disables Zookeeper locking. DbLockManager stores and manages all transaction lock information in the Hive Metastore. Heartbeats are sent regularly from lock holders and transaction initiators to the Hive Metastore to prevent stale locks and transactions. The lock or transaction is aborted if the metastore does not receive a heartbeat within the amount of time specified by the hive.txn.timeout configuration property.

Getting information about locks

Generally, can obtain information about locks by running SHOW LOCKS SCHEMA.Exception: SHOW LOCKS SCHEMA cannot be used with ZooKeeper or in-memory lock managers.