自动分区与动态分区联用分区名称不一致

Viewed 3

自动分区与动态分区联用

版本: doris-2.1.11-rc01-97b77e6cda

自动建表的分区名和动态分区名不一致,如下图,p20250909 、p20250910000000 、p20250911、p20250912000000
image.png

参考地址:
https://doris.apache.org/zh-CN/docs/3.0/table-design/data-partitioning/auto-partitioning#%E4%B8%8E%E5%8A%A8%E6%80%81%E5%88%86%E5%8C%BA%E8%81%94%E7%94%A8

建表,保留历史七天分区:

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"
);
0 Answers