hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From c..@apache.org
Subject svn commit: r1170346 - in /hive/branches/branch-0.8/metastore/scripts/upgrade: derby/009-HIVE-2215.derby.sql mysql/009-HIVE-2215.mysql.sql postgres/009-HIVE-2215.postgres.sql
Date Tue, 13 Sep 2011 21:02:38 GMT
Author: cws
Date: Tue Sep 13 21:02:37 2011
New Revision: 1170346

URL: http://svn.apache.org/viewvc?rev=1170346&view=rev
Log:
HIVE-2441. Metastore upgrade scripts for schema change introduced in HIVE-2215 (Ashutosh Chauhan
via cws)

Added:
    hive/branches/branch-0.8/metastore/scripts/upgrade/derby/009-HIVE-2215.derby.sql
    hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/009-HIVE-2215.mysql.sql
    hive/branches/branch-0.8/metastore/scripts/upgrade/postgres/009-HIVE-2215.postgres.sql

Added: hive/branches/branch-0.8/metastore/scripts/upgrade/derby/009-HIVE-2215.derby.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.8/metastore/scripts/upgrade/derby/009-HIVE-2215.derby.sql?rev=1170346&view=auto
==============================================================================
--- hive/branches/branch-0.8/metastore/scripts/upgrade/derby/009-HIVE-2215.derby.sql (added)
+++ hive/branches/branch-0.8/metastore/scripts/upgrade/derby/009-HIVE-2215.derby.sql Tue Sep
13 21:02:37 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/branches/branch-0.8/metastore/scripts/upgrade/mysql/009-HIVE-2215.mysql.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/009-HIVE-2215.mysql.sql?rev=1170346&view=auto
==============================================================================
--- hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/009-HIVE-2215.mysql.sql (added)
+++ hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/009-HIVE-2215.mysql.sql Tue Sep
13 21:02:37 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/branches/branch-0.8/metastore/scripts/upgrade/postgres/009-HIVE-2215.postgres.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.8/metastore/scripts/upgrade/postgres/009-HIVE-2215.postgres.sql?rev=1170346&view=auto
==============================================================================
--- hive/branches/branch-0.8/metastore/scripts/upgrade/postgres/009-HIVE-2215.postgres.sql
(added)
+++ hive/branches/branch-0.8/metastore/scripts/upgrade/postgres/009-HIVE-2215.postgres.sql
Tue Sep 13 21:02:37 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");
+
+



Mime
View raw message