When i trying to get the Date field from the MSSQL via logstash I am getting the following error :
Caused by: org.jruby.exceptions.NoMethodError: (NoMethodError) undefined method `to_time' for 2016-09-09T17:57:40.873Z:LogStash::Timestamp
at usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.avro_minus_1_dot_9_dot_2.lib.avro.logical_types.encode(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/avro-1.9.2/lib/avro/logical_types.rb:40)
at usr.share
Note : One of the options tried with no luck:
mutate{
convert => {
Sample_date" => "string"
}
}
date{
match => ["Sample_date","YYYY-MM-dd'T'HH:mm:ss'.'SSS'Z'"]
timezone => "Etc/UTC"
target => "Sample_date"
}
I am using Avro codec plugin to validate the schema like :
kafka {
codec => avro {
schema_uri => "/etc/logstash/conf.d/test_schema.avsc"
}
topic_id => "test_dev"
}