Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Content Zone
maxLevel4
locationtop
typelist

Abort Transactions

Info
titleVersion information

As of Hive 2.1.

Code Block
ABORT TRANSACTIONS TransactionID [, ...];

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

Code Block
languagesql
titleExamples:
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 to be cleaned up.

...

 

 

 

 

 

 

 

 

 

Save

Save