Kibana Timestamp Format

[jakelaws]

Hi,

I am currently have NiFi ingesting data into our elastic search environment. We are trying to get elastic to recognize the timestamp format '2017-12-04 18:25:30.114000+00:00' but no matter what we have tried it fails.

I have tried loading it into a new index and seeing if selecting "Index contains time-based events", if it would have it as an option, and it did not.

I also tried pre-formatting the index with things such as:
PUT {index}
{
"mappings": {
"{typeName}": {
"properties": {
"{fieldName}" : {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss.SSSSSSZZ"
}
}
}
}
}

also tried format: strict_date_optional_time

This also did not work and then when trying to import the data into this index I would receive Illegal Argument exception, invalid format.

Please advise on how to get this timestamp format recognized.

Thank you.

[Christian_Dahlqvist]

Timestamps in Elasticsearch are limited to millisecond precision, so I wonder if that could be contributing?

[jakelaws]

I tried changing it to "2017-12-05 15:26:04 UTC" with still no luck. Was not recognized in time based field events drop down.

I tried preformatting with

PUT rest_services
{
"mappings": {
"jmsRunTime": {
"properties": {
"@timestamp" : {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss ZZ"
}
}
}
}
}

With still no luck. Please advise.

[jakelaws]

Any update on this?