jdbc-connector-for-apache-kafka icon indicating copy to clipboard operation
jdbc-connector-for-apache-kafka copied to clipboard

Support arrays in PostgresSQL dialect

Open ivanyu opened this issue 4 years ago • 4 comments

Currently, PostgreSQL dialect have no support for arrays. This will be a useful feature to have.

ivanyu avatar May 14 '20 08:05 ivanyu

Does this mean we cannot submit an array of JSON so we need to keep sending individual JSON with schema attached?

ttrading avatar Apr 01 '21 13:04 ttrading

No you can store you data as JSON. This issue is about ARRAY type in PgSQL (https://www.postgresql.org/docs/11/arrays.html)

willyborankin avatar Apr 01 '21 18:04 willyborankin

what should my schema look like then if i want to insert an array in this form:

[ { "text": "Hello1", "sent_at": 1560507792000.001 }, { "text": "Hello2", "sent_at": 1560507794000.001 } ]

ttrading avatar Apr 05 '21 13:04 ttrading

Please see my answer in issue #86

willyborankin avatar Apr 13 '21 09:04 willyborankin