CODEWITHSUNDEEP
influxdb
Ido Barash
Ido Barash

Reputation: 5132

Influxdb downsampling strategy

We are using influx DB. Basically I wish to store my data for one year total so I created a default RETENTION POLICY fro 365d.

I also want to create downsampling. I store my event every second, but I dont need them in seconds resolution for more than 3 months. basically, after 3 monthes I prefer to SUM the data in days and after 6 months I prefer to sum the data in weeks resolution.

I understood from this doc that I can downsample using "continues queries".

What I also understood that I have to downsample to another table. This will make my query process much harder because I will have to decide which table should I query and maybe combine the data of several tables.

Can I somehow create Downsampling process that will have all the data in the same table?

Regards, Ido

Upvotes: 2

Views: 2071

Answers (1)

dannyman
dannyman

Reputation: 681

To summarize the comments on this question: with Influxdb, you can not have multiple retention policies within a single table. You will have to query across multiple retention policies. You might want to Subscribe to this Github feature request for Intelligent Rollups and Querying of Aggregated Data

Upvotes: 2

Related Questions