CODEWITHSUNDEEP
elasticsearch
miltonlaufer
miltonlaufer

Reputation: 305

ElasticSearch: update by query from a different index

I have the following problem with ElasticSearch. Let's say I have one index called "products". In general, its documents have the following fields:

  1. productId
  2. productPackId
  3. productName
  4. price

And then (for reason that I cannot explain here, but let's say weren't my decision) I have another index called "productPacks" with:

  1. productPackId
  2. name
  3. imageUrl

Now, I need to get the imageUrl field of the index "productPacks" in the "products" index according to which *productPackId" each document on the "products" index has. To clarify: let's say that in "productPacks" the document with

"productPackId" = 1

has as

imageUrl: "https://mywebsite.com/image1.jpg",

what I need is that all documents on the "products" index that have "productPackId" === 1 get then

imageUrl: "https://mywebsite.com/image1.jpg"

I can't find a way of doing it.

Thanks in advance!

(This, of course, would be super easy on a SQL database.)

Upvotes: 2

Views: 1104

Answers (2)

Paco BADIANE
Paco BADIANE

Reputation: 181

The result you expect, you can only do it with a SQL request

https://www.elastic.co/guide/en/elasticsearch/reference/master/xpack-sql.html

Upvotes: 1

brugia
brugia

Reputation: 483

What you basically want to do is join the two indices, on the "productPackId".

This is not possible in elasticsearch over two different indices.

There is a simple solution:

Iterate over each and every document in the index with the image url's(Index 2) and update by query into index 1, use the productPackId to make the query. That way you will be able to add the image_urls into index1.

Elasticsearch does not have any concept of Join's across indexes.

HTH.

Upvotes: 3

Related Questions