[46/50] [abbrv] hive git commit: Revert "HIVE-19250: Schema column definition inconsistencies in MySQL (Naveen Gangam, reviewed by Aihua Xu)"
Revert "HIVE-19250: Schema column definition inconsistencies in MySQL (Naveen Gangam, reviewed by Aihua Xu)" This reverts commit efe9ab8ed6456f7a3e53c643974d4b7822ea3707. Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/dc83c6f4 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/dc83c6f4 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/dc83c6f4 Branch: refs/heads/branch-3 Commit: dc83c6f4b1121d73e3e54a01105e99bcff5189d5 Parents: efe9ab8 Author: Vineet Garg Authored: Tue May 15 14:43:42 2018 -0700 Committer: Vineet Garg Committed: Tue May 15 14:43:42 2018 -0700 -- 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/dc83c6f4/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 bd6bd29..cdaf286 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 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 TABLE_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT; +ALTER TABLE SERDE_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT; +ALTER TABLE SD_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT; 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); +ALTER TABLE NOTIFICATION_LOG MODIFY TBL_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin; 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); +ALTER TABLE COMPLETED_TXN_COMPONENTS MODIFY CTC_TABLE varchar(256) CHARACTER SET latin1 COLLATE latin1_bin; 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;
[46/50] [abbrv] hive git commit: Revert "HIVE-19250: Schema column definition inconsistencies in MySQL (Naveen Gangam, reviewed by Aihua Xu)"
Revert "HIVE-19250: Schema column definition inconsistencies in MySQL (Naveen Gangam, reviewed by Aihua Xu)" This reverts commit efe9ab8ed6456f7a3e53c643974d4b7822ea3707. Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/dc83c6f4 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/dc83c6f4 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/dc83c6f4 Branch: refs/heads/branch-3.0.0 Commit: dc83c6f4b1121d73e3e54a01105e99bcff5189d5 Parents: efe9ab8 Author: Vineet Garg Authored: Tue May 15 14:43:42 2018 -0700 Committer: Vineet Garg Committed: Tue May 15 14:43:42 2018 -0700 -- 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/dc83c6f4/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 bd6bd29..cdaf286 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 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 TABLE_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT; +ALTER TABLE SERDE_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT; +ALTER TABLE SD_PARAMS MODIFY PARAM_VALUE MEDIUMTEXT; 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); +ALTER TABLE NOTIFICATION_LOG MODIFY TBL_NAME varchar(256) CHARACTER SET latin1 COLLATE latin1_bin; 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); +ALTER TABLE COMPLETED_TXN_COMPONENTS MODIFY CTC_TABLE varchar(256) CHARACTER SET latin1 COLLATE latin1_bin; 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;
