Hello, thanks for reply
the above format didnt work for me.
The sample date format present in database for column updated_date is as shown
2017-12-18 00:00:00.000
Here is the input code,
input {
jdbc {
jdbc_driver_library => "D:/Softwares/logstash-6.4.2/lib/sqljdbc4-2.0.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://:/***"
jdbc_user => "####"
jdbc_password => "###"
statement => "SELECT id, name , updated_date FROM sample"
jdbc_paging_enabled => "true"
jdbc_page_size => "50000"
}
}
output{
elasticsearch { codec => json hosts => ["localhost:9200"] index => "idx_sqldata" }
stdout { codec => rubydebug }
}
Output
Could not index event to Elasticsearch. {:status=>400, :action=>["index", {:_id=>nil, :_index=>"idx_sqldata", :_type=>"_doc", :_routing=>nil}, #LogStash::Event:0x613cc85f], :response=>{"index"=>{"_index"=>"idx_sqldata", "_type"=>"_doc", "_id"=>"bcDpnGcBu0SneeiwZGsB", "status"=>400, "error"=>{"type"=>"mapper_parsing_exception", "reason"=>"failed to parse [updated_date]", "caused_by"=>{"type"=>"illegal_argument_exception", "reason"=>"Invalid format: "2018-11-21T18:30:00.000Z" is malformed at "Z""}}}}}