Abort Transactions

ABORT TRANSACTIONS TransactionIDtransactionID [, ...];

ABORT TRANSACTIONS cleans up the specified transaction ids IDs from the Hive metastore so that users do not need to interact with the metastore directly in order to remove the dangling or failed transactions. ABORT TRANSACTIONS is added in Hive 1.3.0 and 2.1.0 (HIVE-12634).

ABORT TRANSACTIONS 0000007, 0000008, 0000010, 0000015;

This command can be used together with SHOW TRANSACTIONS. The latter can help figure out the candidate transaction ids IDs to be cleaned up.