Doris建分区表
drop table if exists test;
CREATE TABLE test
(
xxx varchar(255) comment 'xxx',
xxx text comment 'xxx',
xxx text comment 'xxx',
xxx text comment 'xxx',
xxx text comment 'xxx',
xxx text comment 'xxx',
xxx text comment 'xxx',
dt date comment '分区日期'
) PARTITION BY RANGE(dt) ()
DISTRIBUTED BY HASH(dt)
PROPERTIES
(
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.start" = "-15",
"dynamic_partition.end" = "15",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "32",
"dynamic_partition.create_history_partition"="true",
"replication_num" = "1"
);