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

# · SQL · 15 lines · 13 code · 0 blank · 2 comment · 0 complexity · 16353d6d158dd614aa7d0300a922d353 MD5 · raw file 

    

  1. -- HIVE-1364: Increase the maximum length of various metastore fields,
    2. 

  2. --            and remove TYPE_NAME from COLUMNS primary key
    3. 

  3. ALTER TABLE "TBLS" ALTER "OWNER" SET DATA TYPE VARCHAR(767);
    4. 

  4. ALTER TABLE "COLUMNS" DROP PRIMARY KEY;
    5. 

  5. ALTER TABLE "COLUMNS" ADD PRIMARY KEY ("SD_ID", "COLUMN_NAME");
    6. 

  6. ALTER TABLE "COLUMNS" ALTER "TYPE_NAME" SET DATA TYPE VARCHAR(4000);
    7. 

  7. ALTER TABLE "PARTITION_KEYS" ALTER "PKEY_COMMENT" SET DATA TYPE VARCHAR(4000);
    8. 

  8. ALTER TABLE "SD_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000);
    9. 

  9. ALTER TABLE "SDS" ALTER "INPUT_FORMAT" SET DATA TYPE VARCHAR(4000);
    10. 

  10. ALTER TABLE "SDS" ALTER "LOCATION" SET DATA TYPE VARCHAR(4000);
    11. 

  11. ALTER TABLE "SDS" ALTER "OUTPUT_FORMAT" SET DATA TYPE VARCHAR(4000);
    12. 

  12. ALTER TABLE "SERDE_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000);
    13. 

  13. ALTER TABLE "SERDES" ALTER "SLIB" SET DATA TYPE VARCHAR(4000);
    14. 

  14. ALTER TABLE "TABLE_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000);
    15. 

  15. ALTER TABLE "PARTITION_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000);
    16.