I’m using an InfluxDB 1.7.9, filled of data, without any retention policy.
Now, i’d like to manually cleanup old data by deleting data older than one year but keeping one monthly metric in those (basically, after one year, I keep only one data point per month per series).
What is the best way to do ?
If not possible, can I do an full purge like
DELETE * WHERE time < '2019-06-29'
Once done, I thing it’s possible to do that automatically using an retention policy. I’ve dig an bit the docs but i’m worrying to create mess. Could someone help me to explain the how-to.
Could be basic for you but i’m an influxdb newbies, so thanks for your understanding