Downsample data using INTO clause

Store
,
1

Hi all,
I’m trying to downsample existing data into a new DB with an infinite retention period.
I am trying to use an INTO query to downsample all the data in a DB into a new one. It returns error 400 in Chronograf and 0 written data when run directly in influxdb.

SELECT MEAN(*) INTO "new_db"."autogen".:MEASUREMENT FROM original_db WHERE time >= '1970-01-01T00:00:00Z' AND time <= now() GROUP BY time(60m)

What am I doing wrong? The syntax looks OK to me!

2

I think you are missing RP and measurement name in your FROM

3

Thank you very much. Here is the correct working syntax.

SELECT MEAN() INTO “new_db”.“autogen”.:MEASUREMENT FROM “original_db”.“autogen”././ WHERE time >= ‘1970-01-01T00:00:00Z’ AND time <= now() GROUP BY time(60m)