I’m using 2 retention policies;
name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
one_year 8736h0m0s 168h0m0s 1 false
one_day 24h0m0s 1h0m0s 1 true
and also a Continuous Query, to group and average data into 5 minute chunks;
cq_5m CREATE CONTINUOUS QUERY cq_5m ON emondata BEGIN SELECT mean(grid) AS grid, mean(solar) AS solar, mean(divert) AS divert, mean(usage) AS usage INTO emondata.one_year.downsampled_iot FROM emondata.one_day.iot GROUP BY time(5m), grid, solar, divert, usage END