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

**URL:** <https://discuss.elastic.co/t/missing-converter-handling-for-full-class-name-org-postgresql-util-pgobject-simple-name-pgobject/163338>\
**Category:** Logstash\
**Created:** [January 8, 2019, 10:28am UTC](https://discuss.elastic.co/t/missing-converter-handling-for-full-class-name-org-postgresql-util-pgobject-simple-name-pgobject/163338 "2019-01-08T10:28:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kit\_Tsang](https://avatars.discourse-cdn.com/v4/letter/k/e47c2d/32.png) [@Kit\_Tsang](https://discuss.elastic.co/u/Kit_Tsang)\
**Post date:** [January 8, 2019, 10:28am UTC](https://discuss.elastic.co/t/missing-converter-handling-for-full-class-name-org-postgresql-util-pgobject-simple-name-pgobject/163338/1 "2019-01-08T10:28:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [January 8, 2019, 1:37pm UTC](https://discuss.elastic.co/t/missing-converter-handling-for-full-class-name-org-postgresql-util-pgobject-simple-name-pgobject/163338/2 "2019-01-08T13:37:49Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Kit\_Tsang](https://avatars.discourse-cdn.com/v4/letter/k/e47c2d/32.png) [@Kit\_Tsang](https://discuss.elastic.co/u/Kit_Tsang)\
**Post date:** [January 11, 2019, 9:24am UTC](https://discuss.elastic.co/t/missing-converter-handling-for-full-class-name-org-postgresql-util-pgobject-simple-name-pgobject/163338/3 "2019-01-11T09:24:01Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 8, 2019, 9:24am UTC](https://discuss.elastic.co/t/missing-converter-handling-for-full-class-name-org-postgresql-util-pgobject-simple-name-pgobject/163338/4 "2019-02-08T09:24:02Z")

</div>

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