FAQ
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>

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupcommits @
categorieshive, hadoop
postedJan 15, '15 at 12:57a
activeJan 15, '15 at 12:57a
posts1
users1
websitehive.apache.org

1 user in discussion

Khorgath: 1 post

People

Translate

site design / logo © 2021 Grokbase