Versions Compared

Old Version 311

changes.mady.by.user Eugene Koifman

Saved on

compared with

New Version 312

changes.mady.by.user Thejas Nair

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: fix abort txn doc - supports space, not comma

...

Table of Content Zone
maxLevel4
locationtop
typelist

Abort Transactions

Info
titleVersion information

As of Hive 1.3.0 and 2.1.0 (see Hive Transactions).

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

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

Code Block
languagesql
titleExample:
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.

...