PageRenderTime 20ms CodeModel.GetById 8ms app.highlight 8ms RepoModel.GetById 1ms app.codeStats 1ms

/tags/release-0.1-rc2/hive/external/metastore/scripts/upgrade/mysql/004-HIVE-1364.mysql.sql

#
SQL | 14 lines | 14 code | 0 blank | 0 comment | 0 complexity | d46913c0480fd83dab7235266d6b09e1 MD5 | raw file
 1SELECT '< HIVE-1364: Increase the maximum length of various metastore fields >' AS ' ';
 2ALTER TABLE `TBLS` MODIFY `OWNER` VARCHAR(767);
 3ALTER TABLE `COLUMNS` DROP PRIMARY KEY;
 4ALTER TABLE `COLUMNS` ADD PRIMARY KEY (`SD_ID`, `COLUMN_NAME`);
 5ALTER TABLE `COLUMNS` MODIFY `TYPE_NAME` VARCHAR(4000);
 6ALTER TABLE `PARTITION_KEYS` MODIFY `PKEY_COMMENT` VARCHAR(4000);
 7ALTER TABLE `SD_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000);
 8ALTER TABLE `SDS` MODIFY `INPUT_FORMAT` VARCHAR(4000);
 9ALTER TABLE `SDS` MODIFY `LOCATION` VARCHAR(4000);
10ALTER TABLE `SDS` MODIFY `OUTPUT_FORMAT` VARCHAR(4000);
11ALTER TABLE `SERDE_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000);
12ALTER TABLE `SERDES` MODIFY `SLIB` VARCHAR(4000);
13ALTER TABLE `TABLE_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000);
14ALTER TABLE `PARTITION_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000);