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