Menu
I know DROP MEASUREMENT measurement_name used to drop single measurement. How to delete all measurements at once ?
728
Delete measurements with DROP MEASUREMENT The DROP MEASUREMENT query deletes all data and series from the specified measurement and deletes the measurement from the index. Note: DROP MEASUREMENT drops all data and series in the measurement. It does not drop the associated continuous queries.
Delete a bucket in the InfluxDB UIIn the navigation menu on the left, select Load Data > Buckets. Find the bucket that you would like to delete. Click the icon located far right of the bucket name. Click Confirm to delete the bucket.
Downsampling allows you to reduce the overall disk usage as you collect data over time. Downsampling can also improve query performance for InfluxDB OSS or Cloud. Finally, InfluxDB can ingest hundreds of thousands of points per second.
Theres no way to drop all of the measurements directly, but the query below will achieve the same result.
DROP SERIES FROM /.*/ 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: ...
38
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
