In Influxdb, How to delete all measurements?

Question

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

for future myself: https://docs.influxdata.com/influxdb/v1.3/query_language/database_management/#drop-series-from-the-index-with-drop-series — kmonsoor, Jul 31 '17 at 16:09

score 91 · Accepted Answer · answered Jul 28 '16 at 21:58

91

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

DROP SERIES FROM /.*/

answered Jul 28 '16 at 21:58

Michael Desa

2

This worked for me, but I wanted to only delete one measurement not all, how do I choose to delete all data within a single measurement? – valentt Nov 26 '19 at 21:16

score 6 · Answer 2 · answered Aug 14 '17 at 15:04

For those who are looking to use WHERE clause with DROP SERIES, here it is:

DROP SERIES FROM /.*/ WHERE "your-tag" = 'tag-value-to-delete-data'

Please notice the quotation marks on after the WHERE clause, they should be like this for DROP SERIES; as of InfluxDB v.1.3.

Else, you might get error like ERR: invalid expression: ...

score 1 · Answer 3 · answered Jan 04 '22 at 09:48

1

The way to delete all entries of one MEASUREMENT is

DELETE FROM MEASUREMENT_NAME

answered Jan 04 '22 at 09:48

angie866

score 0 · Answer 4 · answered Mar 27 '23 at 19:38

0

clear bucket in command line: influx delete --bucket 'mybucket' --org 'myorg' --start 1970-01-01T00:00:00Z --stop $(date +"%Y-%m-%dT%H:%M:%SZ")

answered Mar 27 '23 at 19:38

Serwer G-ka

score -2 · Answer 5 · answered Aug 08 '18 at 11:58

-2

use "DELETE Measurement" from InfluxDB admin Panel

answered Aug 08 '18 at 11:58

ehsan latif

5 Answers5