svn commit: r1022312 - in /hadoop/hive/trunk: CHANGES.txt metastore/scripts/upgrade/postgres/ metastore/scripts/upgrade/postgres/upgrade-0.6.0.postgres.sql

[na...@apache.org]

Author: namit
Date: Wed Oct 13 22:10:44 2010
New Revision: 1022312

URL: http://svn.apache.org/viewvc?rev=1022312&view=rev
Log:
HIVE-1709. Add Postgres metastore schema migration scripts (0.5 -> 0.6)
(Yuanjun Li via namit)


Added:
    hadoop/hive/trunk/metastore/scripts/upgrade/postgres/
    hadoop/hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.6.0.postgres.sql
Modified:
    hadoop/hive/trunk/CHANGES.txt

Modified: hadoop/hive/trunk/CHANGES.txt
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/CHANGES.txt?rev=1022312&r1=1022311&r2=1022312&view=diff
==============================================================================
--- hadoop/hive/trunk/CHANGES.txt (original)
+++ hadoop/hive/trunk/CHANGES.txt Wed Oct 13 22:10:44 2010
@@ -98,6 +98,9 @@ Trunk -  Unreleased
     HIVE-537. Hive TypeInfo/ObjectInspector to support union
     (Amareshwari Sriramadasu via namit)
 
+    HIVE-1709. Add Postgres metastore schema migration scripts (0.5 -> 0.6)
+    (Yuanjun Li via namit)
+
   IMPROVEMENTS
 
     HIVE-1394. Do not update transient_lastDdlTime if the partition is modified by a housekeeping

Added: hadoop/hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.6.0.postgres.sql
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.6.0.postgres.sql?rev=1022312&view=auto
==============================================================================
--- hadoop/hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.6.0.postgres.sql (added)
+++ hadoop/hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.6.0.postgres.sql Wed Oct 13 22:10:44 2010
@@ -0,0 +1,27 @@
+-- HIVE-972: Support views
+ALTER TABLE "TBLS" ADD COLUMN "VIEW_EXPANDED_TEXT" text;
+ALTER TABLE "TBLS" ADD COLUMN "VIEW_ORIGINAL_TEXT" text;
+
+-- HIVE-1068: CREATE VIEW followup: add a 'table type' enum
+--            attribute in metastore
+ALTER TABLE "TBLS" ADD COLUMN "TBL_TYPE" character varying(128);
+
+-- HIVE-675: Add database/schema support for Hive QL
+ALTER TABLE "DBS" ALTER "DESC" TYPE character varying(4000);
+ALTER TABLE "DBS" ADD COLUMN "DB_LOCATION_URI" character varying(4000) NOT NULL DEFAULT ''::character varying;
+
+-- HIVE-1364: Increase the maximum length of various metastore fields,
+--            and remove TYPE_NAME from COLUMNS primary key
+ALTER TABLE "TBLS" ALTER "OWNER" TYPE character varying(767);
+ALTER TABLE "COLUMNS" ALTER "TYPE_NAME" TYPE character varying(4000);
+ALTER TABLE "PARTITION_KEYS" ALTER "PKEY_COMMENT" TYPE character varying(4000);
+ALTER TABLE "SD_PARAMS" ALTER "PARAM_VALUE" TYPE character varying(4000);
+ALTER TABLE "SDS" ALTER "INPUT_FORMAT" TYPE character varying(4000);
+ALTER TABLE "SDS" ALTER "LOCATION" TYPE character varying(4000);
+ALTER TABLE "SDS" ALTER "OUTPUT_FORMAT" TYPE character varying(4000);
+ALTER TABLE "SERDE_PARAMS" ALTER "PARAM_VALUE" TYPE character varying(4000);
+ALTER TABLE "SERDES" ALTER "SLIB" TYPE character varying(4000);
+ALTER TABLE "TABLE_PARAMS" ALTER "PARAM_VALUE" TYPE character varying(4000);
+ALTER TABLE "COLUMNS" DROP CONSTRAINT "COLUMNS_pkey";
+ALTER TABLE "COLUMNS" ADD CONSTRAINT "COLUMNS_pkey" PRIMARY KEY ("SD_ID", "COLUMN_NAME");
+ALTER TABLE "PARTITION_PARAMS" ALTER "PARAM_VALUE" TYPE character varying(4000);