Repository: hive Updated Branches: refs/heads/master f3fe47ca5 -> ff38cfb76
HIVE-13784: Hive Metastore start failed on Oracle DB (Hari Subramaniyan, reviewed by Sergey Shelukhin) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/ff38cfb7 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/ff38cfb7 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/ff38cfb7 Branch: refs/heads/master Commit: ff38cfb76e91a21ab10077d7ac62c6828514b0ad Parents: f3fe47c Author: Hari Subramaniyan <harisan...@apache.org> Authored: Wed May 18 12:54:25 2016 -0700 Committer: Hari Subramaniyan <harisan...@apache.org> Committed: Wed May 18 12:54:25 2016 -0700 ---------------------------------------------------------------------- metastore/scripts/upgrade/oracle/034-HIVE-13076.oracle.sql | 2 +- metastore/scripts/upgrade/oracle/hive-schema-2.1.0.oracle.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/ff38cfb7/metastore/scripts/upgrade/oracle/034-HIVE-13076.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/034-HIVE-13076.oracle.sql b/metastore/scripts/upgrade/oracle/034-HIVE-13076.oracle.sql index 5bbd197..a456e1e 100644 --- a/metastore/scripts/upgrade/oracle/034-HIVE-13076.oracle.sql +++ b/metastore/scripts/upgrade/oracle/034-HIVE-13076.oracle.sql @@ -14,4 +14,4 @@ CREATE TABLE IF NOT EXISTS KEY_CONSTRAINTS ENABLE_VALIDATE_RELY NUMBER NOT NULL ) ; ALTER TABLE KEY_CONSTRAINTS ADD CONSTRAINT CONSTRAINTS_PK PRIMARY KEY (CONSTRAINT_NAME, POSITION); -CREATE INDEX CONSTRAINTS_PARENT_TBL_ID_INDEX ON KEY_CONSTRAINTS(PARENT_TBL_ID); +CREATE INDEX CONSTRAINTS_PT_INDEX ON KEY_CONSTRAINTS(PARENT_TBL_ID); http://git-wip-us.apache.org/repos/asf/hive/blob/ff38cfb7/metastore/scripts/upgrade/oracle/hive-schema-2.1.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/hive-schema-2.1.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-schema-2.1.0.oracle.sql index f3dcccd..bdc79ae 100644 --- a/metastore/scripts/upgrade/oracle/hive-schema-2.1.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/hive-schema-2.1.0.oracle.sql @@ -795,7 +795,7 @@ CREATE TABLE KEY_CONSTRAINTS ALTER TABLE KEY_CONSTRAINTS ADD CONSTRAINT CONSTRAINTS_PK PRIMARY KEY (CONSTRAINT_NAME, POSITION); -CREATE INDEX CONSTRAINTS_PARENT_TBL_ID_INDEX ON KEY_CONSTRAINTS(PARENT_TBL_ID); +CREATE INDEX CONSTRAINTS_PT_INDEX ON KEY_CONSTRAINTS(PARENT_TBL_ID); ------------------------------