IIRC CQs are evaluated on intervals which are separated by the 'GROUP BY' timespan and fall on round boundaries, so basically you are recomputing every minute the data for the current 24hour interval.
On Tuesday, June 14, 2016 at 8:21:10 PM UTC+2, [email protected] wrote: > > Hey Folks, > > We are trying to run a CQ each minute which calculates a bunch of > aggregates for the last 24 hours on a sliding scale. We are using: > > RESAMPLE EVERY 1m ....... GROUP BY time(24h) > > > The problem is we are getting our resulting time stamps as > "2016-06-14T00:00:00Z" > (for example) which gives us one measurement *per day* instead of one > measurement *per minute* for the last 24 hours. > > > Would appreciate any direction on how to do this correctly! > > > Thanks, > > -Avery > -- 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/58185324-0bd5-44d6-999f-c33b0101d4f7%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
