jiangxt2 opened a new issue, #13424:
URL: https://github.com/apache/gravitino/issues/13424

   ### Describe the feature
   Support Doris AUTO RANGE partitioning based on `date_trunc` in the Doris 
JDBC catalog. Gravitino should preserve the transform when loading tables, 
create tables with this partitioning, provide list/get access to physical 
partitions, and support native add/drop operations.
   
   ### Motivation
   Doris can create date-based range partitions automatically as data arrives. 
The Doris JDBC catalog currently does not preserve the `date_trunc` partition 
expression when loading such a table and cannot create this AUTO RANGE form 
through Gravitino. As a result, clients cannot rely on Gravitino to retain the 
table's partition definition and interact with its physical partitions.
   
   ### Describe the solution
   Recognize only Doris `date_trunc` partition expressions with one column and 
an interval literal, including the documented form that omits the `AUTO` 
keyword. Preserve the expression as partitioning metadata and generate DDL such 
as `AUTO PARTITION BY RANGE (date_trunc(column, 'month')) ()` when creating a 
table through Gravitino. Use `SHOW CREATE TABLE` to recover the expression and 
`SHOW PARTITIONS` to expose physical ranges. Delegate supported add/drop 
operations and native constraint/version validation to Doris. Keep existing 
manual RANGE and LIST behavior unchanged.
   
   ### Additional context
   Gravitino-created tables use an empty origin-partition list; loading and 
reading native Doris origin partitions remains in scope. The request is limited 
to DATE/DATETIME `date_trunc` AUTO RANGE in the Doris JDBC catalog. AUTO LIST, 
arbitrary partition expressions, `dynamic_partition.*` properties, defining 
origin partitions through Gravitino, public API changes, and manual RANGE/LIST 
UI or assignment-readback work are out of scope. Related issues: 
[#8344](https://github.com/apache/gravitino/issues/8344) covers default bucket 
handling, [#12094](https://github.com/apache/gravitino/issues/12094) covers the 
Web UI workflow for manual RANGE/LIST partitions, and 
[#12093](https://github.com/apache/gravitino/issues/12093) covers manual 
RANGE/LIST assignment readback.
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to