How can I delete multiple data in specific index in elasticsearch

Question

I need to delete the multiple record in specified index/type. i follow this document stil i have same issue

I need to delete all documents in gvisitor type in g_visitor index, i follow below command

curl -XDELETE http://10.1.2.10:9200/g_visitor/gvisitor

its throw below error

No handler found for uri [/g_visitor/gvisitor] and method [DELETE]

Then follow to install Delete By Query plugin and try to remove documents ,

curl -XDELETE 'http://10.1.2.10:9200/g_visitor/gvisitor/_delete_by_query?conflicts=proceed' -d '{
    "query" : { 
        "match_all" : {}
    }
}'

Its throw below error:

  {
     "found":false,
     "_index":"g_visitor",
     "_type":"gvisitor",
     "_id":"_delete_by_query",
     "_version":1,
     "_shards":{
        "total":2,
        "successful":1,
        "failed":0
     }
  }

Suggeset me, How can i delete multiple or all documents in specific type of index in elasticsearch.

Val · Accepted Answer · 2017-03-28 12:54:26Z

3

You cannot delete a mapping type, hence why your first query doesn't work.

You can only delete an index

curl -XDELETE http://10.1.2.10:9200/g_visitor

If you want to use the delete-by-query approach, you can do so, but you need to install the plugin first

sudo bin/plugin install delete-by-query

Then you can use the plugin like this by calling the _query endpoint (not _delete_by_query!!):

curl -XDELETE 'http://10.1.2.10:9200/g_visitor/gvisitor/_query?conflicts=proceed' -d '{
    "query" : { 
        "match_all" : {}
    }
}'

edited Mar 28, 2017 at 12:54

answered Mar 28, 2017 at 12:47

Val

218k14 gold badges377 silver badges384 bronze badges

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

1 Comment

Rajkumar Elumalai Over a year ago

i already installed delete-by-query plugin and try deleted above mentioned way its not works for me

Shuhd · Accepted Answer · 2021-09-08 08:05:24Z

0

if you are using delete-by-query you need to use terms instead of match_all

curl -XDELETE 'http://10.1.2.10:9200/g_visitor/gvisitor/_delete_by_query?conflicts=proceed' -d '{
    "query" : { 
        "terms" : {}
    }
}'

answered Sep 8, 2021 at 8:05

Shuhd

11 bronze badge

Collectives™ on Stack Overflow

How can I delete multiple data in specific index in elasticsearch

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related