I have issue with kapacitor join node with tolerance. In the following code, data goes through join node only if two timestamps were equal
[holtwinters:log3] 2017/10/12 08:06:20 I! {"Name":"measurement","Database":"","RetentionPolicy":"","Group":"","Dimensions":{"ByName":false,"TagNames":[]},"Tags":null,"Fields":{"rvalue":1560.73297119},"Time":"2017-10-12T08:06:20-07:00"}
[holtwinters:log7] 2017/10/12 08:06:20 I! {"Name":"measurement","Database":"","RetentionPolicy":"","Group":"","Dimensions":{"ByName":false,"TagNames":[]},"Tags":null,"Fields":{"hw":1559.79650879},"Time":"2017-10-12T08:06:20-07:00"}
The following data points doesnt go through join node, even with tolerance(10s)
[holtwinters:log3] 2017/10/12 08:03:00 I! {"Name":"measurement","Database":"","RetentionPolicy":"","Group":"","Dimensions":{"ByName":false,"TagNames":[]},"Tags":null,"Fields":{"rvalue":1910.36984253},"Time":"2017-10-12T08:03:00-07:00"}
[holtwinters:log8] 2017/10/12 08:03:00 I! {"Name":"measurement","Database":"","RetentionPolicy":"","Group":"","Dimensions":{"ByName":false,"TagNames":[]},"Tags":null,"Fields":{"hw":2172.644114545176},"Time":"2017-10-12T15:03:06.965293824Z"}
var real = batch
|query('select kw_total from "db"."autogen"."measurement" where "name" = \'cr1\'')
.period(10s)
.every(10s)
.align()
|last('kw_total')
.as('rvalue')
|log()
var pred = batch
|query('select kw_total from "db"."autogen"."measurement" where "name" = \'cr1\'')
.offset(10s)
.period(1m)
.every(10s)
.align()
|shift(10s)
|holtWinters('kw_total', 1, 0, 10s)
.as('value')
|last('value')
.as('hw')
|log()
real
|join(pred)
.as('real', 'pred')
.tolerance(10s)
|log()
Any help greatly appreciated…
Thanks,
Kranthi