[GitHub] [pinot] walterddr opened a new issue #8424: CAST used with GROUP BY causes weird exception

[GitBox]

walterddr opened a new issue #8424:
URL: https://github.com/apache/pinot/issues/8424


   ```
   select 
     playerID, 
     cast(hits as long) AS totalHits
   from baseballStats 
   order by totalHits DESC
   ```
   works fine.
   ```
   select 
     playerID, 
     cast(count(hits) as long) AS totalHits
   from baseballStats 
   group by playerID
   order by totalHits DESC
   ```
   gives 
   ```
   [
     {
       "message": "QueryExecutionError:\nProcessingException(errorCode:450, 
message:InternalError:\njava.lang.NullPointerException\n\tat 
org.apache.pinot.core.operator.combine.GroupByOrderByCombineOperator.mergeResults(GroupByOrderByCombineOperator.java:236)\n\tat
 
org.apache.pinot.core.operator.combine.BaseCombineOperator.getNextBlock(BaseCombineOperator.java:119)\n\tat
 
org.apache.pinot.core.operator.combine.BaseCombineOperator.getNextBlock(BaseCombineOperator.java:50)",
       "errorCode": 200
     }
   ]
   ```


-- 
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-unsubscr...@pinot.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org