You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "comphead (via GitHub)" <gi...@apache.org> on 2023/05/18 20:26:47 UTC

[GitHub] [arrow-datafusion] comphead opened a new issue, #6386: UNION ALL push down projection rule failed

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: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] comphead commented on issue #6386: UNION ALL push down projection rule failed

Posted by "comphead (via GitHub)" <gi...@apache.org>.
comphead commented on issue #6386:
URL: https://github.com/apache/arrow-datafusion/issues/6386#issuecomment-1563142146

   Thanks @jonmmease for reporting this. I'm on it now, hope to close both issues.


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] jonmmease commented on issue #6386: UNION ALL push down projection rule failed

Posted by "jonmmease (via GitHub)" <gi...@apache.org>.
jonmmease commented on issue #6386:
URL: https://github.com/apache/arrow-datafusion/issues/6386#issuecomment-1562942955

   In case it's helpful, here's another query (without a `UNION`) that triggers this error:
   
   ```sql
   WITH tbl_0 as (SELECT 0 as "colA")
   SELECT "colA" FROM tbl_0
   CROSS JOIN (SELECT count(0) as "total" from tbl_0)
   ```


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] UNION ALL push down projection rule failed [arrow-datafusion]

Posted by "Dandandan (via GitHub)" <gi...@apache.org>.
Dandandan commented on issue #6386:
URL: https://github.com/apache/arrow-datafusion/issues/6386#issuecomment-1845043211

   This might be a similar issue https://github.com/apache/arrow-datafusion/issues/8450


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] UNION ALL push down projection rule failed [arrow-datafusion]

Posted by "Dandandan (via GitHub)" <gi...@apache.org>.
Dandandan commented on issue #6386:
URL: https://github.com/apache/arrow-datafusion/issues/6386#issuecomment-1847230831

   It looks like this solved https://github.com/apache/arrow-datafusion/pull/8459 as well


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] UNION ALL push down projection rule failed [arrow-datafusion]

Posted by "Dandandan (via GitHub)" <gi...@apache.org>.
Dandandan closed issue #6386: UNION ALL push down projection rule failed
URL: https://github.com/apache/arrow-datafusion/issues/6386


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org