Repository: hive Updated Branches: refs/heads/branch-3 6bf1d8b64 -> 4ab0d1b8a
HIVE-20413: "cannot insert NULL" for TXN_WRITE_NOTIFICATION_LOG in Oracle (Daniel Dai, reviewed by Thejas Nair) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/4ab0d1b8 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/4ab0d1b8 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/4ab0d1b8 Branch: refs/heads/branch-3 Commit: 4ab0d1b8a7731b231d72493ffed3fb334e8bb1b4 Parents: 6bf1d8b Author: Daniel Dai <dai...@gmail.com> Authored: Fri Aug 17 14:36:33 2018 -0700 Committer: Daniel Dai <dai...@gmail.com> Committed: Fri Aug 17 14:36:33 2018 -0700 ---------------------------------------------------------------------- .../src/main/sql/oracle/hive-schema-3.2.0.oracle.sql | 7 ++++--- .../src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql | 8 +++++--- 2 files changed, 9 insertions(+), 6 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/4ab0d1b8/standalone-metastore/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql b/standalone-metastore/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql index a29752d..6360a8a 100644 --- a/standalone-metastore/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql +++ b/standalone-metastore/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql @@ -1159,14 +1159,15 @@ CREATE TABLE TXN_WRITE_NOTIFICATION_LOG ( WNL_WRITEID number(19) NOT NULL, WNL_DATABASE varchar(128) NOT NULL, WNL_TABLE varchar(128) NOT NULL, - WNL_PARTITION varchar(767) NOT NULL, + WNL_PARTITION varchar(767), WNL_TABLE_OBJ clob NOT NULL, WNL_PARTITION_OBJ clob, WNL_FILES clob, - WNL_EVENT_TIME number(10) NOT NULL, - PRIMARY KEY (WNL_TXNID, WNL_DATABASE, WNL_TABLE, WNL_PARTITION) + WNL_EVENT_TIME number(10) NOT NULL ); +CREATE INDEX TXN_WRITE_NOTIFICATION_LOG_IDX ON TXN_WRITE_NOTIFICATION_LOG (WNL_TXNID, WNL_DATABASE, WNL_TABLE, WNL_PARTITION); + INSERT INTO SEQUENCE_TABLE (SEQUENCE_NAME, NEXT_VAL) VALUES ('org.apache.hadoop.hive.metastore.model.MTxnWriteNotificationLog', 1); -- ----------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/4ab0d1b8/standalone-metastore/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql b/standalone-metastore/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql index 7733f17..f21e872 100644 --- a/standalone-metastore/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql +++ b/standalone-metastore/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql @@ -7,13 +7,15 @@ CREATE TABLE TXN_WRITE_NOTIFICATION_LOG ( WNL_WRITEID number(19) NOT NULL, WNL_DATABASE varchar(128) NOT NULL, WNL_TABLE varchar(128) NOT NULL, - WNL_PARTITION varchar(767) NOT NULL, + WNL_PARTITION varchar(767), WNL_TABLE_OBJ clob NOT NULL, WNL_PARTITION_OBJ clob, WNL_FILES clob, - WNL_EVENT_TIME number(10) NOT NULL, - PRIMARY KEY (WNL_TXNID, WNL_DATABASE, WNL_TABLE, WNL_PARTITION) + WNL_EVENT_TIME number(10) NOT NULL ); + +CREATE INDEX TXN_WRITE_NOTIFICATION_LOG_IDX ON TXN_WRITE_NOTIFICATION_LOG (WNL_TXNID, WNL_DATABASE, WNL_TABLE, WNL_PARTITION); + INSERT INTO SEQUENCE_TABLE (SEQUENCE_NAME, NEXT_VAL) VALUES ('org.apache.hadoop.hive.metastore.model.MTxnWriteNotificationLog', 1); -- These lines need to be last. Insert any changes above.