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

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-26022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

ASF GitHub Bot updated HIVE-26022:
----------------------------------
    Labels: pull-request-available  (was: )

> 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
>            Priority: Blocker
>              Labels: pull-request-available
>             Fix For: 4.0.0-alpha-1
>
>          Time Spent: 10m
>  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)