It's certainly worth opening up a feature request. I didn't find a related one in my quick search.
On Tue, Aug 2, 2016 at 3:01 PM, Peter Sveistrup <[email protected]> wrote: > Thanks for the response. My only problem is that somethimes it might be > the 6th value and other times the 16th value I’m after, so having CQs for > all combinations might be a bit over the top. > > > > If this is useful for others, might it be an idea for a feature request? > > > > Kind regards, Peter > > > > > > > > *From: *Sean Beckett <[email protected]> > *Sent: *02 August 2016 20:09 > *To: *InfluxDB <[email protected]> > *Subject: *Re: [influxdb] How to query every n-th value of a series > > > > There are no query language operators or functions that select points > based on ordinality. The best current solution to your need is to use a CQ, > which won't introduce noticable additional storage or load, unless you are > running on a very low power device. > > > > CREATE CQ... > > SELECT FIRST(value) AS "60th_point" INTO bar FROM foo GROUP BY time(1m), * > > END > > > > That will store the point from xx:xx:00 in the new "bar" measurement. > > > > On Tue, Aug 2, 2016 at 8:19 AM, <[email protected]> wrote: > > Hi guys, > > > > I'm trying to figure out how to query every n-th value of a time series > measurement? Lets say that I store a point every second, and later want to > query every 60th point from time x to time y? > > > > I've seen there are CQs that can make the downsampled data, but for my use > case it does not make sense since it will only add to more load and storage > being used. Performance wise it shouldn't be any harder/slower either to > query 100 point that are not adjacent compared to 100 that are, or am I > wring here? > > > > Thanks, > > Peter > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" 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/aa778b27-3257-42f3-96a5-3b7c3158ad1f%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/aa778b27-3257-42f3-96a5-3b7c3158ad1f%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 InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to a topic in the > Google Groups "InfluxDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/influxdb/Noyc9_72jkE/unsubscribe. > To unsubscribe from this group and all its topics, 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/CALGqCvM2%2BN8OT3tKp2HPpLDe5iao6maZMzGWyus7zjxV5b7PAQ%40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CALGqCvM2%2BN8OT3tKp2HPpLDe5iao6maZMzGWyus7zjxV5b7PAQ%40mail.gmail.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 InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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/CALGqCvNS7hH7mifAOYdjo%2Bv6S1jYF57MmLZMS_8gwTDy-M4wvw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
