comphead opened a new issue, #6386: URL: https://github.com/apache/arrow-datafusion/issues/6386
### Describe the bug Bug description below ### To Reproduce ``` ❯ WITH w1 AS (select 1 as x , max(10) as y), w2 AS (select 5 as n_regionkey) select count(*) cnt from w2 group by n_regionkey union all select x from w1; Optimizer rule 'push_down_projection' failed caused by Error during planning: Aggregate requires at least one grouping or aggregate expression ``` ### Expected behavior Query should work ### Additional context part of UNION ALL problems and originated from https://github.com/apache/arrow-datafusion/issues/5747 -- 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]
