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)
