egalpin opened a new issue, #11139:
URL: https://github.com/apache/pinot/issues/11139
```sql
SELECT CAST(myCol AS LONG) AS myCol WHERE myCol IS NOT NULL
```
The above will fail with
```
Caused by: java.lang.UnsupportedOperationException: Unsupported predicate
type: IS_NULL
at
org.apache.pinot.core.operator.filter.predicate.PredicateEvaluatorProvider.getPredicateEvaluator(PredicateEvaluatorProvider.java:89)
```
Is that because there is no `IsNotNullPredicateEvaluatorFactory` akin to the
other factories found in `PredicateEvaluatorProvider`. Is having
`Is[Not]NullPredicateEvaluatorFactory` a bad idea, or just something that has
not yet been implemented?
The above query works just fine in the case where the alias is changed to be
distinct from the original column name (or alias removed entirely). This works
fine:
```sql
SELECT CAST(myCol AS LONG) AS __myCol WHERE myCol IS NOT NULL
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
