Delete data from elasticsearch

Question

I am trying to delete data of particular type from Elasticsearch. I am using the Sense plugin within Chrome to execute my delete command. When I execute the command to delete index, it works for id, but not for type. In Sense I used:

DELETE /index
- It deleted all data for that index.
DELETE /index/type/id
- It delete data of that id.
DELETE /index/type
- gives error of No handler.

Than I also tried curl commands via Cygwin to do same task it was not working, but it gave me a message about unknown curl. Please help me to know how to delete data of particular type.

Richa is offering the right solution. As a side note, Cygwin does not install curl by default, so you need to install it before it will work. The reason that DELETE /index/type exclaims that there is "No handler" is because the delete API only expects {index}/{type}/{id} or {index} as of ES 2.0. — pickypg
– pickypg, Commented Jul 5, 2016 at 15:51

Richa · Accepted Answer · 2016-07-05 16:05:26Z

1

It seems you are using Elasticsearch version 2.x. In ES 2.x it is not allowed delete a particular type. See this.

You can use delete by query plugin to delete a particular type.

Install delete-by-query plugin using

sudo bin/plugin install delete-by-query

And then run

DELETE /index/type/_query

This would delete the documents of that particular type.

edited Jul 5, 2016 at 16:05

answered Jul 5, 2016 at 15:38

Richa

7,6796 gold badges30 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

pickypg Over a year ago

You can use the delete by query plugin to effectively delete a particular type. Note that its mappings will survive the operation.

pickypg Over a year ago

You should show the example in your answer incase the links break. (I didn't downvote because those links should survive for awhile, but the breaking changes link will definitely break eventually due to current being in it)

Richa Over a year ago

@pickypg.Thnx for your comment. The answer is delete by query plugin and I have added that in my answer. So what else should be added in it? Please explain..

pickypg Over a year ago

Literally show the example of how to install it and how to then use it: bin/plugin install delete-by-query and DELETE /index/type/_query

Richa Over a year ago

@pickypg: Thnx for telling me the improvement. Edited my answer

|

Collectives™ on Stack Overflow

Delete data from elasticsearch

1 Answer 1

6 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Related