htyoung opened a new issue, #39684:
URL: https://github.com/apache/doris/issues/39684

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   1.2.x  2.0.x  2.1.x  3.0.x  master
   
   ### What's Wrong?
   
   When I want to change the bucket num for List partition table, it report 
error.
   
   ```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: 3",
       "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"
     );
   ```
   
   
![image](https://github.com/user-attachments/assets/628edd45-0057-43e5-be5d-aa71a7eea036)
   
   
![image](https://github.com/user-attachments/assets/904ed0c8-ac6a-42af-975c-e7bd37277bbe)
   
   ### What You Expected?
   
   I can modify the default bucket num for List partition table
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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.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