【详述】在starrocks建表,按天分区,这么设置可以永久保存历史数据
【建表sql示例】
CREATE TABLE if not exists redmoonoa9_ac(
id bigint,
ac_group_id bigint,
ac_group_name varchar,
template_id bigint,
check_person_qty int,
type varchar,
year int,
month int,
status varchar,
create_date Date,
create_date_time varchar,
create_user_id bigint,
update_date_time varchar,
update_user_id bigint
)DUPLICATE KEY(id,ac_group_id)
partition by range(create_date)()
DISTRIBUTED BY HASH(id) BUCKETS 10 properties (
“replication_num” = “2”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.start” = “-2147483648”,
“dynamic_partition.end” = “1”,
“dynamic_partition.prefix” = “par”,
“dynamic_partition.buckets” = “10”
);
【参数设置】
“dynamic_partition.start” = “-2147483648”,
“dynamic_partition.end” = “1”
这两个参数应该怎么设置才能使历史数据永久保存
【StarRocks版本】2.5…2
【集群规模】例如：3fe（1 follower+2observer）+3be（fe与be混部）
【联系方式】392388393@qq.com