[GitHub] [pinot] ankitsultana opened a new issue, #10129: [multistage] Projection Not Pushed Down for Agg Queries with No Grouping Sets

[GitBox]

ankitsultana opened a new issue, #10129:
URL: https://github.com/apache/pinot/issues/10129

   Repro:
   
   ```
   SELECT
     COUNT(*)
   FROM
     baseballStats_OFFLINE AS A
     JOIN baseballStats_OFFLINE AS B ON A.playerID = B.playerID
   WHERE
     A.hits > 10 AND B.hits < 5
   ```
   
   This query will end up reading all the columns in the table-scan stage. The 
reason is that there's no projection node created by Calcite. (will add more 
repro queries soon)
   
   I am testing out a few approaches for a fix in this PR: 
https://github.com/apache/pinot/pull/10122
   
   Btw, this is what GPT recommends:
   
   cc: @walterddr 
   
   <img width="786" alt="image" 
src="https://user-images.githubusercontent.com/8644710/212462065-5cec3444-31d4-4965-b4f3-f771303a1fa5.png";>
   


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

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org