You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by cw...@apache.org on 2011/09/13 23:01:36 UTC
svn commit: r1170344 - in /hive/trunk/metastore/scripts/upgrade:
derby/009-HIVE-2215.derby.sql mysql/009-HIVE-2215.mysql.sql
postgres/009-HIVE-2215.postgres.sql
Author: cws
Date: Tue Sep 13 21:01:36 2011
New Revision: 1170344
URL: http://svn.apache.org/viewvc?rev=1170344&view=rev
Log:
HIVE-2441. Metastore upgrade scripts for schema change introduced in HIVE-2215 (Ashutosh Chauhan via cws)
Added:
hive/trunk/metastore/scripts/upgrade/derby/009-HIVE-2215.derby.sql
hive/trunk/metastore/scripts/upgrade/mysql/009-HIVE-2215.mysql.sql
hive/trunk/metastore/scripts/upgrade/postgres/009-HIVE-2215.postgres.sql
Added: hive/trunk/metastore/scripts/upgrade/derby/009-HIVE-2215.derby.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/derby/009-HIVE-2215.derby.sql?rev=1170344&view=auto
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/derby/009-HIVE-2215.derby.sql (added)
+++ hive/trunk/metastore/scripts/upgrade/derby/009-HIVE-2215.derby.sql Tue Sep 13 21:01:36 2011
@@ -0,0 +1,13 @@
+-- Table PARTITION_EVENTS for classes [org.apache.hadoop.hive.metastore.model.MPartitionEvent]
+CREATE TABLE PARTITION_EVENTS
+(
+ PART_NAME_ID BIGINT NOT NULL,
+ DB_NAME VARCHAR(128),
+ EVENT_TIME BIGINT NOT NULL,
+ EVENT_TYPE INTEGER NOT NULL,
+ PARTITION_NAME VARCHAR(767),
+ TBL_NAME VARCHAR(128)
+);
+
+ALTER TABLE PARTITION_EVENTS ADD CONSTRAINT PARTITION_EVENTS_PK PRIMARY KEY (PART_NAME_ID);
+
Added: hive/trunk/metastore/scripts/upgrade/mysql/009-HIVE-2215.mysql.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/mysql/009-HIVE-2215.mysql.sql?rev=1170344&view=auto
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/mysql/009-HIVE-2215.mysql.sql (added)
+++ hive/trunk/metastore/scripts/upgrade/mysql/009-HIVE-2215.mysql.sql Tue Sep 13 21:01:36 2011
@@ -0,0 +1,18 @@
+-- Table `PARTITION_EVENTS` for classes [org.apache.hadoop.hive.metastore.model.MPartitionEvent]
+SELECT '< HIVE-2215 Add api for marking querying set of partitions for events >' AS ' ';
+
+CREATE TABLE IF NOT EXISTS `PARTITION_EVENTS`
+(
+ `PART_NAME_ID` BIGINT NOT NULL,
+ `DB_NAME` VARCHAR(128) BINARY NULL,
+ `EVENT_TIME` BIGINT NOT NULL,
+ `EVENT_TYPE` INTEGER NOT NULL,
+ `PARTITION_NAME` VARCHAR(767) BINARY NULL,
+ `TBL_NAME` VARCHAR(128) BINARY NULL,
+ PRIMARY KEY (`PART_NAME_ID`)
+) ENGINE=INNODB DEFAULT CHARSET=latin1;
+
+-- Constraints for table `PARTITION_EVENTS` for class(es) [org.apache.hadoop.hive.metastore.model.MPartitionEvent]
+CREATE INDEX `PARTITIONEVENTINDEX` ON `PARTITION_EVENTS` (`PARTITION_NAME`);
+
+
Added: hive/trunk/metastore/scripts/upgrade/postgres/009-HIVE-2215.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/009-HIVE-2215.postgres.sql?rev=1170344&view=auto
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/009-HIVE-2215.postgres.sql (added)
+++ hive/trunk/metastore/scripts/upgrade/postgres/009-HIVE-2215.postgres.sql Tue Sep 13 21:01:36 2011
@@ -0,0 +1,18 @@
+SELECT '< HIVE-2215 Add api for marking querying set of partitions for events >';
+
+-- Table "PARTITION_EVENTS" for classes [org.apache.hadoop.hive.metastore.model.MPartitionEvent]
+CREATE TABLE "PARTITION_EVENTS"
+(
+ "PART_NAME_ID" int8 NOT NULL,
+ "DB_NAME" varchar(128) NULL,
+ "EVENT_TIME" int8 NOT NULL,
+ "EVENT_TYPE" int4 NOT NULL,
+ "PARTITION_NAME" varchar(767) NULL,
+ "TBL_NAME" varchar(128) NULL,
+ PRIMARY KEY ("PART_NAME_ID")
+);
+
+-- Constraints for table "PARTITION_EVENTS" for class(es) [org.apache.hadoop.hive.metastore.model.MPartitionEvent]
+CREATE INDEX "PARTITIONEVENTINDEX" ON "PARTITION_EVENTS" ("PARTITION_NAME");
+
+