mtk迁移mysql to mogdb,报错MySQL2008: MySQL Not Support SubPart Type KEY.
原作者:陆凯
适用范围
mtk异构迁移mysql到mogdb
mtk:2.8.3
mogdb:3.0.0
问题概述
在生产中使用mtk工具进行异构迁移(mysql to mogdb)带子分区的表t时,报错MySQL-2008: MySQL Not Support SubPart Type KEY.
mysql表结构(拥有子分区):
CREATE TABLE t (
TRANSIDO varchar(30) NOT NULL,
MOBILE varchar(11) NOT NULL,
INSERTTIME datetime NOT NULL,
APP varchar(100) DEFAULT NULL,
UNIQUE T_UQ_IDX (TRANSIDO,APP,INSERTTIME,MOBILE) USING BTREE,
KEY T_MOBILE_IDX (MOBILE) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
PARTITION BY RANGE (TO_DAYS(INSERTTIME))
SUBPARTITION BY KEY (MOBILE)
SUBPARTITIONS 9
(PARTITION p20230623 VALUES LESS THAN (739059) ENGINE = InnoDB,
PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB) ;