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 |