Elasticsearch exact search query-CodePudding

I'm using query string to search on documents in my index.

GET my_index/_search
{
  "query": {
    "bool": {
      "must": [{
        "query_string": {
          "query": "table test",
          "default_field": "table.name",
          "default_operator":"AND"
        }
      }]
    }
  }
}

the problem is that it returns all additional strings that include search keywords.. I wanna to give strings that have exact phrase. for example the documents table test 1 and table test 12 and table test are in my index. when I search table test, I wanna it just return table test.

how can I handle this?

CodePudding user response：

You can use the match phrase query for your use-case.

CodePudding user response：

You can use Match Phrase Query as Amit suggested in another answer.

Also, if you want to use only Query String type of query then you can give your query in double quotes as shown below:

GET my_index/_search
{
  "query": {
    "bool": {
      "must": [{
        "query_string": {
          "query": "\"table test\"",
          "default_field": "table.name",
          "default_operator":"AND"
        }
      }]
    }
  }
}

Updated:

if you want to do exact match in entire field then you can go ahead with term query in elasticsearch:

{
  "query": {
    "term": {
      "table.name": {
        "value": "table test",
        "boost": 1.0
      }
    }
  }
}