[
https://issues.apache.org/jira/browse/HIVE-11957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15569142#comment-15569142
]
Wei Zheng commented on HIVE-11957:
----------------------------------
[~ekoifman] Can you take a look?
SHOW TRANSACTIONS now output like this:
{code}
hive> show transactions;
OK
Transaction ID Transaction State Started Time Last Heartbeat Time
User Hostname
16 OPEN Mon Oct 10 11:26:14 PDT 2016 Mon Oct 10 11:26:14 PDT 2016
wzheng weimac.local
Time taken: 0.028 seconds, Fetched: 2 row(s)
{code}
> SHOW TRANSACTIONS should show queryID/agent id of the creator
> -------------------------------------------------------------
>
> Key: HIVE-11957
> URL: https://issues.apache.org/jira/browse/HIVE-11957
> Project: Hive
> Issue Type: Improvement
> Components: Transactions
> Affects Versions: 1.0.0
> Reporter: Eugene Koifman
> Assignee: Wei Zheng
> Attachments: HIVE-11957.1.patch, HIVE-11957.2.patch,
> HIVE-11957.3.patch, HIVE-11957.4.patch, HIVE-11957.5.patch
>
>
> this would be very useful for debugging
> should also include heartbeat/create timestamps
> would be nice to support some filtering/sorting options, like sort by create
> time, agent id. filter by table, database, etc
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
