Continuous Query INTO FROM for 2 databases?

InfluxDB 2
,
1

Hi
I´m a beginner so please excuse very entry level question I think.

I´m using influxdB for an automation system and with regard to the documentation I now try to implement a data retention to be able to handle longterm data etc.
Therfore I created a second database “longterm” and now try to create a continous query which selects data from 1 source for a period of 1 minute from database “iobroker” and put it into “longterm”. At the moment database “longterm” is empty and I´m struggeling with the creation and I guess this it based on wrong typing and usage of “” in the command. May I kindly ask if you can have a supportive hint for me.

CREATE CONTINUOUS QUERY “1mTest” ON “longterm”
BEGIN
SELECT integral(“value”) /3600000 AS “value”
INTO “longterm”.“shelly.0.SHBDUO-1#D02226#1.lights.Power”
FROM “iobroker”.“shelly.0.SHBDUO-1#D02226#1.lights.Power”
GROUP BY time(1m),*
END

ERR: retention policy not found: longterm.longterm

Big thx!

influxstudio
influxstudio1184×624 87 KB

2

Thx, after lot´s of try and error found a working solution:

CREATE CONTINUOUS QUERY “5mTest” ON “longterm”
BEGIN
SELECT INTEGRAL(“value”) /3600000 AS value
INTO longterm.autogen.“shelly.0.SHBDUO-1#D02226#1.lights.Power”
FROM iobroker.autogen.“shelly.0.SHBDUO-1#D02226#1.lights.Power”
GROUP BY time(5m),*
END