InfluxQL Continuous Query which deletes data

Question

Is there a way to have a continuous query which deletes data, something like:

CREATE CONTINUOUS QUERY "some_name" ON "mydb"
BEGIN
  delete from "some_measurement" where something='bad'
END

When this is run with InfluxQL 1.8, there is an error

ERR: error parsing query: found DELETE, expected SELECT at line 1, char 53

Answer 1

Not that I'm aware of, however you're not necessarily out of luck as this is exactly the sort of workflow that retention policies were designed to handle in concert with continuous queries.

Assuming your use case is something like "downsample this data into a different measurement, then delete the high granularity data", the official documentation provides an excellent overview.