- We must create a normalizer in update settings.
- To make elasticsearch read as lowercase, we can use normalizer with update mapping and set normalizer to specify field.
- Close index1POST /{index}/_close
- Update settings, and create new normalizer “keyword_normalizer”123456789101112131415PUT /{index}/_settings{"analysis": {"normalizer": {"keyword_normalizer": {"char_filter": [],"filter": ["asciifolding","lowercase"],"type": "custom"}}}}
- Open index1POST /{index}/_open
- Update mapping to mapping the column to new column, ie. “name” to “name.raw”12345678910111213141516PUT /{index}/{type}/_mapping{"{type}": {"properties": {"name": {"type": "text","fields": {"raw": {"normalizer": "keyword_normalizer","type": "keyword"}}}}}}