Repository: hive Updated Branches: refs/heads/master 83e53972c -> d3b036920
HIVE-20221: Increase column width for partition_params (Zoltan Haindrich reviewed by Alan Gates) Signed-off-by: Zoltan Haindrich <[email protected]> Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/d3b03692 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/d3b03692 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/d3b03692 Branch: refs/heads/master Commit: d3b036920acde7bb04840697eb13038103b062b4 Parents: 83e5397 Author: Zoltan Haindrich <[email protected]> Authored: Mon Jul 30 13:54:29 2018 +0200 Committer: Zoltan Haindrich <[email protected]> Committed: Mon Jul 30 13:54:29 2018 +0200 ---------------------------------------------------------------------- .../org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java | 2 +- .../metastore-server/src/main/resources/package.jdo | 2 +- .../src/main/sql/derby/hive-schema-3.2.0.derby.sql | 2 +- .../src/main/sql/derby/hive-schema-4.0.0.derby.sql | 2 +- .../src/main/sql/derby/upgrade-3.1.0-to-3.2.0.derby.sql | 6 ++++++ .../src/main/sql/mssql/hive-schema-3.2.0.mssql.sql | 2 +- .../src/main/sql/mssql/hive-schema-4.0.0.mssql.sql | 2 +- .../src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql | 3 +++ .../src/main/sql/mysql/hive-schema-3.2.0.mysql.sql | 2 +- .../src/main/sql/mysql/hive-schema-4.0.0.mysql.sql | 2 +- .../src/main/sql/mysql/upgrade-3.1.0-to-3.2.0.mysql.sql | 3 +++ .../src/main/sql/oracle/hive-schema-3.2.0.oracle.sql | 2 +- .../src/main/sql/oracle/hive-schema-4.0.0.oracle.sql | 2 +- .../src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql | 7 +++++++ .../src/main/sql/postgres/hive-schema-3.2.0.postgres.sql | 2 +- .../src/main/sql/postgres/hive-schema-4.0.0.postgres.sql | 2 +- .../src/main/sql/postgres/upgrade-3.1.0-to-3.2.0.postgres.sql | 3 +++ 17 files changed, 34 insertions(+), 12 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java index 07be1ba..95d9fe2 100644 --- a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java +++ b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java @@ -768,7 +768,7 @@ class MetaStoreDirectSql { loopJoinOrderedResult(partitions, queryText, 0, new ApplyFunc<Partition>() { @Override public void apply(Partition t, Object[] fields) { - t.putToParameters((String)fields[1], (String)fields[2]); + t.putToParameters((String)fields[1], extractSqlClob(fields[2])); }}); // Perform conversion of null map values for (Partition t : partitions.values()) { http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/resources/package.jdo ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/resources/package.jdo b/standalone-metastore/metastore-server/src/main/resources/package.jdo index 70150da..2a5f016 100644 --- a/standalone-metastore/metastore-server/src/main/resources/package.jdo +++ b/standalone-metastore/metastore-server/src/main/resources/package.jdo @@ -539,7 +539,7 @@ <column name="PARAM_KEY" length="256" jdbc-type="VARCHAR"/> </key> <value> - <column name="PARAM_VALUE" length="4000" jdbc-type="VARCHAR"/> + <column name="PARAM_VALUE" jdbc-type="CLOB"/> </value> </field> </class> http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-3.2.0.derby.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-3.2.0.derby.sql b/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-3.2.0.derby.sql index 50d0815..5787262 100644 --- a/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-3.2.0.derby.sql +++ b/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-3.2.0.derby.sql @@ -59,7 +59,7 @@ CREATE TABLE "APP"."TYPES" ("TYPES_ID" BIGINT NOT NULL, "TYPE_NAME" VARCHAR(128) CREATE TABLE "APP"."GLOBAL_PRIVS" ("USER_GRANT_ID" BIGINT NOT NULL, "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), "USER_PRIV" VARCHAR(128), "AUTHORIZER" VARCHAR(128)); -CREATE TABLE "APP"."PARTITION_PARAMS" ("PART_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" VARCHAR(4000)); +CREATE TABLE "APP"."PARTITION_PARAMS" ("PART_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" CLOB); CREATE TABLE "APP"."PARTITION_EVENTS" ( "PART_NAME_ID" BIGINT NOT NULL, http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-4.0.0.derby.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-4.0.0.derby.sql b/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-4.0.0.derby.sql index 6c6cd49..c889bbd 100644 --- a/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-4.0.0.derby.sql +++ b/standalone-metastore/metastore-server/src/main/sql/derby/hive-schema-4.0.0.derby.sql @@ -59,7 +59,7 @@ CREATE TABLE "APP"."TYPES" ("TYPES_ID" BIGINT NOT NULL, "TYPE_NAME" VARCHAR(128) CREATE TABLE "APP"."GLOBAL_PRIVS" ("USER_GRANT_ID" BIGINT NOT NULL, "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), "USER_PRIV" VARCHAR(128), "AUTHORIZER" VARCHAR(128)); -CREATE TABLE "APP"."PARTITION_PARAMS" ("PART_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" VARCHAR(4000)); +CREATE TABLE "APP"."PARTITION_PARAMS" ("PART_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" CLOB); CREATE TABLE "APP"."PARTITION_EVENTS" ( "PART_NAME_ID" BIGINT NOT NULL, http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/derby/upgrade-3.1.0-to-3.2.0.derby.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/derby/upgrade-3.1.0-to-3.2.0.derby.sql b/standalone-metastore/metastore-server/src/main/sql/derby/upgrade-3.1.0-to-3.2.0.derby.sql index 1d29cd8..cc093cb 100644 --- a/standalone-metastore/metastore-server/src/main/sql/derby/upgrade-3.1.0-to-3.2.0.derby.sql +++ b/standalone-metastore/metastore-server/src/main/sql/derby/upgrade-3.1.0-to-3.2.0.derby.sql @@ -15,6 +15,12 @@ CREATE TABLE TXN_WRITE_NOTIFICATION_LOG ( ); INSERT INTO SEQUENCE_TABLE (SEQUENCE_NAME, NEXT_VAL) VALUES ('org.apache.hadoop.hive.metastore.model.MTxnWriteNotificationLog', 1); +-- HIVE-20221: change PARTITION_PARAMS.PARAM_VALUE to CLOB +ALTER TABLE "APP"."PARTITION_PARAMS" ADD COLUMN "PARAM_VALUE_CLOB" CLOB; +UPDATE "APP"."PARTITION_PARAMS" SET PARAM_VALUE_CLOB=CAST(PARAM_VALUE AS CLOB); +ALTER TABLE "APP"."PARTITION_PARAMS" DROP COLUMN PARAM_VALUE; +RENAME COLUMN "APP"."PARTITION_PARAMS"."PARAM_VALUE_CLOB" TO "PARAM_VALUE"; + -- This needs to be the last thing done. Insert any changes above this line. UPDATE "APP".VERSION SET SCHEMA_VERSION='3.2.0', VERSION_COMMENT='Hive release version 3.2.0' where VER_ID=1; http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql b/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql index 9e586e8..44aedbd 100644 --- a/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql +++ b/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql @@ -598,7 +598,7 @@ CREATE TABLE PARTITION_PARAMS ( PART_ID bigint NOT NULL, PARAM_KEY nvarchar(256) NOT NULL, - PARAM_VALUE nvarchar(4000) NULL + PARAM_VALUE varchar(max) NULL ); ALTER TABLE PARTITION_PARAMS ADD CONSTRAINT PARTITION_PARAMS_PK PRIMARY KEY (PART_ID,PARAM_KEY); http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-4.0.0.mssql.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-4.0.0.mssql.sql b/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-4.0.0.mssql.sql index 9cd9f1f..538c488 100644 --- a/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-4.0.0.mssql.sql +++ b/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-4.0.0.mssql.sql @@ -598,7 +598,7 @@ CREATE TABLE PARTITION_PARAMS ( PART_ID bigint NOT NULL, PARAM_KEY nvarchar(256) NOT NULL, - PARAM_VALUE nvarchar(4000) NULL + PARAM_VALUE varchar(max) NULL ); ALTER TABLE PARTITION_PARAMS ADD CONSTRAINT PARTITION_PARAMS_PK PRIMARY KEY (PART_ID,PARAM_KEY); http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql b/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql index 1e90652..03c5ac5 100644 --- a/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql +++ b/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql @@ -17,6 +17,9 @@ ALTER TABLE TXN_WRITE_NOTIFICATION_LOG ADD CONSTRAINT TXN_WRITE_NOTIFICATION_LOG INSERT INTO SEQUENCE_TABLE (SEQUENCE_NAME, NEXT_VAL) VALUES ('org.apache.hadoop.hive.metastore.model.MTxnWriteNotificationLog', 1); +-- HIVE-20221 +ALTER TABLE "SERDE_PARAMS" ALTER COLUMN "PARAM_VALUE" nvarchar(MAX); + -- These lines need to be last. Insert any changes above. UPDATE VERSION SET SCHEMA_VERSION='3.2.0', VERSION_COMMENT='Hive release version 3.2.0' where VER_ID=1; SELECT 'Finished upgrading MetaStore schema from 3.1.0 to 3.2.0' AS MESSAGE; http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-3.2.0.mysql.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-3.2.0.mysql.sql b/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-3.2.0.mysql.sql index bb2668c..9fba0fc 100644 --- a/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-3.2.0.mysql.sql +++ b/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-3.2.0.mysql.sql @@ -295,7 +295,7 @@ CREATE TABLE IF NOT EXISTS `PARTITION_KEY_VALS` ( CREATE TABLE IF NOT EXISTS `PARTITION_PARAMS` ( `PART_ID` bigint(20) NOT NULL, `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, - `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, + `PARAM_VALUE` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`PART_ID`,`PARAM_KEY`), KEY `PARTITION_PARAMS_N49` (`PART_ID`), CONSTRAINT `PARTITION_PARAMS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`) http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-4.0.0.mysql.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-4.0.0.mysql.sql b/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-4.0.0.mysql.sql index 0130d53..3af2ebb 100644 --- a/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-4.0.0.mysql.sql +++ b/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-4.0.0.mysql.sql @@ -296,7 +296,7 @@ CREATE TABLE IF NOT EXISTS `PARTITION_KEY_VALS` ( CREATE TABLE IF NOT EXISTS `PARTITION_PARAMS` ( `PART_ID` bigint(20) NOT NULL, `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, - `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, + `PARAM_VALUE` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, PRIMARY KEY (`PART_ID`,`PARAM_KEY`), KEY `PARTITION_PARAMS_N49` (`PART_ID`), CONSTRAINT `PARTITION_PARAMS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`) http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-3.1.0-to-3.2.0.mysql.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-3.1.0-to-3.2.0.mysql.sql b/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-3.1.0-to-3.2.0.mysql.sql index 37ba12d..e91c015 100644 --- a/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-3.1.0-to-3.2.0.mysql.sql +++ b/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-3.1.0-to-3.2.0.mysql.sql @@ -16,6 +16,9 @@ CREATE TABLE TXN_WRITE_NOTIFICATION_LOG ( ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO `SEQUENCE_TABLE` (`SEQUENCE_NAME`, `NEXT_VAL`) VALUES ('org.apache.hadoop.hive.metastore.model.MTxnWriteNotificationLog', 1); +-- HIVE-20221 +ALTER TABLE PARTITION_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT; + -- These lines need to be last. Insert any changes above. UPDATE VERSION SET SCHEMA_VERSION='3.2.0', VERSION_COMMENT='Hive release version 3.2.0' where VER_ID=1; SELECT 'Finished upgrading MetaStore schema from 3.1.0 to 3.2.0' AS ' '; http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql index a29752d..886570a 100644 --- a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql +++ b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql @@ -102,7 +102,7 @@ CREATE TABLE PARTITION_PARAMS ( PART_ID NUMBER NOT NULL, PARAM_KEY VARCHAR2(256) NOT NULL, - PARAM_VALUE VARCHAR2(4000) NULL + PARAM_VALUE CLOB NULL ); ALTER TABLE PARTITION_PARAMS ADD CONSTRAINT PARTITION_PARAMS_PK PRIMARY KEY (PART_ID,PARAM_KEY); http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql index 58b63b5..213e23b 100644 --- a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql +++ b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql @@ -102,7 +102,7 @@ CREATE TABLE PARTITION_PARAMS ( PART_ID NUMBER NOT NULL, PARAM_KEY VARCHAR2(256) NOT NULL, - PARAM_VALUE VARCHAR2(4000) NULL + PARAM_VALUE CLOB NULL ); ALTER TABLE PARTITION_PARAMS ADD CONSTRAINT PARTITION_PARAMS_PK PRIMARY KEY (PART_ID,PARAM_KEY); http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql index 978a75d..bbf743f 100644 --- a/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql +++ b/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.1.0-to-3.2.0.oracle.sql @@ -16,6 +16,13 @@ CREATE TABLE TXN_WRITE_NOTIFICATION_LOG ( ); INSERT INTO SEQUENCE_TABLE (SEQUENCE_NAME, NEXT_VAL) VALUES ('org.apache.hadoop.hive.metastore.model.MTxnWriteNotificationLog', 1); +-- HIVE-20221 +ALTER TABLE PARTITION_PARAMS ADD (TEMP CLOB); +UPDATE PARTITION_PARAMS SET TEMP=PARAM_VALUE, PARAM_VALUE=NULL; +ALTER TABLE PARTITION_PARAMS DROP COLUMN PARAM_VALUE; +ALTER TABLE PARTITION_PARAMS RENAME COLUMN TEMP TO PARAM_VALUE; + + -- These lines need to be last. Insert any changes above. UPDATE VERSION SET SCHEMA_VERSION='3.2.0', VERSION_COMMENT='Hive release version 3.2.0' where VER_ID=1; SELECT 'Finished upgrading MetaStore schema from 3.1.0 to 3.2.0' AS Status from dual; http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-3.2.0.postgres.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-3.2.0.postgres.sql b/standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-3.2.0.postgres.sql index 828ac3c..788ddaa 100644 --- a/standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-3.2.0.postgres.sql +++ b/standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-3.2.0.postgres.sql @@ -218,7 +218,7 @@ CREATE TABLE "PARTITION_KEY_VALS" ( CREATE TABLE "PARTITION_PARAMS" ( "PART_ID" bigint NOT NULL, "PARAM_KEY" character varying(256) NOT NULL, - "PARAM_VALUE" character varying(4000) DEFAULT NULL::character varying + "PARAM_VALUE" text DEFAULT NULL ); http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql b/standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql index 7790210..ea088d7 100644 --- a/standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql +++ b/standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql @@ -219,7 +219,7 @@ CREATE TABLE "PARTITION_KEY_VALS" ( CREATE TABLE "PARTITION_PARAMS" ( "PART_ID" bigint NOT NULL, "PARAM_KEY" character varying(256) NOT NULL, - "PARAM_VALUE" character varying(4000) DEFAULT NULL::character varying + "PARAM_VALUE" text DEFAULT NULL ); http://git-wip-us.apache.org/repos/asf/hive/blob/d3b03692/standalone-metastore/metastore-server/src/main/sql/postgres/upgrade-3.1.0-to-3.2.0.postgres.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/sql/postgres/upgrade-3.1.0-to-3.2.0.postgres.sql b/standalone-metastore/metastore-server/src/main/sql/postgres/upgrade-3.1.0-to-3.2.0.postgres.sql index 572e25d..565a85c 100644 --- a/standalone-metastore/metastore-server/src/main/sql/postgres/upgrade-3.1.0-to-3.2.0.postgres.sql +++ b/standalone-metastore/metastore-server/src/main/sql/postgres/upgrade-3.1.0-to-3.2.0.postgres.sql @@ -16,6 +16,9 @@ CREATE TABLE "TXN_WRITE_NOTIFICATION_LOG" ( ); INSERT INTO "SEQUENCE_TABLE" ("SEQUENCE_NAME", "NEXT_VAL") VALUES ('org.apache.hadoop.hive.metastore.model.MTxnWriteNotificationLog', 1); +-- HIVE-20221 +alter table "PARTITION_PARAMS" alter column "PARAM_VALUE" type text using cast("PARAM_VALUE" as text); + -- These lines need to be last. Insert any changes above. UPDATE "VERSION" SET "SCHEMA_VERSION"='3.2.0', "VERSION_COMMENT"='Hive release version 3.2.0' where "VER_ID"=1; SELECT 'Finished upgrading MetaStore schema from 3.1.0 to 3.2.0';
