How to drop Influxdb series using tags

How do we go about cleaning a old series using where clause in InfluxDB ? In many cases resources are no longer used/available but they will still persist as tags in the series, so is ideal to have a process in place that will clean them. Use This script to remove old/unused tags for and of your InfluxDB databases:

use <database name

DROP SERIES FROM /.*/ WHERE "tag-name" = 'tag-value-to-delete-data'
Hope this helps. Note: Dont run this in prod before testing!!!!


Leave a comment or a question in the comment area bellow if you fell like


Be a sport and

Search

Loading... Please wait

Subscribe to our Newsletter

Be a sport and

x