3.0.3 动态分区和自动分区 创建的名称不一致

Viewed 26
3.0

第一种场景：

CREATE TABLE `wjx_test_auto_dynamic_paratition_v32` (
  `dt` date NOT NULL,
  `order_item_id` bigint NOT NULL COMMENT '订单明细id',
  `order_id` bigint NOT NULL COMMENT '订单id',
  `id` bigint NOT NULL COMMENT '主键',
  INDEX idx_order_id (`order_id`) USING INVERTED
) ENGINE = OLAP UNIQUE KEY(`dt`, `order_item_id`) AUTO PARTITION BY RANGE (date_trunc(`dt`, 'day')) () 
  DISTRIBUTED BY HASH(`order_item_id`) BUCKETS 10 PROPERTIES ( "file_cache_ttl_seconds" = "0", "is_being_synced" = "false", 
   "storage_medium" = "hdd", 
   "storage_format" = "V2", 
   "inverted_index_storage_format" = "V2", 
   "enable_unique_key_merge_on_write" = "true", 
   "light_schema_change" = "true", 
   "storage_vault_name" = "s3_vault", 
   "disable_auto_compaction" = "false", 
   "enable_single_replica_compaction" = "false", 
   "group_commit_interval_ms" = "10000", 
   "group_commit_data_bytes" = "134217728", 
   "enable_mow_light_delete" = "false" 
    );  
  


  ALTER TABLE wjx_test_auto_dynamic_paratition_v32 SET (
    "dynamic_partition.enable" = "true",
    "dynamic_partition.time_unit" = "DAY",
    "dynamic_partition.start" = "-60",
    "dynamic_partition.end" = "0",
    "dynamic_partition.prefix" = "p"
);

会自动创建一个p20250208 的partitionName，与自动分区创建的 p20250208000000 的partitionName不一致。

第二种场景：

CREATE TABLE `wjx_test_auto_dynamic_paratition_v6` (
  `dt` date NOT NULL,
  `order_item_id` bigint NOT NULL COMMENT '订单明细id',
  `order_id` bigint NOT NULL COMMENT '订单id',
  `id` bigint NOT NULL COMMENT '主键',
  INDEX idx_order_id (`order_id`) USING INVERTED
) ENGINE = OLAP UNIQUE KEY(`dt`, `order_item_id`) 
AUTO PARTITION BY RANGE (date_trunc(`dt`, 'day')) (
  
  ) 
  DISTRIBUTED BY HASH(`order_item_id`) BUCKETS 10 
  PROPERTIES ( 
  "file_cache_ttl_seconds" = "0", 
  "is_being_synced" = "false", 
  "storage_medium" = "hdd", 
  "storage_format" = "V2", 
  "inverted_index_storage_format" = "V2", 
  "enable_unique_key_merge_on_write" = "true", 
  "light_schema_change" = "true", 
  "storage_vault_name" = "s3_vault", 
  "disable_auto_compaction" = "false", 
  "enable_single_replica_compaction" = "false", 
  "group_commit_interval_ms" = "10000", 
  "group_commit_data_bytes" = "134217728", 
  "enable_mow_light_delete" = "false" , 
  "dynamic_partition.enable" = "true",
  "dynamic_partition.time_unit" = "DAY",
  "dynamic_partition.start" = "-60",
  "dynamic_partition.end" = "0", 
  "dynamic_partition.prefix" = "p"
  );

也会自动创建一个p20250208 的partitionName，与自动分区创建的 p20250208000000 的partitionName不一致。

35
1 Answers

下一个版本会修复这个问题。目前如果需要分区名一致的话推荐手动修改一下来保持

zclllyybb551