1 个回答
创建多分区其实就是需要自己去根据某个字段定义分区,例如:
CREATE TABLE `user` (
`id` int(10) COMMENT "唯一id",
`name` varchar(20) COMMENT "",
`idcard` varchar(18) COMMENT "身份证",
`age` TINYINT(3) NULL COMMENT "年龄",
`cts` DATE NOT NULL COMMENT "数据创建时间"
)
DUPLICATE KEY(`id`, `name`,`idcard`,`age`)
PARTITION BY RANGE(`cts`)
(
PARTITION p202201 VALUES LESS THAN ('2022-02-01'),
PARTITION p202202 VALUES LESS THAN ('2022-03-01'),
PARTITION p202203 VALUES LESS THAN ('2022-04-01')
)
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "V2"
)
发布于:3年前 (2022-11-02) IP属地:四川省
我来回答
您需要 登录 后回答此问题!