rustyconover opened a new issue, #44961: URL: https://github.com/apache/arrow/issues/44961
### Describe the bug, including details regarding any error messages, version, and platform. When using the `pa.dataset.Expression` with the following code: ```python >>> pc.equal(pc.count(pc.field("allergies"), mode="all"), 0) <pyarrow.compute.Expression (count(allergies, {mode=ALL}) == 0)> ``` This expression correctly evaluates as `True` when there are no elements in the `allergies` list column. However, when attempting to use this expression to filter a dataset, the following error occurs: ``` pyarrow.lib.ArrowInvalid: ExecuteScalarExpression cannot Execute non-scalar expression (count(allergies, {mode=ALL}) == 0) ``` Could you clarify why this filtering expression cannot be used? It appears to be a scalar expression, so I'm unsure why it results in this error. Any guidance would be greatly appreciated! ### Component(s) C++, Python -- 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: issues-unsubscr...@arrow.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org