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


(Kit Tsang) #1

{
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.


#2

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) #3

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


(system) closed #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.