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

   PR #35778  will throw exception if dynamic partition overlap with others.  
Don't throw exception now considering behaviour change.  Just ignore create 
this partition.
   
   SQL:
   ```
   COMMENT 'author=zy 大局战斗事实表,一行数据描述的含义:一个玩家在一次大局比赛的记录'
   PARTITION BY RANGE(`dt`)(
   PARTITION `phistory` VALUES less than ('2024-01-01')
   )
   DISTRIBUTED BY HASH(`user_id`, `room_id`) BUCKETS 3
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "dynamic_partition.enable" = "true",
   "dynamic_partition.time_unit" = "DAY",
   "dynamic_partition.end" = "10",
   "dynamic_partition.prefix" = "p",
   "dynamic_partition.create_history_partition" = "true",
   "dynamic_partition.history_partition_num" = "250"
   ); 
   ```
   
   error:
   ```
   ERROR 1105 (HY000): errCode = 2, detailMessage = errCode = 2, detailMessage 
= errCode = 2, detailMessage = Range [types: [DATEV2]; keys: [0000-01-01]; 
..types: [DATEV2]; keys: [2024-01-01]; ) is intersected with range: [types: 
[DATEV2]; keys: [2023-12-29]; ..types: [DATEV2]; keys: [2023-12-30]; ) 
   ```
   
   
   


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