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


(rajesh kumar kalluri) #1

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

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 "}],"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 ","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 ","caused_by":{"type":"illegal_argument_exception","reason":"Parse failure at index [23] of [2018-08-13T14:44:21.253]"}}},"status":400}


(Mark Walkom) #2

Please don't post the same question multiple times, it makes it harder for people to help you.

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


(Mark Walkom) #3