jdbc-connector-for-apache-kafka
jdbc-connector-for-apache-kafka copied to clipboard
Support arrays in PostgresSQL dialect
Currently, PostgreSQL dialect have no support for arrays. This will be a useful feature to have.
Does this mean we cannot submit an array of JSON so we need to keep sending individual JSON with schema attached?
No you can store you data as JSON. This issue is about ARRAY type in PgSQL (https://www.postgresql.org/docs/11/arrays.html)
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 } ]
Please see my answer in issue #86