Select records from first index which are not present in another index

Elastic Stack Elasticsearch
1

i wish select those records from products index which are not in shop_inventory index
is there any way to achieve this in elasticsearch. product_id is the common field in both indexes

2

you cannot join the data from two indices together.

Data modeling question: Is there a chance that you could merge the two indices into one, by putting both information into a single document? Or alternatively take a look at the join datatype

--Alex

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.