Influxdb: How to specify the database, when dropping measurements via Chronograph query

[GeorgWa]

Im sorry to ask this question here, but i cant find information on this topic in the Influxdb docs.
I want do delete a measurement using the Chronograph query interface.
How do i specify the database i want to affect ?

The suggested syntax
DROP MEASUREMENT "weather"
returns
Database not found

In the Influx Interface i can see, that there is no database specified
POST /query?db=&epoch=ms&q=DROP+MEASUREMENT+weather&rp= HTTP/1.1"

Using
DROP MEASUREMENT "therm"."autogen"."weather"
returns
found . ,expected ; at line 1 char 25
suggesting, that no further input is required after the first string.
The same error comes up when specifying
DROP MEASUREMENT "weather" FROM "therm"."autogen"

[jsternberg]

It looks like we do not support ON <db> for this type of query. I'll mark this down as something for us to talk about at the next planning meeting.

[MooreDerek]

Any progress on this?

[mythsman]

mark

[hftautobot]

Any updates on this please :(

[Willis0826]

Is there any workaround ? Temporarily, I couldn't drop the measurement.

[tonylee2016]

same problem here

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale[bot]]

This issue has been automatically closed because it has not had recent activity. Please reopen if this issue is still important to you. Thank you for your contributions.

[tonylee2016]

please reopen, this is important

Im sorry to ask this question here, but i cant find information on this topic in the Influxdb docs.
I want do delete a measurement using the Chronograph query interface.
How do i specify the database i want to affect ?

The suggested syntax
DROP MEASUREMENT "weather"
returns
Database not found

In the Influx Interface i can see, that there is no database specified
POST /query?db=&epoch=ms&q=DROP+MEASUREMENT+weather&rp= HTTP/1.1"

Using
DROP MEASUREMENT "therm"."autogen"."weather"
returns
found . ,expected ; at line 1 char 25
suggesting, that no further input is required after the first string.
The same error comes up when specifying
DROP MEASUREMENT "weather" FROM "therm"."autogen"

[bm2u]

Hi @tonylee2016, here is what I did to drop certain measurement (in your case weather):

use therm.autogen
drop measurement weather

It's gone - It works!

[tomasaschan]

/reopen please.

Or at least give some reason why this won't be addressed. Is there some way the community could help out with this?

[optimuspaul]

@bm2u how can you do that in chronograf? This is pretty frustrating as I don't have direct access to this database.

[bm2u]

@optimuspaul I don't think so. I've used the command line interface (influx) to drop data.

[alexeinz]

same here.. its pretty frustrating in fact...

[upMKuhn]

same here.. its pretty frustrating in fact...

[one-random-dev]

Same here, having to use the command line is a limitation.

Please reopen this or have someone tag it as won't fix, at least some kind of feedback please

[bernardolm]

+1

[lelithium]

This would be very useful.

[Kosygor]

I do upvote. Right now I am playing around with dump measurements for few days.