elasticsearch - Elastic query between two indexes

Question

I have two indexes:

Index1

| id | name |
| 1 | A |
| 2 | B |
| 3 | Z |

We are only 200 documents for Index1.

Index2

| id | stmt_id | description |
| 1 | 11 | AAA
| 2 | 11 | BBB
| 3 | 11 | BBC
| 4 | 22 | DDD
| 5 | 22 | EEE
| 6 | 33 | FFF

We have lots of documents for Index2.

All records are synced to elasticsearch for both indexes.

My Input: [1, 2, 3] (id of Index2 records.)

Now I want to match all Index1 records name with some Index2 records description.

And need output something like this:

{
    1(id of Index1 record) : [ 1 ] (id of index2 record). (-- A matching with AAA.)
    2 : [2, 3] (-- B matching with BBB, BBC.)
    3 : [ ] (-- Z is not matching with any Index2 records description.)
}

What type of query will work in this case.

Tried multiple things but not able to achieve the solution.

Thanks in advance.

question from:https://stackoverflow.com/questions/65912592/elastic-query-between-two-indexes

Answer 1

Waitting for answers