InfluxDB does not support subqueries of any kind. You might be able to use
continuous queries to accomplish your goal.
On Sun, Oct 16, 2016 at 4:19 AM, <gplus....@gmail.com> wrote:
> Is it possible to use the SHOW TAG VALUES statement (with all trailing
> clauses like WITH and WHERE) inside SELECT statement ??
> Particularly inside a WHERE clause wihin the SELECT statemet.
> Let me try to use an example:
> I am trying to select cpu_usage metric from a Datacenter measurement with
> a tag called Building, I want to (sort of) search for when this tag's value
> is in the result of SHOW tag values statement for a different measurement.
> SELECT "cpu_usage" from sixty_weeks."Datacenter" WHERE time > '2016-10-16'
> AND machine =~ /.*Rack1.*/ AND (*"Building" IN* (SHOW TAG VALUES FROM
> sixty_weeks."floormapping" WITH KEY = "buildings" WHERE
> "active" =~ /$var1$/ ))
> I haven't been able to make this work, so I am wondering now: is this even
> possible? and how to do it if yes?
> Remember to include the version number!
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to firstname.lastname@example.org.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> For more options, visit https://groups.google.com/d/optout.
Director of Support and Professional Services
Remember to include the version number!
You received this message because you are subscribed to the Google Groups
To unsubscribe from this group and stop receiving emails from it, send an email
To post to this group, send email to email@example.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit
For more options, visit https://groups.google.com/d/optout.