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) ;