flink-connector-jdbc icon indicating copy to clipboard operation
flink-connector-jdbc copied to clipboard

Published 20 hours ago • verified publisher icon apache

[FLINK-36271] Support reading json and jsonb types in PostgreSQL dialect

Open grzegorz8 opened this issue 5 months ago • 3 comments

When using PostgreSQL JDBC Catalog an error is thrown if any of the tables has column of type json or jsonb.

java.lang.UnsupportedOperationException: Doesn't support Postgres type 'jsonb' yet
  • json / jsonb field is returned as VARCHAR when reading the data.
  • Writing values (insert into ...) to json / jsonb column is not allowed in current design.

grzegorz8 avatar Sep 12 '24 12:09 grzegorz8