Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-26022

Error: ORA-00904 when initializing metastore schema in Oracle

    XMLWordPrintableJSON

Details

    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

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. HIVE-25756 Fix replication metrics backward compatibility issue.

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #3088

          Activity

            People

              zabetak Stamatis Zampetakis
              zabetak Stamatis Zampetakis
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m