Newby here.
I store cumulative data (electric & gas meter data every minute)
I create two CQs:
every hour take the derivative of last cumulative value and store it in HourTotals
every day take the derivative of last cumulative value and store it in DayTotals
The HourTotals is getting new data every hour, but the DayTotals remains empty.
I experimented with the RPs in this matter: Duration and Shard Duration both more and less than 1 day.
Nothing seems to help, result is same.
In the influx log file, I can see that both CQs are running on the right time, and no errors are reported here. So I guess the CQ is fine, but for some reason the hour CQ is creating data and the day CQ is not.
What am I doing wrong here?
(sorry for the mixed dutch/english naming 
)
show continuous queries
name: udp
name query
---- -----
dagtotaal CREATE CONTINUOUS QUERY dagtotaal ON udp BEGIN SELECT derivative(last(cumConsLo)) + derivative(last(cumConsHi)) AS cumCons, derivative(last(cumDelvLo)) + derivative(last(cumDelvHi)) AS cumDelv, derivative(last(cumGas)) AS cumGas INTO udp.infinit.DayTotals FROM udp.two_days.SmartMeter WHERE time > now() - 1d GROUP BY time(1d) END
uurtotaal CREATE CONTINUOUS QUERY uurtotaal ON udp BEGIN SELECT derivative(last(cumConsLo)) + derivative(last(cumConsHi)) AS cumCons, derivative(last(cumDelvLo)) + derivative(last(cumDelvHi)) AS cumDelv, derivative(last(cumGas)) AS cumGas INTO udp.infinit.HourTotals FROM udp.two_days.SmartMeter WHERE time > now() - 1h GROUP BY time(1h) END
show retention policies
name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
autogen 0s 168h0m0s 1 false
two_days 336h0m0s 168h0m0s 1 true
infinit 0s 168h0m0s 1 false
