Querying multiple indices in elasticsearch with association

Question

I have two indices: in index A, I have id of document in index B. I want to search index B by some search term and get all documents from Index A that matches IDs of the search from Index B.

If I was speaking in terms of relational database it would be something like

select * from a, b where a.bid = b.id and b.some_field = 'search_term';

Denormalizing is not possible right now, so I am looking for ideas on how to accomplish this.

I tried multisearch API, but I pretty much get two distinct results, which is not what I need.

Answer 1

等待大神答复