I figured it out later in the night. Thank you! - Will
On Thursday, 8 September 2016 09:13:44 UTC-7, Sean Beckett wrote: > > SELECT LAST(value) FROM testDB GROUP BY pv > > Please review > http://docs.influxdata.com/influxdb/v0.13/query_language/data_exploration/ > for more on how to use InfluxQL. > > On Thu, Sep 8, 2016 at 3:30 AM, <[email protected] <javascript:>> wrote: > >> Maybe I'm setting up my db incorrectly. >> >> Currently, I have a db set up as such: >> >> > CREATE DATABASE "testDB" >> > INSERT testDB,pv=IOC1_hb,host=host1 value=10 >> > INSERT testDB,pv=IOC1_hb,host=host1 value=11 >> > INSERT testDB,pv=IOC1_hb,host=host1 value=1 >> > INSERT testDB,pv=IOC1_hb,host=host1 value=55 >> > INSERT testDB,pv=IOC2_hb,host=host1 value=10 >> > INSERT testDB,pv=IOC2_hb,host=host1 value=33 >> > INSERT testDB,pv=IOC2_hb,host=host1 value=98 >> >> Is there a way to select a specific time and get the latest value from >> each unique tag (pv) up to that specified time? >> >> My efforts in using DISTINCT have failed. >> >> (No time limit specified. No LIMIT defined. Returns nothing) >> > SELECT DISTINCT("pv") FROM testDB >> >> >> Thanks, >> >> - Will >> >> -- >> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/8cdecefb-be37-46f4-97ea-7600b5787987%40googlegroups.com >> . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Sean Beckett > Director of Support and Professional Services > InfluxDB > -- 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/c68aaf62-4f97-4c5f-b05b-9e3b6eda233e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
