[
https://issues.apache.org/jira/browse/HIVE-29254?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shohei Okumiya resolved HIVE-29254.
-----------------------------------
Fix Version/s: 4.3.0
Resolution: Fixed
Merged. [~tarak271] Thanks for your contribution!
https://github.com/apache/hive/pull/6141
> Display TxnId associated with the query in show processlist command
> -------------------------------------------------------------------
>
> Key: HIVE-29254
> URL: https://issues.apache.org/jira/browse/HIVE-29254
> Project: Hive
> Issue Type: Improvement
> Reporter: Taraka Rama Rao Lethavadla
> Assignee: Taraka Rama Rao Lethavadla
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.3.0
>
>
> Today we don't have a way to identify the query id along with the associated
> txn id.
> Show transactions provide
> {noformat}
> +-----------------+--------------------+----------------+----------------------+----------------------------------------------------+--------------------------------------------+
> | txnid | state | startedtime | lastheartbeattime
> | user |
> host |
> +-----------------+--------------------+----------------+----------------------+----------------------------------------------------+--------------------------------------------+
> | Transaction ID | Transaction State | Started Time | Last Heartbeat Time
> | User | Hostname
> |
> | 37 | OPEN | 1759478145278 | 1759478145278
> | hive/ip-10-17-78-194.support.fuse.cloudera....@support.fuse.cloudera.com |
> ip-10-17-78-194.support.fuse.cloudera.com |
> +-----------------+--------------------+----------------+----------------------+----------------------------------------------------+--------------------------------------------+{noformat}
> Here we don't know the query id and not sure if we retrieve it and display in
> the above command
>
> Show processlist gives below data
> {noformat}
> 0: jdbc:hive2://localhost:10000> show processlist;
> +------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+-----------+-------------------+-------------------+---------------+-----------------+
> | User Name | Ip Addr | Execution Engine | Session Id
> | Session Active Time (s) | Session Idle Time (s) |
> Query ID | State | Opened Timestamp | Elapsed
> Time (s) | Runtime (s) | Query |
> +------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+-----------+-------------------+-------------------+---------------+-----------------+
> | hive | 127.0.0.1 | mr |
> 6cdf027f-90e1-48af-b4d8-a11aac71ca1b | 154 | 19
> | rtrivedi_20240624193743_fb4b2bf8-a02a-4b76-a92c-4e3ee4bb6e9e |
> FINISHED | 1719275863493 | 102 | 83 | show
> tables |
> | hive | 127.0.0.1 | mr |
> 43945f54-d65c-424d-b523-08e7675d8223 | 165 | 67
> | rtrivedi_20240624193826_42bff3ed-fb8d-4478-9500-fc6ff2173041 |
> RUNNING | 1719275906721 | 59 | Not finished | show
> databases |
> +------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+-----------+-------------------+-------------------+---------------+-----------------+
> 2 rows selected (4.149 seconds){noformat}
> We can try to display transaction id in this command, so that we can map
> transaction details from the show transactions output
>
> Customer use case:
> Some transactions are hanging for long, but they don't know the query
> corresponding to that txn id before aborting that manually
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
