Elasticsearch

Elasticsearch 6 make text sortable and incasesensitive lowercase

28 February 2019

views

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 index
POST /{index}/_close
1
POST /{index}/_close

Update settings, and create new normalizer “keyword_normalizer”

PUT /{index}/_settings
{
  "analysis": {
    "normalizer": {
      "keyword_normalizer": {
        "char_filter": [],
        "filter": [
          "asciifolding",
          "lowercase"
        ],
        "type": "custom"
      }
    }
  }
}

PUT /{index}/_settings

{

"analysis": {

"normalizer": {

"keyword_normalizer": {

"char_filter": [],

"filter": [

"asciifolding",

"lowercase"

"type": "custom"

}

Open index
POST /{index}/_open
1
POST /{index}/_open

Update mapping to mapping the column to new column, ie. “name” to “name.raw”

PUT /{index}/{type}/_mapping
{
  "{type}": {
    "properties": {
      "name": {
        "type": "text",
        "fields": {
          "raw": {
            "normalizer": "keyword_normalizer",
            "type": "keyword"
          }
        }
      }
    }
  }
}