Strange issue: I have a continuous query on InfluxDB 1.8 which sums hourly values into daily totals. The summing works just fine… it’s just that the timestamp added to the sum is one day behind.
So the continuous query reads hourly values for 03-11-2020 correctly, sums them up correctly, but then timestamps the sum with 02-11-2020 00:00 GMT.
I have this with all my daily CQs, here is one example:
CREATE CONTINUOUS QUERY “cq_1d_gas” ON “home_assistant” BEGIN SELECT sum(“value”) AS value INTO “infinite”.“m3” FROM “autogen”.“m3/h” GROUP BY time(1d), entity_id FILL(previous) tz(‘Europe/Amsterdam’) END
So source hourly values are in autogen.m3/h, daily values are written to infinite.m3. All working great, except for the magic 24h time shift. Of course, I checked the time stamps of the hourly values, they are correct. E.g. input hourly values in this case:
1604296800000 0.106
… … …
1604350800000 0.096
leading to a daily summed CQ of
1604268000000 3.419
Many thanks for your help!