In Elasticsearch, why does my query string overmatch?

Question

I'm inserting my data as follows:

PUT my_index2/doc/1
{
  "key": "party",
  "str_val": "THE TWITTER INC"
}

PUT my_index2/doc/2
{
  "key": "party",
  "str_val": "twitter inc"
}

This query:

POST my_index2/_search
{
  "query": {
    "query_string": {
      "default_field": "str_val",
      "query": "*twitter*"
    }
  }
}

correctly returns both results. If I slightly alter my query to:

POST my_index2/_search
{
  "query": {
    "query_string": {
      "default_field": "str_val",
      "query": "*the twitter*"
    }
  }
}

I'm expecting only one result since *the twitter* should only match "THE TWITTER INC" and not "twitter inc". But two results are returned.

Why is my search returning too many matches?

Polynomial Proton · Accepted Answer · 2019-03-04 23:33:25Z

2

That is because the default_operator for query_string is OR. You can always use explain:true to know how the result was returned. Like below:

POST my_index2/_search
{
  "query": {
    "query_string": {
      "default_field": "str_val",
      "query": "*the twitter*"
    }
  },
  "explain": true
}

For your case, you need to explicity mention AND to return only documents where both terms match i.e. the AND twitter

 POST my_index2/_search
    {
      "query": {
        "query_string": {
          "default_field": "str_val",
          "query": "*the twitter*",
           "default_operator": "AND"
        }
      }
    }

answered Mar 4, 2019 at 23:33

Polynomial Proton

5,18023 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

In Elasticsearch, why does my query string overmatch?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related