[hive] branch master updated: HIVE-26022: Error: ORA-00904 when initializing metastore schema in Oracle (Stamatis Zampetakis, reviewed by Laszlo Bodor)

[zabetak]

This is an automated email from the ASF dual-hosted git repository.

zabetak 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 d696b34  HIVE-26022: Error: ORA-00904 when initializing metastore 
schema in Oracle (Stamatis Zampetakis, reviewed by Laszlo Bodor)
d696b34 is described below

commit d696b34a5765fe950ebe4bfffd36b9ea914dfaab
Author: Stamatis Zampetakis <zabe...@gmail.com>
AuthorDate: Wed Mar 9 17:08:38 2022 +0100

    HIVE-26022: Error: ORA-00904 when initializing metastore schema in Oracle 
(Stamatis Zampetakis, reviewed by Laszlo Bodor)
    
    Closes #3088
---
 Jenkinsfile                                                             | 2 +-
 .../metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql   | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/Jenkinsfile b/Jenkinsfile
index 70d5b91..8d16e60 100644
--- a/Jenkinsfile
+++ b/Jenkinsfile
@@ -257,7 +257,7 @@ fi
   }
 
   def branches = [:]
-  for (def d in ['derby','postgres','mysql']) {
+  for (def d in ['derby','postgres','mysql','oracle']) {
     def dbType=d
     def splitName = "init@$dbType"
     branches[splitName] = {
diff --git 
a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
 
b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
index 166af8a..726fd34 100644
--- 
a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
+++ 
b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
@@ -1281,7 +1281,7 @@ CREATE TABLE "REPLICATION_METRICS" (
   "RM_METADATA" varchar2(4000),
   "RM_PROGRESS" varchar2(4000),
   "RM_START_TIME" integer NOT NULL,
-  "MESSAGE_FORMAT" VARCHAR(16) DEFAULT 'json-0.2',
+  "MESSAGE_FORMAT" VARCHAR(16) DEFAULT 'json-0.2'
 );
 
 --Create indexes for the replication metrics table