Elasticsearch: How to query an array field using OR condition?

Question

I have a few ElasticSearch documents, which contain an Array field.

I want to be able to search the whole index
To find the documents which firstly contains the array field,
and if they do, find those documents which contain the value to be searched.

Following is my data -

{
  "took" : 633,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 4,
      "relation" : "eq"
    },
    "max_score" : 1.0,
    "hits" : [
      {
        "_index" : "demo",
        "_type" : "1",
        "_id" : "1",
        "_score" : 1.0,
        "_source" : {
          "name" : "anon",
          "nick_name" : "an",
          "hobbies" : [
            "reading",
            "writing"
          ]
        }
      },
      {
        "_index" : "demo",
        "_type" : "1",
        "_id" : "2",
        "_score" : 1.0,
        "_source" : {
          "name" : "anon2",
          "nick_name" : "an2",
          "hobbies" : [
            "playing",
            "studying"
          ]
        }
      },
      {
        "_index" : "demo",
        "_type" : "1",
        "_id" : "3",
        "_score" : 1.0,
        "_source" : {
          "name" : "anon3",
          "nick_name" : "an3",
          "hobbies" : [
            "playing",
            "writing"
          ]
        }
      },
      {
        "_index" : "demo",
        "_type" : "1",
        "_id" : "4",
        "_score" : 1.0,
        "_source" : {
          "name" : "anon4",
          "nick_name" : "an4"
        }
      }
    ]
  }
}

I want to get those documents whose hobbies array contains "playing" or "studying" value
ie. documents 2 and 3

Following are my data creation queries -

POST /demo/_doc/1
{
  "name":"anon",
  "nick_name":"an",
  "hobbies":["reading","writing"]
}

POST /demo/_doc/2
{
  "name":"anon2",
  "nick_name":"an2",
  "hobbies":["playing","studying"]
}

POST /demo/_doc/3
{
  "name":"anon3",
  "nick_name":"an3",
  "hobbies":["playing","writing"]
}

POST /demo/_doc/4
{
  "name":"anon4",
  "nick_name":"an4"
}

GET demo/_search
{
  "query": {
    "match_all": {}
  }
}

The following query is able to get me single search, but how can I achieve Or condition?

GET demo/_search
{
  "query": {
    "match": {
      "hobbies": "playing"
    }
  }
}

arkuuu · Accepted Answer · 2019-08-08 07:40:49Z

9

I cannot test it right now, but it could be something like this:

GET demo/_search
{
  "query": {
    "bool": {
      "should": [
        {
          "terms": {
            "hobbies": [
              "playing",
              "studying"
            ]
          }
        }
      ]
    }
  }
}

If your hobbies field is of type keyword.

Edit: Following the example in the documentation, it could be even easier:

GET demo/_search
{
    "query" : {
        "terms" : {
            "hobbies" : ["playing", "studying"]
        }
    }
}

edited Aug 8, 2019 at 7:40

answered Aug 8, 2019 at 7:15

arkuuu

6487 silver badges24 bronze badges

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

Comments

Dev1ce · Accepted Answer · 2019-08-08 09:15:47Z

0

I was able to resolve this using the following es query -

GET demo/_search
{
  "query": {
    "bool": {
      "should": [
        {
          "match": {
            "hobbies": "playing"
          }
        },
        {
          "match": {
            "hobbies": "studying"
          }
        }
      ]
    }
  }
}

answered Aug 8, 2019 at 9:15

Dev1ce

5,98425 gold badges100 silver badges161 bronze badges

8 Comments

arkuuu Over a year ago

I wonder if a document with hobby "play" would be matched by this query. If I remember correctly, match queries are analyzed, stemmed etc and not meant to be used for exact keyword matches?

Dev1ce Over a year ago

Yep able to retrieve the correct resultsets of studying and playing hobby types

arkuuu Over a year ago

But would a document with "hobbies": ["play"] be matched by your query? Because I think the input to the match query is analyzed and stemmed. After stemming your query should effectively look for "play" or "study" and thus both documents would be returned.

Dev1ce Over a year ago

Oh yea doesn’t work for “play” case, works for exact text match only I guess?

arkuuu Over a year ago

Just to clarify - do you want documents with "play" to be matched by your query when looking for "playing" - or not?

|

Musab Dogan · Accepted Answer · 2023-04-04 13:46:46Z

0

Here is another method with operator.

GET demo/_search
{
  "query": {
    "match": {
      "hobbies": {
        "query": "studying, playing",
        "operator": "OR"
      }
    }
  }
}

answered Apr 4, 2023 at 13:46

Musab Dogan

3,8811 gold badge9 silver badges18 bronze badges

Collectives™ on Stack Overflow

Elasticsearch: How to query an array field using OR condition?

3 Answers 3

Comments

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related