This is an automated email from the ASF dual-hosted git repository.
ayushsaxena pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/master by this push:
new 7e4220f015 HIVE-26215: Expose the MIN_HISTORY_LEVEL table through Hive
sys database (#3275). (Simhadri G, reviewed by Ayush Saxena)
7e4220f015 is described below
commit 7e4220f015792451121b9ed39ef52b17e12935af
Author: Simhadri Govindappa <[email protected]>
AuthorDate: Wed May 11 17:13:16 2022 +0530
HIVE-26215: Expose the MIN_HISTORY_LEVEL table through Hive sys database
(#3275). (Simhadri G, reviewed by Ayush Saxena)
---
.../upgrade/hive/hive-schema-4.0.0-alpha-2.hive.sql | 14 ++++++++++++++
.../hive/upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql | 13 +++++++++++++
ql/src/test/results/clientpositive/llap/resourceplan.q.out | 4 ++++
.../clientpositive/llap/strict_managed_tables_sysdb.q.out | 6 ++++++
ql/src/test/results/clientpositive/llap/sysdb.q.out | 9 ++++++++-
5 files changed, 45 insertions(+), 1 deletion(-)
diff --git a/metastore/scripts/upgrade/hive/hive-schema-4.0.0-alpha-2.hive.sql
b/metastore/scripts/upgrade/hive/hive-schema-4.0.0-alpha-2.hive.sql
index e8728f18d4..61cafd8ca9 100644
--- a/metastore/scripts/upgrade/hive/hive-schema-4.0.0-alpha-2.hive.sql
+++ b/metastore/scripts/upgrade/hive/hive-schema-4.0.0-alpha-2.hive.sql
@@ -1466,6 +1466,20 @@ SELECT DISTINCT
HL.`HL_BLOCKEDBY_INT_ID`
FROM SYS.`HIVE_LOCKS` AS HL;
+CREATE EXTERNAL TABLE IF NOT EXISTS `MIN_HISTORY_LEVEL` (
+ `MHL_TXNID` bigint,
+ `MHL_MIN_OPEN_TXNID` bigint
+)
+STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
+TBLPROPERTIES (
+"hive.sql.database.type" = "METASTORE",
+"hive.sql.query" =
+"SELECT
+ \"MHL_TXNID\",
+ \"MHL_MIN_OPEN_TXNID\",
+FROM \"MIN_HISTORY_LEVEL\""
+);
+
CREATE EXTERNAL TABLE IF NOT EXISTS `REPLICATION_METRICS_ORIG` (
`SCHEDULED_EXECUTION_ID` bigint,
`POLICY_NAME` string,
diff --git
a/metastore/scripts/upgrade/hive/upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql
b/metastore/scripts/upgrade/hive/upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql
index 32f39c9e07..a81d6881ed 100644
---
a/metastore/scripts/upgrade/hive/upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql
+++
b/metastore/scripts/upgrade/hive/upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql
@@ -2,5 +2,18 @@ SELECT 'Upgrading MetaStore schema from 4.0.0-alpha-1 to
4.0.0-alpha-2';
USE SYS;
+CREATE EXTERNAL TABLE IF NOT EXISTS `MIN_HISTORY_LEVEL` (
+ `MHL_TXNID` bigint,
+ `MHL_MIN_OPEN_TXNID` bigint
+)
+STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
+TBLPROPERTIES (
+"hive.sql.database.type" = "METASTORE",
+"hive.sql.query" =
+"SELECT
+ \"MHL_TXNID\",
+ \"MHL_MIN_OPEN_TXNID\",
+FROM \"MIN_HISTORY_LEVEL\""
+);
SELECT 'Finished upgrading MetaStore schema from 4.0.0-alpha-1 to
4.0.0-alpha-2';
diff --git a/ql/src/test/results/clientpositive/llap/resourceplan.q.out
b/ql/src/test/results/clientpositive/llap/resourceplan.q.out
index 8fcf133a3a..0a07df4baf 100644
--- a/ql/src/test/results/clientpositive/llap/resourceplan.q.out
+++ b/ql/src/test/results/clientpositive/llap/resourceplan.q.out
@@ -162,6 +162,10 @@ sys locks hive_test_user USER
DELETE true -1 hive_test_user
sys locks hive_test_user USER INSERT true -1
hive_test_user
sys locks hive_test_user USER SELECT true -1
hive_test_user
sys locks hive_test_user USER UPDATE true -1
hive_test_user
+sys min_history_level hive_test_user USER DELETE
true -1 hive_test_user
+sys min_history_level hive_test_user USER INSERT
true -1 hive_test_user
+sys min_history_level hive_test_user USER SELECT
true -1 hive_test_user
+sys min_history_level hive_test_user USER UPDATE
true -1 hive_test_user
sys mv_creation_metadata hive_test_user USER DELETE
true -1 hive_test_user
sys mv_creation_metadata hive_test_user USER INSERT
true -1 hive_test_user
sys mv_creation_metadata hive_test_user USER SELECT
true -1 hive_test_user
diff --git
a/ql/src/test/results/clientpositive/llap/strict_managed_tables_sysdb.q.out
b/ql/src/test/results/clientpositive/llap/strict_managed_tables_sysdb.q.out
index ab08793855..6555050676 100644
--- a/ql/src/test/results/clientpositive/llap/strict_managed_tables_sysdb.q.out
+++ b/ql/src/test/results/clientpositive/llap/strict_managed_tables_sysdb.q.out
@@ -252,6 +252,10 @@ sys locks hive_test_user USER
DELETE true -1 hive_test_user
sys locks hive_test_user USER INSERT true -1
hive_test_user
sys locks hive_test_user USER SELECT true -1
hive_test_user
sys locks hive_test_user USER UPDATE true -1
hive_test_user
+sys min_history_level hive_test_user USER DELETE
true -1 hive_test_user
+sys min_history_level hive_test_user USER INSERT
true -1 hive_test_user
+sys min_history_level hive_test_user USER SELECT
true -1 hive_test_user
+sys min_history_level hive_test_user USER UPDATE
true -1 hive_test_user
sys mv_creation_metadata hive_test_user USER DELETE
true -1 hive_test_user
sys mv_creation_metadata hive_test_user USER INSERT
true -1 hive_test_user
sys mv_creation_metadata hive_test_user USER SELECT
true -1 hive_test_user
@@ -482,6 +486,7 @@ PREHOOK: Output: sys@global_privs
PREHOOK: Output: sys@hive_locks
PREHOOK: Output: sys@key_constraints
PREHOOK: Output: sys@locks
+PREHOOK: Output: sys@min_history_level
PREHOOK: Output: sys@mv_creation_metadata
PREHOOK: Output: sys@mv_tables_used
PREHOOK: Output: sys@notification_log
@@ -544,6 +549,7 @@ POSTHOOK: Output: sys@global_privs
POSTHOOK: Output: sys@hive_locks
POSTHOOK: Output: sys@key_constraints
POSTHOOK: Output: sys@locks
+POSTHOOK: Output: sys@min_history_level
POSTHOOK: Output: sys@mv_creation_metadata
POSTHOOK: Output: sys@mv_tables_used
POSTHOOK: Output: sys@notification_log
diff --git a/ql/src/test/results/clientpositive/llap/sysdb.q.out
b/ql/src/test/results/clientpositive/llap/sysdb.q.out
index be55080ffa..b5c0869bba 100644
--- a/ql/src/test/results/clientpositive/llap/sysdb.q.out
+++ b/ql/src/test/results/clientpositive/llap/sysdb.q.out
@@ -200,6 +200,10 @@ sys locks hive_test_user USER
DELETE true -1 hive_test_user
sys locks hive_test_user USER INSERT true -1
hive_test_user
sys locks hive_test_user USER SELECT true -1
hive_test_user
sys locks hive_test_user USER UPDATE true -1
hive_test_user
+sys min_history_level hive_test_user USER DELETE
true -1 hive_test_user
+sys min_history_level hive_test_user USER INSERT
true -1 hive_test_user
+sys min_history_level hive_test_user USER SELECT
true -1 hive_test_user
+sys min_history_level hive_test_user USER UPDATE
true -1 hive_test_user
sys mv_creation_metadata hive_test_user USER DELETE
true -1 hive_test_user
sys mv_creation_metadata hive_test_user USER INSERT
true -1 hive_test_user
sys mv_creation_metadata hive_test_user USER SELECT
true -1 hive_test_user
@@ -621,6 +625,8 @@ locks partition
locks table
locks txnid
locks user
+min_history_level mhl_min_open_txnid
+min_history_level mhl_txnid
moretypes a
moretypes b
moretypes c
@@ -1228,7 +1234,7 @@ POSTHOOK: query: select count(*) from sds
POSTHOOK: type: QUERY
POSTHOOK: Input: sys@sds
#### A masked pattern was here ####
-75
+76
PREHOOK: query: select param_key, param_value from sd_params order by
param_key, param_value limit 5
PREHOOK: type: QUERY
PREHOOK: Input: sys@sd_params
@@ -1624,6 +1630,7 @@ default sys global_privs BASE_TABLE NULL
NULL NULL NULL NULL YES NO NULL
default sys hive_locks BASE_TABLE NULL NULL NULL
NULL NULL YES NO NULL
default sys key_constraints BASE_TABLE NULL NULL NULL
NULL NULL YES NO NULL
default sys locks VIEW NULL NULL NULL NULL NULL
NO NO NULL
+default sys min_history_level BASE_TABLE NULL NULL
NULL NULL NULL YES NO NULL
default sys mv_creation_metadata BASE_TABLE NULL NULL
NULL NULL NULL YES NO NULL
default sys mv_tables_used BASE_TABLE NULL NULL NULL
NULL NULL YES NO NULL
default sys notification_log BASE_TABLE NULL NULL
NULL NULL NULL YES NO NULL
