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!