ElasticSearch 2.x exists filter for nested field doesn't work

Question

I have the following mapping

{
  "properties": {
    "restaurant_name": {"type": "string"},
    "menu": {
      "type": "nested",
      "properties": {
        "name": {"type": "string"}
      }
    }
  }
}

I am trying to filter all those documents which have optional "menu" field exists

GET /restaurnats/_search
{
  "filter": {
    "query": {
      "bool": {
        "must": [
          {"exists" : { "field" : "menu" }}
        ]
      }
    }
  }
}

But, when I try the same query to filter those documents which have "restaurant_name", then it works fine. So why nested field check doesn't work? How to get it work?

Val · Accepted Answer · 2016-11-08 05:14:51Z

4

You need to use a nested query instead:

{
  "filter": {
    "query": {
      "nested": {
        "path": "menu",
        "query": {
          "bool": {
            "must": [
              {
                "exists": {
                  "field": "menu"
                }
              }
            ]
          }
        }
      }
    }
  }
}

answered Nov 8, 2016 at 5:14

Val

218k14 gold badges377 silver badges384 bronze badges

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

4 Comments

JVK Over a year ago

Thanks @val for the solution

pmishev Over a year ago

This doesn't seem to work when you invert the logic to must_not. In my use case, it returns 0 documents, although there are a lot that are missing the field

Val Over a year ago

@pmishev feel free to create a new question with your specific problem.

pmishev Over a year ago

stackoverflow.com/questions/41262668/…

Collectives™ on Stack Overflow

ElasticSearch 2.x exists filter for nested field doesn't work

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related