创建表时,一次性创建了2022-01-01~至今(by day)的分区,创建分区非常缓慢,导致我在select时显示表已存在,drop时显示表不存在,现在进退两难,请教该怎么处理?
部分DDL:
PARTITION BY RANGE(stat_dt
)
(
START (‘2022-01-01’) END (‘2024-12-28’) EVERY (INTERVAL 1 DAY)
)
DISTRIBUTED BY HASH(stat_dt
) BUCKETS 10
PROPERTIES (
“replication_num” = “3”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.time_zone” = “Asia/Shanghai”,
“dynamic_partition.start” = “-2147483648”,
“dynamic_partition.end” = “2”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.buckets” = “10”,
“dynamic_partition.history_partition_num” = “0”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”,
“compression” = “LZ4”
);