diff --git metastore/scripts/upgrade/derby/README metastore/scripts/upgrade/derby/README new file mode 100644 index 0000000..506eb54 --- /dev/null +++ metastore/scripts/upgrade/derby/README @@ -0,0 +1,17 @@ + +1) Shutdown your metastore instance. + +2) Perform a backup of your Derby metastore database. Probably + the easiest way of doing this is to just create a copy of the + Derby database "metastore_db" directory. + +3) Execute the upgrade script: + % ij + ij version 10.4 + ij> CONNECT 'jdbc:derby:/Users/bob/hive/metastore_db;databaseName=metastore_db'; + ij> RUN 'upgrade-0.6.0.derby.sql'; + ij> quit; + +NOTE: You may need to install the Derby 'ij' utility. + Look here for installation instructions: + http://db.apache.org/derby/docs/10.4/getstart/ diff --git metastore/scripts/upgrade/derby/upgrade-0.6.0.derby.sql metastore/scripts/upgrade/derby/upgrade-0.6.0.derby.sql new file mode 100644 index 0000000..a0e2084 --- /dev/null +++ metastore/scripts/upgrade/derby/upgrade-0.6.0.derby.sql @@ -0,0 +1,26 @@ +-- HIVE-972: Support views +ALTER TABLE "TBLS" ADD "VIEW_ORIGINAL_TEXT" LONG VARCHAR DEFAULT NULL; +ALTER TABLE "TBLS" ADD "VIEW_EXPANDED_TEXT" LONG VARCHAR DEFAULT NULL; + +-- HIVE-1068: CREATE VIEW followup: add a 'table type' enum +-- attribute in metastore +ALTER TABLE "TBLS" ADD COLUMN "TBL_TYPE" VARCHAR(128); + +-- HIVE-675: Add database/schema support for Hive QL +ALTER TABLE "DBS" ALTER "DESC" SET DATA TYPE VARCHAR(4000); +ALTER TABLE "DBS" ADD "DB_LOCATION_URI" VARCHAR(4000) NOT NULL DEFAULT ''; + +-- HIVE-1364: Increase the maximum length of various metastore fields, +-- and remove TYPE_NAME from COLUMNS primary key +ALTER TABLE "TBLS" ALTER "OWNER" SET DATA TYPE VARCHAR(767); +ALTER TABLE "COLUMNS" ALTER "TYPE_NAME" SET DATA TYPE VARCHAR(4000); +ALTER TABLE "PARTITION_KEYS" ALTER "PKEY_COMMENT" SET DATA TYPE VARCHAR(4000); +ALTER TABLE "SD_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000); +ALTER TABLE "SDS" ALTER "INPUT_FORMAT" SET DATA TYPE VARCHAR(4000); +ALTER TABLE "SDS" ALTER "LOCATION" SET DATA TYPE VARCHAR(4000); +ALTER TABLE "SDS" ALTER "OUTPUT_FORMAT" SET DATA TYPE VARCHAR(4000); +ALTER TABLE "SERDE_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000); +ALTER TABLE "SERDES" ALTER "SLIB" SET DATA TYPE VARCHAR(4000); +ALTER TABLE "TABLE_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000); +ALTER TABLE "COLUMNS" DROP PRIMARY KEY; +ALTER TABLE "COLUMNS" ADD PRIMARY KEY ("SD_ID", "COLUMN_NAME"); diff --git metastore/scripts/upgrade/mysql/README metastore/scripts/upgrade/mysql/README new file mode 100644 index 0000000..3d4360f --- /dev/null +++ metastore/scripts/upgrade/mysql/README @@ -0,0 +1,9 @@ + +1) Shutdown your metastore instance. + +2) Perform a backup of your MySQL metastore database: + % mysqldump --opt > metastore_backup.sql + +3) Execute the upgrade script: + % mysql --user= --password= \ + < upgrade-0.6.0.mysql.sql diff --git metastore/scripts/upgrade/mysql/upgrade-0.6.0.mysql.sql metastore/scripts/upgrade/mysql/upgrade-0.6.0.mysql.sql new file mode 100644 index 0000000..5ffac2a --- /dev/null +++ metastore/scripts/upgrade/mysql/upgrade-0.6.0.mysql.sql @@ -0,0 +1,26 @@ +-- HIVE-972: Support views +ALTER TABLE `TBLS` ADD `VIEW_EXPANDED_TEXT` mediumtext; +ALTER TABLE `TBLS` ADD `VIEW_ORIGINAL_TEXT` mediumtext; + +-- HIVE-1068: CREATE VIEW followup: add a 'table type' enum +-- attribute in metastore +ALTER TABLE `TBLS` ADD `TBL_TYPE` VARCHAR(128); + +-- HIVE-675: Add database/schema support for Hive QL +ALTER TABLE `DBS` MODIFY `DESC` VARCHAR(4000); +ALTER TABLE `DBS` ADD `DB_LOCATION_URI` VARCHAR(4000) NOT NULL DEFAULT ''; + +-- HIVE-1364: Increase the maximum length of various metastore fields, +-- and remove TYPE_NAME from COLUMNS primary key +ALTER TABLE `TBLS` MODIFY `OWNER` VARCHAR(767); +ALTER TABLE `COLUMNS` MODIFY `TYPE_NAME` VARCHAR(4000); +ALTER TABLE `PARTITION_KEYS` MODIFY `PKEY_COMMENT` VARCHAR(4000); +ALTER TABLE `SD_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000); +ALTER TABLE `SDS` MODIFY `INPUT_FORMAT` VARCHAR(4000); +ALTER TABLE `SDS` MODIFY `LOCATION` VARCHAR(4000); +ALTER TABLE `SDS` MODIFY `OUTPUT_FORMAT` VARCHAR(4000); +ALTER TABLE `SERDE_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000); +ALTER TABLE `SERDES` MODIFY `SLIB` VARCHAR(4000); +ALTER TABLE `TABLE_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000); +ALTER TABLE `COLUMNS` DROP PRIMARY KEY; +ALTER TABLE `COLUMNS` ADD PRIMARY KEY (`SD_ID`, `COLUMN_NAME`);