How to update the default datatype of the field from text to date?

Elastic Stack Elasticsearch
1

I am using AWS IoT CORE and transferring the data to Elastics search service. Then i am creating the Index pattern in the Kibana.
My IoT device gives the date in standard UTC format "2018-07-01 01:01:01:44567" OR "YYYY-MM-DD HH:mm:ss:SSS"

field : "event_ts7" by default is loaded as string. Can you please help me with updating the default data type to date from string ?? I Need the field to be date.

Elastic Search image :

26%20AM
Screen Shot 2018-07-11 at 10.54.26 AM.png1344×1186 56 KB

Kibana Index pattern image :

41%20AM
Screen Shot 2018-07-11 at 10.53.41 AM.png2416×1246 256 KB

02%20AM
Screen Shot 2018-07-11 at 10.54.02 AM.png2514×1494 329 KB

Also I can see duplicate fields in the index patter with the .Keyword .
How to remove the .keyword field.

00%20AM
Screen Shot 2018-07-11 at 11.06.00 AM.png2064×1090 159 KB

2

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