You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "dang-stripe (via GitHub)" <gi...@apache.org> on 2026/03/24 21:03:03 UTC
[I] [multistage] physical optimizer causes `"function" is null` for boolean filters [pinot]
dang-stripe opened a new issue, #17960:
URL: https://github.com/apache/pinot/issues/17960
We ran into this error when trying the physical optimizer.
Error:
```
ERROR [PinotClientRequest] [jersey-server-managed-async-executor-79481:91294] Query processing exceptions: {150=SQLParsingError: Error composing query plan: Cannot invoke "org.apache.pinot.common.request.Function.getOperator()" because "function" is null. Cannot invoke "org.apache.pinot.common.request.Function.getOperator()" because "function" is null}
```
Query:
```
SET useMultistageEngine=true;
SET usePhysicalOptimizer=true;
SELECT * FROM "table1"
WHERE "user" = 'user_1234' AND "success" = true
```
Removing the filter on `success` works. Claude's analysis seems to indicate:
* `LeafStageToPinotQuery` needs to be updated to wrap IDENTIFIER/LITERAL expressions into FUNCTION expressions that the pruners can handle
* Pruners should have null checks on `getFunctionCall()` so this path fails gracefully
--
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
Re: [I] [multistage] physical optimizer causes `"function" is null` for boolean filters [pinot]
Posted by "ankitsultana (via GitHub)" <gi...@apache.org>.
ankitsultana commented on issue #17960:
URL: https://github.com/apache/pinot/issues/17960#issuecomment-4129094912
@dang-stripe : are you raising the fix for this?
--
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
Re: [I] [multistage] physical optimizer causes `"function" is null` for boolean filters [pinot]
Posted by "dang-stripe (via GitHub)" <gi...@apache.org>.
dang-stripe commented on issue #17960:
URL: https://github.com/apache/pinot/issues/17960#issuecomment-4129947043
@ankitsultana Yes I'll take this one
--
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
Re: [I] [multistage] physical optimizer causes `"function" is null` for boolean filters [pinot]
Posted by "xiangfu0 (via GitHub)" <gi...@apache.org>.
xiangfu0 closed issue #17960: [multistage] physical optimizer causes `"function" is null` for boolean filters
URL: https://github.com/apache/pinot/issues/17960
--
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