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

   ## Proposed changes
   
   Issue Number: close #xxx
   
   before we forbid it in https://github.com/apache/doris/pull/33736, now it's 
time to let it go.
   
   now we support:
   ```sql
   mysql> create table auto_dynamic(
       ->             k0 datetime(6) NOT NULL
       ->         )
       ->         auto partition by range (date_trunc(k0, 'year'))
       ->         (
       ->         )
       ->         DISTRIBUTED BY HASH(`k0`) BUCKETS 2
       ->         properties(
       ->             "dynamic_partition.enable" = "true",
       ->             "dynamic_partition.prefix" = "p",
       ->             "dynamic_partition.start" = "-50",
       ->             "dynamic_partition.end" = "0",
       ->             "dynamic_partition.time_unit" = "year",
       ->             "replication_num" = "1"
       ->         );
   Query OK, 0 rows affected (0.12 sec)
   ```
   
   with this, the users could manage their data more flexible
   
   we will refactor the docs of it, and the only recommended way it set end to 
zero.


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