hi,
my table geometry, JSONB, i get the below exception.
Exception when executing JDBC query {:exception=>Sequel::DatabaseError, :message=>"Java::OrgLogstash::MissingConverterException: Missing Converter handling for full class name=org.postgresql.util.PGobject, simple name=PGobject", :cause=>"org.logstash.MissingConverterException: Missing Converter handling for full class name=org.postgresql.util.PGobject, simple name=PGobject"}
my conf like :``Preformatted text> `
input {
jdbc {
jdbc_driver_library => "C:\Users\Lenovo\Desktop\ELK\logstash-8.1.0\logstash-core\lib\jars\postgresql-42.4.0.jar"
jdbc_driver_class => "org.postgresql.Driver"
jdbc_connection_string => "jdbc:postgresql://localhost/hb"
jdbc_user => "p"
jdbc_password => "1234"
statement => 'SELECT * FROM "E-ANOMAL"'
}
}
filter {
ruby {
code => "
require 'json'
begin
point_json = JSON.parse(event.get('location'))
data_json = JSON.parse(event.get('additionaldata').to_s || {})
event.set('lon', point_json['coordinates'][0])
event.set('lat', point_json['coordinates'][1])
event.set('data', data_json)
rescue Exception => e
event.tag('invalide boundaries json')
end
"
}
}
output {
elasticsearch {
hosts => ["http://localhost:9200"]
index => "my-index"
user => "ela"
password => "ro"
document_id =>"%{id}"
}
}
please you suggestion