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 <http://docs.influxdata.com/influxdb/v1.0/concepts/storage_engine/#compactions>. 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: > Hi, > > 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? > > Thanks! > > -- > 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 influxdb@googlegroups.com. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/03a8977e-e33f-47bc-b1d8-3e3e99c1e4f5%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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 influxdb@googlegroups.com. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvNw8iij01%3DsY%2BNai5Ta9d6k2yhZ0NNssDP6ZHVuphSW_A%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
