That use case does make sense, thanks for sharing. It's a reasonable workaround until SHOW TAG VALUES accepts a WHERE time clause <https://github.com/influxdata/influxdb/issues/5668>.
On Wed, Jun 29, 2016 at 12:18 PM, <[email protected]> wrote: > 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. > -- 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/CALGqCvN6yiNaW%2Bj9ULT%2BGZ8Kw8oSARz-U-b4WY%2BFwEdridNxAg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
