Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Elasticsearch field name aliasing

Is it possible to setup alias for field names in elasticsearch? (Just like how index names can be aliased)

For example: i have a document {'firstname': 'John', 'lastname': 'smith'}

I would like to alias 'firstname' to 'fn'...

like image 370
user3658423 Avatar asked Feb 13 '15 10:02

user3658423


2 Answers

Just a quick update, Elasticsearch 6.4 came up with feature called Alias Datatype. Check the below mapping and query as sample.

Note that the type of the field is alias in the below mapping for fieldname fn

Sample Mapping:

PUT myindex
{
  "mappings": {
    "_doc": {
      "properties": {
        "firstname": {
          "type": "text"
        },
        "fn": {
          "type": "alias",
          "path": "firstname" 
        }
      }
    }
  }
}

Sample Query:

GET myindex/_search
{
  "query": {
    "match" : {
      "fn" : "Steve"
    }
  }
}

The idea is to use the alias for actual field on which inverted index is created. Note that fields with alias datatype aren't meant for write operations and its only meant for querying purpose.

Although you can refer to the link I've mentioned for more details, below are just some of the important points.

  • Field alias is only meant to be used when your index has a single mapping. Index has to be created post 6.xx version or be created in older version with the setting index.mapping.single_type: true
  • Can be used in querying, aggregations, sorting, highlighting and suggestion operations
  • Target field must be actual field on which inverted index is created
  • Cannot create alias of another alias field
  • Cannot use alias on multiple fields. Single alias, Single field.
  • Cannot be used as part of source filtering using _source.
like image 68
Kamal Avatar answered Sep 23 '22 23:09

Kamal


There is no direct field alias functionality. However, you could rename the fields upon indexing using the index_name property in your mappings.

index_name : The name of the field that will be stored in the index. Defaults to the property/field name.

See here for more information: http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-core-types.html

like image 28
Manolis Avatar answered Sep 21 '22 23:09

Manolis