I believe the "IN" keyword is only supported with the "SHOW TAG VALUES
<https://docs.influxdata.com/influxdb/v1.0/query_language/spec/#show-tag-values>"
queries, where you can limit the tag values returned. For example:
> SHOW TAG VALUES FROM "cpu" WITH KEY IN ("region", "host") WHERE "service"
= 'redis'
Will limit the output to display the values of the "region" and "host" tag
keys only where the service is equal to "redis". I'd recommend opening an
issue <https://github.com/influxdata/influxdb/issues/new> against the repo
if you'd like to see support for "IN" in select queries, though.
Thanks,
Ross
On Mon, Jun 27, 2016 at 7:08 AM, Sneha <[email protected]> wrote:
> Hi,
>
> Could you please help us with the syntax on how to use the 'IN' operator
> in lambda expression/InfluxQL?
>
> I've been trying out options like select * from disk where host in
> ('yyy','xxx') but seems like the 'IN' keyword is not recognized. Could you
> please help?
>
> Thanks,
> Sneha
>
> --
> 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/3d8303ed-bff4-4123-a721-4431c1d07a42%40googlegroups.com
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
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/CAD8sRLBYxKW-4fVEh%2Bhs6GbVJP8ey1AbxY3P4Z_Pt%3Dex9ZCYVw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
