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 分区

https://pingcap.com/docs-cn/stable/reference/sql/partitioning/#分区表

非常感谢!

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

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。