upgrade-0.6.0.postgres.sql 1.6 KB

123456789101112131415161718192021222324252627
  1. -- HIVE-972: Support views
  2. ALTER TABLE "TBLS" ADD COLUMN "VIEW_EXPANDED_TEXT" text;
  3. ALTER TABLE "TBLS" ADD COLUMN "VIEW_ORIGINAL_TEXT" text;
  4. -- HIVE-1068: CREATE VIEW followup: add a 'table type' enum
  5. -- attribute in metastore
  6. ALTER TABLE "TBLS" ADD COLUMN "TBL_TYPE" character varying(128);
  7. -- HIVE-675: Add database/schema support for Hive QL
  8. ALTER TABLE "DBS" ALTER "DESC" TYPE character varying(4000);
  9. ALTER TABLE "DBS" ADD COLUMN "DB_LOCATION_URI" character varying(4000) NOT NULL DEFAULT ''::character varying;
  10. -- HIVE-1364: Increase the maximum length of various metastore fields,
  11. -- and remove TYPE_NAME from COLUMNS primary key
  12. ALTER TABLE "TBLS" ALTER "OWNER" TYPE character varying(767);
  13. ALTER TABLE "COLUMNS" ALTER "TYPE_NAME" TYPE character varying(4000);
  14. ALTER TABLE "PARTITION_KEYS" ALTER "PKEY_COMMENT" TYPE character varying(4000);
  15. ALTER TABLE "SD_PARAMS" ALTER "PARAM_VALUE" TYPE character varying(4000);
  16. ALTER TABLE "SDS" ALTER "INPUT_FORMAT" TYPE character varying(4000);
  17. ALTER TABLE "SDS" ALTER "LOCATION" TYPE character varying(4000);
  18. ALTER TABLE "SDS" ALTER "OUTPUT_FORMAT" TYPE character varying(4000);
  19. ALTER TABLE "SERDE_PARAMS" ALTER "PARAM_VALUE" TYPE character varying(4000);
  20. ALTER TABLE "SERDES" ALTER "SLIB" TYPE character varying(4000);
  21. ALTER TABLE "TABLE_PARAMS" ALTER "PARAM_VALUE" TYPE character varying(4000);
  22. ALTER TABLE "COLUMNS" DROP CONSTRAINT "COLUMNS_pkey";
  23. ALTER TABLE "COLUMNS" ADD CONSTRAINT "COLUMNS_pkey" PRIMARY KEY ("SD_ID", "COLUMN_NAME");
  24. ALTER TABLE "PARTITION_PARAMS" ALTER "PARAM_VALUE" TYPE character varying(4000);