You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2022/11/28 07:25:19 UTC
[GitHub] [pinot] ankitsultana opened a new issue, #9867: [multistage] Add Support for Not-In Operator
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-unsubscribe@pinot.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] walterddr commented on issue #9867: [multistage] Add Support for Not-In Operator
Posted by GitBox <gi...@apache.org>.
walterddr commented on issue #9867:
URL: https://github.com/apache/pinot/issues/9867#issuecomment-1329478992
CC @agavra for the 1 less column - i believe this has to do with how the current pinot-broker reducers expects vs. how calcite expects. thus pinot-server instance response operator returns something not compatible.
--
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@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] walterddr closed issue #9867: [multistage] Add Support for Not-In Operator
Posted by GitBox <gi...@apache.org>.
walterddr closed issue #9867: [multistage] Add Support for Not-In Operator
URL: https://github.com/apache/pinot/issues/9867
--
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@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org