Retention policies and continuous queries made simple

(Carsten Köbke) #21

I did my test setup and it also shows data getting downsampled that is newer then configured in the CQ.
Seems they changed the behavior. Still searching

(Carsten Köbke) #22

Found it, seems i overlooked it or they changed it some time ago

Note: Notice that the cq_query does not require a time range in a WHERE clause. InfluxDB automatically generates a time range for the cq_query when it executes the CQ. Any user-specified time ranges in the cq_query ’s WHERE clause will be ignored by the system.`

Will change my howto these days


Yeah, I just found that too, disappointing.
Do you think there is another method to run the CQ with only ‘old’ data?

(Carsten Köbke) #24

Nope there is no way to do it. but if you think about it, its even better and doesnt make a difference for grafana graphs.