You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ng...@apache.org on 2018/05/15 21:10:23 UTC
hive git commit: HIVE-19250: Schema column definition inconsistencies
in MySQL (Naveen Gangam, reviewed by Aihua Xu)
Repository: hive
Updated Branches:
refs/heads/master 6e6b0cb7b -> 50e04b208
HIVE-19250: Schema column definition inconsistencies in MySQL (Naveen Gangam, reviewed by Aihua Xu)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/50e04b20
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/50e04b20
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/50e04b20
Branch: refs/heads/master
Commit: 50e04b208d42bd2321c625522951602af571c310
Parents: 6e6b0cb
Author: Naveen Gangam <ng...@apache.org>
Authored: Mon Apr 23 13:51:45 2018 -0400
Committer: Naveen Gangam <ng...@apache.org>
Committed: Tue May 15 17:03:29 2018 -0400
----------------------------------------------------------------------
metastore/scripts/upgrade/mysql/039-HIVE-12274.mysql.sql | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/50e04b20/metastore/scripts/upgrade/mysql/039-HIVE-12274.mysql.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/mysql/039-HIVE-12274.mysql.sql b/metastore/scripts/upgrade/mysql/039-HIVE-12274.mysql.sql
index cdaf286..bd6bd29 100644
--- a/metastore/scripts/upgrade/mysql/039-HIVE-12274.mysql.sql
+++ b/metastore/scripts/upgrade/mysql/039-HIVE-12274.mysql.sql
@@ -1,14 +1,14 @@
ALTER TABLE COLUMNS_V2 MODIFY TYPE_NAME MEDIUMTEXT;
-ALTER TABLE TABLE_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT;
-ALTER TABLE SERDE_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT;
-ALTER TABLE SD_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT;
+ALTER TABLE TABLE_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_bin;
+ALTER TABLE SERDE_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_bin;
+ALTER TABLE SD_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_bin;
ALTER TABLE TBLS MODIFY TBL_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL;
-ALTER TABLE NOTIFICATION_LOG MODIFY TBL_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin;
+ALTER TABLE NOTIFICATION_LOG MODIFY TBL_NAME varchar(256);
ALTER TABLE PARTITION_EVENTS MODIFY TBL_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL;
ALTER TABLE TAB_COL_STATS MODIFY TABLE_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL;
ALTER TABLE PART_COL_STATS MODIFY TABLE_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL;
-ALTER TABLE COMPLETED_TXN_COMPONENTS MODIFY CTC_TABLE varchar(256) CHARACTER SET latin1 COLLATE latin1_bin;
+ALTER TABLE COMPLETED_TXN_COMPONENTS MODIFY CTC_TABLE varchar(256);
ALTER TABLE COLUMNS_V2 MODIFY COLUMN_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL;
ALTER TABLE PART_COL_PRIVS MODIFY COLUMN_NAME varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL;