You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Taraka Rama Rao Lethavadla (Jira)" <ji...@apache.org> on 2025/11/13 07:01:00 UTC

[jira] [Updated] (HIVE-29313) Update documentation about displaying txn id in show processlist

     [ https://issues.apache.org/jira/browse/HIVE-29313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Taraka Rama Rao Lethavadla updated HIVE-29313:
----------------------------------------------
    Description: 
New output from show processlist would look like
{noformat}
+------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+---------+--------------------------+-------------------+---------------+
| User Name  |  Ip Addr   | Execution Engine  |              Session Id               | Session Active Time (s)  | Session Idle Time (s)  |                      Query ID                      |  State   | Txn ID  |   Opened Timestamp (s)   | Elapsed Time (s)  |  Runtime (s)  |
+------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+---------+--------------------------+-------------------+---------------+
| anonymous  | 127.0.0.1  | tez               | fb33f25e-bc8f-42f4-9ed2-28ca3ea55806  | 3                        | 1                      | tarak_20251113120712_e9a91156-c8fa-401d-9ab9-b44444c6768d | RUNNING  | 527     | 2025-11-13 12:07:12.571  | 1                 | Not finished  |
| anonymous  | 127.0.0.1  | tez               | 24c029d3-cfa3-43ae-966c-a262b3f0d323  | 3                        | 1                      | tarak_20251113120712_ff6524ff-2e12-4d36-803a-e1425ec18e60 | RUNNING  | 528     | 2025-11-13 12:07:12.579  | 1                 | Not finished  |
+------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+---------+--------------------------+-------------------+---------------+{noformat}

  was:
New output from show processlist would look like
{noformat}
+------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+---------+--------------------------+-------------------+---------------+| User Name  |  Ip Addr   | Execution Engine  |              Session Id               | Session Active Time (s)  | Session Idle Time (s)  |                      Query ID                      |  State   | Txn ID  |   Opened Timestamp (s)   | Elapsed Time (s)  |  Runtime (s)  |+------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+---------+--------------------------+-------------------+---------------+| anonymous  | 127.0.0.1  | tez               | fb33f25e-bc8f-42f4-9ed2-28ca3ea55806  | 3                        | 1                      | tarak_20251113120712_e9a91156-c8fa-401d-9ab9-b44444c6768d | RUNNING  | 527     | 2025-11-13 12:07:12.571  | 1                 | Not finished  || anonymous  | 127.0.0.1  | tez               | 24c029d3-cfa3-43ae-966c-a262b3f0d323  | 3                        | 1                      | tarak_20251113120712_ff6524ff-2e12-4d36-803a-e1425ec18e60 | RUNNING  | 528     | 2025-11-13 12:07:12.579  | 1                 | Not finished  |+------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+---------+--------------------------+-------------------+---------------+{noformat}


> Update documentation about displaying txn id in show processlist
> ----------------------------------------------------------------
>
>                 Key: HIVE-29313
>                 URL: https://issues.apache.org/jira/browse/HIVE-29313
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Taraka Rama Rao Lethavadla
>            Assignee: Taraka Rama Rao Lethavadla
>            Priority: Major
>
> New output from show processlist would look like
> {noformat}
> +------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+---------+--------------------------+-------------------+---------------+
> | User Name  |  Ip Addr   | Execution Engine  |              Session Id               | Session Active Time (s)  | Session Idle Time (s)  |                      Query ID                      |  State   | Txn ID  |   Opened Timestamp (s)   | Elapsed Time (s)  |  Runtime (s)  |
> +------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+---------+--------------------------+-------------------+---------------+
> | anonymous  | 127.0.0.1  | tez               | fb33f25e-bc8f-42f4-9ed2-28ca3ea55806  | 3                        | 1                      | tarak_20251113120712_e9a91156-c8fa-401d-9ab9-b44444c6768d | RUNNING  | 527     | 2025-11-13 12:07:12.571  | 1                 | Not finished  |
> | anonymous  | 127.0.0.1  | tez               | 24c029d3-cfa3-43ae-966c-a262b3f0d323  | 3                        | 1                      | tarak_20251113120712_ff6524ff-2e12-4d36-803a-e1425ec18e60 | RUNNING  | 528     | 2025-11-13 12:07:12.579  | 1                 | Not finished  |
> +------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+---------+--------------------------+-------------------+---------------+{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)