https://docs.influxdata.com/influxdb/v0.13/query_language/functions/#distinct
What you want, most likely, is SELECT COUNT(DISTINCT(userid)) FROM...GROUP BY username On Wed, Aug 31, 2016 at 8:33 AM, <[email protected]> wrote: > Hello > > I am trying to create a distinct value on two fields similar to the way > this is handled in PostgreSQL. i.e. SELECT DISTINCT userid, username FROM > ... > > in InfluxDB DISTINCT does not appear to support multiple fields as the I > ge the following when running: SELECT COUNT(DISTINCT(userid,username)) > FROM ... > > ERR: error parsing query: count(distinct <field>) can only have one > argument > > Is there another approach to this that will yield the same results? TIA > > - > Alan Jackson > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/e6c194b8-3cd9-4cc9-a355-f18dfc241f95%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvOoXoAFDdvsPKbw_9yXwaSDRZvaqb8Rkmi6gJUomtCL7Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
