Update by query, values from another index

Elastic Stack Elasticsearch
1

I have an index with values like

FIRST_INDEX (10 billion entries)
{
id: 123,
car: "Volvo"
},
{
id: 124,
car: "Vaneo"
}

The goal is to fill the above FIRST_INDEX with values from the SECOND_INDEX.

SECOND_INDEX (1 million entries)
{
car: "Volvo"
doors: "4"
},
{
car: "Vaneo"
doors: "6"
}

How do I update FIRST_INDEX with values of doors from the second index? Can I do an update by query and keep this within Elasticsearch?

Final output

FIRST_INDEX (10 billion entries, with new entries)
{
id: 123,
car: "Volvo",
doors: "4"
},
{
id: 124,
car: "Vaneo",
doors: "6"
}
2

Maybe (hard to tell without further details) having an enrich processor could help you in this case. See Enrich your data | Elasticsearch Guide [8.1] | Elastic for more

3

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