I’m trying to use three projections in same query like below in a Druid environment: But instead I get an error saying – Unknown exception / Cannot build plan for query It seems to work perfectly fine when I put just one count(distinct) in the query. How can this be resolved? Answer As the Druid documentation points out: COUNT(DISTINCT expr)
Tag: druid
SUM aggregation do not work on empty subqueries with DRUID
Assuming I am executing the following two queries on Druid: I tried to combine both counts in one single query with a sum aggregation like the following: And it works well UNLESS one of the two counts returns 0 rows. In that case I receive a Query returned no data message and I don’t have any final result from the