I’ve been using Influx now for a few months, Version 1.81.
I started now to use continuous queries, but i’m having the issue that i dont know whether they are executed. Could anyone give me some help with that?
I am using three kinds of RP: 14days, 90days and INF.
Data in the 14 days RP is of high volume, while the 90day RP only consists of:
- downsampled 14day data
- Data which only occurs 1-5 times a day.
To easy display the data in grafana i wanted to duplicate my data of the 90d into the 14day RP.
Therefore i am using the following CQ:
CREATE CONTINUOUS QUERY test_1 ON mydatabase RESAMPLE EVERY 2h FOR 7d BEGIN SELECT * INTO mydatabase.rp_14.mymeasurement FROM mydatabase.rp_90.mymeasurement GROUP BY * END
Although it seems not to work, no data is transfered, not even newly inserted one.
Also other queries like:
CREATE CONTINUOUS QUERY test_2 ON mydatabase BEGIN SELECT mean(*) INTO mydatabase.rp_90.mymeasurement FROM mydatabase.rp_14.mymeasurement GROUP BY *, time(1d) END
are not executed.
Any suggestion or help on that issue?
Is there a other possible to achive what i am wanting?