learner1212 opened a new issue, #20226: URL: https://github.com/apache/doris/issues/20226
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description Materialized view stored in a special table in doris, but it not support define its own partition, and its data will keep util base table partition deleted. When I want to acceleration my query on latest one hour, my materialized view must keep one year(because my base table data keep one year). In another scenario, I want to query a sum metric one day about one year ago, we must keep our detail data more than one year. In the above two scenarios, we wasted a lot of spaceļ¼ so I hope when we create materialized view, we can create dynamic partition on it, that we can separate materialized view and base table life cycle management by process their partitions. ### Use case _No response_ ### Related issues _No response_ ### Are you willing to submit PR? - [ ] 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
