PageRenderTime 38ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. SELECT '< HIVE-1364: Increase the maximum length of various metastore fields >' AS ' ';
  2. ALTER TABLE `TBLS` MODIFY `OWNER` VARCHAR(767);
  3. ALTER TABLE `COLUMNS` DROP PRIMARY KEY;
  4. ALTER TABLE `COLUMNS` ADD PRIMARY KEY (`SD_ID`, `COLUMN_NAME`);
  5. ALTER TABLE `COLUMNS` MODIFY `TYPE_NAME` VARCHAR(4000);
  6. ALTER TABLE `PARTITION_KEYS` MODIFY `PKEY_COMMENT` VARCHAR(4000);
  7. ALTER TABLE `SD_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000);
  8. ALTER TABLE `SDS` MODIFY `INPUT_FORMAT` VARCHAR(4000);
  9. ALTER TABLE `SDS` MODIFY `LOCATION` VARCHAR(4000);
  10. ALTER TABLE `SDS` MODIFY `OUTPUT_FORMAT` VARCHAR(4000);
  11. ALTER TABLE `SERDE_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000);
  12. ALTER TABLE `SERDES` MODIFY `SLIB` VARCHAR(4000);
  13. ALTER TABLE `TABLE_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000);
  14. ALTER TABLE `PARTITION_PARAMS` MODIFY `PARAM_VALUE` VARCHAR(4000);