We want to downsample all of our raw measurements (resolution around 3s) older than 6 months into the same measurement with a resolution of 15 mins. After being alive for 5 years the data may be deleted.
I’ve seen many examples, but all of them put the downsampled data into a new database. That is not what we want. We want the resulting data to be in the same database so we can query it together with the raw data.
Make a graph that stretches from 7 to 5 months ago (the oldest data will have a resolution of 15min and the joungest 3s).
Could someone show me how to do this? (I mean: How do I create the retention policies and a continuous query that does the downsampling)