Drop measurements

hellobhaskar · November 27, 2018, 6:30am

Is there any way to drop some measurements from storing.We are getting lot of measurements from consul which doesnt follow best practices of schema design. We also dont use them hence is there any way to drop those metrics

foxmask · November 27, 2018, 1:53pm

github.com/influxdata/influxdb

DROP MEASUREMENT "xyz" not working

opened 05:10AM - 09 Apr 18 UTC

mgf909

kind/bug pm/review area/meta queries 1.x

### Bug report Cannot delete measurments. I accidentally created a bunch of …MS SQL server measurements into my Telegraf db, and want to remove them. When i try to remove them with DROP MEASUREMENT "<name of measurement>" it doesnt actually seem to drop it... My mistake seems to have created over 1000 measurements, so i suspect the bug/issue is due to the number of measurements. If i create a new test database i can drop measurements as expected. __System info:__ Influx 1.5.1 running on Red Hat 4.8.5-11 __Steps to reproduce:__ Create a lot of measurements - i did this by trying to use the MS SQL Server telegraf input. 1. USE telegraf 2. DROP MEASUREMENT "xa7_sessions" It doesnt matter what measurement i specify, i cannot remove it. There is no error 3. SHOW MEASUREMENTS Its still there! __Expected behavior:__ Id expect the measurement to no longer be returned after running the DROP MEASUREMENT command. __Actual behavior:__ SHOW MEASUREMENT continues to return the measurement..and will not die ;-( __Additional info:__ [Include gist of relevant config, logs, etc.]

Could help

Topic		Replies	Views
Cannot remove _internal measurements / series	5	2218	December 21, 2018
Cannot drop measurement in Influxdb 1.8 influxdb , influxql	3	634	March 5, 2024
Drop measurement InfluxDB 2 influxdb , influxql , query , cli	2	260	February 19, 2024
Delete "MEASUREMENTS " from the database Telegraf	16	34047	December 17, 2020
New measurements in my database? Cannot delete empty measurement?	1	778	February 14, 2019

Drop measurements

Related topics