Naveen Gangam created HIVE-19250: ------------------------------------ Summary: Schema column definitions inconsistencies in MySQL Key: HIVE-19250 URL: https://issues.apache.org/jira/browse/HIVE-19250 Project: Hive Issue Type: Bug Components: Hive Affects Versions: 2.1.0 Reporter: Naveen Gangam Assignee: Naveen Gangam
There are some inconsistencies in column definitions in MySQL between a schema that was upgraded to 2.1 (from an older release) vs installing the 2.1.0 schema directly. > `CQ_TBLPROPERTIES` varchar(2048) DEFAULT NULL, 117d117 < `CQ_TBLPROPERTIES` varchar(2048) DEFAULT NULL, 135a136 > `CC_TBLPROPERTIES` varchar(2048) DEFAULT NULL, 143d143 < `CC_TBLPROPERTIES` varchar(2048) DEFAULT NULL, 156c156 < `CTC_TXNID` bigint(20) DEFAULT NULL, --- > `CTC_TXNID` bigint(20) NOT NULL, 158c158 < `CTC_TABLE` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, --- > `CTC_TABLE` varchar(256) DEFAULT NULL, 476c476 < `TBL_NAME` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, --- > `TBL_NAME` varchar(256) DEFAULT NULL, 664c664 < KEY `PCS_STATS_IDX` (`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME`,`PARTITION_NAME`), --- > KEY `PCS_STATS_IDX` (`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME`,`PARTITION_NAME`) > USING BTREE, 768c768 < `PARAM_VALUE` mediumtext, --- > `PARAM_VALUE` mediumtext CHARACTER SET latin1 COLLATE latin1_bin, 814c814 < `PARAM_VALUE` mediumtext, --- > `PARAM_VALUE` mediumtext CHARACTER SET latin1 COLLATE latin1_bin, 934c934 < `PARAM_VALUE` mediumtext, --- > `PARAM_VALUE` mediumtext CHARACTER SET latin1 COLLATE latin1_bin, 1066d1065 < `TXN_HEARTBEAT_COUNT` int(11) DEFAULT NULL, 1067a1067 > `TXN_HEARTBEAT_COUNT` int(11) DEFAULT NULL, 1080c1080 < `TC_TXNID` bigint(20) DEFAULT NULL, --- > `TC_TXNID` bigint(20) NOT NULL, 1082c1082 < `TC_TABLE` varchar(128) DEFAULT NULL, --- > `TC_TABLE` varchar(128) NOT NULL, 1084c1084 < `TC_OPERATION_TYPE` char(1) DEFAULT NULL, --- > `TC_OPERATION_TYPE` char(1) NOT NULL, -- This message was sent by Atlassian JIRA (v7.6.3#76005)