AND search in an array of strings Elasticsearch

Question

Let's say I have an array field containing strings in Elasticsearch documents. Let the array in one of the documents be

mArray1: ["string1", "string2", "string3", "string4"]
mArray2: ["string1", "string7", "string11"]

I want a query to search the document which has both "string1" and "string2", i.e. it should return mArray1. Here is what I am using which uses OR filtering.I am also matching for another field which should be compulsory

query: {
    bool: {
      filter: [
        {
          range: {
            "math.score": {
              gte: 80
            }
          }
        },
        {
          multi_match: {
            query: "name1",
            fields: ["name", "full_name"],
            type: "phrase_prefix"
          }
        }
      ],
      must: [
        {
          terms: {
            "arrayField": ["string1", "string2"]
          }
        }
      ]
    }
  }

khachik · Accepted Answer · 2021-10-29 16:48:45Z

0

terms matches any of the values specified, you want to match documents that have both string1 and string2 to, then you need to two term queries in must:

"must" : [
    {
        "term" : {
            "arrayField" : "string1"
        }
    },
    {
        "term" : {
            "arrayField" : "string2"
        }
    }
]

answered Oct 29, 2021 at 16:48

khachik

28.8k10 gold badges63 silver badges98 bronze badges

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

2 Comments

jamshid Over a year ago

But there's no way to specify the order of elements so it matches ["string1", "string2", "string3", "string4"] but not ["string2", "string1", "string3", "string4"] ?

khachik Over a year ago

There is no way to do it in ES, unless you use scripted queries (which come with their own problems like performance/scaling).

Collectives™ on Stack Overflow

AND search in an array of strings 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