dangerousfeng opened a new issue, #19927: URL: https://github.com/apache/doris/issues/19927
### 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 物化视图的表能否有一个自定义的表名作为一张新的表存在 Whether a table with a materialized view can have a custom table name as a new table ### Use case 我现在创建了一个物化视图： `create materialized view k1_k2_sumk3 as select k1, k2, sum(k3) from example_table group by k1, k2;` 为了后续使用方便，我需要现创建一个对应的视图： `create view example_db.view_that_target_table (k1, k2, k3) AS select k1, k2, sum(k3) as v1 from example_table group by k1, k2;` 然后再基于这个视图做后续的查询使用，或者JOIN操作： `select k1, v1 from view_that_target_table` `select k1, v1 from view_that_target_table join ...` 是否可以在创建物化视图时指定其表名，因为本身物化视图的数据就是一个新的表数据。 ### 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]
