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: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org