Elasticsearch: searching in array

Question

I have the following objects in elasticsearch players index.

GET /players/_search

"hits": [
     {
        "_index": "players",
        "_type": "1",
        "_id": "rRI5A8mVRUKKTA08bK90Vw",
        "_score": 0.2712221,
        "_source": {
           "id": "1",
           "first_name": "Lebron",
           "last_name": "James",
           "numbers": [
              {
                 "number": "23",
                 "team": {
                    "city": "Cliveland",
                    "name": "Cavaliers"
                 }
              },
              {
                 "number": "6",
                 "team": {
                    "city": "Maimi",
                    "name": "Heat"
                 }
              }
           ]
        }
     }
  ]

Now I want to search players who played in "maimi" and had number "23" (there is no such player in this index). I tried

GET /players/_search
{
    "query": { 
        "bool" : {
            "must" : [
                {
                    "term" : {
                        "numbers.number" : "23"
                    }
                },
                {   "term" : {
                        "numbers.team.city" : "maimi" 
                    }
                }
            ]
        }
    }
}

But elasticsearch still found LeBron. How should I do the correct request to elasticsearch?

ThomasC · Accepted Answer · 2014-09-26 07:29:47Z

2

It's because of the structure of your data and how it's indexed : arrays inner objects are flattened internally.

Actually, your document is indexed in ElasticSearch like this :

numbers.number:     [23,6]
numbers.team.city:  [Cliveland,Maimi]
numbers.team.name:  [Cavaliers,Heat]

The association between inner objects are lost though and searching for Cliveland Heat number 6 would match this document too.

You should use a nested object mapping to solve this : the inner objects will be kept as they are.

answered Sep 26, 2014 at 7:29

ThomasC

8,2052 gold badges29 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch: searching in array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related