https://doris.apache.org/zh-CN/docs/2.1/table-design/data-partitioning/auto-partitioning
官网案例
create table auto_dynamic(
k0 datetime(6) NOT NULL
)
auto partition by range (date_trunc(k0, 'year'))
(
)
DISTRIBUTED BY HASH(k0) BUCKETS 2
properties(
"dynamic_partition.enable" = "true",
"dynamic_partition.prefix" = "pa",
"dynamic_partition.start" = "-50",
"dynamic_partition.end" = "0", --- Dynamic Partition 不创建分区
"dynamic_partition.time_unit" = "year",
"replication_num" = "1"
);
SHOW PARTITIONS FROM auto_dynamic;
建完表会马上创建一个当年的分区,pa2026 ,文档写的动态分区不创建分区
