stamboli opened a new issue, #16178: URL: https://github.com/apache/druid/issues/16178
[SampleSaleData.json](https://github.com/apache/druid/files/14668899/SampleSaleData.json) [SampleSaleData.csv](https://github.com/apache/druid/files/14668912/SampleSaleData.csv) ### Affected Version 29.0.0 ### Description - Steps to reproduce the problem Upload the csv being attached, druid spec for it is also attached for reference Simplest query that can reproduce issues is as follows SELECT COUNT(DISTINCT (CASE WHEN (("SampleSaleData"."__time" >= '2022-01-12T00:00:00.000Z') AND ("SampleSaleData"."__time" < '2022-01-13T00:00:00.000Z')) THEN "City" END)) AS "P2-DistinctCities", COUNT(DISTINCT (CASE WHEN (("SampleSaleData"."__time" >= '2022-01-05T00:00:00.000Z') AND ("SampleSaleData"."__time" < '2022-01-06T00:00:00.000Z')) THEN "City" END)) AS "P1-DistinctCities" FROM SampleSaleData "SampleSaleData" This query which used to work earlier and give results as 4, 8 is now returning 0,0 - Any debugging that you have already done -If this query is run keeping one aggregation at a time, either first one or second one only this still gives correct result, only when both are present it is giving wrong result -- 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]
