htyoung opened a new pull request, #39688:
URL: https://github.com/apache/doris/pull/39688

   ## Proposed changes
   
   Issue Number: close #39684
   
   <!--Describe your changes.-->
   
   ```sql
   CREATE TABLE `test1` (
       `id1` VARCHAR(255) NULL COMMENT 'id1',
       `id2` VARCHAR(255) NULL COMMENT 'id2',
       `event_time` VARCHAR(255) NULL COMMENT '事件时间',
       `event_date` VARCHAR(255) NULL COMMENT '事件日期',
       `event_ts` VARCHAR(256) NULL COMMENT '事件发生时间戳(毫秒)',
       `dt` VARCHAR(255) NOT NULL COMMENT '日期分区',
       `hr` VARCHAR(255) NOT NULL COMMENT '小时分区'
     ) ENGINE = OLAP DUPLICATE KEY(`id1`) COMMENT 'xxx' PARTITION BY LIST(`dt`, 
`hr`) (
       PARTITION p2024082021 VALUES IN (("2024-08-20", "21"))
     ) DISTRIBUTED BY HASH(`dt`, `hr`) BUCKETS 2 PROPERTIES (
       "replication_allocation" = "tag.location.default: 1",
       "min_load_replica_num" = "-1",
       "is_being_synced" = "false",
       "storage_medium" = "hdd",
       "storage_format" = "V2",
       "inverted_index_storage_format" = "V1",
       "light_schema_change" = "true",
       "disable_auto_compaction" = "false",
       "enable_single_replica_compaction" = "false",
       "group_commit_interval_ms" = "10000",
       "group_commit_data_bytes" = "134217728"
     );
   ```
   
   1. 修改前表已有分区的bucket num为2
   
![image](https://github.com/user-attachments/assets/77efdd0c-f845-41a4-9a31-e454808ffe67)
   
   2. 修改List分区表bucket num(从2 -> 4)
   
![image](https://github.com/user-attachments/assets/53b19918-2879-4cb3-b2bd-84ba35a7fc59)
   
   3. 修改List分区后,添加的新分区bucket num为4
   
![image](https://github.com/user-attachments/assets/1f41f73f-d70f-433e-a7b6-8346b7dfcc4e)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to