Continuous queries require a GROUP BY time statement, and using a GROUP BY time statement requires that the SELECT clause contains only functions, no bare columns. I think you've found the right combination to accomplish what you want.
On Wed, Aug 31, 2016 at 6:09 AM, Fulvio Spelta <[email protected]> wrote: > I think that in order to align the TS i have to run a query with the dummy > aggregation on all the fields, something like: > SELECT MIN(field_1), MIN(field_2), DIFFERENCE(MIN("vieBurnerFlame")) as > ch FROM "gInfluxTemperatures" WHERE (time >= now() - 1d) GROUP BY TIME( > 5m) > > is it? > > -- > 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/b58b2ec2-a5e2-405b-9464-9c7df3d3f8ae%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/b58b2ec2-a5e2-405b-9464-9c7df3d3f8ae%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > 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/CALGqCvOKCqUFZwC%3D9Y8o%2BHLCBJ2fYedBVYA4La%3DEwg%2Bf5k5ybA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
