There is no way to downsample in place. The first challenge is that it
requires deleting many individual raw data points after a month, rather
than dropping entire files from disk, as retention policies do. Individual
deletes are expensive in InfluxDB. They create a tombstone record which
must be purged during a TSM compaction
The second challenge is that any CQ sampling the raw data would pick up the
new downsampled data, too, unless it was written to another field, which
breaks the query compatibility you're looking for.
See https://github.com/influxdata/influxdb/issues/7198 and
https://github.com/influxdata/influxdb/issues/6910 for the discussion of
this feature to date.
On Wed, Oct 12, 2016 at 2:21 PM, <alexan...@delvelabs.ca> wrote:
> I'm trying to figure out if it's possible to have a continuous query that
> would keep collectd's 10 seconds granularity, for up to a month, but then
> drop to an hourly mean, for up to a year then delete it.
> Setting the retention policy for a year is quite simple...
> But is it possible to down sample data -in place- so that the graphs are
> simply less precise over time, but without requiring a different table /
> graph for the downsampling output?
> Remember to include the version number!
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to email@example.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> For more options, visit https://groups.google.com/d/optout.
Director of Support and Professional Services
Remember to include the version number!
You received this message because you are subscribed to the Google Groups
To unsubscribe from this group and stop receiving emails from it, send an email
To post to this group, send email to firstname.lastname@example.org.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit
For more options, visit https://groups.google.com/d/optout.