CODEWITHSUNDEEP
elasticsearchsearchmatchwildcard
bob dabelina
bob dabelina

Reputation: 537

elasticsearch wild card query not working

I seem to be running into a peculiar issue when I run my query with the match directive as below I get a hit

{
  "query":
        {"match": {
            "value.account.names.lastName" : "*GUILLERMO*"
          }
    }
}

Now when I use the query with the wild card character such as below I don't get a hit.

{
  "query":
        {"wildcard": {
            "value.account.names.lastName" : "*GUILLERMO*"
          }
    }
}

I am really lost as to what the issue maybe. Many thanks in advance for any input

Upvotes: 3

Views: 10097

Answers (1)

briarheart
briarheart

Reputation: 2006

Assuming you are trying to run wildcard query against analyzed field the behavior of Elasticsearch is totally correct. As Elasticsearch documentation states wildcard query operates on the terms level. When you index document with field name that contains string "Guillermo del Toro" value of that field will be lowercased and split into three tokens: "guillermo", "del" and "toro". Then when you run wildcard query *GUILLERMO* against name field Elasticsearch compares query string as it is with every single token trying to find a match. Here you will not get a hit just because of your query string is in uppercase and analyzed token is in lowercase.

Running wildcard queries against analyzed field is probably a bad idea but if it is strongly required I would recommend to use built-in name.keyword field instead of just name field (but again you will face a problem of case sensitivity). Better solution is to create your own lowercased not-analyzed field for that purpose.

Upvotes: 6

Related Questions