ElasticSearch multi_match query for array of strings

Question

I need to query 3000 data from ElasticSearch, and currently I am using multi_match for querying. Is there a way to match using an array of strings? Term is not usable as it only queries the exact value of the string.

Below is an example of an ideal request:

{

    "size": 1,
    "_source": ["_id"],
    "query": {
        "multi_match": {
            "query": ["val1", "val2"],
            "fields": [
                "name",
                "url"
            ]
        }
    }
}

EDIT:

Another use case would be like searching schools:

{

    "size": 1,
    "_source": ["_id"],
    "query": {
        "multi_match": {
            "query": ["school name 1", "school name 2"],
            "fields": [
                "name"
            ]
        }
    }
}

Consider the spaces of each values to be the whole school name.

Val · Accepted Answer · 2020-07-28 13:00:44Z

1

multi_match doesn't accept and array of values but nothing prevents you from sending a string containing the values. The query string will be analyzed into two tokens val1 and val2 and each will be matched separately on each field.

{

    "size": 1,
    "_source": ["_id"],
    "query": {
        "multi_match": {
            "query": "val1 val2",
            "fields": [
                "name",
                "url"
            ]
        }
    }
}

answered Jul 28, 2020 at 13:00

Val

218k14 gold badges377 silver badges384 bronze badges

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

13 Comments

illumillukilluallukalluto Over a year ago

Thanks for the response. Is there any way that ElasticSearch has similar query like SQL that can compare the column's value from a list? eg: SQL's =ANY() or IN operator?

Val Over a year ago

That's what the above query does under the hood, you just need to concatenate the array into a space separated string

illumillukilluallukalluto Over a year ago

What if the values have spaces in them? Are there any way to have separators in each values considering most values have two or more words? I'm still new to ElasticSearch

Val Over a year ago

It would help to know your use case, because there are different ways of achieving what you want, but it depends on what you actually need. Feel free to expand on your use case

illumillukilluallukalluto Over a year ago

Just edited my question. My problem is that I need to query school names from ElasticSearch and I think that querying those schools as a form of list of values would be faster and more efficient.

|

Collectives™ on Stack Overflow

ElasticSearch multi_match query for array of strings

1 Answer 1

13 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

13 Comments

Your Answer

Sign up or log in

Post as a guest

Related