hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From khorg...@apache.org
Subject svn commit: r1651918 - in /hive/trunk/metastore: scripts/upgrade/derby/ scripts/upgrade/mssql/ scripts/upgrade/mysql/ scripts/upgrade/oracle/ scripts/upgrade/postgres/ src/model/
Date Thu, 15 Jan 2015 00:57:13 GMT
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>
 



Mime
View raw message