At my organization we are writing points with timestamps into influxDb.
That means a point with a timestamp hour of 9:59 AM, may be written past 10 AM.
A continuous query that runs hourly will miss this point during its execution.
What I’d like to know is whether I can configure the continuous query to run every hour plus 5 minutes, for example. (09:05, 10:05, 11:05… etc.)
Our hourly CQs, usually go something like this:
CREATE CONTINUOUS QUERY CQ1 ON myDB
BEGIN SELECT sum(Total) AS Total
GROUP BY time(1h), task_name, task_id fill(none)