Kafka Connect JDBC Array Type

[Alex Good <Al...@makerlabs.co.uk>]

Hey All,

I'm using the JDBC sink to materialise a kafka topic in a postgres table.
The records in the topic are avro messages. I'm running into this problem
because one of the fields in the messages is an array:

org.apache.kafka.connect.errors.ConnectException: null (ARRAY) type doesn't
have a mapping to the SQL database column type

Now, that makes sense to me. I'm wondering if there is anyway to get this
data into the database with the built in JDBC connector or otherwise. I
have no problem with it just being a string representation of the array,
although I would prefer if I could use postgres native JSON or ARRAY
types. Anyone had any experience with this? The only real constraint is I
want to use upsert semantics, or at least, some method which doesn't result
in duplicates in the table.

Thanks
Alex