Fetch only filtered nested objects from index in elasticsearch

Question

I have a document with nested objects, something like this:

{
    "title" : "Title 1",
    "books": [{
        "book_title": "b title 1",
        "year": 2014
    }, {
        "book_title": "b title 2",
        "year": 2015
    }]
}

Now I need to filter the books on by title (not book_title) and year (let's say 2014). The output I need will be:

{
    "title" : "Title 1",
    "books": [{
        "book_title": "b title 1",
        "year": 2014
    }]
}

When I use a nested filter I get all the nested objects even if they don't match. How can I fetch only the matched nested objects?

Val · Accepted Answer · 2015-09-25 03:20:33Z

6

You need to use the nested inner_hits feature like below.

{
  "_source": [
    "title"
  ],
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "title": "title 1"
          }
        },
        {
          "nested": {
            "path": "books",
            "query": {
              "term": {
                "books.year": 2014
              }
            },
            "inner_hits": {}
          }
        }
      ]
    }
  }
}

In the output you'll get exactly what you expect, namely the title field and the matching book from the nested books array.

answered Sep 25, 2015 at 3:20

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

Fetch only filtered nested objects from index in elasticsearch

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related