Managing Hive Transactions

ACID transactions create a number of locks during the course of operations. You can manage transactions and corresponding locks using a number of tools within Hive. For more info, see Hive transactions.

Note

Qubole supports Hive ACID transactions in Spark and Presto as well. Hive ACID Transactions describes the prerequisites, supported ACID features, and Hive ACID compaction that applies to all three query engines.

To check active and aborted transactions, run show transactions as illustrated below.

../../../../_images/ShowTranxn.png

To check locks that get created as a result of transactions, run show locks as illustrated below.

../../../../_images/ShowLocks.png