自动分区与动态分区联用
版本: doris-2.1.11-rc01-97b77e6cda
自动建表的分区名和动态分区名不一致,如下图,p20250909 、p20250910000000 、p20250911、p20250912000000
建表,保留历史七天分区:
CREATE TABLE tb1
(
dt datetime NOT NULL COMMENT '时间分区',
job_desc VARCHAR(255) COMMENT '任务描述'
) UNIQUE KEY(dt)
COMMENT '任务详情'
AUTO PARTITION BY RANGE (date_trunc(`dt`, 'day'))()
DISTRIBUTED BY HASH(`dt`) BUCKETS AUTO
PROPERTIES (
"dynamic_partition.enable" = "true",
"dynamic_partition.prefix" = "p",
"dynamic_partition.start" = "-7",
"dynamic_partition.end" = "0", --- Dynamic Partition 不创建分区
"dynamic_partition.time_unit" = "day",
"replication_num" = "3"
);