ankitsultana opened a new issue, #9867:
URL: https://github.com/apache/pinot/issues/9867
At present the following query doesn't work:
```
SELECT
teamID
FROM
baseballStats
WHERE
teamID NOT IN (
SELECT
teamID
FROM
baseballStats
WHERE
hits > 10
)
```
This gets converted to a left-join which is correct. However there a couple
of issues:
1. The FilterOperand doesn't recognize the "IS NOT TRUE" function.
2. Projection for the table-scan is not pushed down, so the join ends up
pulling in data for all the columns.
re: 2, it also hits a bug where the mailbox send operator receives a block
which has 1 less column (teamID0 column) than expected.
This query can also benefit from colocated joins.
cc: @walterddr
--
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
