Dateparsefailure on logstash

Elastic Stack Logstash
1

I am pulling data from sql and I have date field

I am still getting this error on output. and can't figure out where this is coming from.

                     "tags" => [
    [0] "_dateparsefailure"
],

I try without any filter and it shows up like this
"installdate0" => 2019-04-11T14:57:59.000Z

How do I parse this one? as it has T in middle.

This is what I have try so far for testing and it give me same error

echo "2019-04-11T14:57:59.000Z" | /usr/share/logstash/bin/logstash -e 'input { stdin {} } filter { date { match => [ "message", "yyyy-MM-dd HH:mm:ss.SSSZ"] } }'

I also try this but it does not even print anything it just error outs on java

echo "2019-04-11T14:57:59.000Z" | /usr/share/logstash/bin/logstash -e 'input { stdin {} } filter { date { match => [ "message", "yyyy-MM-ddTHH:mm:ss.SSSZ"] } }'

Looks like I am not parsing this T in middle?

2

If that is the output of a rubydebug codec then you will not be able to parse it using a date filter, nor do you need to. There are no quotes around 2019-04-11T14:57:59.000Z, so it is not a string, it is already a LogStash::Timestamp. The jdbc input can automatically parse date columns into dates, so that you do not need to use a date filter.

3

perfect. I just dump that in index and created template to confirm and it is date field.