# Datatypes are not updated on Kibana

**URL:** https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065
**Category:** Kibana
**Created:** [July 13, 2017, 5:52pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065 "2017-07-13T17:52:11Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 13, 2017, 5:52pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/1 "2017-07-13T17:52:11Z")

</div>

Hi team,

I am new to Elasticsearch. I am sending the Purelytics data from Dynatrace to ES and can see the data on Kibana. we have observed that **data.startTime** and **data.endTime** of JSON documents are mapped to **Number** data type. We are not able to modify the existing index data types. So, I have created the new index and modified the mappings of **data.startTime** and **endTim** e to Date format, able to see that change in ES but not reflected on Kibana webpage. So could you please suggest what would be the better option to do so.

Thanks  
Shyamala

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [July 13, 2017, 6:39pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/2 "2017-07-13T18:39:45Z")

</div>

Kibana caches field info from your index pattern. You can manually refresh it by clicking the refresh button on the index pattern management page:

 ![](https://us1.discourse-cdn.com/elastic/original/3X/9/e/9ea490da3a9025deceee06ec21150fb5ea7ed7ac.png)

---

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 13, 2017, 7:13pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/3 "2017-07-13T19:13:12Z")

</div>

Thanks for the Response Bargs!!!

even after clicking on refresh button also , having the same issue

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [July 13, 2017, 7:23pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/4 "2017-07-13T19:23:37Z")

</div>

Hmm, so you deleted the old indices with the incorrect mappings and the index pattern is pointing at the new indices with the correct mappings? What version of Kibana and ES are you using?

---

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 13, 2017, 7:25pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/5 "2017-07-13T19:25:41Z")

</div>

I didn't deleted the old version but reindexed the data to new index.I am using 5.4.1 of both Kibana and ES

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [July 13, 2017, 7:30pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/6 "2017-07-13T19:30:27Z")

</div>

Does the existing kibana index pattern match both the old indices and new indices you reindexed into? It sounds like you might need to create a new index pattern that only matches the new indices.

---

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 13, 2017, 7:32pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/7 "2017-07-13T19:32:34Z")

</div>

I have created new index with the same mapping as old one but the difference is i have changed the **data.starttime** and **data.endtime** datatypes to **date**

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [July 13, 2017, 9:50pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/8 "2017-07-13T21:50:02Z")

</div>

Right. Does your index-pattern in Kibana match the names of the old indices, the new indices, or both? If the index-pattern in Kibana still matches the names of the old indices, it's still going to pick up field info from their mappings.

---

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 14, 2017, 3:59pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/9 "2017-07-14T15:59:36Z")

</div>

yes names of the both indices is same... so can i delete the old one ?Here i am directly pulling the data from Dynatrace server

---

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 14, 2017, 4:04pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/10 "2017-07-14T16:04:24Z")

</div>

Bargs,

Is there any way to update the data types while re indexing the data?

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [July 14, 2017, 9:11pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/11 "2017-07-14T21:11:12Z")

</div>

Yes, if you no longer need the old indices it would probably be best to delete them.

> Is there any way to update the data types while re indexing the data?

Generally what you'll want to do is define an [index template](https://www.elastic.co/guide/en/elasticsearch/reference/5.5/indices-templates.html) that will match the new index name. The index template will allow you to define the correct mappings ahead of time.

---

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 17, 2017, 7:56pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/12 "2017-07-17T19:56:54Z")

</div>

Thanks for Reply Bargs!!!!!

I am pulling the data directly from Dynatrace server, backend itself only creating the mapping..  
so how can i edit the edit for this scenario.

Thanks  
Shyamala

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [July 18, 2017, 3:35pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/13 "2017-07-18T15:35:23Z")

</div>

I'm sorry, I don't think I understand your question. Can you elaborate?

---

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 18, 2017, 4:50pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/14 "2017-07-18T16:50:13Z")

</div>

Sure Bargs,

I am taking the data from another server so whenever i am creating the index it automatically creating the mapping backend [itself.So](http://itself.So) i am asking how can i edit such mapping?

Thanks  
Shyamala

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [July 18, 2017, 8:38pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/15 "2017-07-18T20:38:27Z")

</div>

Do your indices follow a naming convention? If you create an index template before the concrete indices are created, it will match new index names based on the pattern you provide and apply its settings to the new index. So for instance if I defined an index template with the pattern `logstash-*` and then created a new index called `logstash-2017-07-18` the template would match and apply its settings to this new index. Templates only apply at index creation time and mappings cannot be edited after index creation, so for existing indices you would need to re-index after creating this index template.

---

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 24, 2017, 2:46am UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/16 "2017-07-24T02:46:49Z")

</div>

HI Bargs,

I have deleted all existing indices and created index template and one new index but the data is mapping to old index.how can i delete that old index permanently.

---

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 24, 2017, 2:47am UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/17 "2017-07-24T02:47:27Z")

</div>

how can i delete index permanently on kibana?

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [July 24, 2017, 1:22pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/18 "2017-07-24T13:22:45Z")

</div>

Deleting the index via the ES API should be sufficient [https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-delete-index.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-delete-index.html)

If the old mappings are still applied to the new indices, perhaps there's an old template still around. You can list all of the existing index templates [https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-templates.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-templates.html)

Finally, if you mean that the old mappings are still showing up in Kibana, you'll either need to refresh the field list or recreate the index pattern in Kibana after you've got the mappings sorted out in Elasticsearch.

---

<div class="post-metadata">

### Author: ![shyamalaponnada](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shyamalaponnada](https://discuss.elastic.co/u/shyamalaponnada)
#### Post date: [July 24, 2017, 7:51pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/19 "2017-07-24T19:51:07Z")

</div>

Thanks Bargs!!!! Issue got resolved and fields are upadated

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 21, 2017, 7:51pm UTC](https://discuss.elastic.co/t/datatypes-are-not-updated-on-kibana/93065/20 "2017-08-21T19:51:22Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
