Doris分区表-动态分区
https://doris.apache.org/zh-CN/docs/dev/advanced/partition/dynamic-partition
动态分区是在 Doris 0.12 版本中引入的新功能。旨在对表级别的分区实现生命周期管理(TTL),减少用户的使用负担。
目前实现了动态添加分区及动态删除分区的功能。
动态分区只支持 Range 分区。
注意:这个功能在被CCR同步时将会失效。如果这个表是被CCR复制而来的,即PROPERTIES中包含is_being_synced = true时,在show create table中会显示开启状态,但不会实际生效。当is_being_synced被设置为 false 时,这些功能将会恢复生效,但is_being_synced属性仅供CCR外围模块使用,在CCR同步的过程中不要手动设置。
示例
CREATE TABLE `dwd_test_xxxx_aaaa_rim` (
`apply_date` date NULL COMMENT '日期',
`user_course_id` bigint(20) NULL COMMENT 'id',
`supplier_id` bigint(20) NULL COMMENT 'id',
`order_id` bigint(20) NULL COMMENT '订单id',
`apply_time` datetime NULL COMMENT '时间',
`origin_channel_arguments` varchar(512) NULL COMMENT '渠道参数'
)
ENGINE=OLAP
UNIQUE KEY(`apply_date`,`user_course_id`,`supplier_id`)
COMMENT '测试表'
PARTITION BY RANGE(`apply_date`) ()
DISTRIBUTED BY HASH(`supplier_id`) BUCKETS 3
PROPERTIES
(
"replication_allocation" = "tag.location.default: 3",
"is_being_synced" = "false",
"storage_format" = "V2",
"compression" = "ZSTD",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.start" = "-5",
"dynamic_partition.end" = "1",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "1"
);