Hi, I have an InfluxDB running on a Pi3B+ storing power consumption of 4 devices I have a home. The device give a reading every 20secs, and then I have a process to create hourly, daily, aggregate values. Now I would like to delete the raw values that are older than 30 days but I cannot get a que…

Hi @mouthpiec , Sure. Bare in mind though I’m using an older influx version (1.5.2 currently) I have one main assumption here, you are running the stack on linux variant. There are two ways you can do this really, with CQ’s or Kapacitor batch tasks. Personally, i prefer to use the latter (there is …

Delete specific data older than 30 days

Store

philb November 20, 2019, 10:08am 4

You can create an additional retention policy for your aggregated data for 2 years

raw.30days
aggregate.2years

When you process your raw data output it to the aggregate.2years

Topic		Replies	Views
Delete old data from measurements InfluxDB 2 influxql , flux	3	1855	February 9, 2022
Is there a way ton keep key date values in influxdb, bypassing retention system? Store	3	711	February 26, 2018
Kapacitor data aggregation does not save aggregated data for all series influxdb , kapacitor	8	1850	April 3, 2017
Dump converted data to a new measurement? Store influxdb	9	1846	July 2, 2019
[InfluxDB] [1.7.9] Purge old data manually influxdb	4	6212	January 1, 2021

Delete specific data older than 30 days

Related topics