[
https://issues.apache.org/jira/browse/HIVE-22628?focusedWorklogId=837920&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-837920
]
ASF GitHub Bot logged work on HIVE-22628:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 09/Jan/23 12:36
Start Date: 09/Jan/23 12:36
Worklog Time Spent: 10m
Work Description: deniskuzZ commented on code in PR #3921:
URL: https://github.com/apache/hive/pull/3921#discussion_r1064577019
##########
metastore/scripts/upgrade/hive/hive-schema-4.0.0.hive.sql:
##########
@@ -2008,6 +2008,75 @@ JOIN
WHERE
SE.SCHEDULED_QUERY_ID=SQ.SCHEDULED_QUERY_ID;
+CREATE OR REPLACE VIEW `TRANSACTIONS` (
+ `TXN_ID`,
+ `STATE`,
+ `STARTED`,
+ `LAST_HEARTBEAT`,
+ `USER`,
+ `HOST`,
+ `AGENT_INFO`,
+ `META_INFO`,
+ `HEARTBEAT_COUNT`,
+ `TYPE`,
+ `TC_DATABASE`,
+ `TC_TABLE`,
+ `TC_PARTITION`,
+ `TC_OPERATION_TYPE`,
+ `TC_WRITEID`
+) AS
+SELECT DISTINCT
+ T.`TXN_ID`,
+ CASE WHEN T.`TXN_STATE` = 'o' THEN 'open' WHEN T.`TXN_STATE` = 'a' THEN
'aborted' WHEN T.`TXN_STATE` = 'c' THEN 'commited' ELSE 'UNKNOWN' END AS
TXN_STATE,
+ FROM_UNIXTIME(T.`TXN_STARTED` DIV 1000) AS TXN_STARTED,
+ FROM_UNIXTIME(T.`TXN_LAST_HEARTBEAT` DIV 1000) AS TXN_LAST_HEARTBEAT,
+ T.`TXN_USER`,
+ T.`TXN_HOST`,
+ T.`TXN_AGENT_INFO`,
+ T.`TXN_META_INFO`,
+ T.`TXN_HEARTBEAT_COUNT`,
+ CASE WHEN T.`TXN_TYPE` = 0 THEN 'DEFAULT' WHEN T.`TXN_TYPE` = 1 THEN
'REPL_CREATED' WHEN T.`TXN_TYPE` = 2 THEN 'READ_ONLY' WHEN T.`TXN_TYPE` = 3
THEN 'COMPACTION' END AS TXN_TYPE,
+ TC.`TC_DATABASE`,
+ TC.`TC_TABLE`,
+ TC.`TC_PARTITION`,
+ CASE WHEN TC.`TC_OPERATION_TYPE` = 's' THEN 'SELECT' WHEN
TC.`TC_OPERATION_TYPE` = 'i' THEN 'INSERT' WHEN TC.`TC_OPERATION_TYPE` = 'u'
THEN 'UPDATE' WHEN TC.`TC_OPERATION_TYPE` = 'c' THEN 'COMPACT' END AS
OPERATION_TYPE,
+ TC.`TC_WRITEID`
+FROM `SYS`.`TXNS` AS T
+LEFT JOIN `SYS`.`TXN_COMPONENTS` AS TC ON T.`TXN_ID` = TC.`TC_TXNID`;
-
-
+CREATE OR REPLACE VIEW `LOCKS` (
Review Comment:
same as above + check the permissions
Issue Time Tracking
-------------------
Worklog Id: (was: 837920)
Time Spent: 1h 20m (was: 1h 10m)
> Add locks and transactions tables from sys db to information_schema
> -------------------------------------------------------------------
>
> Key: HIVE-22628
> URL: https://issues.apache.org/jira/browse/HIVE-22628
> Project: Hive
> Issue Type: Improvement
> Affects Versions: 4.0.0
> Reporter: Zoltan Chovan
> Assignee: Akshat Mathur
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1h 20m
> Remaining Estimate: 0h
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
