ElasticSearch: check if nested object array is empty

Question

How do I go about fetching all documents w/o any objects in a field?

I have the following mapping:

"properties" : {
  "name": {
    "type": "text"
  },
  "nestedArray": {
    "type": "nested",
    "properties": {
      "prop1": {
        "type": "text"
      },
      "prop2": {
        "type": "text"
      }
    }
  }
}

and I want to get all documents where "nestedArray" is empty or doesn't exist.

I'm using elasticSearch 5.0

ChintanShah25 · Accepted Answer · 2016-11-22 17:46:27Z

32

I think exists query would solve this problem. Try following query

{
  "query": {
    "bool": {
      "must_not": [
        {
          "nested": {
            "path": "nestedArray",
            "query": {
              "bool": {
                "filter": {
                  "exists": {
                    "field": "nestedArray"
                  }
                }
              }
            }
          }
        }
      ]
    }
  }
}

answered Nov 22, 2016 at 17:46

ChintanShah25

12.7k3 gold badges45 silver badges44 bronze badges

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

4 Comments

rodney757 Over a year ago

Thanks, I was trying the exists query, but I had the nested and bool switched.

ChintanShah25 Over a year ago

glad I could help

jose.arias Over a year ago

Thank you! I spent almost an hour looking for this answer.

FishingIsLife Over a year ago

thank you. To me it is pretty confusing to use the nested attribute here as I just want to check whether the array is empty and not if one the inside objects value.

Kunwar Shukla · Accepted Answer · 2022-10-23 05:16:21Z

0

Try this

{
  "size": 5000,
  "query": {
    "bool": {
      "filter": [],
      "must_not": [
        {
          "nested": {
            "path": "nestedArray",
            "query": {
              "exists": {
                "field": "nestedArray"
              }
            }
          }
        }
      ]
    }
  },
  "from": 0
}

answered Oct 23, 2022 at 5:16

Kunwar Shukla

256 bronze badges

Collectives™ on Stack Overflow

ElasticSearch: check if nested object array is empty

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related