Date format in Elastic search mapping template creation


(Suganthi Thangavel) #1

Hi ,

I have time field in my csv to pass to kibana. What is the format that i have to use in elastic search mapping template ting HH:mm:ss.SSS as time field in kibana . I used the below one which i got from Elastic search date formats URL "https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html"

curl -XPUT 10.210.91.108:9200/_template/test2 -d '{
"template": "hmtindex2*",
"settings": {
"number_of_shards": 1,
"number_of_replicas": 0,
"index.refresh_interval": "5s"
},
"sort": {
"elapsed": {
"order": "asc",
"ignore_unmapped": true
}
},
"mappings": {
"logs": {
"properties": {
"Hierarchy_Name": {
"type": "string"
},
"RetrieveTime": {
"format": "HH:mm:ss.SSS",
"type": "date"
},
"cont": {
"type": "integer"
},
"col1": {
"type": "integer"
}
}
}
}
}
}'

But In kibana "RetrieveTime" comes as "string" field help me,


(system) #2