Elasticsearch match nested field against array of values

Question

I'm trying to apply a terms query on a nested field using mongoid-elasticsearch and ElasticSearch 2.0. This has come to be quite frustrating since the trial-error didn't pay off much and the docs on the subject are rather sparse. Here is my query:

  {
    "query": {
      "nested": {
        "path": "awards",
        "query": {
          "bool": {
            "must": [
              { "match": { "awards.year":  "2010"}}
            ]
          }
        }
      },
      "nested":{
        "path": "procuring_entity",
        "query": {
          "bool": {
            "must": [
              { "terms": { "procuring_entity.country": ["ES", "PL"]}}
            ]
          }
        }
      }
    }
  }

While "match" and "term", work just fine, when combined with the "terms" query it returns no results, even thought it should. My mappings looks like this:

  elasticsearch!({
    prefix_name: false,
    index_name: 'documents',
    index_options: {
      mappings: {
        document: {
          properties: {
            procuring_entity: {
              type: "nested"
            },
            awards: {
              type: "nested"
            }
          }
        }
      }
    },
    wrapper: :load
  })

If "nested" doesn't count as analyzer (which as far as I know doesn't), than there's no problem with that. As for the second example,I don't think it's the case since the array of values that it's matched against comes from exterior. Is terms query possible on nested fields? Am I doing something wrong? Is there any other way to match a nested field against multiple values?

Any thoughts would be much appreciated.

a shot in the dark could you use lowercase in the terms query example :` ["es", "pl"]` since terms query are not analyzed and it is probably that the data for procuring_entity is being analyzed as standard while indexing — keety
– keety, Commented Nov 23, 2015 at 18:53

fabianvf · Accepted Answer · 2015-11-23 20:11:52Z

1

I think you would need to change your mappings for your nested types for this - the terms query only works on not_analyzed fields. If you update your mapping to something like:

elasticsearch!({
    prefix_name: false,
    index_name: 'documents',
    index_options: {
    mappings: {
        document: {
            properties: {
                procuring_entity: {
                    type: 'nested',
                    properties: {
                        country: {
                            'type': 'string',
                            'index': 'not_analyzed'
                        }
                    }
                },
                awards: {
                    type: 'nested'
                }
            }
        }
    }
    },
    wrapper: :load
})

I think the query should work if you do that.

answered Nov 23, 2015 at 20:11

fabianvf

8758 silver badges15 bronze badges

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

2 Comments

Georgiana.b Over a year ago

It worked. So one has to explicitly map a field as not_analyzed or it will otherwise be analyzed. Thank you!

fabianvf Over a year ago

No problem! This behavior can be surprising. Don't forget to select this as the answer, so it shows up resolved for other people.

Collectives™ on Stack Overflow

Elasticsearch match nested field against array of values

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