[ https://issues.apache.org/jira/browse/HIVE-26022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stamatis Zampetakis resolved HIVE-26022. ---------------------------------------- Assignee: Stamatis Zampetakis Resolution: Fixed Fixed in https://github.com/apache/hive/commit/d696b34a5765fe950ebe4bfffd36b9ea914dfaab. Thanks for the review [~abstractdog]! > 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 > Assignee: Stamatis Zampetakis > Priority: Blocker > Labels: pull-request-available > Fix For: 4.0.0-alpha-1 > > Time Spent: 20m > Remaining Estimate: 0h > > 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)