What is the command to delete a particular series[i.e., for example out of 10 servers I need to delete one particular server] from influxdb? Influxdb version which we are using is “1.5.2”. Following are the commands which we followed to delete a particular series drop series from metric_nam…

The link you’ve referred to has done the trick for me in the past. Why did it not help? Can you paste the full command you’ve tried, and whether you’ve encountered an error?

Following are the commands which I have performed to delete a series drop series from metric_name where host = ‘hostname’ delete from metric_name where host = ‘hostname’ No, I didn’t encounter any error. If possible, can you please paste the command which you have used in the past to delete a ser…

This is simply what I’ve run and it seems to have worked: DROP SERIES FROM "measurement" WHERE "tag" = 'value'

[image] valentinbora: DROP SERIES FROM “measurement” WHERE “tag” = ‘value’ I have performed the following command, but it doesn’t work, is there any other command other than this. Can you please help us. Thanks! DROP SERIES FROM “measurement” WHERE “host” = ‘hostname’

it seems like you’re not understanding what a measurement is. here’s an example from my setup. First I ssh to my influxdb server, launch influx CLI and show the databases. jjensen@host:~$ influx Connected to http://localhost:8086 version 1.5.2 InfluxDB shell version: 1.5.2 > show databases name: d…

Tried the following command, which gave the output as below - Command: show tag values from measurement_name with key=host; key value host testing host Avinash host seshu host Karthik host Venky host harsha host anil host avi And based on the key …

You need to include your tag value in quotes. > drop series from "measurement_name" where host='harsha'

After performing the command: drop series from “measurement_name” where host=‘harsha’ also it is not deleting. Thank you!

You said you want to delete from telegraf, correct? Have you stopped the telegraf agent on the host harsha? If you haven’t done this, then even if you drop the series, the telegraf agent on the host will likely still be still sending data to InfluxDB, giving you the impression that the DROP SERIES …

Is there a command to delete series permanently. The above commands are just truncating the data. Thanks!

Commad to delete a particular series from influxdb

dandv June 24, 2019, 2:09am 18

I’m also seeing DROP SERIES followed by SHOWing the same series, still not deleting the series. Nothing recreates it - a SELECT * proves that by showing nothing.

Topic		Replies	Views
Delete a particular series, how?	1	656	December 19, 2018
Drop series doesn't work	8	1157	December 15, 2020
Database manipulation Store	1	466	June 24, 2020
Error: not implemented: DROP SERIES InfluxDB 2 influxql	2	1185	October 23, 2022
Drop series from Influx 1.8 database InfluxDB 1 influxdb , getting-started	1	47	September 7, 2025

Commad to delete a particular series from influxdb

Related topics