tidb创建分区表失败

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:5.7.10-TiDB-v2.0.11
  • 【问题描述】:下面的命令创建分区表失败

CREATE TABLE dubbo_invoke ( id varchar(255) NOT NULL DEFAULT ‘’, invoke_date date NOT NULL, service varchar(255) DEFAULT NULL, method varchar(255) DEFAULT NULL, consumer varchar(255) DEFAULT NULL, provider varchar(255) DEFAULT NULL, type varchar(255) DEFAULT ‘’, invoke_time bigint(20) DEFAULT NULL, success int(11) DEFAULT NULL, failure int(11) DEFAULT NULL, elapsed int(11) DEFAULT NULL, concurrent int(11) DEFAULT NULL, max_elapsed int(11) DEFAULT NULL, max_concurrent int(11) DEFAULT NULL, PRIMARY KEY (id,invoke_date), KEY index_service (service) USING BTREE, KEY index_method (method) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT PARTITION BY LIST (MOD(TO_DAYS(invoke_date), 15)) (PARTITION p00 VALUES IN (0) ENGINE = InnoDB, PARTITION p01 VALUES IN (1) ENGINE = InnoDB, PARTITION p02 VALUES IN (2) ENGINE = InnoDB, PARTITION p03 VALUES IN (3) ENGINE = InnoDB, PARTITION p04 VALUES IN (4) ENGINE = InnoDB, PARTITION p05 VALUES IN (5) ENGINE = InnoDB, PARTITION p06 VALUES IN (6) ENGINE = InnoDB, PARTITION p07 VALUES IN (7) ENGINE = InnoDB, PARTITION p08 VALUES IN (8) ENGINE = InnoDB, PARTITION p09 VALUES IN (9) ENGINE = InnoDB, PARTITION p10 VALUES IN (10) ENGINE = InnoDB, PARTITION p11 VALUES IN (11) ENGINE = InnoDB, PARTITION p12 VALUES IN (12) ENGINE = InnoDB, PARTITION p13 VALUES IN (13) ENGINE = InnoDB, PARTITION p14 VALUES IN (14) ENGINE = InnoDB) ;

报错信息如下:

请问是什么原因呢

若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。

目前 TiDB 只支持 Range 和 Hash 分区,还不支持 List 分区

非常感谢!

:+1::+1::+1: