You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
According to the docs, count(disctinct()) is supported, but other nested aggregate queries still return values, but they are not correct. A non 200 response should be returned instead, since they are not supported.
Some examples: select mean(distinct(customerId)) from customer_events returns null select min(distinct(customerId)) from customer_events returns 1.7976931348623157e+308 select max(distinct(customerId)) from customer_events returns -1.7976931348623157e+308
The text was updated successfully, but these errors were encountered:
andpol
changed the title
Nested queries return incorrect values
Nested aggregations return incorrect values
Sep 10, 2014
@jvshahid well the OP mentioned that you get bad values using min(distinct()) and max(distinct()), and i was just commenting that in #780 you can see the same incorrect values being returned without having to nest. i.e. #780 shows that it happens with just max(field), you don't need max(distinct(field)) to reproduce the incorrect value. ditto for min.
According to the docs, count(disctinct()) is supported, but other nested aggregate queries still return values, but they are not correct. A non 200 response should be returned instead, since they are not supported.
Some examples:
select mean(distinct(customerId)) from customer_events
returns nullselect min(distinct(customerId)) from customer_events
returns 1.7976931348623157e+308select max(distinct(customerId)) from customer_events
returns -1.7976931348623157e+308The text was updated successfully, but these errors were encountered: