stamboli commented on issue #16178:
URL: https://github.com/apache/druid/issues/16178#issuecomment-2011818779
Looking at your test case I formed query based on it which works.
SELECT
COUNT(DISTINCT "City") FILTER (WHERE ("SampleSaleData"."__time" >=
'2022-01-12T00:00:00.000Z') AND ("SampleSaleData"."__time" <
'2022-01-13T00:00:00.000Z')) AS "P2-DistinctCities",
COUNT(DISTINCT "City") FILTER (WHERE ("SampleSaleData"."__time" >=
'2022-01-05T00:00:00.000Z') AND ("SampleSaleData"."__time" <
'2022-01-06T00:00:00.000Z')) AS "P2-DistinctCities"
FROM
SampleSaleData "SampleSaleData"
But this query, very specific to druid. The solution we are building need to
work with multiple DB this query is not working with MySQL as well as
Snowflake, the queries are built dynamically, so a very specific druid SQL
needs to be built. Until now CASE based query was worked with other traditional
standard DBs used to work with druid as well.
So overall now this is failure is specifically related to CASE statements
with multiple such aggregations
--
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]
