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

mouthpiec November 20, 2019, 9:52am 3

thanks Scott for your feedback.
The problem is that I would like to keep the aggregate values for a long period of time (2yrs) and delete only the raw values after 30 days. I think if i set the retention policy to 30 days all the data will be deleted

Topic		Replies	Views
Delete old data from measurements InfluxDB 2 influxql , flux	3	1892	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	1848	July 2, 2019
[InfluxDB] [1.7.9] Purge old data manually influxdb	4	6236	January 1, 2021

Delete specific data older than 30 days

Related topics