Elasticsearch search with nested objects

Question

I have the following object in elastic.

Is there way to run a full text search query like: Fizz AND bar

{
  "258": "Fizz buzz",
  "12416": [
    {
      "161": 54,
      "273": "text doc.txt",
      "544": [
        "text/plain"
      ],
      "12290": "foo bar",
    }
  ]
}

I've read about Runtime fields but it supports only keyword type and will work only in case of full match.

12416 is a nested object or array? on which field of 12416 you want to do the query? — Kaveh
– Kaveh, Commented Jun 15, 2021 at 15:31

jaspreet chahal · Accepted Answer · 2021-06-17 08:01:36Z

2

Query string will not work on nested field. You can either use a nested query or implement a custom _all field

PUT index117
{
  
  "mappings": {
    "properties": {
      "_all":{
        "type": "text"
      },
      "258":{
        "type": "text",
        "copy_to": "_all"  --> copies data to _all field
      },
      "12416":{
        "type": "nested",
        "properties": {
          "12290":{
            "type":"text",
            "copy_to": "_all"
          }
        }
      }
    }
  }
}


POST index117/_doc
{
  "258": "Fizz buzz",
  "12416": [
    {
      "161": 54,
      "273": "text doc.txt",
      "544": [
        "text/plain"
      ],
      "12290": "foo bar"
    }
  ]
}

GET index117/_search
{
  "query": {
    "query_string": {
      "default_field": "_all",
      "query": "foo AND bar"
    }
  }  
}

answered Jun 17, 2021 at 8:01

jaspreet chahal

9,1492 gold badges14 silver badges30 bronze badges

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

2 Comments

Liastre Over a year ago

Why query string will not work on nested field? Do you have any affirmation through documentation on this?

jaspreet chahal Over a year ago

@Liastre There is this discussion on discuss.elastic.co/t/query-string-on-nested-objects/58587 . nested object is a different construct . there is a dedicated query to handle it

Collectives™ on Stack Overflow

Elasticsearch search with nested objects

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related