Hello, I having a problem with Kapacitor when try to collect metrics. Im using batch() node to take data, everything work ok but period() method uses a diferent time zone.
For example if i useperiod(15m) as you can see at log time zone its diferent
ts=2021-02-22T16:24:24.190+01:00 lvl=debug msg=âstarting next batch queryâ service=kapacitor task_master=main task=Atenas_CoberturaAtenasPorcentajeKOs node=alert9 query=âSELECT sum(ndocuments) AS value200 FROM atenas_service.rp_semanal.CoberturaAtenasPorcentajeKOs WHERE status =~ /20*/ AND time >= â2021-02-22T15:09:24.190524042Zâ AND time < â2021-02-22T15:24:24.190524042Zâ GROUP BY time(15m, 0s)â
I have tried using tz(âEurope\Madridâ) but result its the same.
I have set environment tz at Kapacitor.conf .
Also another question : Why group by generates two outputs ?
SELECT sum(ndocuments) AS value200 FROM atenas_service.rp_semanal.CoberturaAtenasPorcentajeKOs WHERE status =~ /20*/ AND time >= â2021-02-22T15:09:24.190524042Zâ AND time < â2021-02-22T15:24:24.190524042Zâ GROUP BY time(15m, 0s), team
name: CoberturaAtenasPorcentajeKOs
tags: team=atenas
time value200
2021-02-22T15:00:00Z 33
2021-02-22T15:15:00Z 88
Can one help me ?
Thanks