[ 
https://issues.apache.org/jira/browse/HIVE-11957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15573672#comment-15573672
 ] 

Eugene Koifman commented on HIVE-11957:
---------------------------------------

are you sure adding new fields in the middle of "struct TxnInfo {" won't break 
compatibility with old clients?
Seems like adding to the end is safer, though I don't know for sure

Have you considered timezone issues when formatting a timestamp in human 
readable?
Is it using the same TZ as when it was generated.
SHOW LOCKS uses timestamps - so this makes it impossible to correlate the data 
between the 2 outputs.
I think raw timestamp is easier/more reliable.




> 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)

Reply via email to