[HIVE-26022] Error: ORA-00904 when initializing metastore schema in Oracle

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Assignee: Stamatis Zampetakis
• Reporter: Stamatis Zampetakis
• Created: 09/Mar/22 15:57
• Updated: 17/Nov/22 08:47
• Resolved: 10/Mar/22 10:18

Description

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:

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)

The problem can be reproduced by running the ITestOracle.

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

Issue Links

• is caused by: HIVE-25756 Fix replication metrics backward compatibility issue.
• links to: GitHub Pull Request #3088