The functions operate on a bucket, but are not inclusive of the end time. For example, the 1h bucket starting at midnight UTC ends at 00:59.999999999 UTC, and does not include 01:00 UTC.
The point at 04:00 is NOT part of the bucket starting at 03:00, so the value is 116 - 95 = 21. Note that this is exactly the same as the other buckets. The bucket starting at midnight gives a spread of 21, which is the 00:45 value minus the 00:00 value (27 - 6 = 21), not the 01:00 value minus the 00:00 value (32 - 6 = 26). The fact that your WHERE time range extends to 04:00 inclusive doesn't affect the query return. The exact point at 04:00 is not part of any 1h bucket except the one it starts, and there is no other value in that hour to which to compare, so it returns zero. On Thu, Jun 16, 2016 at 11:15 PM, Sekhar Beri <[email protected]> wrote: > Hello Sean, > Thank you for the quick response and I am sorry for the typo. I > figured out the solution for that now everything fine, I am getting results > what I am expected. > > Below are the actual records that i have in influxDB > > > 2015-01-01T00:00:00Z 6 > 2015-01-01T00:15:00Z 11 > 2015-01-01T00:30:00Z 18 > 2015-01-01T00:45:00Z 27 > 2015-01-01T01:00:00Z 32 > 2015-01-01T01:15:00Z 38 > 2015-01-01T01:30:00Z 45 > 2015-01-01T01:45:00Z 52 > 2015-01-01T02:00:00Z 60 > 2015-01-01T02:15:00Z 66 > 2015-01-01T02:30:00Z 76 > 2015-01-01T02:45:00Z 86 > 2015-01-01T03:00:00Z 95 > 2015-01-01T03:15:00Z 103 > 2015-01-01T03:30:00Z 110 > 2015-01-01T03:45:00Z 116 > 2015-01-01T04:00:00Z 125 > *Query:* > > > *select spread(consumption_count) from TestMeterData where time >= > '2015-01-01 00:00:00' and time <= '2015-01-01 04:00:00' and meter_id='1' > group by time(1h)* > > when i run above query i got fallowing records as output > > 2015-01-01T00:00:00Z 21 > 2015-01-01T01:00:00Z 20 > 2015-01-01T02:00:00Z 26 > 2015-01-01T03:00:00Z 21 > 2015-01-01T04:00:00Z 0 > > Now here is my problem, I am storing data in for every 15 mins time > interval, But when I get the results last 15 mins data of every hour was > missing. I have figured out solution with another method, But why it is not > happening with *Spread* function? > > Thank you. > > On Fri, Jun 17, 2016 at 2:02 AM, Sean Beckett <[email protected]> wrote: > >> Please provide some actual query input and output. Your retyped example >> has a typo (time before 7 p.m. and later than 11 p.m. of the same day) and >> I'm not sure what else might be off. >> >> On Tue, Jun 14, 2016 at 1:09 AM, <[email protected]> wrote: >> >>> *Hello Everyone,* >>> * I am storing data for every 15 minutes in influx >>> database. When I wrote a query to get data using spread and grouping by one >>> hour. Every time i am losing last 15 minutes data.* >>> >>> *Below is my query* >>> >>> *select consumption count from testData where time < = '* >>> *2016-06-12T19:00:00Z'** and time >= '**2016-06-12T23:00:00Z**'* >>> >>> what i need to do to get last 15 mins data. >>> >>> Example: >>> >>> consider i have data like below >>> *2016-06-12T19:00:00Z -> 15* >>> *2016-06-12T19:15:00Z -> 22* >>> *2016-06-12T19:30:00Z -> 28* >>> *2016-06-12T19:45:00Z -> 32* >>> *2016-06-12T20:00:00Z -> 36* >>> >>> *When i run above query with above time intervals i am getting spread >>> value 17 which is 32-15 instead of this i need to get 21 which is 36-15. >>> which causes me losing last 15 minutes data. * >>> >>> *Anyone, please help on this.* >>> >>> *Thankyou in advance* >>> >>> -- >>> 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/ba13aaed-aadf-4def-9575-f7358300ec1c%40googlegroups.com >>> <https://groups.google.com/d/msgid/influxdb/ba13aaed-aadf-4def-9575-f7358300ec1c%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/TZgglmSro5A/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/CALGqCvMdieABqm7CScMRCAaq9JyWMRG5JzAB3w31Tj0yyY_hrw%40mail.gmail.com >> <https://groups.google.com/d/msgid/influxdb/CALGqCvMdieABqm7CScMRCAaq9JyWMRG5JzAB3w31Tj0yyY_hrw%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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/CAEvTO9wg-aAmOkjvkP257qBmVhoQPKqVYHdAPiO6oaTLOXmPRA%40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CAEvTO9wg-aAmOkjvkP257qBmVhoQPKqVYHdAPiO6oaTLOXmPRA%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/CALGqCvO9%3D%2B4tfqLjdAx3F%2BvXJ_6xW%3DEUJu4vN31d4obh7OfJvw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
