Elasticsearch nested type select query

Question

I have a field with mapping:

   "my_field_name": {
            "type": "nested",
            "properties": {
              "labels": {
                "type": "text"
              },
              "source": {
                "type": "text"
              }
            }
          }

and when I put data, format is like:

"my_field_name": {
            "url_of_an_image": [
              "tag1",
              "tag2",
              "tag3",
              "tag4",
              "tag5"
            ],
            "url_of_an_image2": [
              "tag4",
              "tag5",
              "tag6",
              "tag7",
              "tag8"
            ]
}

I want to write an elasticsearch query to gather all the documents that contains given tag.

How can I search a tag in all documents and select the ones that contains given tag?

Thank you

glenacota · Accepted Answer · 2019-03-16 10:35:59Z

1

(EDITED AFTER COMMENT)

As a first consideration, the mapping doesn't match the structure of your document, e.g., my_field_name has neither labels nor source fields. Which is the one that better represents your data?

As a second consideration, in your comment you said that

while querying I don't know "url_of_an_image" since it is different for each document

However, from your example, it looks like url_of_an_image is a property of the items of my_field_name rather than of the document. Therefore, I'd suggest doing something like:

"my_field_name": [
  {
    "image_url": "url_of_an_image",
    "tags": [
       "tag1",
       "tag2",
       "tag3",
       "tag4",
       "tag5"
    ]
  },
  {
    "image_url": "url_of_an_image2",
    "tags": [
       "tag4",
       "tag5",
       "tag6",
       "tag7",
       "tag8"
    ]
  }
]

And this would be the mapping:

"my_field_name": {
  "type": "nested",
  "properties": {
     "image_url": {
       "type": "text"
     },
     "tags": {
       "type": "text"
    }
  }
}

This way, you can run queries like:

{
  "query": {
    "nested" : {
      "path" : "my_field_name",
      "query" : {
        "bool" : {
          "must" : [
            { "match" : {"my_field_name.image_url" : "url_of_an_image2"} },
            { "match" : {"my_field_name.tags" : "tag3"} }
          ]
        }
      }
    }
  }
}

edited Mar 16, 2019 at 10:35

answered Mar 16, 2019 at 9:20

glenacota

2,5571 gold badge14 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

bakayim Over a year ago

Hello @glenacota, unfortunately it did not worked. And moreover, while querying I don't know "url_of_an_image" since it is different for each document (some of documents may have the same url_of_an_image but it is not important). I am trying to find a way to query without specifying a "url_of_an_image". I have different documents with different "url_of_an_image"s and each of them has a list of tags. I want to gather all the documents that contain given tag

bakayim Over a year ago

Hello @glenacota, I will update here after trying your suggestion. Thank you

core · Accepted Answer · 2019-03-16 00:14:38Z

0

You can achieve this by using the Nested Query: https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-nested-query.html

answered Mar 16, 2019 at 0:14

core

8711 gold badge9 silver badges28 bronze badges

1 Comment

bakayim Over a year ago

Actually, it does not provide me a solution. I tried it already

Collectives™ on Stack Overflow

Elasticsearch nested type select query

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related