Every SELECT statement must have at least one field. You selecting only a tag. Use either "SHOW TAG VALUES" or include a field in the query.
On Mon, Sep 26, 2016 at 6:55 AM, Paul Letskii <[email protected]> wrote: > Hi all! > > InfluxDB version 1.0\ > > I'm trying to get list of hosts from measurement "mem_usage_percent". > > This query works: > SELECT * FROM "mem_usage_percent" > > This one doesn't: > SELECT "host" FROM "mem_usage_percent" > Accordingly to documentation it has to. > > My final goal is to count number of unique hosts. Like: SELECT > count("host") FROM "mem_usage_percent" > > What is correct syntax to get information from certain field? > > Thank you in advance! > > Best regards, > Paul Letskii > > -- > 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/f3c71013-7e8c-4fdb-9808-0b1fb35e9052%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/f3c71013-7e8c-4fdb-9808-0b1fb35e9052%40googlegroups.com?utm_medium=email&utm_source=footer> > . > 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/CALGqCvPuY48kupH-jQ7U2Cihck9jeDQ9W9SkELwSM9hxXMHitA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
