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"
}