HIVE-11831 : TXN tables in Oracle should be created with ROWDEPENDENCIES (Sergey Shelukhin, reviewed by Alan Gates)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/41a12cb2 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/41a12cb2 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/41a12cb2 Branch: refs/heads/beeline-cli Commit: 41a12cb26789c94be22fa2936fc4ca41b3e675ba Parents: 7b92f44 Author: Sergey Shelukhin <[email protected]> Authored: Thu Sep 24 18:09:23 2015 -0700 Committer: Sergey Shelukhin <[email protected]> Committed: Thu Sep 24 18:09:23 2015 -0700 ---------------------------------------------------------------------- .../scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql | 10 +++++----- .../scripts/upgrade/oracle/hive-schema-0.14.0.oracle.sql | 10 +++++----- .../upgrade/oracle/hive-txn-schema-0.13.0.oracle.sql | 10 +++++----- .../upgrade/oracle/hive-txn-schema-0.14.0.oracle.sql | 10 +++++----- 4 files changed, 20 insertions(+), 20 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/41a12cb2/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql index 6bd8df9..014b7c0 100644 --- a/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql @@ -766,21 +766,21 @@ CREATE TABLE TXNS ( TXN_LAST_HEARTBEAT NUMBER(19) NOT NULL, TXN_USER varchar(128) NOT NULL, TXN_HOST varchar(128) NOT NULL -); +) ROWDEPENDENCIES; CREATE TABLE TXN_COMPONENTS ( TC_TXNID NUMBER(19) REFERENCES TXNS (TXN_ID), TC_DATABASE VARCHAR2(128) NOT NULL, TC_TABLE VARCHAR2(128), TC_PARTITION VARCHAR2(767) NULL -); +) ROWDEPENDENCIES; CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID NUMBER(19), CTC_DATABASE varchar(128) NOT NULL, CTC_TABLE varchar(128), CTC_PARTITION varchar(767) -); +) ROWDEPENDENCIES; CREATE TABLE NEXT_TXN_ID ( NTXN_NEXT NUMBER(19) NOT NULL @@ -801,7 +801,7 @@ CREATE TABLE HIVE_LOCKS ( HL_USER varchar(128) NOT NULL, HL_HOST varchar(128) NOT NULL, PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID) -); +) ROWDEPENDENCIES; CREATE INDEX HL_TXNID_INDEX ON HIVE_LOCKS (HL_TXNID); @@ -820,7 +820,7 @@ CREATE TABLE COMPACTION_QUEUE ( CQ_WORKER_ID varchar(128), CQ_START NUMBER(19), CQ_RUN_AS varchar(128) -); +) ROWDEPENDENCIES; CREATE TABLE NEXT_COMPACTION_QUEUE_ID ( NCQ_NEXT NUMBER(19) NOT NULL http://git-wip-us.apache.org/repos/asf/hive/blob/41a12cb2/metastore/scripts/upgrade/oracle/hive-schema-0.14.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/hive-schema-0.14.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-schema-0.14.0.oracle.sql index f1f71ce..ec9abba 100644 --- a/metastore/scripts/upgrade/oracle/hive-schema-0.14.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/hive-schema-0.14.0.oracle.sql @@ -766,21 +766,21 @@ CREATE TABLE TXNS ( TXN_LAST_HEARTBEAT NUMBER(19) NOT NULL, TXN_USER varchar(128) NOT NULL, TXN_HOST varchar(128) NOT NULL -); +) ROWDEPENDENCIES; CREATE TABLE TXN_COMPONENTS ( TC_TXNID NUMBER(19) REFERENCES TXNS (TXN_ID), TC_DATABASE VARCHAR2(128) NOT NULL, TC_TABLE VARCHAR2(128), TC_PARTITION VARCHAR2(767) NULL -); +) ROWDEPENDENCIES; CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID NUMBER(19), CTC_DATABASE varchar(128) NOT NULL, CTC_TABLE varchar(128), CTC_PARTITION varchar(767) -); +) ROWDEPENDENCIES; CREATE TABLE NEXT_TXN_ID ( NTXN_NEXT NUMBER(19) NOT NULL @@ -801,7 +801,7 @@ CREATE TABLE HIVE_LOCKS ( HL_USER varchar(128) NOT NULL, HL_HOST varchar(128) NOT NULL, PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID) -); +) ROWDEPENDENCIES; CREATE INDEX HL_TXNID_INDEX ON HIVE_LOCKS (HL_TXNID); @@ -820,7 +820,7 @@ CREATE TABLE COMPACTION_QUEUE ( CQ_WORKER_ID varchar(128), CQ_START NUMBER(19), CQ_RUN_AS varchar(128) -); +) ROWDEPENDENCIES; CREATE TABLE NEXT_COMPACTION_QUEUE_ID ( NCQ_NEXT NUMBER(19) NOT NULL http://git-wip-us.apache.org/repos/asf/hive/blob/41a12cb2/metastore/scripts/upgrade/oracle/hive-txn-schema-0.13.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/hive-txn-schema-0.13.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-txn-schema-0.13.0.oracle.sql index 7435ea8..58e53c4 100644 --- a/metastore/scripts/upgrade/oracle/hive-txn-schema-0.13.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/hive-txn-schema-0.13.0.oracle.sql @@ -24,21 +24,21 @@ CREATE TABLE TXNS ( TXN_LAST_HEARTBEAT NUMBER(19) NOT NULL, TXN_USER varchar(128) NOT NULL, TXN_HOST varchar(128) NOT NULL -); +) ROWDEPENDENCIES; CREATE TABLE TXN_COMPONENTS ( TC_TXNID NUMBER(19) REFERENCES TXNS (TXN_ID), TC_DATABASE VARCHAR2(128) NOT NULL, TC_TABLE VARCHAR2(128), TC_PARTITION VARCHAR2(767) NULL -); +) ROWDEPENDENCIES; CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID NUMBER(19), CTC_DATABASE varchar(128) NOT NULL, CTC_TABLE varchar(128), CTC_PARTITION varchar(767) -); +) ROWDEPENDENCIES; CREATE TABLE NEXT_TXN_ID ( NTXN_NEXT NUMBER(19) NOT NULL @@ -59,7 +59,7 @@ CREATE TABLE HIVE_LOCKS ( HL_USER varchar(128) NOT NULL, HL_HOST varchar(128) NOT NULL, PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID) -); +) ROWDEPENDENCIES; CREATE INDEX HL_TXNID_INDEX ON HIVE_LOCKS (HL_TXNID); @@ -78,7 +78,7 @@ CREATE TABLE COMPACTION_QUEUE ( CQ_WORKER_ID varchar(128), CQ_START NUMBER(19), CQ_RUN_AS varchar(128) -); +) ROWDEPENDENCIES; CREATE TABLE NEXT_COMPACTION_QUEUE_ID ( NCQ_NEXT NUMBER(19) NOT NULL http://git-wip-us.apache.org/repos/asf/hive/blob/41a12cb2/metastore/scripts/upgrade/oracle/hive-txn-schema-0.14.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/hive-txn-schema-0.14.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-txn-schema-0.14.0.oracle.sql index 7435ea8..58e53c4 100644 --- a/metastore/scripts/upgrade/oracle/hive-txn-schema-0.14.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/hive-txn-schema-0.14.0.oracle.sql @@ -24,21 +24,21 @@ CREATE TABLE TXNS ( TXN_LAST_HEARTBEAT NUMBER(19) NOT NULL, TXN_USER varchar(128) NOT NULL, TXN_HOST varchar(128) NOT NULL -); +) ROWDEPENDENCIES; CREATE TABLE TXN_COMPONENTS ( TC_TXNID NUMBER(19) REFERENCES TXNS (TXN_ID), TC_DATABASE VARCHAR2(128) NOT NULL, TC_TABLE VARCHAR2(128), TC_PARTITION VARCHAR2(767) NULL -); +) ROWDEPENDENCIES; CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID NUMBER(19), CTC_DATABASE varchar(128) NOT NULL, CTC_TABLE varchar(128), CTC_PARTITION varchar(767) -); +) ROWDEPENDENCIES; CREATE TABLE NEXT_TXN_ID ( NTXN_NEXT NUMBER(19) NOT NULL @@ -59,7 +59,7 @@ CREATE TABLE HIVE_LOCKS ( HL_USER varchar(128) NOT NULL, HL_HOST varchar(128) NOT NULL, PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID) -); +) ROWDEPENDENCIES; CREATE INDEX HL_TXNID_INDEX ON HIVE_LOCKS (HL_TXNID); @@ -78,7 +78,7 @@ CREATE TABLE COMPACTION_QUEUE ( CQ_WORKER_ID varchar(128), CQ_START NUMBER(19), CQ_RUN_AS varchar(128) -); +) ROWDEPENDENCIES; CREATE TABLE NEXT_COMPACTION_QUEUE_ID ( NCQ_NEXT NUMBER(19) NOT NULL
