Yep, that helped. Thanks for the quick response! On Tuesday, January 10, 2017 at 7:17:37 PM UTC-5, Regan Kuchan wrote: > > Hi Matt, > > The behavior you're seeing is the result of InfluxDB's preset epoch time > boundaries <http://www.epochconverter.com/weeks/2017>. By default, > InfluxDB uses those preset time boundaries, not the time at which you > created the CQ, to define when a week begins and when a week ends. The > current epoch week starts on January 09, 2017 and ends just before January > 16, 2017. > > If you want to personalize the CQ time boundaries you can use an > offset_interval of one day in the GROUP BY time() clause: > > CREATE CONTINUOUS QUERY weekly_data_cq ON db > BEGIN > [...] > GROUP BY id, time(1w,1d) > END > > Check out example 4 > <https://docs.influxdata.com/influxdb/v1.1/query_language/continuous_queries/#examples-of-basic-syntax> > > in the docs for another example. > > Just in case: I noticed you said you were seeing the time range Jan 10 up > to Jan 17, not Jan 09 up to Jan 16. I created a similar CQ with version > 1.1.1 and saw, as I expected, January 09 up to January 16. If you are > indeed seeing Jan 10 up to Jan 17 let us know - that wouldn't be consistent > with the expected behavior. > > I hope this helps! You're right - we don't have any examples with the > longer-term intervals in the docs. I'll work on getting something like this > added to the CQ doc or at least have an FAQ on it. > > On Tue, Jan 10, 2017 at 2:50 PM, <[email protected] <javascript:>> > wrote: > >> On Tuesday, January 10, 2017 at 5:42:04 PM UTC-5, Matthew Guindin wrote: >> > 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 >> >> I forgot one additional part, the Continuous Query is running `RESAMPLE >> EVERY 30m FOR 1w` >> >> -- >> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/dcdd18a3-cade-4bca-9000-7f86fc95ffca%40googlegroups.com >> . >> For more options, visit https://groups.google.com/d/optout. >> > >
-- 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/db5f0c45-7e92-42c9-a950-66de05d39262%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
