change field name of an index in elasticsearch

Question

I want to ask that, how to change field names in elasticsearch index. I mean,

"_source": {
"name_of_field": "lorem"
}

change "name_of_field" to "new_name"

the both answer solves the question but the exact match one by escoder. I'm not able to select both so I ve selected escoder's answer. But i ve upvoted yours. Thanks for answering. — Orkun
– Orkun, Commented Jan 8, 2021 at 6:22

Bhavya · Accepted Answer · 2020-12-31 12:29:32Z

2

As mentioned by @Elasticsearch Ninja you can use the alias, you can also use update by query API

Adding a working example

Index Mapping:

{
  "mappings": {
    "properties": {
      "name": {
        "type": "text"
      }
    }
  }
}

Index Data:

{
    "name":"John"
}

Update by Query API

POST /_update_by_query

{
  "query": { 
    "bool": {
        "must_not": {
            "exists": {
                "field": "title"
            }
        }
    }
  },
  "script" : {
    "inline": "ctx._source.title = ctx._source.name; ctx._source.remove(\"name\");"
  }
}

By the above query name field name will be changed to title

edited Dec 31, 2020 at 12:29

answered Dec 31, 2020 at 12:24

Bhavya

16.2k3 gold badges23 silver badges52 bronze badges

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

2 Comments

Bhavya Over a year ago

@rknd did you get a chance to go through the answer, looking forward to get feedback from you 🙂

Orkun Over a year ago

Thanks for answer. This solves the question

Amit · Accepted Answer · 2020-12-31 12:06:50Z

2

Refer official ES documentation on how to rename a field, you need to use alias for doing it.

From the same docs

Renaming a field would invalidate data already indexed under the old field name. Instead, add an alias field to create an alternate field name.

answered Dec 31, 2020 at 12:06

Amit

32.5k7 gold badges68 silver badges101 bronze badges

Collectives™ on Stack Overflow

change field name of an index in elasticsearch

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related