Downsampling and data retention | InfluxDB OSS 1.7 Documentation InfluxDB can handle hundreds of thousands of data points per second. Working with that much data over a long period of time can create storage concerns. A natural solution is to downsample the data; keep the high precision…

I believe you can use the regex expression with the “measurement” names e.g. select * from /cpu_usage/ Please check but I’m not sure about this feature. Anyways it will not help with the queries since they will go over both the tables if this is supported. Getting back to your original question; …

I have a follow up question. I’m using the same example for downsampling, and it’s done by this code which creates an CQ: > CREATE CONTINUOUS QUERY "cq_30m" ON "food_data" BEGIN SELECT mean("website") AS "mean_website",mean("phone") AS "mean_phone" INTO "a_year"."downsampled_orders" FROM "or…

I was just looking for the same functionality. It’s really strange for me data data base design for time series storing doesn’t have it. Does any one know the workaround?

[image] Down sample data in same measurement and delete old data I think this presentation may help you: DOWNSAMPLING DATA I have only done with with continuous queries in InfluxDB directly. Influx has a regex syntax from Go and other shorthand to the same downsampling t…

Downsample into same measure?

InfluxDB 1 InfluxQL

alberto_gcs March 3, 2022, 10:21am 5

Topic		Replies	Views
Downsampling older data into same measurement Store	6	3774	March 3, 2022
Down sampling existing data Systems influxdb	3	2075	July 26, 2019
Down sample data in same measurement and delete old data Systems influxdb	1	4260	November 13, 2018
Manual Downsampling Influx 1.8 Kapacitor downsample	3	946	April 29, 2021
Continuous queries and downsampling Store	3	1302	January 28, 2018

Downsample into same measure?

Related topics