# How to rename field name in Elasticsearch with Time efficient?
**URL:** https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179
**Category:** Elasticsearch
**Created:** [March 9, 2022, 7:31am UTC](https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179 "2022-03-09T07:31:43Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Haridoss\_M](https://discuss.elastic.co/u/Haridoss_M)
#### Post date: [March 9, 2022, 7:31am UTC](https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179/1 "2022-03-09T07:31:43Z")
I have been using the following query to rename fieldName.
```auto
POST http://localhost:9200/INDEX_NAME/_update_by_query
{
"query": {
"exists": {
"field": "NEW_FIELD_NAME"
}
},
"script" : {
"inline": "ctx._source.NEW_FIELD_NAME = ctx._source.OLD_FIELD_NAME; ctx._source.remove(\"OLD_FIELD_NAME\");"
}
}
```
But for more than 42 Lakhs of data. It takes about 2-3 minutes.
Is there any way to reduce timing?....
The Elasticsearch version is _ **5.6.4** _
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [March 9, 2022, 7:47am UTC](https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179/2 "2022-03-09T07:47:26Z")
> [@Haridoss\_M](#):
>
> The Elasticsearch version is _ **5.6.4** _
UPGRADE!
We have release 8.1.0 so you are far behind the supported versions.
With the recent version, you could use field aliases which has an immediate effect but the old field still exists.
If you really want to remove, there is no other way than reindexing.
I'd recommend to do a reindex from remote and reindex your whole data from 5.6 to 8.1 and using an ingest pipeline using the [rename-processor](https://www.elastic.co/guide/en/elasticsearch/reference/8.1/rename-processor.html).
It will take a significant amount of time anyway.
---
### Author:  [@casterQ](https://discuss.elastic.co/u/casterQ)
#### Post date: [March 9, 2022, 10:17am UTC](https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179/3 "2022-03-09T10:17:02Z")
try `slice` and `scroll_size ` params
> **[Update By Query API | Elasticsearch Guide \[8.1\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-update-by-query.html#docs-update-by-query-api-query-params)**
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [March 9, 2022, 10:28am UTC](https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179/4 "2022-03-09T10:28:48Z")
I'm unsure if "slice" was implemented by then. 😉
---
### Author:  [@casterQ](https://discuss.elastic.co/u/casterQ)
#### Post date: [March 9, 2022, 10:39am UTC](https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179/5 "2022-03-09T10:39:13Z")
The doc has `slice`，means it can work?
> **[Update By Query API | Elasticsearch Reference \[5.6\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/5.6/docs-update-by-query.html#docs-update-by-query-api-query-params)**
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [March 9, 2022, 11:04am UTC](https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179/6 "2022-03-09T11:04:05Z")
Ha! Good. I didn't check. This version is so old! 😉
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [March 9, 2022, 9:51pm UTC](https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179/7 "2022-03-09T21:51:49Z")
> [@Haridoss\_M](#):
>
> The Elasticsearch version is _ **5.6.4** _
Yep, 5.X has been [EOL](https://www.elastic.co/support/eol) for years now and is no longer supported.
Please upgrade as a matter of urgency.
---
### Author:  [@Haridoss\_M](https://discuss.elastic.co/u/Haridoss_M)
#### Post date: [March 10, 2022, 12:31pm UTC](https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179/8 "2022-03-10T12:31:21Z")
Thanks for the time. I think upgrading the version will take so much time in my company. So I will keep it in hold for now.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 7, 2022, 12:32pm UTC](https://discuss.elastic.co/t/how-to-rename-field-name-in-elasticsearch-with-time-efficient/299179/9 "2022-04-07T12:32:10Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.