View transaction locks introduction
As a Hive administrator, you can get troubleshooting information about locks on a table, partition, or schema.
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.