Hello, I can’t delete a “measurements” from the database. Unfortunately I created a CQ by assigning a wrong name to the “measurements” and I would like to delete it, but I cannot manage with any command, even deleting the continuous query. The measure in question is called: “sensor_infinite_datar…

Hi @Anaisdg , thanks to the documentation you indicated, my friend Mario ( shogunxam (MARIO D'AMICO) · GitHub ) was able to process the code that allowed the cancellation of the “measurements”: curl -u myusername: mypassword -XPOST ‘http: // localhost: 8086 / query? db = mydb’ --data-urlencode ‘q = …

Delete "MEASUREMENTS " from the database

Telegraf

Anaisdg December 16, 2020, 5:10pm 13

Hello @SmartM-ui,
I haven’t used the 1.x API in a while, so I might be wrong, but you could try:

curl http://localhost:8086/query \
  -d db="homeassistant" \
  -d q='drop measurement "sensor_infinite_dataraw_temperture"'

Topic		Replies	Views
Cannot delete from database Telegraf	1	545	November 23, 2018
Delete all measurement start with InfluxDB 2 influxdb	3	99	April 1, 2024
Delete Measurement not possible InfluxDB 1	1	464	October 4, 2021
Deleting measurements InfluxDB 2 influxdb	3	3730	January 28, 2022
Delete measurements by name from bucket InfluxDB 2 client-libraries , flux	5	8720	July 1, 2020

Delete "MEASUREMENTS " from the database

Related Topics