You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Naveen Gangam (JIRA)" <ji...@apache.org> on 2018/04/19 18:52:00 UTC
[jira] [Created] (HIVE-19250) Schema column definitions
inconsistencies in MySQL
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)