Elasticsearch query not giving exact match
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"
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"
}
}
}
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"}}})))