SHOW TRANSACTION

    grammar:

    Example return result:

    • TransactionId: transaction id
    • Label: the label of the corresponding load job
    • TransactionStatus: transaction status * PREPARE: preparation stage * COMMITTED: The transaction was successful, but the data is not visible * VISIBLE: The transaction was successful and the data is visible * ABORTED: transaction failed
    • LoadJobSourceType: The type of the load job.
    • PrepareTime: transaction start time
    • CommitTime: the time when the transaction was successfully committed
    • FinishTime: The time when the data is visible
    • ErrorReplicasCount: Number of replicas with errors
    • ListenerId: the id of the related load job
    • TimeoutMs: transaction timeout time in milliseconds

    1. SHOW TRANSACTION WHERE ID = 4005;

    2. Specify the db and view the transaction with id 4005: