Any help on this please ? On Tuesday, 14 February 2017 19:00:38 UTC+5:30, kmg wrote: > > 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 influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. 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/986e1e56-2ed2-4f21-b3b5-43f72a491c12%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
