表结果如下:
CREATE TABLE IF NOT EXISTS test1
(
project
VARCHAR(100),
channel_id
VARCHAR(100),
device_id
VARCHAR(150),
user
VARCHAR(50),
update_time
DateTime,
created_at
DateTime(3) COMMENT '创建时间',
)
UNIQUE KEY(project, channel_id,device_id)
DISTRIBUTED BY HASH(device_id) BUCKETS 10
PROPERTIES (
"enable_unique_key_merge_on_write" = "true",
"store_row_column" = "true",
"function_column.sequence_type" = "DATETIME",
"function_column.sequence_col" = "created_at",
)
这是业务表的部分表结构, 打算从clickhouse 迁到 doris 中,clickhouse 的写法: TTL update_time + toIntervalMonth(6);
有2个疑惑:
- 能不能分区,这种情况如何分区?
- 过期key 如何删除