I just came to know the newer version of Influxdb supports subquery. I tried to add this feature into my existing architecture, But it shows null value[Emptry output]. Could someone please help me whats wrong here.
Does subquery only work on select operations ? SubQuery I tried : SELECT last(*) FROM "database1_vm_data" where "vm_name"='(SHOW TAG VALUES FROM "database1_vm_data" WITH KEY = "vm_name")' Here I'm trying to pass the tag names [ which contains VMs name] to where clause to find last value of each VMs Full Steps : > use database1 Using database database1 > > SHOW TAG VALUES FROM "database1_vm_data" WITH KEY = "vm_name" name: database1_vm_data key value --- ----- vm_name appvm2 vm_name appvm3 vm_name appvm1 > > > > SELECT last(*) FROM "database1_vm_data" where "vm_name"='appvm1' name: database1_vm_data time last_location last_os_name last_os_type last_os_version ---- ------------- ------------ ------------ --------------- 0 eastus UbuntuServer Linux 16.04.0-LTS > > >SELECT last(*) FROM "database1_vm_data" where "vm_name"='(SHOW TAG VALUES FROM "database1_vm_data" WITH KEY = "vm_name")' > > -- 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 [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/d286e98d-4f51-4ec2-91ee-bc0303a51bb8%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
