[GitHub] [incubator-pinot] chundongwang commented on issue #6253: NullPointerException is thrown when query with aggregation on top of groovy functions

[GitBox <gi...@apache.org>]

chundongwang commented on issue #6253:
URL: https://github.com/apache/incubator-pinot/issues/6253#issuecomment-725070465


   With the help from @npawar (thanks!), I got it to work. So to sum up,
   
   1. Aggregation functions like `Avg`/`Sum`/`PercentileTDigest##` would all require `double` so need to convert the  groovy return to be `double`, which means all possible return values should be cast to `double` (eg using `column_name.toDouble()`) ;
   2. I have a number literal, `0.0`, in the query which I assumed to make it double. Actually that became a `BigDecimal` and cause issue. So instead I used 0d and second exception is gone.
   3. More exception could be found on server log, not broker log.


----------------------------------------------------------------
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.

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



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