In Influxdb, How to delete all measurements?

influxdb
rajagopalx picture rajagopalx · Jul 26, 2016 · Viewed 55.1k times · Source

I know DROP MEASUREMENT measurement_name used to drop single measurement. How to delete all measurements at once ?

Answer

Michael Desa picture Michael Desa · Jul 28, 2016

Theres no way to drop all of the measurements directly, but the query below will achieve the same result.

DROP SERIES FROM /.*/

Related questions

Can you delete data from influxdb?

How do you delete data from influxdb? The documentation shows it should be as simple as: delete from foo where time < now() -1h For some reason, influxdb rejects my delete statements saying "Delete queries can't have where clause …

Read More
How to format time in influxdb select query

I am new to InfluxDB. I am querying data in admin ui. I see time as timestamp. Is it possible to see it formatted as date and time?

Read More
InfluxDB - Getting only last value in query

Is possible to query only for the last value (or n-th value) of the results of a query? For example, in the query: SELECT value FROM response_times WHERE time > now() - 1h limit 1000; Is possible to get only …

Read More