You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2016/05/18 19:54:51 UTC

hive git commit: HIVE-13784: Hive Metastore start failed on Oracle DB (Hari Subramaniyan, reviewed by Sergey Shelukhin)

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 <ha...@apache.org>
Authored: Wed May 18 12:54:25 2016 -0700
Committer: Hari Subramaniyan <ha...@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);
 
 
 ------------------------------