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?
   
   
![image](https://user-images.githubusercontent.com/15338313/217767211-d1162d60-96d0-49dc-b276-2381881aedc2.png)
   如图:
   正常查询,可以走物化视图
   
   把查询的表,改成子查询以后。无法走物化视图
   
![image](https://user-images.githubusercontent.com/15338313/217767417-a98809e2-4a6f-4c1e-a507-47900da21150.png)
   
   
   
   ### 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

Reply via email to