The continuous query only seems to work when I specify the from statement. Is it because I’ve got string values in some measurements? and in that case how can I regex exclude them?
CREATE CONTINUOUS QUERY “downsample mean” ON telegraf BEGIN
SELECT mean(*)
INTO telegraf.storage.:MEASUREMENT
FROM telegraf.tmp.cpu GROUP BY time(5m), *
END
CREATE CONTINUOUS QUERY “downsample mean” ON telegraf BEGIN
SELECT mean()
INTO telegraf.storage.:MEASUREMENT
FROM telegraf.tmp././ GROUP BY time(5m), *
Hello @Werner123,
Apologies sometimes questions get buried.
Continuous queries in InfluxDB require specifying the exact measurement name. You cannot use wildcards directly in the measurement name. Docs for reference: docshttps://archive.docs.influxdata.com/influxdb/v0.12/query_language/continuous_queries/#cq-definition