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 | 
