HIVE-11970 : COLUMNS_V2 table in metastore should have a longer name field (Sergey Shelukhin, reviewed by Alan Gates)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/a953b436 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/a953b436 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/a953b436 Branch: refs/heads/llap Commit: a953b43628bf0dbbb9aadc4ae936e8c964534f3f Parents: 82bc0e1 Author: Sergey Shelukhin <ser...@apache.org> Authored: Thu Oct 1 14:09:36 2015 -0700 Committer: Sergey Shelukhin <ser...@apache.org> Committed: Thu Oct 1 14:09:36 2015 -0700 ---------------------------------------------------------------------- .../upgrade/derby/021-HIVE-11970.derby.sql | 6 +++++ .../upgrade/derby/hive-schema-1.3.0.derby.sql | 12 +++++----- .../upgrade/derby/hive-schema-2.0.0.derby.sql | 12 +++++----- .../derby/upgrade-1.2.0-to-1.3.0.derby.sql | 1 + .../derby/upgrade-1.2.0-to-2.0.0.derby.sql | 3 ++- .../upgrade/mssql/007-HIVE-11970.mssql.sql | 6 +++++ .../upgrade/mssql/hive-schema-1.3.0.mssql.sql | 12 +++++----- .../upgrade/mssql/hive-schema-2.0.0.mssql.sql | 12 +++++----- .../mssql/upgrade-1.2.0-to-1.3.0.mssql.sql | 1 + .../mssql/upgrade-1.2.0-to-2.0.0.mssql.sql | 7 +++--- .../upgrade/mysql/022-HIVE-11970.mysql.sql | 6 +++++ .../upgrade/mysql/hive-schema-1.3.0.mysql.sql | 12 +++++----- .../upgrade/mysql/hive-schema-2.0.0.mysql.sql | 12 +++++----- .../mysql/upgrade-1.2.0-to-1.3.0.mysql.sql | 1 + .../mysql/upgrade-1.2.0-to-2.0.0.mysql.sql | 2 ++ .../upgrade/oracle/022-HIVE-11970.oracle.sql | 23 ++++++++++++++++++++ .../upgrade/oracle/hive-schema-1.3.0.oracle.sql | 12 +++++----- .../upgrade/oracle/hive-schema-2.0.0.oracle.sql | 12 +++++----- .../oracle/upgrade-1.2.0-to-1.3.0.oracle.sql | 2 ++ .../oracle/upgrade-1.2.0-to-2.0.0.oracle.sql | 2 ++ .../postgres/021-HIVE-11970.postgres.sql | 6 +++++ .../postgres/hive-schema-1.3.0.postgres.sql | 12 +++++----- .../postgres/hive-schema-2.0.0.postgres.sql | 12 +++++----- .../upgrade-1.2.0-to-1.3.0.postgres.sql | 1 + .../upgrade-1.2.0-to-2.0.0.postgres.sql | 1 + 25 files changed, 124 insertions(+), 64 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/derby/021-HIVE-11970.derby.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/derby/021-HIVE-11970.derby.sql b/metastore/scripts/upgrade/derby/021-HIVE-11970.derby.sql new file mode 100644 index 0000000..6a01a53 --- /dev/null +++ b/metastore/scripts/upgrade/derby/021-HIVE-11970.derby.sql @@ -0,0 +1,6 @@ +ALTER TABLE "COLUMNS_V2" ALTER "COLUMN_NAME" SET DATA TYPE VARCHAR(1000); +ALTER TABLE "PART_COL_PRIVS" ALTER "COLUMN_NAME" SET DATA TYPE VARCHAR(1000); +ALTER TABLE "TBL_COL_PRIVS" ALTER "COLUMN_NAME" SET DATA TYPE VARCHAR(1000); +ALTER TABLE "SORT_COLS" ALTER "COLUMN_NAME" SET DATA TYPE VARCHAR(1000); +ALTER TABLE "TAB_COL_STATS" ALTER "COLUMN_NAME" SET DATA TYPE VARCHAR(1000); +ALTER TABLE "PART_COL_STATS" ALTER "COLUMN_NAME" SET DATA TYPE VARCHAR(1000); http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/derby/hive-schema-1.3.0.derby.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/derby/hive-schema-1.3.0.derby.sql b/metastore/scripts/upgrade/derby/hive-schema-1.3.0.derby.sql index c50375f..20eb326 100644 --- a/metastore/scripts/upgrade/derby/hive-schema-1.3.0.derby.sql +++ b/metastore/scripts/upgrade/derby/hive-schema-1.3.0.derby.sql @@ -22,13 +22,13 @@ CREATE TABLE "APP"."TBL_PRIVS" ("TBL_GRANT_ID" BIGINT NOT NULL, "CREATE_TIME" IN CREATE TABLE "APP"."DATABASE_PARAMS" ("DB_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(180) NOT NULL, "PARAM_VALUE" VARCHAR(4000)); -CREATE TABLE "APP"."TBL_COL_PRIVS" ("TBL_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(128), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "TBL_COL_PRIV" VARCHAR(128), "TBL_ID" BIGINT); +CREATE TABLE "APP"."TBL_COL_PRIVS" ("TBL_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(1000), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "TBL_COL_PRIV" VARCHAR(128), "TBL_ID" BIGINT); CREATE TABLE "APP"."SERDE_PARAMS" ("SERDE_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" VARCHAR(4000)); -CREATE TABLE "APP"."COLUMNS_V2" ("CD_ID" BIGINT NOT NULL, "COMMENT" VARCHAR(4000), "COLUMN_NAME" VARCHAR(128) NOT NULL, "TYPE_NAME" VARCHAR(4000), "INTEGER_IDX" INTEGER NOT NULL); +CREATE TABLE "APP"."COLUMNS_V2" ("CD_ID" BIGINT NOT NULL, "COMMENT" VARCHAR(4000), "COLUMN_NAME" VARCHAR(1000) NOT NULL, "TYPE_NAME" VARCHAR(4000), "INTEGER_IDX" INTEGER NOT NULL); -CREATE TABLE "APP"."SORT_COLS" ("SD_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(128), "ORDER" INTEGER NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); +CREATE TABLE "APP"."SORT_COLS" ("SD_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(1000), "ORDER" INTEGER NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); CREATE TABLE "APP"."CDS" ("CD_ID" BIGINT NOT NULL); @@ -64,7 +64,7 @@ CREATE TABLE "APP"."TBLS" ("TBL_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT N CREATE TABLE "APP"."PARTITION_KEYS" ("TBL_ID" BIGINT NOT NULL, "PKEY_COMMENT" VARCHAR(4000), "PKEY_NAME" VARCHAR(128) NOT NULL, "PKEY_TYPE" VARCHAR(767) NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); -CREATE TABLE "APP"."PART_COL_PRIVS" ("PART_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(128), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PART_ID" BIGINT, "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "PART_COL_PRIV" VARCHAR(128)); +CREATE TABLE "APP"."PART_COL_PRIVS" ("PART_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(1000), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PART_ID" BIGINT, "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "PART_COL_PRIV" VARCHAR(128)); CREATE TABLE "APP"."SDS" ("SD_ID" BIGINT NOT NULL, "INPUT_FORMAT" VARCHAR(4000), "IS_COMPRESSED" CHAR(1) NOT NULL, "LOCATION" VARCHAR(4000), "NUM_BUCKETS" INTEGER NOT NULL, "OUTPUT_FORMAT" VARCHAR(4000), "SERDE_ID" BIGINT, "CD_ID" BIGINT, "IS_STOREDASSUBDIRECTORIES" CHAR(1) NOT NULL); @@ -94,9 +94,9 @@ CREATE TABLE "APP"."MASTER_KEYS" ("KEY_ID" INTEGER NOT NULL generated always as CREATE TABLE "APP"."DELEGATION_TOKENS" ( "TOKEN_IDENT" VARCHAR(767) NOT NULL, "TOKEN" VARCHAR(767)); -CREATE TABLE "APP"."TAB_COL_STATS"("DB_NAME" VARCHAR(128) NOT NULL,"TABLE_NAME" VARCHAR(128) NOT NULL, "COLUMN_NAME" VARCHAR(128) NOT NULL, "COLUMN_TYPE" VARCHAR(128) NOT NULL, "LONG_LOW_VALUE" BIGINT, "LONG_HIGH_VALUE" BIGINT, "DOUBLE_LOW_VALUE" DOUBLE, "DOUBLE_HIGH_VALUE" DOUBLE, "BIG_DECIMAL_LOW_VALUE" VARCHAR(4000), "BIG_DECIMAL_HIGH_VALUE" VARCHAR(4000),"NUM_DISTINCTS" BIGINT, "NUM_NULLS" BIGINT NOT NULL, "AVG_COL_LEN" DOUBLE, "MAX_COL_LEN" BIGINT, "NUM_TRUES" BIGINT, "NUM_FALSES" BIGINT, "LAST_ANALYZED" BIGINT, "CS_ID" BIGINT NOT NULL, "TBL_ID" BIGINT NOT NULL); +CREATE TABLE "APP"."TAB_COL_STATS"("DB_NAME" VARCHAR(128) NOT NULL,"TABLE_NAME" VARCHAR(128) NOT NULL, "COLUMN_NAME" VARCHAR(1000) NOT NULL, "COLUMN_TYPE" VARCHAR(128) NOT NULL, "LONG_LOW_VALUE" BIGINT, "LONG_HIGH_VALUE" BIGINT, "DOUBLE_LOW_VALUE" DOUBLE, "DOUBLE_HIGH_VALUE" DOUBLE, "BIG_DECIMAL_LOW_VALUE" VARCHAR(4000), "BIG_DECIMAL_HIGH_VALUE" VARCHAR(4000),"NUM_DISTINCTS" BIGINT, "NUM_NULLS" BIGINT NOT NULL, "AVG_COL_LEN" DOUBLE, "MAX_COL_LEN" BIGINT, "NUM_TRUES" BIGINT, "NUM_FALSES" BIGINT, "LAST_ANALYZED" BIGINT, "CS_ID" BIGINT NOT NULL, "TBL_ID" BIGINT NOT NULL); -CREATE TABLE "APP"."PART_COL_STATS"("DB_NAME" VARCHAR(128) NOT NULL,"TABLE_NAME" VARCHAR(128) NOT NULL, "PARTITION_NAME" VARCHAR(767) NOT NULL, "COLUMN_NAME" VARCHAR(128) NOT NULL, "COLUMN_TYPE" VARCHAR(128) NOT NULL, "LONG_LOW_VALUE" BIGINT, "LONG_HIGH_VALUE" BIGINT, "DOUBLE_LOW_VALUE" DOUBLE, "DOUBLE_HIGH_VALUE" DOUBLE, "BIG_DECIMAL_LOW_VALUE" VARCHAR(4000), "BIG_DECIMAL_HIGH_VALUE" VARCHAR(4000),"NUM_DISTINCTS" BIGINT, "NUM_NULLS" BIGINT NOT NULL, "AVG_COL_LEN" DOUBLE, "MAX_COL_LEN" BIGINT, "NUM_TRUES" BIGINT, "NUM_FALSES" BIGINT, "LAST_ANALYZED" BIGINT, "CS_ID" BIGINT NOT NULL, "PART_ID" BIGINT NOT NULL); +CREATE TABLE "APP"."PART_COL_STATS"("DB_NAME" VARCHAR(128) NOT NULL,"TABLE_NAME" VARCHAR(128) NOT NULL, "PARTITION_NAME" VARCHAR(767) NOT NULL, "COLUMN_NAME" VARCHAR(1000) NOT NULL, "COLUMN_TYPE" VARCHAR(128) NOT NULL, "LONG_LOW_VALUE" BIGINT, "LONG_HIGH_VALUE" BIGINT, "DOUBLE_LOW_VALUE" DOUBLE, "DOUBLE_HIGH_VALUE" DOUBLE, "BIG_DECIMAL_LOW_VALUE" VARCHAR(4000), "BIG_DECIMAL_HIGH_VALUE" VARCHAR(4000),"NUM_DISTINCTS" BIGINT, "NUM_NULLS" BIGINT NOT NULL, "AVG_COL_LEN" DOUBLE, "MAX_COL_LEN" BIGINT, "NUM_TRUES" BIGINT, "NUM_FALSES" BIGINT, "LAST_ANALYZED" BIGINT, "CS_ID" BIGINT NOT NULL, "PART_ID" BIGINT NOT NULL); CREATE TABLE "APP"."VERSION" ("VER_ID" BIGINT NOT NULL, "SCHEMA_VERSION" VARCHAR(127) NOT NULL, "VERSION_COMMENT" VARCHAR(255)); http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/derby/hive-schema-2.0.0.derby.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/derby/hive-schema-2.0.0.derby.sql b/metastore/scripts/upgrade/derby/hive-schema-2.0.0.derby.sql index 1cc0a24..abc6bf4 100644 --- a/metastore/scripts/upgrade/derby/hive-schema-2.0.0.derby.sql +++ b/metastore/scripts/upgrade/derby/hive-schema-2.0.0.derby.sql @@ -22,13 +22,13 @@ CREATE TABLE "APP"."TBL_PRIVS" ("TBL_GRANT_ID" BIGINT NOT NULL, "CREATE_TIME" IN CREATE TABLE "APP"."DATABASE_PARAMS" ("DB_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(180) NOT NULL, "PARAM_VALUE" VARCHAR(4000)); -CREATE TABLE "APP"."TBL_COL_PRIVS" ("TBL_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(128), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "TBL_COL_PRIV" VARCHAR(128), "TBL_ID" BIGINT); +CREATE TABLE "APP"."TBL_COL_PRIVS" ("TBL_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(1000), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "TBL_COL_PRIV" VARCHAR(128), "TBL_ID" BIGINT); CREATE TABLE "APP"."SERDE_PARAMS" ("SERDE_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" VARCHAR(4000)); -CREATE TABLE "APP"."COLUMNS_V2" ("CD_ID" BIGINT NOT NULL, "COMMENT" VARCHAR(4000), "COLUMN_NAME" VARCHAR(128) NOT NULL, "TYPE_NAME" VARCHAR(4000), "INTEGER_IDX" INTEGER NOT NULL); +CREATE TABLE "APP"."COLUMNS_V2" ("CD_ID" BIGINT NOT NULL, "COMMENT" VARCHAR(4000), "COLUMN_NAME" VARCHAR(1000) NOT NULL, "TYPE_NAME" VARCHAR(4000), "INTEGER_IDX" INTEGER NOT NULL); -CREATE TABLE "APP"."SORT_COLS" ("SD_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(128), "ORDER" INTEGER NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); +CREATE TABLE "APP"."SORT_COLS" ("SD_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(1000), "ORDER" INTEGER NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); CREATE TABLE "APP"."CDS" ("CD_ID" BIGINT NOT NULL); @@ -64,7 +64,7 @@ CREATE TABLE "APP"."TBLS" ("TBL_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT N CREATE TABLE "APP"."PARTITION_KEYS" ("TBL_ID" BIGINT NOT NULL, "PKEY_COMMENT" VARCHAR(4000), "PKEY_NAME" VARCHAR(128) NOT NULL, "PKEY_TYPE" VARCHAR(767) NOT NULL, "INTEGER_IDX" INTEGER NOT NULL); -CREATE TABLE "APP"."PART_COL_PRIVS" ("PART_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(128), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PART_ID" BIGINT, "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "PART_COL_PRIV" VARCHAR(128)); +CREATE TABLE "APP"."PART_COL_PRIVS" ("PART_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(1000), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PART_ID" BIGINT, "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "PART_COL_PRIV" VARCHAR(128)); CREATE TABLE "APP"."SDS" ("SD_ID" BIGINT NOT NULL, "INPUT_FORMAT" VARCHAR(4000), "IS_COMPRESSED" CHAR(1) NOT NULL, "LOCATION" VARCHAR(4000), "NUM_BUCKETS" INTEGER NOT NULL, "OUTPUT_FORMAT" VARCHAR(4000), "SERDE_ID" BIGINT, "CD_ID" BIGINT, "IS_STOREDASSUBDIRECTORIES" CHAR(1) NOT NULL); @@ -94,9 +94,9 @@ CREATE TABLE "APP"."MASTER_KEYS" ("KEY_ID" INTEGER NOT NULL generated always as CREATE TABLE "APP"."DELEGATION_TOKENS" ( "TOKEN_IDENT" VARCHAR(767) NOT NULL, "TOKEN" VARCHAR(767)); -CREATE TABLE "APP"."TAB_COL_STATS"("DB_NAME" VARCHAR(128) NOT NULL,"TABLE_NAME" VARCHAR(128) NOT NULL, "COLUMN_NAME" VARCHAR(128) NOT NULL, "COLUMN_TYPE" VARCHAR(128) NOT NULL, "LONG_LOW_VALUE" BIGINT, "LONG_HIGH_VALUE" BIGINT, "DOUBLE_LOW_VALUE" DOUBLE, "DOUBLE_HIGH_VALUE" DOUBLE, "BIG_DECIMAL_LOW_VALUE" VARCHAR(4000), "BIG_DECIMAL_HIGH_VALUE" VARCHAR(4000),"NUM_DISTINCTS" BIGINT, "NUM_NULLS" BIGINT NOT NULL, "AVG_COL_LEN" DOUBLE, "MAX_COL_LEN" BIGINT, "NUM_TRUES" BIGINT, "NUM_FALSES" BIGINT, "LAST_ANALYZED" BIGINT, "CS_ID" BIGINT NOT NULL, "TBL_ID" BIGINT NOT NULL); +CREATE TABLE "APP"."TAB_COL_STATS"("DB_NAME" VARCHAR(128) NOT NULL,"TABLE_NAME" VARCHAR(128) NOT NULL, "COLUMN_NAME" VARCHAR(1000) NOT NULL, "COLUMN_TYPE" VARCHAR(128) NOT NULL, "LONG_LOW_VALUE" BIGINT, "LONG_HIGH_VALUE" BIGINT, "DOUBLE_LOW_VALUE" DOUBLE, "DOUBLE_HIGH_VALUE" DOUBLE, "BIG_DECIMAL_LOW_VALUE" VARCHAR(4000), "BIG_DECIMAL_HIGH_VALUE" VARCHAR(4000),"NUM_DISTINCTS" BIGINT, "NUM_NULLS" BIGINT NOT NULL, "AVG_COL_LEN" DOUBLE, "MAX_COL_LEN" BIGINT, "NUM_TRUES" BIGINT, "NUM_FALSES" BIGINT, "LAST_ANALYZED" BIGINT, "CS_ID" BIGINT NOT NULL, "TBL_ID" BIGINT NOT NULL); -CREATE TABLE "APP"."PART_COL_STATS"("DB_NAME" VARCHAR(128) NOT NULL,"TABLE_NAME" VARCHAR(128) NOT NULL, "PARTITION_NAME" VARCHAR(767) NOT NULL, "COLUMN_NAME" VARCHAR(128) NOT NULL, "COLUMN_TYPE" VARCHAR(128) NOT NULL, "LONG_LOW_VALUE" BIGINT, "LONG_HIGH_VALUE" BIGINT, "DOUBLE_LOW_VALUE" DOUBLE, "DOUBLE_HIGH_VALUE" DOUBLE, "BIG_DECIMAL_LOW_VALUE" VARCHAR(4000), "BIG_DECIMAL_HIGH_VALUE" VARCHAR(4000),"NUM_DISTINCTS" BIGINT, "NUM_NULLS" BIGINT NOT NULL, "AVG_COL_LEN" DOUBLE, "MAX_COL_LEN" BIGINT, "NUM_TRUES" BIGINT, "NUM_FALSES" BIGINT, "LAST_ANALYZED" BIGINT, "CS_ID" BIGINT NOT NULL, "PART_ID" BIGINT NOT NULL); +CREATE TABLE "APP"."PART_COL_STATS"("DB_NAME" VARCHAR(128) NOT NULL,"TABLE_NAME" VARCHAR(128) NOT NULL, "PARTITION_NAME" VARCHAR(767) NOT NULL, "COLUMN_NAME" VARCHAR(1000) NOT NULL, "COLUMN_TYPE" VARCHAR(128) NOT NULL, "LONG_LOW_VALUE" BIGINT, "LONG_HIGH_VALUE" BIGINT, "DOUBLE_LOW_VALUE" DOUBLE, "DOUBLE_HIGH_VALUE" DOUBLE, "BIG_DECIMAL_LOW_VALUE" VARCHAR(4000), "BIG_DECIMAL_HIGH_VALUE" VARCHAR(4000),"NUM_DISTINCTS" BIGINT, "NUM_NULLS" BIGINT NOT NULL, "AVG_COL_LEN" DOUBLE, "MAX_COL_LEN" BIGINT, "NUM_TRUES" BIGINT, "NUM_FALSES" BIGINT, "LAST_ANALYZED" BIGINT, "CS_ID" BIGINT NOT NULL, "PART_ID" BIGINT NOT NULL); CREATE TABLE "APP"."VERSION" ("VER_ID" BIGINT NOT NULL, "SCHEMA_VERSION" VARCHAR(127) NOT NULL, "VERSION_COMMENT" VARCHAR(255)); http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/derby/upgrade-1.2.0-to-1.3.0.derby.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/derby/upgrade-1.2.0-to-1.3.0.derby.sql b/metastore/scripts/upgrade/derby/upgrade-1.2.0-to-1.3.0.derby.sql index dee744b..6359de4 100644 --- a/metastore/scripts/upgrade/derby/upgrade-1.2.0-to-1.3.0.derby.sql +++ b/metastore/scripts/upgrade/derby/upgrade-1.2.0-to-1.3.0.derby.sql @@ -1,3 +1,4 @@ -- Upgrade MetaStore schema from 1.2.0 to 1.3.0 +RUN '021-HIVE-11970.derby.sql'; UPDATE "APP".VERSION SET SCHEMA_VERSION='1.3.0', VERSION_COMMENT='Hive release version 1.3.0' where VER_ID=1; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/derby/upgrade-1.2.0-to-2.0.0.derby.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/derby/upgrade-1.2.0-to-2.0.0.derby.sql b/metastore/scripts/upgrade/derby/upgrade-1.2.0-to-2.0.0.derby.sql index 976ebd1..adf3cb0 100644 --- a/metastore/scripts/upgrade/derby/upgrade-1.2.0-to-2.0.0.derby.sql +++ b/metastore/scripts/upgrade/derby/upgrade-1.2.0-to-2.0.0.derby.sql @@ -1,3 +1,4 @@ --- Upgrade MetaStore schema from 1.3.0 to 2.0.0 +-- Upgrade MetaStore schema from 1.2.0 to 2.0.0 +RUN '021-HIVE-11970.derby.sql'; UPDATE "APP".VERSION SET SCHEMA_VERSION='2.0.0', VERSION_COMMENT='Hive release version 2.0.0' where VER_ID=1; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/mssql/007-HIVE-11970.mssql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mssql/007-HIVE-11970.mssql.sql b/metastore/scripts/upgrade/mssql/007-HIVE-11970.mssql.sql new file mode 100644 index 0000000..69b11a2 --- /dev/null +++ b/metastore/scripts/upgrade/mssql/007-HIVE-11970.mssql.sql @@ -0,0 +1,6 @@ +ALTER TABLE "COLUMNS_V2" ALTER COLUMN "COLUMN_NAME" VARCHAR(1000) NOT NULL; +ALTER TABLE "PART_COL_PRIVS" ALTER COLUMN "COLUMN_NAME" VARCHAR(1000) NULL; +ALTER TABLE "TBL_COL_PRIVS" ALTER COLUMN "COLUMN_NAME" VARCHAR(1000) NULL; +ALTER TABLE "SORT_COLS" ALTER COLUMN "COLUMN_NAME" VARCHAR(1000) NULL; +ALTER TABLE "TAB_COL_STATS" ALTER COLUMN "COLUMN_NAME" VARCHAR(1000) NOT NULL; +ALTER TABLE "PART_COL_STATS" ALTER COLUMN "COLUMN_NAME" VARCHAR(1000) NOT NULL; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/mssql/hive-schema-1.3.0.mssql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mssql/hive-schema-1.3.0.mssql.sql b/metastore/scripts/upgrade/mssql/hive-schema-1.3.0.mssql.sql index 7165edd..01c1376 100644 --- a/metastore/scripts/upgrade/mssql/hive-schema-1.3.0.mssql.sql +++ b/metastore/scripts/upgrade/mssql/hive-schema-1.3.0.mssql.sql @@ -75,7 +75,7 @@ CREATE TABLE PART_COL_STATS ( CS_ID bigint NOT NULL, AVG_COL_LEN float NULL, - "COLUMN_NAME" nvarchar(128) NOT NULL, + "COLUMN_NAME" nvarchar(1000) NOT NULL, COLUMN_TYPE nvarchar(128) NOT NULL, DB_NAME nvarchar(128) NOT NULL, BIG_DECIMAL_HIGH_VALUE nvarchar(255) NULL, @@ -184,7 +184,7 @@ ALTER TABLE GLOBAL_PRIVS ADD CONSTRAINT GLOBAL_PRIVS_PK PRIMARY KEY (USER_GRANT_ CREATE TABLE PART_COL_PRIVS ( PART_COLUMN_GRANT_ID bigint NOT NULL, - "COLUMN_NAME" nvarchar(128) NULL, + "COLUMN_NAME" nvarchar(1000) NULL, CREATE_TIME int NOT NULL, GRANT_OPTION smallint NOT NULL CHECK (GRANT_OPTION IN (0,1)), GRANTOR nvarchar(128) NULL, @@ -218,7 +218,7 @@ CREATE TABLE TAB_COL_STATS ( CS_ID bigint NOT NULL, AVG_COL_LEN float NULL, - "COLUMN_NAME" nvarchar(128) NOT NULL, + "COLUMN_NAME" nvarchar(1000) NOT NULL, COLUMN_TYPE nvarchar(128) NOT NULL, DB_NAME nvarchar(128) NOT NULL, BIG_DECIMAL_HIGH_VALUE nvarchar(255) NULL, @@ -283,7 +283,7 @@ ALTER TABLE DBS ADD CONSTRAINT DBS_PK PRIMARY KEY (DB_ID); CREATE TABLE TBL_COL_PRIVS ( TBL_COLUMN_GRANT_ID bigint NOT NULL, - "COLUMN_NAME" nvarchar(128) NULL, + "COLUMN_NAME" nvarchar(1000) NULL, CREATE_TIME int NOT NULL, GRANT_OPTION smallint NOT NULL CHECK (GRANT_OPTION IN (0,1)), GRANTOR nvarchar(128) NULL, @@ -396,7 +396,7 @@ ALTER TABLE PARTITION_EVENTS ADD CONSTRAINT PARTITION_EVENTS_PK PRIMARY KEY (PAR CREATE TABLE SORT_COLS ( SD_ID bigint NOT NULL, - "COLUMN_NAME" nvarchar(128) NULL, + "COLUMN_NAME" nvarchar(1000) NULL, "ORDER" int NOT NULL, INTEGER_IDX int NOT NULL ); @@ -533,7 +533,7 @@ CREATE TABLE COLUMNS_V2 ( CD_ID bigint NOT NULL, COMMENT nvarchar(256) NULL, - "COLUMN_NAME" nvarchar(128) NOT NULL, + "COLUMN_NAME" nvarchar(1000) NOT NULL, TYPE_NAME nvarchar(4000) NOT NULL, INTEGER_IDX int NOT NULL ); http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/mssql/hive-schema-2.0.0.mssql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mssql/hive-schema-2.0.0.mssql.sql b/metastore/scripts/upgrade/mssql/hive-schema-2.0.0.mssql.sql index 36e7c1f..1ec8632 100644 --- a/metastore/scripts/upgrade/mssql/hive-schema-2.0.0.mssql.sql +++ b/metastore/scripts/upgrade/mssql/hive-schema-2.0.0.mssql.sql @@ -75,7 +75,7 @@ CREATE TABLE PART_COL_STATS ( CS_ID bigint NOT NULL, AVG_COL_LEN float NULL, - "COLUMN_NAME" nvarchar(128) NOT NULL, + "COLUMN_NAME" nvarchar(1000) NOT NULL, COLUMN_TYPE nvarchar(128) NOT NULL, DB_NAME nvarchar(128) NOT NULL, BIG_DECIMAL_HIGH_VALUE nvarchar(255) NULL, @@ -184,7 +184,7 @@ ALTER TABLE GLOBAL_PRIVS ADD CONSTRAINT GLOBAL_PRIVS_PK PRIMARY KEY (USER_GRANT_ CREATE TABLE PART_COL_PRIVS ( PART_COLUMN_GRANT_ID bigint NOT NULL, - "COLUMN_NAME" nvarchar(128) NULL, + "COLUMN_NAME" nvarchar(1000) NULL, CREATE_TIME int NOT NULL, GRANT_OPTION smallint NOT NULL CHECK (GRANT_OPTION IN (0,1)), GRANTOR nvarchar(128) NULL, @@ -218,7 +218,7 @@ CREATE TABLE TAB_COL_STATS ( CS_ID bigint NOT NULL, AVG_COL_LEN float NULL, - "COLUMN_NAME" nvarchar(128) NOT NULL, + "COLUMN_NAME" nvarchar(1000) NOT NULL, COLUMN_TYPE nvarchar(128) NOT NULL, DB_NAME nvarchar(128) NOT NULL, BIG_DECIMAL_HIGH_VALUE nvarchar(255) NULL, @@ -283,7 +283,7 @@ ALTER TABLE DBS ADD CONSTRAINT DBS_PK PRIMARY KEY (DB_ID); CREATE TABLE TBL_COL_PRIVS ( TBL_COLUMN_GRANT_ID bigint NOT NULL, - "COLUMN_NAME" nvarchar(128) NULL, + "COLUMN_NAME" nvarchar(1000) NULL, CREATE_TIME int NOT NULL, GRANT_OPTION smallint NOT NULL CHECK (GRANT_OPTION IN (0,1)), GRANTOR nvarchar(128) NULL, @@ -396,7 +396,7 @@ ALTER TABLE PARTITION_EVENTS ADD CONSTRAINT PARTITION_EVENTS_PK PRIMARY KEY (PAR CREATE TABLE SORT_COLS ( SD_ID bigint NOT NULL, - "COLUMN_NAME" nvarchar(128) NULL, + "COLUMN_NAME" nvarchar(1000) NULL, "ORDER" int NOT NULL, INTEGER_IDX int NOT NULL ); @@ -533,7 +533,7 @@ CREATE TABLE COLUMNS_V2 ( CD_ID bigint NOT NULL, COMMENT nvarchar(256) NULL, - "COLUMN_NAME" nvarchar(128) NOT NULL, + "COLUMN_NAME" nvarchar(1000) NOT NULL, TYPE_NAME nvarchar(4000) NOT NULL, INTEGER_IDX int NOT NULL ); http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/mssql/upgrade-1.2.0-to-1.3.0.mssql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mssql/upgrade-1.2.0-to-1.3.0.mssql.sql b/metastore/scripts/upgrade/mssql/upgrade-1.2.0-to-1.3.0.mssql.sql index fd12a92..9cf9d25 100644 --- a/metastore/scripts/upgrade/mssql/upgrade-1.2.0-to-1.3.0.mssql.sql +++ b/metastore/scripts/upgrade/mssql/upgrade-1.2.0-to-1.3.0.mssql.sql @@ -1,5 +1,6 @@ SELECT 'Upgrading MetaStore schema from 1.2.0 to 1.3.0' AS MESSAGE; +:r 007-HIVE-11970.mssql.sql; UPDATE VERSION SET SCHEMA_VERSION='1.3.0', VERSION_COMMENT='Hive release version 1.3.0' where VER_ID=1; SELECT 'Finished upgrading MetaStore schema from 1.2.0 to 1.3.0' AS MESSAGE; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/mssql/upgrade-1.2.0-to-2.0.0.mssql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mssql/upgrade-1.2.0-to-2.0.0.mssql.sql b/metastore/scripts/upgrade/mssql/upgrade-1.2.0-to-2.0.0.mssql.sql index fd12a92..de3d29d 100644 --- a/metastore/scripts/upgrade/mssql/upgrade-1.2.0-to-2.0.0.mssql.sql +++ b/metastore/scripts/upgrade/mssql/upgrade-1.2.0-to-2.0.0.mssql.sql @@ -1,5 +1,6 @@ -SELECT 'Upgrading MetaStore schema from 1.2.0 to 1.3.0' AS MESSAGE; +SELECT 'Upgrading MetaStore schema from 1.2.0 to 2.0.0' AS MESSAGE; +:r 007-HIVE-11970.mssql.sql; -UPDATE VERSION SET SCHEMA_VERSION='1.3.0', VERSION_COMMENT='Hive release version 1.3.0' where VER_ID=1; -SELECT 'Finished upgrading MetaStore schema from 1.2.0 to 1.3.0' AS MESSAGE; +UPDATE VERSION SET SCHEMA_VERSION='2.0.0', VERSION_COMMENT='Hive release version 2.0.0' where VER_ID=1; +SELECT 'Finished upgrading MetaStore schema from 1.2.0 to 2.0.0' AS MESSAGE; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/mysql/022-HIVE-11970.mysql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mysql/022-HIVE-11970.mysql.sql b/metastore/scripts/upgrade/mysql/022-HIVE-11970.mysql.sql new file mode 100644 index 0000000..4517e00 --- /dev/null +++ b/metastore/scripts/upgrade/mysql/022-HIVE-11970.mysql.sql @@ -0,0 +1,6 @@ +ALTER TABLE `COLUMNS_V2` MODIFY `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL; +ALTER TABLE `PART_COL_PRIVS` MODIFY `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL; +ALTER TABLE `TBL_COL_PRIVS` MODIFY `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL; +ALTER TABLE `SORT_COLS` MODIFY `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL; +ALTER TABLE `TAB_COL_STATS` MODIFY `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL; +ALTER TABLE `PART_COL_STATS` MODIFY `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql b/metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql index 71de138..ce0ac54 100644 --- a/metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql +++ b/metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql @@ -52,7 +52,7 @@ CREATE TABLE IF NOT EXISTS `CDS` ( CREATE TABLE IF NOT EXISTS `COLUMNS_V2` ( `CD_ID` bigint(20) NOT NULL, `COMMENT` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TYPE_NAME` varchar(4000) DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`CD_ID`,`COLUMN_NAME`), @@ -296,7 +296,7 @@ CREATE TABLE IF NOT EXISTS `PARTITION_PARAMS` ( /*!40101 SET character_set_client = utf8 */; CREATE TABLE IF NOT EXISTS `PART_COL_PRIVS` ( `PART_COLUMN_GRANT_ID` bigint(20) NOT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `CREATE_TIME` int(11) NOT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, @@ -544,7 +544,7 @@ CREATE TABLE IF NOT EXISTS `SKEWED_VALUES` ( /*!40101 SET character_set_client = utf8 */; CREATE TABLE IF NOT EXISTS `SORT_COLS` ( `SD_ID` bigint(20) NOT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `ORDER` int(11) NOT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`SD_ID`,`INTEGER_IDX`), @@ -604,7 +604,7 @@ CREATE TABLE IF NOT EXISTS `TBLS` ( /*!40101 SET character_set_client = utf8 */; CREATE TABLE IF NOT EXISTS `TBL_COL_PRIVS` ( `TBL_COLUMN_GRANT_ID` bigint(20) NOT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `CREATE_TIME` int(11) NOT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, @@ -650,7 +650,7 @@ CREATE TABLE IF NOT EXISTS `TAB_COL_STATS` ( `CS_ID` bigint(20) NOT NULL, `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TBL_ID` bigint(20) NOT NULL, `LONG_LOW_VALUE` bigint(20), @@ -678,7 +678,7 @@ CREATE TABLE IF NOT EXISTS `PART_COL_STATS` ( `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARTITION_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PART_ID` bigint(20) NOT NULL, `LONG_LOW_VALUE` bigint(20), http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/mysql/hive-schema-2.0.0.mysql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mysql/hive-schema-2.0.0.mysql.sql b/metastore/scripts/upgrade/mysql/hive-schema-2.0.0.mysql.sql index 6547cf1..3a2c0e2 100644 --- a/metastore/scripts/upgrade/mysql/hive-schema-2.0.0.mysql.sql +++ b/metastore/scripts/upgrade/mysql/hive-schema-2.0.0.mysql.sql @@ -52,7 +52,7 @@ CREATE TABLE IF NOT EXISTS `CDS` ( CREATE TABLE IF NOT EXISTS `COLUMNS_V2` ( `CD_ID` bigint(20) NOT NULL, `COMMENT` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TYPE_NAME` varchar(4000) DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`CD_ID`,`COLUMN_NAME`), @@ -296,7 +296,7 @@ CREATE TABLE IF NOT EXISTS `PARTITION_PARAMS` ( /*!40101 SET character_set_client = utf8 */; CREATE TABLE IF NOT EXISTS `PART_COL_PRIVS` ( `PART_COLUMN_GRANT_ID` bigint(20) NOT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `CREATE_TIME` int(11) NOT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, @@ -544,7 +544,7 @@ CREATE TABLE IF NOT EXISTS `SKEWED_VALUES` ( /*!40101 SET character_set_client = utf8 */; CREATE TABLE IF NOT EXISTS `SORT_COLS` ( `SD_ID` bigint(20) NOT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `ORDER` int(11) NOT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`SD_ID`,`INTEGER_IDX`), @@ -604,7 +604,7 @@ CREATE TABLE IF NOT EXISTS `TBLS` ( /*!40101 SET character_set_client = utf8 */; CREATE TABLE IF NOT EXISTS `TBL_COL_PRIVS` ( `TBL_COLUMN_GRANT_ID` bigint(20) NOT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `CREATE_TIME` int(11) NOT NULL, `GRANT_OPTION` smallint(6) NOT NULL, `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, @@ -650,7 +650,7 @@ CREATE TABLE IF NOT EXISTS `TAB_COL_STATS` ( `CS_ID` bigint(20) NOT NULL, `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TBL_ID` bigint(20) NOT NULL, `LONG_LOW_VALUE` bigint(20), @@ -678,7 +678,7 @@ CREATE TABLE IF NOT EXISTS `PART_COL_STATS` ( `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARTITION_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, - `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, + `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PART_ID` bigint(20) NOT NULL, `LONG_LOW_VALUE` bigint(20), http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-1.3.0.mysql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-1.3.0.mysql.sql b/metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-1.3.0.mysql.sql index 44a9946..1b32d93 100644 --- a/metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-1.3.0.mysql.sql +++ b/metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-1.3.0.mysql.sql @@ -1,4 +1,5 @@ SELECT 'Upgrading MetaStore schema from 1.2.0 to 1.3.0' AS ' '; SOURCE 021-HIVE-7018.mysql.sql; +SOURCE 022-HIVE-11970.mysql.sql; UPDATE VERSION SET SCHEMA_VERSION='1.3.0', VERSION_COMMENT='Hive release version 1.3.0' where VER_ID=1; SELECT 'Finished upgrading MetaStore schema from 1.2.0 to 1.3.0' AS ' '; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql b/metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql index 22d5242..1340f27 100644 --- a/metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql +++ b/metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql @@ -1,4 +1,6 @@ SELECT 'Upgrading MetaStore schema from 1.2.0 to 2.0.0' AS ' '; +SOURCE 021-HIVE-7018.mysql.sql; +SOURCE 022-HIVE-11970.mysql.sql; UPDATE VERSION SET SCHEMA_VERSION='2.0.0', VERSION_COMMENT='Hive release version 2.0.0' where VER_ID=1; SELECT 'Finished upgrading MetaStore schema from 1.2.0 to 2.0.0' AS ' '; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/oracle/022-HIVE-11970.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/022-HIVE-11970.oracle.sql b/metastore/scripts/upgrade/oracle/022-HIVE-11970.oracle.sql new file mode 100644 index 0000000..2f11157 --- /dev/null +++ b/metastore/scripts/upgrade/oracle/022-HIVE-11970.oracle.sql @@ -0,0 +1,23 @@ +ALTER TABLE COLUMNS_V2 MODIFY ( + "COLUMN_NAME" VARCHAR2(1000) +); + +ALTER TABLE PART_COL_PRIVS MODIFY ( + "COLUMN_NAME" VARCHAR2(1000) +); + +ALTER TABLE TBL_COL_PRIVS MODIFY ( + "COLUMN_NAME" VARCHAR2(1000) +); + +ALTER TABLE SORT_COLS MODIFY ( + "COLUMN_NAME" VARCHAR2(1000) +); + +ALTER TABLE TAB_COL_STATS MODIFY ( + "COLUMN_NAME" VARCHAR2(1000) +); + +ALTER TABLE PART_COL_STATS MODIFY ( + "COLUMN_NAME" VARCHAR2(1000) +); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/oracle/hive-schema-1.3.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/hive-schema-1.3.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-schema-1.3.0.oracle.sql index 7605bc7..d2e7945 100644 --- a/metastore/scripts/upgrade/oracle/hive-schema-1.3.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/hive-schema-1.3.0.oracle.sql @@ -29,7 +29,7 @@ ALTER TABLE NUCLEUS_TABLES ADD CONSTRAINT NUCLEUS_TABLES_PK PRIMARY KEY (CLASS_N CREATE TABLE PART_COL_PRIVS ( PART_COLUMN_GRANT_ID NUMBER NOT NULL, - "COLUMN_NAME" VARCHAR2(128) NULL, + "COLUMN_NAME" VARCHAR2(1000) NULL, CREATE_TIME NUMBER (10) NOT NULL, GRANT_OPTION NUMBER (5) NOT NULL, GRANTOR VARCHAR2(128) NULL, @@ -55,7 +55,7 @@ CREATE TABLE COLUMNS_V2 ( CD_ID NUMBER NOT NULL, "COMMENT" VARCHAR2(256) NULL, - "COLUMN_NAME" VARCHAR2(128) NOT NULL, + "COLUMN_NAME" VARCHAR2(1000) NOT NULL, TYPE_NAME VARCHAR2(4000) NOT NULL, INTEGER_IDX NUMBER(10) NOT NULL ); @@ -166,7 +166,7 @@ ALTER TABLE INDEX_PARAMS ADD CONSTRAINT INDEX_PARAMS_PK PRIMARY KEY (INDEX_ID,PA CREATE TABLE TBL_COL_PRIVS ( TBL_COLUMN_GRANT_ID NUMBER NOT NULL, - "COLUMN_NAME" VARCHAR2(128) NULL, + "COLUMN_NAME" VARCHAR2(1000) NULL, CREATE_TIME NUMBER (10) NOT NULL, GRANT_OPTION NUMBER (5) NOT NULL, GRANTOR VARCHAR2(128) NULL, @@ -272,7 +272,7 @@ ALTER TABLE TABLE_PARAMS ADD CONSTRAINT TABLE_PARAMS_PK PRIMARY KEY (TBL_ID,PARA CREATE TABLE SORT_COLS ( SD_ID NUMBER NOT NULL, - "COLUMN_NAME" VARCHAR2(128) NULL, + "COLUMN_NAME" VARCHAR2(1000) NULL, "ORDER" NUMBER (10) NOT NULL, INTEGER_IDX NUMBER(10) NOT NULL ); @@ -467,7 +467,7 @@ CREATE TABLE TAB_COL_STATS ( CS_ID NUMBER NOT NULL, DB_NAME VARCHAR2(128) NOT NULL, TABLE_NAME VARCHAR2(128) NOT NULL, - COLUMN_NAME VARCHAR2(128) NOT NULL, + COLUMN_NAME VARCHAR2(1000) NOT NULL, COLUMN_TYPE VARCHAR2(128) NOT NULL, TBL_ID NUMBER NOT NULL, LONG_LOW_VALUE NUMBER, @@ -503,7 +503,7 @@ CREATE TABLE PART_COL_STATS ( DB_NAME VARCHAR2(128) NOT NULL, TABLE_NAME VARCHAR2(128) NOT NULL, PARTITION_NAME VARCHAR2(767) NOT NULL, - COLUMN_NAME VARCHAR2(128) NOT NULL, + COLUMN_NAME VARCHAR2(1000) NOT NULL, COLUMN_TYPE VARCHAR2(128) NOT NULL, PART_ID NUMBER NOT NULL, LONG_LOW_VALUE NUMBER, http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/oracle/hive-schema-2.0.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/hive-schema-2.0.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-schema-2.0.0.oracle.sql index 8d963ce..2dcdd77 100644 --- a/metastore/scripts/upgrade/oracle/hive-schema-2.0.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/hive-schema-2.0.0.oracle.sql @@ -29,7 +29,7 @@ ALTER TABLE NUCLEUS_TABLES ADD CONSTRAINT NUCLEUS_TABLES_PK PRIMARY KEY (CLASS_N CREATE TABLE PART_COL_PRIVS ( PART_COLUMN_GRANT_ID NUMBER NOT NULL, - "COLUMN_NAME" VARCHAR2(128) NULL, + "COLUMN_NAME" VARCHAR2(1000) NULL, CREATE_TIME NUMBER (10) NOT NULL, GRANT_OPTION NUMBER (5) NOT NULL, GRANTOR VARCHAR2(128) NULL, @@ -55,7 +55,7 @@ CREATE TABLE COLUMNS_V2 ( CD_ID NUMBER NOT NULL, "COMMENT" VARCHAR2(256) NULL, - "COLUMN_NAME" VARCHAR2(128) NOT NULL, + "COLUMN_NAME" VARCHAR2(1000) NOT NULL, TYPE_NAME VARCHAR2(4000) NOT NULL, INTEGER_IDX NUMBER(10) NOT NULL ); @@ -166,7 +166,7 @@ ALTER TABLE INDEX_PARAMS ADD CONSTRAINT INDEX_PARAMS_PK PRIMARY KEY (INDEX_ID,PA CREATE TABLE TBL_COL_PRIVS ( TBL_COLUMN_GRANT_ID NUMBER NOT NULL, - "COLUMN_NAME" VARCHAR2(128) NULL, + "COLUMN_NAME" VARCHAR2(1000) NULL, CREATE_TIME NUMBER (10) NOT NULL, GRANT_OPTION NUMBER (5) NOT NULL, GRANTOR VARCHAR2(128) NULL, @@ -272,7 +272,7 @@ ALTER TABLE TABLE_PARAMS ADD CONSTRAINT TABLE_PARAMS_PK PRIMARY KEY (TBL_ID,PARA CREATE TABLE SORT_COLS ( SD_ID NUMBER NOT NULL, - "COLUMN_NAME" VARCHAR2(128) NULL, + "COLUMN_NAME" VARCHAR2(1000) NULL, "ORDER" NUMBER (10) NOT NULL, INTEGER_IDX NUMBER(10) NOT NULL ); @@ -467,7 +467,7 @@ CREATE TABLE TAB_COL_STATS ( CS_ID NUMBER NOT NULL, DB_NAME VARCHAR2(128) NOT NULL, TABLE_NAME VARCHAR2(128) NOT NULL, - COLUMN_NAME VARCHAR2(128) NOT NULL, + COLUMN_NAME VARCHAR2(1000) NOT NULL, COLUMN_TYPE VARCHAR2(128) NOT NULL, TBL_ID NUMBER NOT NULL, LONG_LOW_VALUE NUMBER, @@ -503,7 +503,7 @@ CREATE TABLE PART_COL_STATS ( DB_NAME VARCHAR2(128) NOT NULL, TABLE_NAME VARCHAR2(128) NOT NULL, PARTITION_NAME VARCHAR2(767) NOT NULL, - COLUMN_NAME VARCHAR2(128) NOT NULL, + COLUMN_NAME VARCHAR2(1000) NOT NULL, COLUMN_TYPE VARCHAR2(128) NOT NULL, PART_ID NUMBER NOT NULL, LONG_LOW_VALUE NUMBER, http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/oracle/upgrade-1.2.0-to-1.3.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/upgrade-1.2.0-to-1.3.0.oracle.sql b/metastore/scripts/upgrade/oracle/upgrade-1.2.0-to-1.3.0.oracle.sql index f072a1c..bd283d4 100644 --- a/metastore/scripts/upgrade/oracle/upgrade-1.2.0-to-1.3.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/upgrade-1.2.0-to-1.3.0.oracle.sql @@ -1,4 +1,6 @@ SELECT 'Upgrading MetaStore schema from 1.2.0 to 1.3.0' AS Status from dual; +@022-HIVE-11970.oracle.sql; + UPDATE VERSION SET SCHEMA_VERSION='1.3.0', VERSION_COMMENT='Hive release version 1.3.0' where VER_ID=1; SELECT 'Finished upgrading MetaStore schema from 1.2.0 to 1.3.0' AS Status from dual; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/oracle/upgrade-1.2.0-to-2.0.0.oracle.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/oracle/upgrade-1.2.0-to-2.0.0.oracle.sql b/metastore/scripts/upgrade/oracle/upgrade-1.2.0-to-2.0.0.oracle.sql index efff2c9..ceb09be 100644 --- a/metastore/scripts/upgrade/oracle/upgrade-1.2.0-to-2.0.0.oracle.sql +++ b/metastore/scripts/upgrade/oracle/upgrade-1.2.0-to-2.0.0.oracle.sql @@ -1,4 +1,6 @@ SELECT 'Upgrading MetaStore schema from 1.2.0 to 2.0.0' AS Status from dual; +@022-HIVE-11970.oracle.sql; + UPDATE VERSION SET SCHEMA_VERSION='2.0.0', VERSION_COMMENT='Hive release version 2.0.0' where VER_ID=1; SELECT 'Finished upgrading MetaStore schema from 1.2.0 to 2.0.0' AS Status from dual; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/postgres/021-HIVE-11970.postgres.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/postgres/021-HIVE-11970.postgres.sql b/metastore/scripts/upgrade/postgres/021-HIVE-11970.postgres.sql new file mode 100644 index 0000000..08cb4a5 --- /dev/null +++ b/metastore/scripts/upgrade/postgres/021-HIVE-11970.postgres.sql @@ -0,0 +1,6 @@ +ALTER TABLE "COLUMNS_V2" ALTER "COLUMN_NAME" TYPE character varying(1000); +ALTER TABLE "PART_COL_PRIVS" ALTER "COLUMN_NAME" TYPE character varying(1000); +ALTER TABLE "TBL_COL_PRIVS" ALTER "COLUMN_NAME" TYPE character varying(1000); +ALTER TABLE "SORT_COLS" ALTER "COLUMN_NAME" TYPE character varying(1000); +ALTER TABLE "TAB_COL_STATS" ALTER "COLUMN_NAME" TYPE character varying(1000); +ALTER TABLE "PART_COL_STATS" ALTER "COLUMN_NAME" TYPE character varying(1000); http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/postgres/hive-schema-1.3.0.postgres.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/postgres/hive-schema-1.3.0.postgres.sql b/metastore/scripts/upgrade/postgres/hive-schema-1.3.0.postgres.sql index 3ab5b3e..9bb5765 100644 --- a/metastore/scripts/upgrade/postgres/hive-schema-1.3.0.postgres.sql +++ b/metastore/scripts/upgrade/postgres/hive-schema-1.3.0.postgres.sql @@ -42,7 +42,7 @@ CREATE TABLE "CDS" ( CREATE TABLE "COLUMNS_V2" ( "CD_ID" bigint NOT NULL, "COMMENT" character varying(4000), - "COLUMN_NAME" character varying(128) NOT NULL, + "COLUMN_NAME" character varying(1000) NOT NULL, "TYPE_NAME" character varying(4000), "INTEGER_IDX" integer NOT NULL ); @@ -217,7 +217,7 @@ CREATE TABLE "PARTITION_PARAMS" ( CREATE TABLE "PART_COL_PRIVS" ( "PART_COLUMN_GRANT_ID" bigint NOT NULL, - "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, + "COLUMN_NAME" character varying(1000) DEFAULT NULL::character varying, "CREATE_TIME" bigint NOT NULL, "GRANT_OPTION" smallint NOT NULL, "GRANTOR" character varying(128) DEFAULT NULL::character varying, @@ -340,7 +340,7 @@ CREATE TABLE "SERDE_PARAMS" ( CREATE TABLE "SORT_COLS" ( "SD_ID" bigint NOT NULL, - "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, + "COLUMN_NAME" character varying(1000) DEFAULT NULL::character varying, "ORDER" bigint NOT NULL, "INTEGER_IDX" bigint NOT NULL ); @@ -382,7 +382,7 @@ CREATE TABLE "TBLS" ( CREATE TABLE "TBL_COL_PRIVS" ( "TBL_COLUMN_GRANT_ID" bigint NOT NULL, - "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, + "COLUMN_NAME" character varying(1000) DEFAULT NULL::character varying, "CREATE_TIME" bigint NOT NULL, "GRANT_OPTION" smallint NOT NULL, "GRANTOR" character varying(128) DEFAULT NULL::character varying, @@ -486,7 +486,7 @@ CREATE TABLE "TAB_COL_STATS" ( "CS_ID" bigint NOT NULL, "DB_NAME" character varying(128) DEFAULT NULL::character varying, "TABLE_NAME" character varying(128) DEFAULT NULL::character varying, - "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, + "COLUMN_NAME" character varying(1000) DEFAULT NULL::character varying, "COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying, "TBL_ID" bigint NOT NULL, "LONG_LOW_VALUE" bigint, @@ -522,7 +522,7 @@ CREATE TABLE "PART_COL_STATS" ( "DB_NAME" character varying(128) DEFAULT NULL::character varying, "TABLE_NAME" character varying(128) DEFAULT NULL::character varying, "PARTITION_NAME" character varying(767) DEFAULT NULL::character varying, - "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, + "COLUMN_NAME" character varying(1000) DEFAULT NULL::character varying, "COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying, "PART_ID" bigint NOT NULL, "LONG_LOW_VALUE" bigint, http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/postgres/hive-schema-2.0.0.postgres.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/postgres/hive-schema-2.0.0.postgres.sql b/metastore/scripts/upgrade/postgres/hive-schema-2.0.0.postgres.sql index 6442eb1..c749a29 100644 --- a/metastore/scripts/upgrade/postgres/hive-schema-2.0.0.postgres.sql +++ b/metastore/scripts/upgrade/postgres/hive-schema-2.0.0.postgres.sql @@ -42,7 +42,7 @@ CREATE TABLE "CDS" ( CREATE TABLE "COLUMNS_V2" ( "CD_ID" bigint NOT NULL, "COMMENT" character varying(4000), - "COLUMN_NAME" character varying(128) NOT NULL, + "COLUMN_NAME" character varying(1000) NOT NULL, "TYPE_NAME" character varying(4000), "INTEGER_IDX" integer NOT NULL ); @@ -217,7 +217,7 @@ CREATE TABLE "PARTITION_PARAMS" ( CREATE TABLE "PART_COL_PRIVS" ( "PART_COLUMN_GRANT_ID" bigint NOT NULL, - "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, + "COLUMN_NAME" character varying(1000) DEFAULT NULL::character varying, "CREATE_TIME" bigint NOT NULL, "GRANT_OPTION" smallint NOT NULL, "GRANTOR" character varying(128) DEFAULT NULL::character varying, @@ -340,7 +340,7 @@ CREATE TABLE "SERDE_PARAMS" ( CREATE TABLE "SORT_COLS" ( "SD_ID" bigint NOT NULL, - "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, + "COLUMN_NAME" character varying(1000) DEFAULT NULL::character varying, "ORDER" bigint NOT NULL, "INTEGER_IDX" bigint NOT NULL ); @@ -382,7 +382,7 @@ CREATE TABLE "TBLS" ( CREATE TABLE "TBL_COL_PRIVS" ( "TBL_COLUMN_GRANT_ID" bigint NOT NULL, - "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, + "COLUMN_NAME" character varying(1000) DEFAULT NULL::character varying, "CREATE_TIME" bigint NOT NULL, "GRANT_OPTION" smallint NOT NULL, "GRANTOR" character varying(128) DEFAULT NULL::character varying, @@ -486,7 +486,7 @@ CREATE TABLE "TAB_COL_STATS" ( "CS_ID" bigint NOT NULL, "DB_NAME" character varying(128) DEFAULT NULL::character varying, "TABLE_NAME" character varying(128) DEFAULT NULL::character varying, - "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, + "COLUMN_NAME" character varying(1000) DEFAULT NULL::character varying, "COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying, "TBL_ID" bigint NOT NULL, "LONG_LOW_VALUE" bigint, @@ -522,7 +522,7 @@ CREATE TABLE "PART_COL_STATS" ( "DB_NAME" character varying(128) DEFAULT NULL::character varying, "TABLE_NAME" character varying(128) DEFAULT NULL::character varying, "PARTITION_NAME" character varying(767) DEFAULT NULL::character varying, - "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, + "COLUMN_NAME" character varying(1000) DEFAULT NULL::character varying, "COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying, "PART_ID" bigint NOT NULL, "LONG_LOW_VALUE" bigint, http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/postgres/upgrade-1.2.0-to-1.3.0.postgres.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/postgres/upgrade-1.2.0-to-1.3.0.postgres.sql b/metastore/scripts/upgrade/postgres/upgrade-1.2.0-to-1.3.0.postgres.sql index cdd3792..b1ec241 100644 --- a/metastore/scripts/upgrade/postgres/upgrade-1.2.0-to-1.3.0.postgres.sql +++ b/metastore/scripts/upgrade/postgres/upgrade-1.2.0-to-1.3.0.postgres.sql @@ -1,5 +1,6 @@ SELECT 'Upgrading MetaStore schema from 1.2.0 to 1.3.0'; +\i 021-HIVE-11970.postgres.sql; UPDATE "VERSION" SET "SCHEMA_VERSION"='1.3.0', "VERSION_COMMENT"='Hive release version 1.3.0' where "VER_ID"=1; SELECT 'Finished upgrading MetaStore schema from 1.2.0 to 1.3.0'; http://git-wip-us.apache.org/repos/asf/hive/blob/a953b436/metastore/scripts/upgrade/postgres/upgrade-1.2.0-to-2.0.0.postgres.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/postgres/upgrade-1.2.0-to-2.0.0.postgres.sql b/metastore/scripts/upgrade/postgres/upgrade-1.2.0-to-2.0.0.postgres.sql index b6b0c35..628444c 100644 --- a/metastore/scripts/upgrade/postgres/upgrade-1.2.0-to-2.0.0.postgres.sql +++ b/metastore/scripts/upgrade/postgres/upgrade-1.2.0-to-2.0.0.postgres.sql @@ -1,5 +1,6 @@ SELECT 'Upgrading MetaStore schema from 1.2.0 to 2.0.0'; +\i 021-HIVE-11970.postgres.sql; UPDATE "VERSION" SET "SCHEMA_VERSION"='2.0.0', "VERSION_COMMENT"='Hive release version 2.0.0' where "VER_ID"=1; SELECT 'Finished upgrading MetaStore schema from 1.2.0 to 2.0.0';