| SELECT '< HIVE-1364: Increase the maximum length of various metastore fields >' AS ' '; |
| ALTER TABLE `TBLS` MODIFY `OWNER` VARCHAR(767); |
| ALTER TABLE `COLUMNS` DROP PRIMARY KEY; |
| ALTER TABLE `COLUMNS` ADD PRIMARY KEY (`SD_ID`, `COLUMN_NAME`); |
| 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 `PARTITION_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000); |
