@mark my command to create RP
CREATE RETENTION POLICY "rp1h “stress” DURATION 1h REPLICATION 1
and for selecting as @jackzampolin mention on this post i ran below command:
select last() from cpu where time > now() - 1m
select first() from cpu where time > now() - 1m
and also check count column of table in database:
select count(*) from stress
name: cpu
time count_value
0 100000
FYI:after I’ve created RP, I have two RPs:
SHOW RETENTION POLICIES ON “stress”
autogen 0s 168h0m0s 1 true
a_hour 1h0m0s 1h0m0s 1 false
