I have 2 indexes in my Elasticsearch setup. <ul> <li>index_a</li> <li>index_b</li> </ul> <code>index_a</code> has a field <code>location</code> and have about 1000 documents where as <code>index_b</code> has a field <code>city</code> and have about 600 documents. I want to find out all the <code>locations</code> from <code>index_a</code> that are not in the <code>city</code> field in <code>index_b</code>. What query should I make to achieve the above ?

You perform two queries: select "all necessary info" from index_b, then perform the search on index_a using the "info" from index_b. Elasticsearch is not able to "join" in any way two indices in a single query, and rather prefers having denormalized data, or use nested or parent-child relationships.

How to do a join negative query in ES

1 Answers

You perform two queries: select "all necessary info" from index_b, then perform the search on index_a using the "info" from index_b.

Elasticsearch is not able to "join" in any way two indices in a single query, and rather prefers having denormalized data, or use nested or parent-child relationships.