{ statement=> "select json_agg(json_build_object('a', value1::int)) from my_table" // postgres } I got the following error: Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::OrgLogstash::MissingConverterException: Missing Converter handling for full class name=org.p…

Kit_Tsang (Kit Tsang) January 11, 2019, 9:24am 3

The issue is solved by cast the json result to an string in postgres level and parse the json string in logstash.

4 Likes

Logstash cannot support postgres geometry type

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Missing Converter handling for full class name=org.postgresql.util.PGobject, simple name=PGobject