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]> 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]. > 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/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/CALGqCvM%3DafkjhFpVjAfpeeUVLwkeiq4Pym25DHbCd4HZXWGvpQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
