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 d0d5d6d7d11 HIVE-28436: Fix Incorrect syntax in Hive schema file for
table MIN_HISTORY_LEVEL (#5388). (Indhumathi Muthumurugesh, reviewed by Ayush
Saxena, Shohei Okumiya, Kokila N)
d0d5d6d7d11 is described below
commit d0d5d6d7d11b3eece0d0bc17b429cb30dec5dc79
Author: Indhumathi27 <34215196+indhumath...@users.noreply.github.com>
AuthorDate: Mon Aug 12 11:49:06 2024 +0530
HIVE-28436: Fix Incorrect syntax in Hive schema file for table
MIN_HISTORY_LEVEL (#5388). (Indhumathi Muthumurugesh, reviewed by Ayush Saxena,
Shohei Okumiya, Kokila N)
---
ql/src/test/queries/clientpositive/sysdb.q | 2 ++
ql/src/test/results/clientpositive/llap/sysdb.q.out | 8 ++++++++
.../src/main/sql/hive/hive-schema-4.0.0-alpha-2.hive.sql | 2 +-
.../src/main/sql/hive/hive-schema-4.0.0-beta-1.hive.sql | 2 +-
.../metastore-server/src/main/sql/hive/hive-schema-4.0.0.hive.sql | 2 +-
.../metastore-server/src/main/sql/hive/hive-schema-4.1.0.hive.sql | 2 +-
.../main/sql/hive/upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql | 2 +-
7 files changed, 15 insertions(+), 5 deletions(-)
diff --git a/ql/src/test/queries/clientpositive/sysdb.q
b/ql/src/test/queries/clientpositive/sysdb.q
index 9370c44ddbf..6bfa6c918a4 100644
--- a/ql/src/test/queries/clientpositive/sysdb.q
+++ b/ql/src/test/queries/clientpositive/sysdb.q
@@ -124,6 +124,8 @@ select max(num_distincts) from sys.tab_col_stats;
select * from compactions;
+select MHL_TXNID,MHL_MIN_OPEN_TXNID from MIN_HISTORY_LEVEL;
+
use INFORMATION_SCHEMA;
select count(*) from SCHEMATA;
diff --git a/ql/src/test/results/clientpositive/llap/sysdb.q.out
b/ql/src/test/results/clientpositive/llap/sysdb.q.out
index 7fe712061b4..4503715f230 100644
--- a/ql/src/test/results/clientpositive/llap/sysdb.q.out
+++ b/ql/src/test/results/clientpositive/llap/sysdb.q.out
@@ -1643,6 +1643,14 @@ POSTHOOK: Input: sys@completed_compactions
#### A masked pattern was here ####
1 default default scr_txn NULL major initiated NULL NULL
NULL #Masked# NULL NULL NULL NULL NULL NULL NULL
NULL NULL #Masked# manual 4.1.0-SNAPSHOT NULL default NULL
NULL
2 default default scr_txn_2 NULL minor initiated NULL
NULL NULL #Masked# NULL NULL NULL NULL NULL NULL
NULL NULL NULL #Masked# manual 4.1.0-SNAPSHOT NULL default
NULL NULL
+PREHOOK: query: select MHL_TXNID,MHL_MIN_OPEN_TXNID from MIN_HISTORY_LEVEL
+PREHOOK: type: QUERY
+PREHOOK: Input: sys@min_history_level
+#### A masked pattern was here ####
+POSTHOOK: query: select MHL_TXNID,MHL_MIN_OPEN_TXNID from MIN_HISTORY_LEVEL
+POSTHOOK: type: QUERY
+POSTHOOK: Input: sys@min_history_level
+#### A masked pattern was here ####
PREHOOK: query: use INFORMATION_SCHEMA
PREHOOK: type: SWITCHDATABASE
PREHOOK: Input: database:information_schema
diff --git
a/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0-alpha-2.hive.sql
b/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0-alpha-2.hive.sql
index 4896576043f..fb3d1943313 100644
---
a/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0-alpha-2.hive.sql
+++
b/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0-alpha-2.hive.sql
@@ -1510,7 +1510,7 @@ TBLPROPERTIES (
"hive.sql.query" =
"SELECT
\"MHL_TXNID\",
- \"MHL_MIN_OPEN_TXNID\",
+ \"MHL_MIN_OPEN_TXNID\"
FROM \"MIN_HISTORY_LEVEL\""
);
diff --git
a/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0-beta-1.hive.sql
b/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0-beta-1.hive.sql
index 679e8ff6e83..cf8cbf36ff3 100644
---
a/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0-beta-1.hive.sql
+++
b/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0-beta-1.hive.sql
@@ -1517,7 +1517,7 @@ TBLPROPERTIES (
"hive.sql.query" =
"SELECT
\"MHL_TXNID\",
- \"MHL_MIN_OPEN_TXNID\",
+ \"MHL_MIN_OPEN_TXNID\"
FROM \"MIN_HISTORY_LEVEL\""
);
diff --git
a/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0.hive.sql
b/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0.hive.sql
index 689bb763389..aeb930f224c 100644
---
a/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0.hive.sql
+++
b/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.0.0.hive.sql
@@ -1517,7 +1517,7 @@ TBLPROPERTIES (
"hive.sql.query" =
"SELECT
\"MHL_TXNID\",
- \"MHL_MIN_OPEN_TXNID\",
+ \"MHL_MIN_OPEN_TXNID\"
FROM \"MIN_HISTORY_LEVEL\""
);
diff --git
a/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.1.0.hive.sql
b/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.1.0.hive.sql
index bd478dee30d..d02dee3e922 100644
---
a/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.1.0.hive.sql
+++
b/standalone-metastore/metastore-server/src/main/sql/hive/hive-schema-4.1.0.hive.sql
@@ -1507,7 +1507,7 @@ TBLPROPERTIES (
"hive.sql.query" =
"SELECT
\"MHL_TXNID\",
- \"MHL_MIN_OPEN_TXNID\",
+ \"MHL_MIN_OPEN_TXNID\"
FROM \"MIN_HISTORY_LEVEL\""
);
diff --git
a/standalone-metastore/metastore-server/src/main/sql/hive/upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql
b/standalone-metastore/metastore-server/src/main/sql/hive/upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql
index e151a3da84f..c49652f4d3a 100644
---
a/standalone-metastore/metastore-server/src/main/sql/hive/upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql
+++
b/standalone-metastore/metastore-server/src/main/sql/hive/upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql
@@ -12,7 +12,7 @@ TBLPROPERTIES (
"hive.sql.query" =
"SELECT
\"MHL_TXNID\",
- \"MHL_MIN_OPEN_TXNID\",
+ \"MHL_MIN_OPEN_TXNID\"
FROM \"MIN_HISTORY_LEVEL\""
);
