Elasticsearch searching exact value of field with case insensitive

Question

How can I search in elasticsearch field by its exact value but with case insensitive query? For example I have field with value { "Type": "Płatność kartą" }, and my query will search by value "płatność kartą". I need to be able to search by list of string parameters (i.e. "płatność kartą", "płatność gotówką", etc.). I tried elastic TERMS query but it didn't return value when sensitive case difference appears. Field index is set to not_analyzed.

Russ Cam · Accepted Answer · 2017-03-13 22:07:23Z

3

If you choose not analyzed when indexing, Elastic is not analyzing these terms at index time and that means they are stored verbatim. So when you are querying, you get no results as the query terms don't match the stored fields.

In order to be able to query with lowercase and get the uppercase results, too, you need to use an analyzer on your mapping. Here are the available options from the docs.

If none the available analyzers fit you, you can define your custom one, by specifying the filters you want to be applied. For example, using just the lowercase filter, Elastic will index the RegisteredPaymentType field just lowercased. Then, while querying, the same analyzer will be applied to the query and you will get the expecting results.

edited Mar 13, 2017 at 22:07

Russ Cam

126k34 gold badges211 silver badges275 bronze badges

answered Mar 13, 2017 at 18:03

christinabo

1,1302 gold badges13 silver badges20 bronze badges

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

3 Comments

Mateusz Over a year ago

I have changed analyzer to simple and now I hava mapping {"Type":{"type":"string","analyzer":"simple"}}, but when I try to search using terms for text "platność w drodze" I didn't get results. When I search for only one word, for example "platność", I get many result as expected. What I'm doing wrong?

christinabo Over a year ago

Have you re-indexed the data after changing the mapping? In addition to that, do you consider for example "l" and "ł" the same character? Simple analyzer probably does not handle this difference. Asciifolding filter does.

Filip Cordas Over a year ago

If use simple analyzer it uses a tokenizer (It will create terms by splitting for empty space so you will get tree terms "platność", "w", "drodze") and when you ask for the term you get the one you need. With simple field I thing will work match_phrase but you need to learn more on analyzsis api if you want to use.

Collectives™ on Stack Overflow

Elasticsearch searching exact value of field with case insensitive

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related