Hi, I need to save disk space and i want to deal with downsampling to do the job.
I'd like to relocate measurement and tag set from the default Retention Policy to a new RP called "1month" if I try to "copy" them with a CQ like the query below, I get an error because my CQ doesn't have aggregation Query : |CREATE RETENTION POLICY "1month" ON "snmpdb" DURATION 30d REPLICATION 1 SHARD DURATION 4h CREATE CONTINUOUS QUERY "cq_60s" on "snmpdb" begin select * into "1month"."downsampled_snmpdb" from snmpdb group by time(60s), * end | Error : |ERR: error parsing query: GROUP BY requires at least one aggregate function | Maybe CG feature is not for that use... Anyone has a similar use case? Thx, -- Félix Defrance PGP: 0x0F04DC57 -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/ba41e3e9-98f4-0726-1e05-e7f74db98d7f%40d2france.fr. For more options, visit https://groups.google.com/d/optout.
