On Wednesday, 29 June 2016 20:31:33 UTC+2, Sean Beckett wrote: > > Find all series _with_ recent data. And then subtract it from the whole set. > > > This is the only solution I can see working with the current query language > tools.
Thanks Sean for the quick response. > I'm curious what the use case is for dropping data this way instead of using > retention policies. We have Influx for storing system metrics from Telegraf and visualizing with Grafana. There you can have a template pull-down menu which is populated from SHOW TAG VALUES query. For example: show tag values from cpu with key = "host" If you have an environment, where hosts come and go (like AWS instances) then tag values may contain hosts that are long dead, but still contain data. So my policy may be (for example): * keep data for 1 year for hosts that are currently alive * drop data for hosts that are dead for 30 days. This will keep SHOW TAG VALUES relatively clean. I would like to drop series to un-clutter tag values, rather than save disk space. Regards, Brano Zarnovican -- 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/fd96be30-03c6-427b-a276-cbebd0db8c39%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
