Unable to match alphanumeric string with wildcard inside query_string in ElasticSearch

Question

I'm using the following mapping:

"letters": {
    "mappings": {
       "letter": {
          "properties": {
            "destCode": {
               "type": "string",
               "index": "not_analyzed"
            },
            "tag": {
               "type": "string",
               "index": "not_analyzed"
            }
         }
      }
   }
}

My docs contains two fields:

tag: mostly alphanumeric and may contain some '/' or '@'chars
destCode: 99% a numeric string

The following query_String (i know wildcards are bad):

"query": {
    "query_string": {
        "default_field": "destCode",
        "query": "*604"
    }   
}

correctly matches 0144604, 4521604 destCode values.

But it doesn't work for tag field, for ex the query:

"query": {
    "query_string": {
        "default_field": "tag",
        "query": "CDG*" 
    }   
}

does not match values: CDG711892, CDG88978 and i also tried lowercase cdg* without success.

@mfundi Can you provide us with some sample documents?

Yeikel
– Yeikel

2016-12-26 22:14:36 +00:00
Commented Dec 26, 2016 at 22:14 — Yeikel
– Yeikel, Commented Dec 26, 2016 at 22:14

Lax · Accepted Answer · 2016-12-26 18:20:29Z

1

In the mapping you set the field as not analyzed, because of that when you index data, elasticsearch don't analyzed it,because of that if you index data as lowercase you will not hit nothing if you search uppercase. Remove

index": "not_analyzed

And it will work

answered Dec 26, 2016 at 18:20

Lax

1,1671 gold badge8 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Unable to match alphanumeric string with wildcard inside query_string in ElasticSearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related