pcallahan-r7 opened a new issue #11390: URL: https://github.com/apache/druid/issues/11390
Please provide a detailed title (e.g. "Broker crashes when using TopN query with Bound filter" instead of just "Broker crashes"). ### Affected Version 0.20.1 ### Description Using the wikipedia tutorial data, this query works fine. Note the `SUM(added)` in the inner query. ```sql select DS_GET_QUANTILE(DS_QUANTILES_SKETCH(xxxx), 0.5) AS test FROM (select countryIsoCode, SUM(added) AS xxxx FROM wikipedia GROUP BY 1 having xxxx > 0) ``` Now change the query to be `ABS(SUM(added))` and no results are produced. Expected the same result. Note the `having` clause must be present to observe this defect. Also note I believe this has been fixed in the latest version of Imply druid. full query that fails: ```sql select DS_GET_QUANTILE(DS_QUANTILES_SKETCH(xxxx), 0.5) AS test FROM (select countryIsoCode, ABS(SUM(added)) AS xxxx FROM wikipedia GROUP BY 1 having xxxx > 0) ``` - Cluster size: micro - Configurations in use: wikipedia tutorial data -- 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]
