cheezman34 opened a new issue #9596: STDDEV throws exception when combined with a FILTER clause that returns no rows URL: https://github.com/apache/druid/issues/9596 Trivial example of what I'm talking about: `SELECT STDDEV("field1") FILTER(WHERE 1=2), "field2" FROM my_table GROUP BY 2;` If the FILTER clause happens to filter all rows for a given GROUP BY group, then druid throws a `java.lang.IllegalStateException: should not be empty holder` exception. I'd expect it to instead give back a NaN value or something along those lines.
---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
