Multiple sample rates in the same query

#1

I intend to downsample data, but the problem is that I also want to be able to query across these downsampled versions of the same measurement from different rollups so that the resulting dataset will decrease in sample rate as timestamps get older. This, of course, is possible by querying from all the rollups and then joining the results outside influx, but it misses the point, as the queries won’t be retention policy agnostic
Is there any other strategy to downsampling so that can be possible?

1 Like
#2

Hi Serban,

Unfortunately we don’t have the ability to query across rollups, although there is an open GitHub issue that intends to address this: https://github.com/influxdata/influxdb/issues/7198

In the meantime you’ll need a query for each of the retention policies.