Elasticsearch datetime problems

I am using the latest Dremo (2.0.1) on Windows.

I am trying to read an index from Elasticsearch. If the date time format/index metadata is defined as follows the Query will fail with the error message (Failed to parse date time value 2017/11/01 00:01:05.908 in field source_data.will_fail_timestamp):

will_fail_timestamp ": { “format”: “Y/M/d H:m:s.SSS”, “type”: “date”},

If the date time of an Elasticsearch index is defined without the format it will succeed as in:

“will_succeed_timestamp”: { “type”: “date”},

Is there a workaround for this problem?

2 Likes