There is no restriction on where the results of CQs may be stored. Since you are using a different destination field name, and not using a wildcard field matcher in the function there is no risk of circular writes. Your use case should be fine.
On Mon, Oct 24, 2016 at 5:56 AM, tariq zafar <[email protected]> wrote: > Is it possible to use continuous queries on the same measurement that is > used as source so that my historical data is also saved in the same table? > > For instance, if I have a measurement in default RP "active_logins" > > Can I write > > CREATE CONTINUOUS QUERY ON "database" > BEGIN > SELECT mean("values") AS average INTO "database"."default"."active_logins" > from "active_logins" GROUP BY time(30m), <all other columns(tag keys)> > END > > -- > Remember to include the version number! > --- > You received this message because you are subscribed to the Google Groups > "InfluxData" 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/e1308e0a-cd33-42b3-915d-54106ad371b0%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/e1308e0a-cd33-42b3-915d-54106ad371b0%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 version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" 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/CALGqCvPjPk%3DhD26_9y8pZUcjVFfdeZXyZE8fC05NJmPeUw6z8Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
