[FLINK-36271] Support json and jsonb type in PostgreSQL JDBC Dialect

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Connectors / JDBC, Table SQL / JDBC
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Grzegorz Kołakowski
• Created: 12/Sep/24 12:25
• Updated: 06/Nov/24 09:26

Description

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

 

java.lang.UnsupportedOperationException: Doesn't support Postgres type 'jsonb' yet

Json/jsonb field can be returned as VARCHAR when reading the data.

Writing values to json/jsonb column is not allowed in current design.

 

Issue Links

• links to: GitHub Pull Request #141