Failed to parse date field with query validator

Elastic Stack Elasticsearch
1

Hi there,

I am trying to validate ELasticsearch query for a date field, but it fails raising error as follows

<<
localhost:8020/myindex/_validate/query?explain

{
"query":
{
"term":
{
"docproperties.esindextime": "2015-07-25T18:06:08.000001Z"
}
}

}

<<
{
"valid": false,
"_shards": {
"total": 1,
"successful": 1,
"failed": 0
},
"explanations": [
{
"index": "myindex",
"valid": false,
"error": "[myindex/b0Crwg2bQHq16daNWmFDIg] QueryShardException[failed to create query: {\n "term" : {\n "docproperties.esindextime" : {\n "value" : "2015-07-25T18:06:08.000001Z",\n "boost" : 1.0\n }\n }\n}]; nested: ElasticsearchParseException[failed to parse date field [2015-07-25T18:06:08.000001Z] with format [yyyy-MM-dd'T'HH:mm:ss:SSS'Z']]; nested: IllegalArgumentException[Parse failure at index [19] of [2015-07-25T18:06:08.000001Z]];; ElasticsearchParseException[failed to parse date field [2015-07-25T18:06:08.000001Z] with format [yyyy-MM-dd'T'HH:mm:ss:SSS'Z']]; nested: IllegalArgumentException[Parse failure at index [19] of [2015-07-25T18:06:08.000001Z]];; java.lang.IllegalArgumentException: Parse failure at index [19] of [2015-07-25T18:06:08.000001Z]"
}
]
}

2

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