ElasticSearch : IN operator query with query_string

Question

I want to match records against a query string, so I wrote the following query which is working fine:

{
  "query": {
    "query_string": {
      "fields": ["rollno","name"],
        "query": "*John*"
      }
  }
}

Now, apart from matching the fields, I want to implement IN query against another field as well. I tried this query, as:

{
"query": {
    "query_string": {
        "fields": ["rollno", "name"],
        "query": "*John*"
    },
    "match": {
        "majorSubject": ["Biology", "Chemistry"]
    }
  }
}

All I get is search_parse_exception.

How to this IN operation?

Val · Accepted Answer · 2017-07-08 08:50:16Z

2

You need to use a bool/must query in order to combine both sub-queries:

{
  "query": {
    "bool": {
      "must": [
        {
          "query_string": {
            "fields": [
              "rollno",
              "name"
            ],
            "query": "*John*"
          }
        },
        {
          "terms": {
            "majorSubject": [
              "Biology",
              "Chemistry"
            ]
          }
        }
      ]
    }
  }
}

if the majorSubject field is an analyzed string, use lowercase terms instead:

{
  "query": {
    "bool": {
      "must": [
        {
          "query_string": {
            "fields": [
              "rollno",
              "name"
            ],
            "query": "*John*"
          }
        },
        {
          "terms": {
            "majorSubject": [
              "biology",
              "chemistry"
            ]
          }
        }
      ]
    }
  }
}

edited Jul 8, 2017 at 8:50

answered Jul 7, 2017 at 12:35

Val

218k14 gold badges377 silver badges384 bronze badges

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

4 Comments

Shubham A. Over a year ago

When I do this, query doesn't return any results at all, when I actually have matching data. Please see my answer how I solved this. That may have side-affects I do not know right now.

Val Over a year ago

Try with lowercase biology and chemistry

Val Over a year ago

Yes, that's because the majorSubject field is an analyzed string and henced the indexed tokens were lowercased.

Shubham A. Over a year ago

I understand. When I defined my mapping, I should have specified majorSubject as non_analyzed so that only exact values are matched against it as in my case, majorSubject will have some fixed values only. But right now, anatomy will match both Social anatomy and Biological anatomy, definitely a problem. Thanks for the insight !

Collectives™ on Stack Overflow

ElasticSearch : IN operator query with query_string

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related