You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by kh...@apache.org on 2015/01/15 01:57:13 UTC
svn commit: r1651918 - in /hive/trunk/metastore: scripts/upgrade/derby/
scripts/upgrade/mssql/ scripts/upgrade/mysql/ scripts/upgrade/oracle/
scripts/upgrade/postgres/ src/model/
Author: khorgath
Date: Thu Jan 15 00:57:12 2015
New Revision: 1651918
URL: http://svn.apache.org/r1651918
Log:
HIVE-9321 : Notification message size can be arbitrarily long, DbNotificationListener limits to 1024 (Alan Gates via Sushanth Sowmyan)
Modified:
hive/trunk/metastore/scripts/upgrade/derby/020-HIVE-9296.derby.sql
hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.15.0.derby.sql
hive/trunk/metastore/scripts/upgrade/mssql/005-HIVE-9296.mssql.sql
hive/trunk/metastore/scripts/upgrade/mssql/hive-schema-0.15.0.mssql.sql
hive/trunk/metastore/scripts/upgrade/mysql/020-HIVE-9296.mysql.sql
hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.15.0.mysql.sql
hive/trunk/metastore/scripts/upgrade/oracle/021-HIVE-9296.oracle.sql
hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.15.0.oracle.sql
hive/trunk/metastore/scripts/upgrade/postgres/020-HIVE-9296.postgres.sql
hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.15.0.postgres.sql
hive/trunk/metastore/src/model/package.jdo
Modified: hive/trunk/metastore/scripts/upgrade/derby/020-HIVE-9296.derby.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/derby/020-HIVE-9296.derby.sql?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/derby/020-HIVE-9296.derby.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/derby/020-HIVE-9296.derby.sql Thu Jan 15 00:57:12 2015
@@ -1,4 +1,4 @@
-CREATE TABLE "APP"."NOTIFICATION_LOG" ("NL_ID" BIGINT NOT NULL, "DB_NAME" VARCHAR(128), "EVENT_ID" BIGINT NOT NULL, "EVENT_TIME" INTEGER NOT NULL, "EVENT_TYPE" VARCHAR(32) NOT NULL, "MESSAGE" VARCHAR(1024) NOT NULL, "TBL_NAME" VARCHAR(128));
+CREATE TABLE "APP"."NOTIFICATION_LOG" ("NL_ID" BIGINT NOT NULL, "DB_NAME" VARCHAR(128), "EVENT_ID" BIGINT NOT NULL, "EVENT_TIME" INTEGER NOT NULL, "EVENT_TYPE" VARCHAR(32) NOT NULL, "MESSAGE" LONG VARCHAR, "TBL_NAME" VARCHAR(128));
CREATE TABLE "APP"."NOTIFICATION_SEQUENCE" ("NNI_ID" BIGINT NOT NULL, "NEXT_EVENT_ID" BIGINT NOT NULL);
Modified: hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.15.0.derby.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.15.0.derby.sql?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.15.0.derby.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.15.0.derby.sql Thu Jan 15 00:57:12 2015
@@ -104,7 +104,7 @@ CREATE TABLE "APP"."FUNCS" ("FUNC_ID" BI
CREATE TABLE "APP"."FUNC_RU" ("FUNC_ID" BIGINT NOT NULL, "RESOURCE_TYPE" INTEGER NOT NULL, "RESOURCE_URI" VARCHAR(4000), "INTEGER_IDX" INTEGER NOT NULL);
-CREATE TABLE "APP"."NOTIFICATION_LOG" ("NL_ID" BIGINT NOT NULL, "DB_NAME" VARCHAR(128), "EVENT_ID" BIGINT NOT NULL, "EVENT_TIME" INTEGER NOT NULL, "EVENT_TYPE" VARCHAR(32) NOT NULL, "MESSAGE" VARCHAR(1024) NOT NULL, "TBL_NAME" VARCHAR(128));
+CREATE TABLE "APP"."NOTIFICATION_LOG" ("NL_ID" BIGINT NOT NULL, "DB_NAME" VARCHAR(128), "EVENT_ID" BIGINT NOT NULL, "EVENT_TIME" INTEGER NOT NULL, "EVENT_TYPE" VARCHAR(32) NOT NULL, "MESSAGE" LONG VARCHAR, "TBL_NAME" VARCHAR(128));
CREATE TABLE "APP"."NOTIFICATION_SEQUENCE" ("NNI_ID" BIGINT NOT NULL, "NEXT_EVENT_ID" BIGINT NOT NULL);
Modified: hive/trunk/metastore/scripts/upgrade/mssql/005-HIVE-9296.mssql.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/mssql/005-HIVE-9296.mssql.sql?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/mssql/005-HIVE-9296.mssql.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/mssql/005-HIVE-9296.mssql.sql Thu Jan 15 00:57:12 2015
@@ -6,7 +6,7 @@ CREATE TABLE NOTIFICATION_LOG
EVENT_TYPE varchar(32) NOT NULL,
DB_NAME varchar(128) NULL,
TBL_NAME varchar(128) NULL,
- MESSAGE varchar(1024) NOT NULL
+ MESSAGE text NULL
);
GO
Modified: hive/trunk/metastore/scripts/upgrade/mssql/hive-schema-0.15.0.mssql.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/mssql/hive-schema-0.15.0.mssql.sql?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/mssql/hive-schema-0.15.0.mssql.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/mssql/hive-schema-0.15.0.mssql.sql Thu Jan 15 00:57:12 2015
@@ -578,7 +578,7 @@ CREATE TABLE NOTIFICATION_LOG
EVENT_TYPE varchar(32) NOT NULL,
DB_NAME varchar(128) NULL,
TBL_NAME varchar(128) NULL,
- MESSAGE varchar(1024) NOT NULL
+ MESSAGE text NULL
);
ALTER TABLE NOTIFICATION_LOG ADD CONSTRAINT NOTIFICATION_LOG_PK PRIMARY KEY (NL_ID);
Modified: hive/trunk/metastore/scripts/upgrade/mysql/020-HIVE-9296.mysql.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/mysql/020-HIVE-9296.mysql.sql?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/mysql/020-HIVE-9296.mysql.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/mysql/020-HIVE-9296.mysql.sql Thu Jan 15 00:57:12 2015
@@ -6,7 +6,7 @@ CREATE TABLE IF NOT EXISTS `NOTIFICATION
`EVENT_TYPE` varchar(32) NOT NULL,
`DB_NAME` varchar(128),
`TBL_NAME` varchar(128),
- `MESSAGE` varchar(1024) NOT NULL,
+ `MESSAGE` mediumtext,
PRIMARY KEY (`NL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Modified: hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.15.0.mysql.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.15.0.mysql.sql?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.15.0.mysql.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.15.0.mysql.sql Thu Jan 15 00:57:12 2015
@@ -803,7 +803,7 @@ CREATE TABLE IF NOT EXISTS `NOTIFICATION
`EVENT_TYPE` varchar(32) NOT NULL,
`DB_NAME` varchar(128),
`TBL_NAME` varchar(128),
- `MESSAGE` varchar(1024) NOT NULL,
+ `MESSAGE` mediumtext,
PRIMARY KEY (`NL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Modified: hive/trunk/metastore/scripts/upgrade/oracle/021-HIVE-9296.oracle.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/oracle/021-HIVE-9296.oracle.sql?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/oracle/021-HIVE-9296.oracle.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/oracle/021-HIVE-9296.oracle.sql Thu Jan 15 00:57:12 2015
@@ -6,7 +6,7 @@ CREATE TABLE NOTIFICATION_LOG
EVENT_TYPE VARCHAR2(32) NOT NULL,
DB_NAME VARCHAR2(128),
TBL_NAME VARCHAR2(128),
- MESSAGE VARCHAR2(1024) NOT NULL
+ MESSAGE CLOB NULL
);
ALTER TABLE NOTIFICATION_LOG ADD CONSTRAINT NOTIFICATION_LOG_PK PRIMARY KEY (NL_ID);
Modified: hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.15.0.oracle.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.15.0.oracle.sql?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.15.0.oracle.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.15.0.oracle.sql Thu Jan 15 00:57:12 2015
@@ -559,7 +559,7 @@ CREATE TABLE NOTIFICATION_LOG
EVENT_TYPE VARCHAR2(32) NOT NULL,
DB_NAME VARCHAR2(128),
TBL_NAME VARCHAR2(128),
- MESSAGE VARCHAR2(1024) NOT NULL
+ MESSAGE CLOB NULL
);
ALTER TABLE NOTIFICATION_LOG ADD CONSTRAINT NOTIFICATION_LOG_PK PRIMARY KEY (NL_ID);
Modified: hive/trunk/metastore/scripts/upgrade/postgres/020-HIVE-9296.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/020-HIVE-9296.postgres.sql?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/020-HIVE-9296.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/020-HIVE-9296.postgres.sql Thu Jan 15 00:57:12 2015
@@ -6,7 +6,7 @@ CREATE TABLE "NOTIFICATION_LOG"
"EVENT_TYPE" VARCHAR(32) NOT NULL,
"DB_NAME" VARCHAR(128),
"TBL_NAME" VARCHAR(128),
- "MESSAGE" VARCHAR(1024) NOT NULL,
+ "MESSAGE" text,
PRIMARY KEY ("NL_ID")
);
Modified: hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.15.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.15.0.postgres.sql?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.15.0.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.15.0.postgres.sql Thu Jan 15 00:57:12 2015
@@ -587,7 +587,7 @@ CREATE TABLE "NOTIFICATION_LOG"
"EVENT_TYPE" VARCHAR(32) NOT NULL,
"DB_NAME" VARCHAR(128),
"TBL_NAME" VARCHAR(128),
- "MESSAGE" VARCHAR(1024) NOT NULL,
+ "MESSAGE" text,
PRIMARY KEY ("NL_ID")
);
Modified: hive/trunk/metastore/src/model/package.jdo
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/src/model/package.jdo?rev=1651918&r1=1651917&r2=1651918&view=diff
==============================================================================
--- hive/trunk/metastore/src/model/package.jdo (original)
+++ hive/trunk/metastore/src/model/package.jdo Thu Jan 15 00:57:12 2015
@@ -1005,7 +1005,7 @@
<column name="TBL_NAME" length="128" jdbc-type="VARCHAR" allows-null="true"/>
</field>
<field name="message">
- <column name="MESSAGE" length="1024" jdbc-type="VARCHAR" allows-null="false"/>
+ <column name="MESSAGE" jdbc-type="LONGVARCHAR"/>
</field>
</class>