I’m trying to downsample using the guide from the influxdb docs. I have a database “telegraf” with a retention policy “autogen”
I created a CQ to do this using this statement:
CREATE CONTINUOUS QUERY "cq" ON "telegraf" BEGIN SELECT MEAN(*) INTO "downsampled".:MEASUREMENT FROM "telegraf"."autogen"./.*/ GROUP BY time(10s),* END
The CQ seems to work, but all of my fields are renamed. For example telegraf.autogen.cpu has fields like “usage_guest” and “usage_idle”, but telegraf.autogen.cpu has “mean_usage_guest” and “mean_usage_idle”
Is there a way to downsample into a new RP with the same field names?