Elastic search: exact match query on string array

Question

Given this document:

{"name": "Perfect Sunny-Side Up Eggs","ingredientList": ["canola oil","eggs"]}

How can I build a query in elastic search to return exact matches on a string array given query term "oil eggs", so far this it what I have, but it returns other irrelevant documents:

POST /recipes/recipe/_search
{
   "query": {
      "match": {
         "ingredientList": {
            "query": [
               "oil",
               "eggs"
            ],
            "operator": "and"
         }
      }
   }
}

for instance, this document is returned but it doesn't contain "oil". Results should only contain "oil" and "eggs":

{"name": "Quick Baked French Toast","ingredientList": ["butter","cinnamon raisin bread","eggs"]}

You need a bool query with multiple Must clauses: elastic.co/guide/en/elasticsearch/reference/current/… — Ant P
– Ant P, Commented Oct 9, 2016 at 13:28

fylie · Accepted Answer · 2016-10-09 13:48:22Z

5

Your query will look like this:

{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "ingredientList": "oil"
          }
        },
        {
          "term": {
            "ingredientList": "eggs"
          }
        }
      ]
    }
  }
}

Gives me the results:

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 5,
    "successful" : 5,
    "failed" : 0
  },
  "hits" : {
    "total" : 1,
    "max_score" : 1.0,
    "hits" : [ {
      "_index" : "ingredients",
      "_type" : "recipe",
      "_id" : "AVeprXFrNutW6yNguPqp",
      "_score" : 1.0,
      "_source" : {
        "name" : "Perfect Sunny-Side Up Eggs",
        "ingredientList" : [ "canola oil", "eggs" ]
      }
    } ]
  }
}

edited Oct 9, 2016 at 13:48

answered Oct 9, 2016 at 13:39

fylie

1,7251 gold badge12 silver badges14 bronze badges

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

5 Comments

Remsy Schmilinsky Over a year ago

Thank you so much!

tomfl Over a year ago

Hello, I know this was posted a long time ago but I'm trying to do something similar, except in my case it should contain the exact phrase "oil" and not "canola oil". Do you know how to do this ? Thanks.

Vladimir Over a year ago

@tomfl Hi, I'm looking for the same thing, did you resolve it?

tomfl Over a year ago

@Vladimir Hmm if I remember correctly I had to change the analyzer to keyword : elastic.co/guide/en/elasticsearch/reference/current/…

Jason Smiley Over a year ago

to make "oil" not match on "canola oil", then say "term": { "ingredientList.keyword": "oil" }

Tanmay · Accepted Answer · 2020-08-03 05:53:09Z

Elastic dont have API to exact match array. But same can be achieved using two methods:

Using multiple must blocks (not preferred)

Using terms set query and script

 "query": {
   "bool": {
     "must": [
       {
         "terms_set": {
           "ingredientList": {
             "terms": ingredients,
             "minimum_should_match_script": {
               "source": "Math.min(params.num_terms, {})".format(len(ingredients))
             }
           }
         }
       },
       {
         "script": {
           "script": {
             "inline": "doc['ingredientList'].length == params.list_length",
             "lang": "painless",
             "params": {
               "list_length": len(ingredients)
             }
           }
         }
       }
     ]
   }
 }

Collectives™ on Stack Overflow

Elastic search: exact match query on string array

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related