为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【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) ;
报错信息如下:
请问是什么原因呢
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。