前提:
- tidb版本4.0.0
问题:
1、使用分区语句REORGANIZE PARTITION tidb报错不支持,想问下tidb后续版本是否会支持这个拆分分区的语句。
使用例子:
CREATE TABLE `deliver_sale` (
`code` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '客户编码',
`name` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '客户名称',
`file_id` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '原始文件ID',
`seller_date` date NOT NULL COMMENT '销售日期',
PRIMARY KEY (`seller_date`),
KEY `index_source_file_id` (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='销售数据'
PARTITION BY RANGE ( TO_DAYS(`seller_date`) ) (
PARTITION `p01` VALUES LESS THAN ( TO_DAYS('2020-01-25')),
PARTITION `p02` VALUES LESS THAN ( TO_DAYS('2020-02-25')),
PARTITION `p03` VALUES LESS THAN ( TO_DAYS('2020-03-25')),
PARTITION `p04` VALUES LESS THAN ( TO_DAYS('2020-04-25')),
PARTITION `p05` VALUES LESS THAN ( TO_DAYS('2020-05-25')),
);
# 新增分区
ALTER TABLE test.deliver_sale ADD PARTITION (PARTITION p06 VALUES LESS THAN ( TO_DAYS('2020-06-25')));
ALTER TABLE test.deliver_sale ADD PARTITION (PARTITION p07 VALUES LESS THAN ( TO_DAYS('2020-07-25')));
# 拆分分区
ALTER TABLE test.deliver_sale REORGANIZE PARTITION p07 INTO (
PARTITION s0 VALUES LESS THAN ( TO_DAYS('2020-07-15')),
PARTITION s1 VALUES LESS THAN ( TO_DAYS('2020-07-25'))
);