Continuous query help, (does not put enough data into the 'next' retention policy)

1

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
2

changing to

CREATE CONTINUOUS QUERY "test2hcq" ON "test" BEGIN SELECT mean(value) as value INTO "test"."2h".:MEASUREMENT FROM "test"."1h"./.*/ GROUP BY time(1m), * fill(previous) END

> select * from "2h"."ceph_value" limit 10
name: ceph_value
time                 value
----                 -----
2018-12-23T00:29:00Z 237690643658.65118
>

Somehow tags like host, instance, type, type_instance are lost.

3

This also does not help, it does get me the tags, but it looks like it is not grouping on the other columns.

CREATE CONTINUOUS QUERY "test2hcq" ON "test" BEGIN SELECT mean(value) as value, first(*) INTO "test"."2h".:MEASUREMENT FROM "test"."1h"./.*/ GROUP BY time(1m), * fill(previous) END