On Tuesday, October 25, 2016 at 8:55:49 PM UTC-5, [email protected] wrote: > I have this continuous query in version 1.02 of influx > > CREATE CONTINUOUS QUERY cqDailyTasks ON r1metrics BEGIN SELECT count(*) INTO > metrics..dailyTasks FROM metrics..tasks GROUP BY time(1d), * END > > I have data since 12 of Oct > > This continous query did not back fill to the 12 as i expected. What did i > do wrong? > > I tried adding a RESAMPLE EVERY 1m and that did add some data but not till > the 12. > > Thanks
(For other newbies out that) I just found that I have to backfill it myself with an into clause. I did this SELECT count(*) INTO r1metrics..dailyTasks FROM r1metrics..tasks where time < now() GROUP BY time(1d), * and it worked. Influx handles the duplicates by overwriting them -- 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/0018e601-ca08-431c-ba2f-438d00350075%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
