Great, thanks for your kind and rapid help. Feature request opened here. <https://github.com/influxdata/influxdb/issues/7109>
onsdag 3. august 2016 00.19.49 UTC+2 skrev Sean Beckett følgende: > > 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] > <javascript:>> 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 <javascript:> >> *Sent: *02 August 2016 20:09 >> *To: *InfluxDB <javascript:> >> *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] <javascript:>> >> 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] <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/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] <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/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/a5df054d-2275-46eb-9a05-6457a0419840%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
