Kibana : Discover: failed to parse date field [2018-08-13T14:44:21.253] with format Invalid date

I am getting an exception trying to filter on a date_time field in Kibana.

Discover: failed to parse date field [2018-08-13T14:44:21.253] with format Invalid date

ModificationTimestamp has the following timestamp:

"ModificationTimestamp": {
"type": "date",
"format": "date_time"
}

Error: Request to Elasticsearch failed: {"error":{"root_cause":[{"type":"parse_exception","reason":"failed to parse date field [2018-08-13T14:44:21.253] with format Invalid date"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"els_08_18_2018_01","node":"6wx5q3j9TTycZ2lDk5hTlQ","reason":{"type":"query_shard_exception","reason":"failed to create query: {\n "bool" : {\n "must" : [\n {\n "match_phrase" : {\n "ModificationTimestamp" : {\n "query" : "2018-08-13T14:44:21.253",\n "slop" : 0,\n "zero_terms_query" : "NONE",\n "boost" : 1.0\n }\n }\n }\n ],\n "filter" : [\n {\n "match_all" : {\n "boost" : 1.0\n }\n }\n ],\n "adjust_pure_negative" : true,\n "boost" : 1.0\n }\n}","index_uuid":"Bs0TW6S2RkWdoyYKKXTPMA","index":"elastic_08_18_2018_01","caused_by":{"type":"parse_exception","reason":"failed to parse date field [2018-08-13T14:44:21.253] with format Invalid date","caused_by":{"type":"illegal_argument_exception","reason":"Parse failure at index [23] of [2018-08-13T14:44:21.253]"}}}}],"caused_by":{"type":"parse_exception","reason":"failed to parse date field [2018-08-13T14:44:21.253] with format Invalid date","caused_by":{"type":"illegal_argument_exception","reason":"Parse failure at index [23] of [2018-08-13T14:44:21.253]"}}},"status":400}

Sounds like your date isn't being mapped correctly. You should take a look at http://localhost:9200/_mapping and ensure your field is being correctly mapped to a date type with the correct format.

Cheers
Rashmi

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