[0.9.4.2] invalid DELETE query doesn't return error

[caoli5288]

30m ago, I run delete from xxx where time < now() -7d and it lag till now.
By the way, the process influxd always use 200% cpu time.

[caoli5288]

2 hours past :-)

[beckettsean]

DELETE FROM is not yet a valid query. #1647 is the open issue for making it work.

The query should give a parser error, though.

[caoli5288]

@beckettsean So how can I delete a specific record?

[beckettsean]

@caoli5288 you cannot delete a specific record.

[caoli5288]

@beckettsean Never can not?

[beckettsean]

@caoli5288 it is possible to overwrite a point, or to delete a series or measurement, or use a retention policy to bulk delete older data, but InfluxDB does not support the deletion of a single point. It is one of the optimizations that allows for much higher throughput than a traditional RDBMS.

[caoli5288]

@beckettsean Thanks!

[nathanielc]

I can reproduce the hang on 0.9.4.2 but not in master. @caoli5288 Do you still see the issue on a newer version?

[caoli5288]

@nathanielc When I knew it was an not supported operation , I never tried it again. THX.