I’m trying to downsample data on a weekly basis and am hitting a problem
with the time range it's apparently running against.
I have a continuous query that looks like this:
CREATE CONTINUOUS QUERY weekly_data_cq ON db
BEGIN
SELECT sum(count) as sum, last(*)
INTO db.one_month.weekly_data
FROM db.autogen.daily_data
GROUP BY id, time(1w)
END
The data that's being recorded to `weekly_data` seems inconsistent somehow
based on the day of the week this is run. Am I misunderstanding something
with the database?
When this runs today, it’s producing data for the week starting today and
ending on the 17th, not from the 3rd to the 10th as I figured it would run.
I haven’t found documentation or examples using this large of a window
since the documentation is using hours or minutes, so I’m not sure if this
is a bug or if I’m not using the DB properly.
-Matt
--
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/7012acd0-b276-41e0-9fed-a1398f177e24%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
