You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@gluten.apache.org by "lgbo-ustc (via GitHub)" <gi...@apache.org> on 2024/09/04 05:50:43 UTC

[I] [CH]Pushdown extra projection before `expand` [incubator-gluten]

lgbo-ustc opened a new issue, #7112:
URL: https://github.com/apache/incubator-gluten/issues/7112

   ### Description
   
   For following query
   ```sql
   
   select x, y, count(if(a > 0, b, c)) as n from t
   group by x, y with cube
   ```
   
   It will add an extra projection after `expand` for pre-calculating `if(a>0,b, c)`.
   
   
   For performance, we should push down the projection before `expand`


-- 
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-unsubscribe@gluten.apache.org.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org


Re: [I] [CH]Pushdown extra projection before `expand` [incubator-gluten]

Posted by "lgbo-ustc (via GitHub)" <gi...@apache.org>.
lgbo-ustc commented on issue #7112:
URL: https://github.com/apache/incubator-gluten/issues/7112#issuecomment-2330883766

   before pushdown
   ![image](https://github.com/user-attachments/assets/0b123e0e-b2fe-40e0-b01e-1420c72b0f73)
   
   
   after pushdown
   ![image](https://github.com/user-attachments/assets/f8d088aa-8c3a-4081-ab9d-98c9354acc2a)
   


-- 
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-unsubscribe@gluten.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org


Re: [I] [CH]Pushdown extra projection before `expand` [incubator-gluten]

Posted by "lgbo-ustc (via GitHub)" <gi...@apache.org>.
lgbo-ustc closed issue #7112: [CH]Pushdown extra projection before `expand`
URL: https://github.com/apache/incubator-gluten/issues/7112


-- 
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-unsubscribe@gluten.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@gluten.apache.org
For additional commands, e-mail: commits-help@gluten.apache.org