[jira] [Work logged] (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?focusedWorklogId=738895&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-738895 ]

ASF GitHub Bot logged work on HIVE-26022:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 09/Mar/22 16:11
            Start Date: 09/Mar/22 16:11
    Worklog Time Spent: 10m 
      Work Description: zabetak opened a new pull request #3088:
URL: https://github.com/apache/hive/pull/3088


   ### What changes were proposed in this pull request?
   1. Remove trailing comma from CREATE TABLE statement
   2. Enable tests for Oracle in CI
   
   ### Why are the changes needed?
   1. Fix initialization problem
   2. Protect against future regressions
   
   ### Does this PR introduce _any_ user-facing change?
   No
   
   ### How was this patch tested?
   `mvn -pl standalone-metastore/metastore-server verify -DskipITests=false -Dit.test=ITestOracle -Dtest=nosuch`


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 738895)
    Remaining Estimate: 0h
            Time Spent: 10m

> 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
>             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)