Elasticsearch querying nested objects returning no results

Question

I have created Elasticsearch index and one of the nested field has mapping as following.

"groups": {
    "type": "nested",
    "properties": {
        "name": {
             "type": "text"
        },
        "value": {
             "type": "text"
        }
    }
}

On details about ES version, its 5.0 and I am using official python client elasticsearch-py on client side. I want to query this nested field based on its value.

Lets say there is another field called name which is a text type field. I want to find all name starting with A and falling under group specified.

Some sample data,

Groups - HR(name=HR, value=hr), Marketing(name=Marketing, value=marketing) Names - Andrew, Alpha, Barry, John

Andrew and Alpha belong to group HR.

Based on this I tried a query

{
    'query': {
        'bool': {
            'must': [{
                'match_phrase_prefix': {
                    'title': 'A'
                }
            }]
        },
        'nested': {
            'path': 'groups',
            'query': {
                'bool': {
                    'must': [{
                        'match': {
                            'groups.value': 'hr'
                        }
                    }]
                }
            }
        }
    }
}

For this query I referred ES docs but this query does not return anything. It would be great if someone can point out what is wrong with this query or mapping itself.

Val · Accepted Answer · 2016-11-18 10:09:50Z

2

You're almost there, you simply need to move the nested query inside the bool/must query:

{
    'query': {
        'bool': {
            'must': [
              {
                'match_phrase_prefix': {
                    'title': 'A'
                }
              },
              {
                'nested': {
                   'path': 'groups',
                   'query': {
                     'bool': {
                       'must': [{
                          'match': {
                            'groups.value': 'hr'
                          }
                        }]
                     }
                   }
                }
              }
            ]
        }
    }
}

answered Nov 18, 2016 at 10:09

Val

218k14 gold badges377 silver badges384 bronze badges

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

3 Comments

Rajesh Yogeshwar Over a year ago

would I need to update my mapping to get the desired result?

Rajesh Yogeshwar Over a year ago

It worked. Thanks mate!! Answer is accepted but SO is stopping me right now! So will do it when allowed to.

Val Over a year ago

No your mapping is fine, just the query was malformed

Collectives™ on Stack Overflow

Elasticsearch querying nested objects returning no results

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related