I have one measurement ‘temp’, which is stored to db ‘temp’ with 1 day retention policy, for example every 1 minute.
Every 1 hour the continuous query calculates 1 hour’s average value and stores it to the same measurement ‘temp’, but with different policy (‘INF’), like this:
CREATE DATABASE “temp”
CREATE RETENTION POLICY “rp_day” ON “temp” DURATION 1d REPLICATION 1 DEFAULT
CREATE RETENTION POLICY “autogen” ON “temp” DURATION INF REPLICATION 1 – autogen is INF by default
CREATE CONTINUOUS QUERY “cq_avg_1h” ON “temp” BEGIN
SELECT mean(“value”) AS “value”
INTO “autogen”.“temp”
FROM “rp_day”.“temp”
GROUP BY time(1h),*
END
Is this schema possible and causes no issues?
