[jira] [Created] (HIVE-26022) Error: ORA-00904 when initializing metastore schema in Oracle

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

Stamatis Zampetakis created HIVE-26022:
------------------------------------------

             Summary: Error: ORA-00904 when initializing metastore schema in Oracle
                 Key: HIVE-26022
                 URL: https://issues.apache.org/jira/browse/HIVE-26022
             Project: Hive
          Issue Type: Bug
          Components: Standalone Metastore
            Reporter: Stamatis Zampetakis
             Fix For: 4.0.0-alpha-1


The Metastore schema tool fails to create the database schema when the underlying backend is Oracle. 

The initialization scripts fails while creating the "REPLICATION_METRICS" table:

{noformat}
338/362      --Create table replication metrics
339/362      CREATE TABLE "REPLICATION_METRICS" ( 
  "RM_SCHEDULED_EXECUTION_ID" number PRIMARY KEY, 
  "RM_POLICY" varchar2(256) NOT NULL, 
  "RM_DUMP_EXECUTION_ID" number NOT NULL, 
  "RM_METADATA" varchar2(4000), 
  "RM_PROGRESS" varchar2(4000), 
  "RM_START_TIME" integer NOT NULL, 
  "MESSAGE_FORMAT" VARCHAR(16) DEFAULT 'json-0.2', 
);
Error: ORA-00904: : invalid identifier (state=42000,code=904)
{noformat}

The problem can be reproduced by running the {{ITestOracle}}.

{noformat}
mvn -pl standalone-metastore/metastore-server verify -DskipITests=false -Dit.test=ITestOracle -Dtest=nosuch
{noformat}






--
This message was sent by Atlassian Jira
(v8.20.1#820001)