Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Query regression: allow multiple count(distinct()) aggregates #9144

Closed
rbetts opened this issue Nov 21, 2017 · 3 comments
Closed

Query regression: allow multiple count(distinct()) aggregates #9144

rbetts opened this issue Nov 21, 2017 · 3 comments
Assignees
Labels
area/influxql Issues related to InfluxQL query language kind/bug
Milestone

Comments

@rbetts
Copy link
Contributor

rbetts commented Nov 21, 2017

function distinct() cannot be combined with other functions

[I] 2017-11-21T15:50:00Z SELECT count(distinct(a_f)) AS a, count(distinct(b_f)) AS b INTO blah FROM baz WHERE type = 'u' OR type = 'c' OR type = 'd' AND time >= '2017-11-21T15:45:00Z' AND time < '2017-11-21T15:50:00Z' GROUP BY time(5m) service=query
[I] 2017-11-21T15:50:00Z error: aggregate function distinct() cannot be combined with other functions or fields.

@rbetts rbetts added area/influxql Issues related to InfluxQL query language kind/bug labels Nov 21, 2017
@rbetts rbetts added this to the 1.4.0 milestone Nov 21, 2017
@ghost ghost added the review label Nov 21, 2017
@ghost ghost removed the review label Nov 28, 2017
@rbetts rbetts modified the milestones: 1.4.0, 1.4.3 Nov 29, 2017
@Codelica
Copy link

Codelica commented Dec 7, 2017

Sorry to revive a closed issue, but we have a lot of queries that I believe are being affected by this. Just curious if there is an ETA for 1.4.3, which I assume includes the fix? Will it be pending a fix for #9134 ?

Again, sorry to ask, but I just haven't been able to think through a workaround for our counts.

@larrywalker
Copy link

I had to down rev to 1.3.6 because this broke several of our continuous queries that had distinct(count(field)) in them. The queries won't run in 1.4.

Waiting for this one to get merged into 1.4.3 before I try again.

@jsternberg
Copy link
Contributor

This has been backported to 1.4 and will be in 1.4.3.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/influxql Issues related to InfluxQL query language kind/bug
Projects
None yet
Development

No branches or pull requests

4 participants