ankitsultana opened a new issue, #10628:
URL: https://github.com/apache/pinot/issues/10628
This query:
```
SELECT COUNT(*) FROM userAttributes_OFFLINE
WHERE daysSinceFirstTrip NOT IN (SELECT daysSinceFirstTrip FROM
userAttributes_OFFLINE)
```
fails with:
```
2023/04/17 15:08:16.508 ERROR [OpChainSchedulerService]
[query_worker_on_60908_port-7-thread-5] (OpChain{8_0_1}): Completed erroneously
(8_0_1) Queued Count: 2, Executing Time: 21ms, Queued Time: 0ms {1000=class
java.lang.Boolean cannot be cast to class java.lang.Number (java.lang.Boolean
and java.lang.Number are in module java.base of loader 'bootstrap')
java.lang.ClassCastException: class java.lang.Boolean cannot be cast to
class java.lang.Number (java.lang.Boolean and java.lang.Number are in module
java.base of loader 'bootstrap')
at
org.apache.pinot.query.runtime.operator.utils.AggregationUtils.mergeMin(AggregationUtils.java:62)
at
org.apache.pinot.query.runtime.operator.utils.AggregationUtils$Accumulator.lambda$static$6(AggregationUtils.java:116)
at
org.apache.pinot.query.runtime.operator.utils.AggregationUtils$Accumulator.accumulate(AggregationUtils.java:174)
at
org.apache.pinot.query.runtime.operator.AggregateOperator.consumeInputBlocks(AggregateOperator.java:205)}
```
Calcite defines an ordering between boolean values (see
`SqlFunctions::compare`) which is the same as `Boolean.compareTo`, i.e. false
is less than true. I think we need to update AggregationUtils to add support
for a boolean merger for min/max functions.
@somandal : Can you lmk your thoughts?
--
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]