Sorry for not doing enough research, but by reading the mailing list sounds like it's not currently available. I'm kind of stuck because I consider this feature really useful. Please comment to confirm my findings, or let me know if I'm missing anything. Thanks!
On Monday, June 27, 2016 at 12:08:16 PM UTC-4, [email protected] wrote: > Hi all: > > I'm most likely missing something but I couldn't get a continuous query to > work. I'm trying to do a `mean()` on my data for the last 24 hours every 10 > minutes, so here's the creation: > > ``` > CREATE CONTINUOUS QUERY latency_mean ON latency_prod RESAMPLE EVERY 10m > BEGIN > SELECT mean(twoway_delay_avg) AS twoway_delay_avg > INTO latency_prod."default".latency_mean > FROM latency_prod."default".latency > GROUP BY time(1d), * > END > ``` > I was expecting that the query would execute every 10 minutes and take the > `mean()` for data lies in `time > now() - 1d`, but the output of influxdb.log > says otherwise: > > ``` > [continuous_querier] 2016/06/27 11:07:03 executing continuous query > latency_mean (2016-06-26 20:00:00 -0400 EDT to 2016-06-27 20:00:00 -0400 EDT) > [query] 2016/06/27 11:07:03 SELECT mean(twoway_delay_avg) AS twoway_delay_avg > INTO latency_prod."default".latency_mean FROM latency_prod."default".latency > WHERE time >= '2016-06-27T00:00:00Z' AND time < '2016-06-28T00:00:00Z' GROUP > BY time(1d), * > [continuous_querier] 2016/06/27 11:08:03 executing continuous query > latency_mean (2016-06-26 20:00:00 -0400 EDT to 2016-06-27 20:00:00 -0400 EDT) > [query] 2016/06/27 11:08:03 SELECT mean(twoway_delay_avg) AS twoway_delay_avg > INTO latency_prod."default".latency_mean FROM latency_prod."default".latency > WHERE time >= '2016-06-27T00:00:00Z' AND time < '2016-06-28T00:00:00Z' GROUP > BY time(1d), * > ``` > From the time range it's clearly doing a query on the same time range, which > is a whole day range. Can somebody tell me what I'm doing wrong? Thanks! > > ps: I'm using version 0.13.0 -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. 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/e4b02849-ebb9-47a1-9a88-dbbf00822acc%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
