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/22d1fce3-281d-4f5f-b730-60b9f6de2cfb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
