Elasticsearch query not giving exact match

Question

Am searching elasticsearch with the below match query, which is not giving me the exact match instead its giving some more irrevalant match also.

am using elasticsearch 6.2.3

Please find my query below

get items/_search
{
   "query" : {
      "match" : {
         "code" : "7000-8900"
      }
   }
}

Please find the response am getting it from match query

7000-8900
7000-8002-WK
7000-8002-W

this is exactly the goal of elasticsearch ^^ search against tokens, keep in mind that your document fields are tokenized into words (tokens), search operation is made against these words (document and query). — Thomas Decaux, Jun 12 '18 at 13:31

Davide Lorenzo MARINO · Accepted Answer · 2018-06-12T13:41:27.103

21

Instead of match you have to use term query, as the documentation describe:

The term query finds documents that contain the exact term specified in the inverted index

So you have to change your query as follow:

get items/_search
{
   "query" : {
      "term" : {
         "code.keyword" : "7000-8900"
      }
   }
}

If you don't get any result there are two possibilities:

The term searched is not what you think it really is (for example is not trimmed)
The index has no explicit mapping and the automatic mapping didn't recognize the field code as a string.

Note: if the mapping is correct and code is a term field it is possible to use "code". If the mapping was automatic and the mapping recognize it as text you need to use "code.keyword"

edited Jun 12 '18 at 13:41

answered Jun 12 '18 at 13:28

Davide Lorenzo MARINO

26,420
4
39
56

4

No results with `term` – Karthikeyan Jun 12 '18 at 13:30
1

Check if there is some space or special char around code – Davide Lorenzo MARINO Jun 12 '18 at 13:31
3

You might need to use `code.keyword` with the `term` query and not just `code` – Val Jun 12 '18 at 13:34
its working properly for other fields like `"name" : "product7265"` – Karthikeyan Jun 12 '18 at 13:35
yes it might be `The index has no explicit mapping and the automatic mapping didn't recognize the field code as a string.` ., what shall i do for this? – Karthikeyan Jun 12 '18 at 13:37
Probably name was mapped as keyword, while code as text – Davide Lorenzo MARINO Jun 12 '18 at 13:37
@Karthikeyan check the updated answer (thx @Val) and use code.keyword not code – Davide Lorenzo MARINO Jun 12 '18 at 13:38
1

Its works., but in some case i need to search like `"code.keyword" : "7000-8002-*"` this is not working. i just want to search anything ( * ) – Karthikeyan Jun 12 '18 at 13:42
This is not a term (exact) search. In this case you need to use a wildcard query https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-wildcard-query.html – Davide Lorenzo MARINO Jun 12 '18 at 13:43
For elastic search 8.4 above query returns exact match only, How can i return results like mentioned in the question – Rahul Kumar Oct 05 '22 at 11:15
The question was asking for exact matching. If you need a like or similar search this is not the question / answer for you @RahulKumar – Davide Lorenzo MARINO Oct 05 '22 at 13:54

score 11 · Answer 2 · answered Dec 14 '19 at 00:09

11

I had the same issue with the match, so I tried to use term. But it is a bad practice. ES says, we should not use term for string matching.

If you specify the field as keyword, the match will do the exact match anyway.

If you haven't defined the field as keyword, you can still do the query like this:

get items/_search
{
   "query" : {
      "match" : {
         "code.keyword" : "7000-8900"
      }
   }
}

answered Dec 14 '19 at 00:09

Sándor Tóth

743
4
10

It worked. I checked my column mapping on which i was applying search. it was "text" and type was "keyword". { "query": { "bool": { "filter": [ { "term": { "node_title.keyword": "5-Verify-Offhours" } } ] } } } – Hassan Raza Jul 28 '20 at 12:21

score 4 · Answer 3 · answered Jul 20 '18 at 06:44

You can try this method.This query return exact match record.

import json
from elasticsearch import Elasticsearch

es = Elasticsearch('http://localhost:9200')
res = es.search(index="test_index", doc_type="test_doc", body=json.dumps({"query": {"match_phrase": {"name": "Jhon"}}})))

score 0 · Answer 4 · answered Oct 24 '22 at 21:34

0

You can also search exact with .raw:
get items/_search
{
   "query" : {
      "match" : {
         "code.raw" : "7000-8900"
      }
   }
}

answered Oct 24 '22 at 21:34

Surya Bhamidipati

13
5

Elasticsearch query not giving exact match

4 Answers4