HIVE-19230: Schema column width inconsistency in Oracle (Naveen Gangam, reviewed by Yongzhi Chen)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/bdb0457a Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/bdb0457a Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/bdb0457a Branch: refs/heads/storage-branch-2.6 Commit: bdb0457af9595570994d9929e65c27e185e8b26a Parents: 9fe65da Author: Naveen Gangam <ngan...@apache.org> Authored: Thu Apr 19 16:57:33 2018 -0400 Committer: Naveen Gangam <ngan...@apache.org> Committed: Mon Apr 23 13:54:34 2018 -0400 ---------------------------------------------------------------------- .../scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql | 4 ++-- .../scripts/upgrade/oracle/hive-txn-schema-2.3.0.oracle.sql | 4 ++-- .../src/main/sql/oracle/hive-schema-3.0.0.oracle.sql | 4 ++-- 3 files changed, 6 insertions(+), 6 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/bdb0457a/metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql index 80adfc2..c6e564d 100644 --- a/metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql @@ -32,7 +32,7 @@ CREATE TABLE TXNS ( CREATE TABLE TXN_COMPONENTS ( TC_TXNID NUMBER(19) REFERENCES TXNS (TXN_ID), TC_DATABASE VARCHAR2(128) NOT NULL, - TC_TABLE VARCHAR2(256), + TC_TABLE VARCHAR2(128), TC_PARTITION VARCHAR2(767) NULL, TC_OPERATION_TYPE char(1) NOT NULL ) ROWDEPENDENCIES; @@ -40,7 +40,7 @@ CREATE TABLE TXN_COMPONENTS ( CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID NUMBER(19), CTC_DATABASE varchar(128) NOT NULL, - CTC_TABLE varchar(128), + CTC_TABLE varchar(256), CTC_PARTITION varchar(767) ) ROWDEPENDENCIES; http://git-wip-us.apache.org/repos/asf/hive/blob/bdb0457a/metastore/scripts/upgrade/oracle/hive-txn-schema-2.3.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/hive-txn-schema-2.3.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-txn-schema-2.3.0.oracle.sql index 12c24a5..1852fa6 100644 --- a/metastore/scripts/upgrade/oracle/hive-txn-schema-2.3.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/hive-txn-schema-2.3.0.oracle.sql @@ -32,7 +32,7 @@ CREATE TABLE TXNS ( CREATE TABLE TXN_COMPONENTS ( TC_TXNID NUMBER(19) REFERENCES TXNS (TXN_ID), TC_DATABASE VARCHAR2(128) NOT NULL, - TC_TABLE VARCHAR2(256), + TC_TABLE VARCHAR2(128), TC_PARTITION VARCHAR2(767) NULL, TC_OPERATION_TYPE char(1) NOT NULL ) ROWDEPENDENCIES; @@ -42,7 +42,7 @@ CREATE INDEX TC_TXNID_INDEX ON TXN_COMPONENTS (TC_TXNID); CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID NUMBER(19), CTC_DATABASE varchar(128) NOT NULL, - CTC_TABLE varchar(128), + CTC_TABLE varchar(256), CTC_PARTITION varchar(767) ) ROWDEPENDENCIES; http://git-wip-us.apache.org/repos/asf/hive/blob/bdb0457a/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql b/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql index 42a972f..f9e1a19 100644 --- a/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql +++ b/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql @@ -959,7 +959,7 @@ CREATE TABLE TXNS ( CREATE TABLE TXN_COMPONENTS ( TC_TXNID NUMBER(19) REFERENCES TXNS (TXN_ID), TC_DATABASE VARCHAR2(128) NOT NULL, - TC_TABLE VARCHAR2(256), + TC_TABLE VARCHAR2(128), TC_PARTITION VARCHAR2(767) NULL, TC_OPERATION_TYPE char(1) NOT NULL, TC_WRITEID NUMBER(19) @@ -970,7 +970,7 @@ CREATE INDEX TC_TXNID_INDEX ON TXN_COMPONENTS (TC_TXNID); CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID NUMBER(19), CTC_DATABASE VARCHAR2(128) NOT NULL, - CTC_TABLE VARCHAR2(128), + CTC_TABLE VARCHAR2(256), CTC_PARTITION VARCHAR2(767), CTC_TIMESTAMP timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL, CTC_WRITEID NUMBER(19)
