How to delete multiple documents in elasticsearch?

Question

I want to delete many documents from elasticsearch that don't exist anymore on my database.

I know that to delete multiple documents (with ids 1,2,3 for example) we use :

curl -XDELETE localhost:9200/index/doc/ids=1,2,3

But I want to keep only those ids and delete the rest, it something like the following instruction in SQL.

DELETE FROM table1 WHERE id_column NOT IN (1,2,3);

Is there an equivalent of NOT IN in this case for elasticsearch?

this might be useful elastic.co/guide/en/elasticsearch/reference/current/… — Kaushik
– Kaushik, Commented Sep 22, 2017 at 13:17

Arash.Zandi · Accepted Answer · 2020-01-13 07:11:40Z

7

It may be little dangerous but you can use delete by query. delete by query api

The query will be something like this:

query : {bool : { must_not : {ids : values : [1,2,3,... ]}}}

Arash.Zandi

1,7172 gold badges22 silver badges35 bronze badges

answered Sep 22, 2017 at 19:58

tomas

3372 silver badges13 bronze badges

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

1 Answer 1