getTransactionStatus

Syntax

getTransactionStatus()

Arguments

None

Details

Get the status of transactions. Return a table containing the following columns:

  • tid: The transaction ID.

  • startTime: The time when the transaction started.

  • type: The type of operations involved in the transaction, including APPEND, DROP, SQLUPDATE, SQLUPSERT, SQLDELETE, FILEOPERATE, or UNKNOWN.

  • status: The transaction status. It can be BEGIN, COMMIT, COMPLETE, or ROLLBACK.

  • partitionCount: The number of partitions involved in the transaction.

  • endTime: The time when the transaction ended.

  • elapsedTime: The elapsed time of the transaction.

Examples

getTransactionStatus()
tid startTime type status partitionCount endTime elapsedTime
3135 2022.06.07 16:19:48.477 APPEND BEGIN 4 584
3143 2022.06.07 16:11:27.489 APPEND COMMIT 4 2022.06.07 16:11:33.100 484