I created retention policies
CREATE RETENTION POLICY "1h" ON test DURATION 1h REPLICATION 1
CREATE RETENTION POLICY "2h" ON test DURATION 2h REPLICATION 1
I created continuous query
CREATE CONTINUOUS QUERY "test2hcq" ON "test" BEGIN
SELECT mean(*)
INTO "test"."2h".:MEASUREMENT
FROM "test"."1h"./.*/
GROUP BY time(1m),*
END
If I insert some data into “test”.“1h” from a database that gets 10s samples, with
SELECT * INTO "test"."1h".:MEASUREMENT FROM "collections"."autogen"./.*/ WHERE time > now() - 10m
> select count(value) from "1h"."ceph_value"
name: ceph_value
time count
---- -----
1970-01-01T00:00:00Z 2305730
I expect to have at least 10 records, but I only have one
> select count(mean_value) from "2h"."ceph_value"
name: ceph_value
time count
---- -----
1970-01-01T00:00:00Z 1