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]

Reply via email to