On Tuesday, October 25, 2016 at 8:55:49 PM UTC-5, job...@gmail.com 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

I figure it out.  It looks like you have to backfill manually by running an 
"into" query

The query I ran is

SELECT count(*) INTO r1metrics..dailyTasks FROM r1metrics..tasks where time < 
now() GROUP BY time(1d)

-- 
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 influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
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/9dee0832-f9d2-44e4-a3c8-e62c75440b0d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to