Continuous query doesn't create MEASUREMENTS

influxql
influxdb
#1

I am following the guide to down sample and it’s not creating the measurement for the CQ.

I made a database Test and data will be populated in measurement “infoLog”

retention policies:
> show retention policies on “Test”

name    duration  shardGroupDuration replicaN default
----    --------  ------------------ -------- -------
autogen 0s        168h0m0s           1        false
4_weeks 672h0m0s  24h0m0s            1        true
a_year  8736h0m0s 168h0m0s           1        false

my CQ:
name: Test
name query
---- -----
cq_2m CREATE CONTINUOUS QUERY cq_2m ON Test BEGIN SELECT mean(UsedMemory) AS mean_UsedMemory INTO Test.a_year.downsampled_orders2min FROM Test."4_weeks".infoLog GROUP BY time(2m) END

cq_inst CREATE CONTINUOUS QUERY cq_inst ON Test RESAMPLE EVERY 2m BEGIN SELECT mean(InstantaneousOpsPerSec) AS mean_InstantaneousOpsPerSec INTO Test.a_year.downsampled_orders2min FROM Test.infoLog."4_weeks" GROUP BY time(2m) END

I’m trying to make a CQ that will get the average of a field every 2 minutes. I have also tried FOR…EVERY like this suggests.

Not sure what I’m doing wrong.

#2

still have this issue, any help?

#3

I truly suggest you to run it with a cron command like
*/2 * * * * curl -i -XPOST http://localhost:8086/query --data-urlencode "q=SELECT mean(UsedMemory) AS mean_UsedMemory INTO Test.a_year.downsampled_orders2min FROM Test."4_weeks".infoLog GROUP BY time(2m)"

In your CQ try to add RESAMPLE EVERY 10m :
CREATE CONTINUOUS QUERY cq_2m ON Test RESAMPLE EVERY 10m BEGIN SELECT mean(Used....

if this works,delete the cron job.

Take care at this double quotes : ...FROM Test.**"**4_weeks**"**.infoLog....