I'm having this error when I add a Time Filter in Kibana Canvas.
[essql] > Unexpected error from Elasticsearch: [parse_exception] failed to parse date field [2019-06-27T14:55:01.165Z] with format [yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis||yyyy-MM-dd'T'HH:mm:ss.SSSZ||basic_date_time]: [failed to parse date field [2019-06-27T14:55:01.165Z] with format [yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis||yyyy-MM-dd'T'HH:mm:ss.SSSZ||basic_date_time]]
Why 2019-06-27T14:55:01.165Z doesn't match yyyy-MM-dd'T'HH:mm:ss.SSSZ?
which Elasticsearch version are you using? Can you try yyyy-MM-dd'T'HH:mm:ss.SSSX? Note that formats have changed due to the switch to java time away from joda time in Elasticsearch 7.0 and above.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.