This syntax is used to view transaction details for the specified transaction id or label.

    Example of returned result:

    2.              Label: insert_8d807d5d-bcdd-46eb-be6d-3fa87aa4952d
    3.        Coordinator: FE: 10.74.167.16
    4.  TransactionStatus: VISIBLE
    6.        PrepareTime: 2020-01-09 14:59:07
    7.         CommitTime: 2020-01-09 14:59:09
    9. ErrorReplicasCount: 0
    10.         ListenerId: -1
    11.          TimeoutMs: 300000
    • TransactionId: transaction id
    • Label: the label corresponding to the import task
    • Coordinator: The node responsible for transaction coordination
    • TransactionStatus: transaction status
      • PREPARE: preparation stage
      • COMMITTED: The transaction succeeded, but the data was not visible
      • VISIBLE: The transaction succeeded and the data is visible
      • ABORTED: Transaction failed
    • PrepareTime: transaction start time
    • CommitTime: The time when the transaction was successfully committed
    • FinishTime: The time when the data is visible
    • Reason: error message
    • ErrorReplicasCount: The number of replicas with errors
    • ListenerId: The id of the related import job
    • TimeoutMs: Transaction timeout, in milliseconds

    2. In the specified db, view the transaction with id 4005:

    1. SHOW, TRANSACTION