You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by kg...@apache.org on 2018/07/30 11:54:54 UTC
hive git commit: HIVE-20221: Increase column width for
partition_params (Zoltan Haindrich reviewed by Alan Gates)
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 <ki...@rxd.hu>
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 <ki...@rxd.hu>
Authored: Mon Jul 30 13:54:29 2018 +0200
Committer: Zoltan Haindrich <ki...@rxd.hu>
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';