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

[Kit_Tsang]

{
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.postgresql.util.PGobject, simple name=PGobject>

The psql return a json type field. But it seems like the data type is not support in logstash. My question is how to store the json value into elasticsearch via logstash and what kind of data type logstash are suppored.

[Badger]

If your SQL is returning a type that logstash does not understand then I believe the fix is to add a CAST or CONVERT to the SQL.

[Kit_Tsang]

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