Invalid format: "2019-05-16" is too short

Elastic Stack Elasticsearch
1

I use logstash transfer data from mysql to elasticsearch.When logstash output data to elasticsearch,it throw an exception : Invalid format: "2019-05-16" is too short.

image
image.png1045×168 8.66 KB

the column start_date in mysql data type is date.I have another column named complete_time and it's mysql data type is datetime.I've tried set the date format in template/logstash.json but the problem still happens.
image

2

you can add another format like yyyy-MM-dd to the list of formats. You could also just go with strict_date_optional_time||epoch_millis or date_optional_time||epoch_millis in your mapping.

--Alex