This isn't really supported yet. I've opened a new issue: https://github.com/influxdata/influxdb/issues/6921
On Mon, Jun 27, 2016 at 9:17 AM, <[email protected]> wrote: > 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. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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/CALGqCvNzpR6K-E68kvX%3DZ5afwoq%2Bv95MBOZLdGqpfF-B4eiJug%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
