No date field named timestamp found

Grafana Elasticsearch
1

trying to create a new elasticsearch datasource produces the following error “No date field named timestamp found”

The data was created using the following format;

‘{ “user”:“user.1”, “timestamp”: 337712739, “type”: “date”, “format”: “epoch_second” }’

And the mapping produces the following…

{
“monitor” : {
“mappings” : {
“rbt” : {
“properties” : {
“format” : {
“type” : “text”,
“fields” : {
“keyword” : {
“type” : “keyword”,
“ignore_above” : 256
}
}
},
“timestamp” : {
“type” : “long”
},
“type” : {
“type” : “text”,
“fields” : {
“keyword” : {
“type” : “keyword”,
“ignore_above” : 256
}
}
},
“user” : {
“type” : “text”,
“fields” : {
“keyword” : {
“type” : “keyword”,
“ignore_above” : 256
}
}
}
}
}
}
}
}

Any ideas?

Thanks

2

Create elasticsearch index date mapping field like and date format should be like

"properties" : { "serverDate": { "type": "date"   , "index" : "true"  , "format": "strict_date_optional_time||epoch_millis" }}

Date format should be ’ 2018-06-21T09:44:17Z’ (‘Y-m-d\TH:i:s\Z’)