On Monday, June 27, 2016 at 11:46:27 PM UTC+5:30, Sean Beckett wrote: > "IN" is not supported for SELECT queries, only some SHOW queries, as Ross > mentioned. > > > You can accomplish the same result with regular expressions: > > > select * from disk where host =~ /'yyy','xxx'/ > > > > On Mon, Jun 27, 2016 at 8:31 AM, Ross McDonald <[email protected]> wrote: > > > I believe the "IN" keyword is only supported with the "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 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. > > > > > > -- > > > Sean Beckett > Director of Support and Professional Services > InfluxDB
Hi Sean, I was able to get the query working using regex as you mentioned using the syntax, select * from disk where host =~ /yyy|xxx/ Thanks for the help, this works well for me! -- 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/dbf9f7f6-1e04-4c78-b9fa-383497456385%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
