Indhumathi27 opened a new pull request #3955: URL: https://github.com/apache/carbondata/pull/3955
### Why is this PR needed? If a MV having aggregation, is created with all columns present in main table, then some sub-queries are not hitting mv. ### What changes were proposed in this PR? 1. When all columns are given in projection in a aggregate query, logical plan will not have Project node. Added Project node to logical plan in this case, to match subqueries also to mv. 2. In GroupByGroupByNochildData pattern, added check for checking CAST(aggregate expression) and used group by result to get final compensation result ### Does this PR introduce any user interface change? - No ### Is any new testcase added? - Yes ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org