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 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…