How to query in elasticsearch?

Question

I am working on elastic search to fetch the record which contain string "bond"

{
  "query": {
    "match": {
      "name": "Bond"
    }
  }
}

but I am getting empty array as a output. Though multiple records are present containing string "bold" , but i am getting empty hits. (hits:[])

How to solve this issue?

I am using same query for another index and its working but for index named as "all_colleges", its not working. Its only returning the record when string is perfect match. i.e. "Bond" == "Bond"

Does this answer your question? elasticsearch query string containing / — KennetsuR
– KennetsuR, Commented Feb 14, 2022 at 9:35
This reference may be helpful for you. Otherwise please show us the mappings of your ES. — KennetsuR
– KennetsuR, Commented Feb 14, 2022 at 9:45
@AdityaSonawane this is possible by allowing some fuzziness, you can check my answer below — Val
– Val, Commented Feb 14, 2022 at 10:23

Val · Accepted Answer · 2022-02-14 10:22:35Z

1

You can try with fuzziness:

{
  "query": {
    "match": {
      "name": {
         "query": "Bond",
         "fuzziness": "AUTO"
      }
    }
  }
}

edited Feb 14, 2022 at 10:22

answered Feb 14, 2022 at 9:56

Val

218k14 gold badges376 silver badges383 bronze badges

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

6 Comments

Aditya Sonawane Over a year ago

its giving following output

{   "took" : 1,   "timed_out" : false,   "_shards" : {     "total" : 1,     "successful" : 1,     "skipped" : 0,     "failed" : 0   },   "hits" : {     "total" : {       "value" : 0,       "relation" : "eq"     },     "max_score" : null,     "hits" : [ ]   } }

Val Over a year ago

Can you share the mapping of the name field?

Aditya Sonawane Over a year ago

i dont have much knowledge, is there any way i can share my screen and you can help me to solve this issue

Aditya Sonawane Over a year ago

{   "properties": {     "country": {       "type": "keyword"     },     "course_global_rank": {       "type": "long"     },     "course_name": {       "type": "keyword"     },     "global_rank": {       "type": "long"     },     "name": {       "type": "keyword"     },     "sub_course": {       "type": "keyword"     },     "sub_course_global_rank": {       "type": "long"     }   } }

Val Over a year ago

Ok, I see the problem, your name field is of type keyword (value is not analyzed), so the match query with fuzziness won't work here. You should change it to text instead

|

Noahfaita · Accepted Answer · 2022-02-14 10:00:34Z

0

Actually there is many parameters you can add to get the results that you want in elastic search. Please check this link https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-match-query.html

You can try this one

{
    "query": {
        "match": {
            "name": {
                "query": "Bond",
                "fuzziness": "AUTO"
             }
         }
     }
}

`

answered Feb 14, 2022 at 10:00

Noahfaita

214 bronze badges

Collectives™ on Stack Overflow

How to query in elasticsearch?

2 Answers 2

6 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Linked

Related