Derivative downsample CQ

jasonmkeller · May 2, 2017, 5:24pm

Done; sorry for the delay

github.com/influxdata/influxdb

Missing intervals in downsample CQ

opened 05:23PM - 02 May 17 UTC

closed 05:30AM - 31 Jul 19 UTC

jasonkeller

1.x wontfix

### Bug report __System info:__ [Include InfluxDB version, operating system n…ame, and other relevant details] InfluxDB 1.2.2, RHEL7 __Steps to reproduce:__ Create a downsample CQ ``` name query ---- ----- cq_interface CREATE CONTINUOUS QUERY cq_interface ON telegraf BEGIN SELECT non_negative_derivative(max(ifHCInOctets), 1s) * 8 AS in_bandwidth, non_negative_derivative(max(ifHCOutOctets), 1s) * 8 AS out_bandwidth INTO telegraf.coarse.interface FROM telegraf.fine.interface GROUP BY time(1h), * END ``` __Expected behavior:__ [What you expected to happen] Expected a downsampled point at every hour __Actual behavior:__ [What actually happened] One interval (0000 to 0059 UTC) is always missing. __Additional info:__ [Include gist of relevant config, logs, etc.] ``` > time mean > ---- ---- > 2017-04-24T22:00:00Z 8.087672388333334e+08 > 2017-04-24T23:00:00Z 5.1333139691333336e+08 > 2017-04-25T00:00:00Z > 2017-04-25T01:00:00Z 3.6771099004888886e+08 > 2017-04-25T02:00:00Z 2.7155306081333333e+08 > 2017-04-25T03:00:00Z 2.5967737418e+08 > 2017-04-25T04:00:00Z 2.2444512318666667e+08 > 2017-04-25T05:00:00Z 2.631946728888889e+08 > 2017-04-25T06:00:00Z 2.370487154511111e+08 > 2017-04-25T07:00:00Z 2.3160151775111112e+08 > 2017-04-25T08:00:00Z 2.8540324688222224e+08 > 2017-04-25T09:00:00Z 3.2931515402666664e+08 > 2017-04-25T10:00:00Z 3.1178820714e+08 > 2017-04-25T11:00:00Z 3.3946282773777777e+08 > 2017-04-25T12:00:00Z 1.5727707702222223e+09 > 2017-04-25T13:00:00Z 4.676712102415556e+09 > 2017-04-25T14:00:00Z 5.32045180074e+09 > 2017-04-25T15:00:00Z 5.563749168948889e+09 > 2017-04-25T16:00:00Z 5.266778042544444e+09 > 2017-04-25T17:00:00Z 5.04857448816e+09 > 2017-04-25T18:00:00Z 5.457751590317778e+09 > 2017-04-25T19:00:00Z 5.464998330106667e+09 > 2017-04-25T20:00:00Z 3.905074336771111e+09 > 2017-04-25T21:00:00Z 2.0503537871688888e+09 > 2017-04-25T22:00:00Z 9.482162149355556e+08 > 2017-04-25T23:00:00Z 5.871217549577777e+08 > 2017-04-26T00:00:00Z > 2017-04-26T01:00:00Z 3.8481892825333333e+08 > 2017-04-26T02:00:00Z 2.802886362822222e+08 > 2017-04-26T03:00:00Z 2.5633334344e+08 > 2017-04-26T04:00:00Z 2.2594040661333334e+08 > 2017-04-26T05:00:00Z 2.3159232344444445e+08 > 2017-04-26T06:00:00Z 2.6096797832e+08 > 2017-04-26T07:00:00Z 2.3024448323777777e+08 > 2017-04-26T08:00:00Z 3.0825314184e+08 > 2017-04-26T09:00:00Z 3.197389336933333e+08 > 2017-04-26T10:00:00Z 2.874293079688889e+08 > 2017-04-26T11:00:00Z 3.282012284488889e+08 > 2017-04-26T12:00:00Z 1.5318391435044444e+09 ``` Link to discussion... https://community.influxdata.com/t/derivative-downsample-cq/559/17

jasonmkeller · May 17, 2017, 1:36pm

Per hannoman over at Github, I managed to work around this issue with the following…

Add a “RESAMPLE FOR 2h” clause to your CQ.

Topic		Replies	Views
Use of a Continuous Query with non_negative_difference and non_negative_derivative functions Store influxdb , time-series	0	2302	February 15, 2018
Derivative on downsampled bucket gives wrong result InfluxDB 2 influxdb , influxql	0	644	March 26, 2021
Thinning samples for derivative, when not aligned to bucket window	0	707	May 26, 2018
Downsampling existing data influxdb	3	7519	June 8, 2017
Continuous Query not downsampling data Store	0	701	March 8, 2018

Derivative downsample CQ

Related topics