YangTan09 opened a new issue, #16567: URL: https://github.com/apache/doris/issues/16567
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version doris 1.1.3 ### What's Wrong?  如图: 正常查询,可以走物化视图 把查询的表,改成子查询以后。无法走物化视图  ### What You Expected? 这2个查询应该都能正确走物化视图才对 失败的sql: explain SELECT `month` , `year` , sum(value) FROM ( select * from ecommerce.s_platform_monthly_standard_dm ) flt GROUP BY flt.month, flt.year ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] 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: commits-unsubscr...@doris.apache.org.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