You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by da...@apache.org on 2018/08/17 21:34:53 UTC
hive git commit: HIVE-20413: "cannot insert NULL" for
TXN_WRITE_NOTIFICATION_LOG in Oracle (Daniel Dai, reviewed by Thejas Nair)
Repository: hive
Updated Branches:
refs/heads/master 5681647b7 -> 5449dffc2
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/5449dffc
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/5449dffc
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/5449dffc
Branch: refs/heads/master
Commit: 5449dffc2cb3d0b9c0ba22eadc98d72f6d561d55
Parents: 5681647
Author: Daniel Dai <da...@gmail.com>
Authored: Fri Aug 17 14:34:26 2018 -0700
Committer: Daniel Dai <da...@gmail.com>
Committed: Fri Aug 17 14:34:26 2018 -0700
----------------------------------------------------------------------
.../src/main/sql/oracle/hive-schema-3.2.0.oracle.sql | 7 ++++---
.../src/main/sql/oracle/hive-schema-4.0.0.oracle.sql | 7 ++++---
.../src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql | 8 +++++---
3 files changed, 13 insertions(+), 9 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/5449dffc/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql
index 886570a..c0df830 100644
--- a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql
+++ b/standalone-metastore/metastore-server/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/5449dffc/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
index 2c5d6b2..33aa080 100644
--- a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
+++ b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
@@ -1161,14 +1161,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/5449dffc/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql
index bbf743f..c5e48a1 100644
--- a/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql
+++ b/standalone-metastore/metastore-server/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);
-- HIVE-20221