PageRenderTime 16ms CodeModel.GetById 12ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 1ms

/tags/release-0.0.0-rc0/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--            and remove TYPE_NAME from COLUMNS primary key
 3ALTER TABLE "TBLS" ALTER "OWNER" SET DATA TYPE VARCHAR(767);
 4ALTER TABLE "COLUMNS" DROP PRIMARY KEY;
 5ALTER TABLE "COLUMNS" ADD PRIMARY KEY ("SD_ID", "COLUMN_NAME");
 6ALTER TABLE "COLUMNS" ALTER "TYPE_NAME" SET DATA TYPE VARCHAR(4000);
 7ALTER TABLE "PARTITION_KEYS" ALTER "PKEY_COMMENT" SET DATA TYPE VARCHAR(4000);
 8ALTER TABLE "SD_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000);
 9ALTER TABLE "SDS" ALTER "INPUT_FORMAT" SET DATA TYPE VARCHAR(4000);
10ALTER TABLE "SDS" ALTER "LOCATION" SET DATA TYPE VARCHAR(4000);
11ALTER TABLE "SDS" ALTER "OUTPUT_FORMAT" SET DATA TYPE VARCHAR(4000);
12ALTER TABLE "SERDE_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000);
13ALTER TABLE "SERDES" ALTER "SLIB" SET DATA TYPE VARCHAR(4000);
14ALTER TABLE "TABLE_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000);
15ALTER TABLE "PARTITION_PARAMS" ALTER "PARAM_VALUE" SET DATA TYPE VARCHAR(4000);