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.
