How to delete document with multiple index in Elasticsearch

Question

I have sample data like below.

Data_id Name    Destination
224345565   HCM South VietNam
456566666   HN  North VietNam

 Index: Sample_1

sample_1 sample1

Data_id Food    Drink
224345565   Banh Mi Milk Coffee
456566666   Bun Cha Nuoc quac

 Index Sample_2

sample_2 sample2 I want to delete HCM name in first table and the data related with the same Data_id in Sample_2 also deleted. How can I do it? DELETE /sample_1, sample_2/_doc/224345565 ????

Bhavya · Accepted Answer · 2021-08-24 12:47:11Z

2

You can use delete by query API, to delete some specific documents (based on a condition) from multiple indexes.

POST /sample1,sample2/_delete_by_query
{
  "query": {
    "match": {
      "Data_id": 224345565
    }
  }
}

answered Aug 24, 2021 at 12:47

Bhavya

16.2k3 gold badges23 silver badges52 bronze badges

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

6 Comments

Bhavya Over a year ago

@Josley please go through the answer, and let me know if this resolves your issue ?

Josley Over a year ago

Hi @ESCoder, I try with your answer, the data in sample2 was deleted but data in a sample is still exists!

Bhavya Over a year ago

@Josley have you added both the index in the post-call -> POST /sample1,sample2/_delete_by_query ? Because I tried it, and this query is working fine

Bhavya Over a year ago

@Josley can you please share the query which you are using along with the POST API call

Josley Over a year ago

Could you look through the new image in the post! The other example is about data in 2 different indexs.

|

Collectives™ on Stack Overflow

How to delete document with multiple index in Elasticsearch

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related