You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Stamatis Zampetakis (Jira)" <ji...@apache.org> on 2022/03/10 10:19:00 UTC
[jira] [Resolved] (HIVE-26022) Error: ORA-00904 when initializing metastore schema in Oracle
[ 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)