can't search through arrays in elasticsearch

Question

i have these documents in Elasticsearch:

{
    "id_object": "9",
    "size_id": "-1",
    "enabled": 1,
    "verified": 0,
    "countries": [
       "Germany"
    ]
},
{
    "id_object": "19",
    "size_id": "-1",
    "enabled": 1,
    "verified": 0,
    "countries": [
       "Germany",
       "France"
    ]
}

I use the following query to fetch all documents that have "Germany" inside:

GET abc/def/_search
{
  "query": {
    "filtered": {
      "filter": {
    "bool": {
      "must": {
        "term": {
          "countries": "Germany"
        }
      }
    }
  }
}

} }

but it returns no results! what am i doing wrong?

Andrei Stefan · Accepted Answer · 2014-10-27 08:23:19Z

2

"Term" filters are not analyzed, meaning they will match exact terms, without lowercasing, without any other filtering or processing. So, your query will look into the inverted index by exact match "Germany", whereas if you used the standard analyzer when you put those two documents in ES, they would have been recorded as "germany" (lowercase) and as "france" lowercase.

So, in your case your filter will match like this:

{   "query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": {
            "term": {
              "countries": "germany"
            }
          }
        }
      }
    }}}

On the other hand, "match" queries will be analyzed, so, if you're looking for "Germany", this instead will match:

{
  "query": {
    "filtered": {
      "query": {
        "bool": {
          "must": [
            {"match": {
              "countries": "Germany"
            }}
          ]
        }
      }
    }
  }
}

answered Oct 27, 2014 at 8:23

Andrei Stefan

52.5k6 gold badges102 silver badges92 bronze badges

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

2 Comments

TeAmEr Over a year ago

Which one would be faster in processing if i have like 3 million documents ? query or filter?

Andrei Stefan Over a year ago

Filter. If you query for the same terms often, then it would help because filters are cached.

Collectives™ on Stack Overflow

can't search through arrays in elasticsearch

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