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
You can obtain information about locks by running SHOW LOCKS SCHEMA unless ZooKeeper
or in-memory lock managers are used.
