[jira] [Created] (FLINK-36271) Support json and jsonb type in PostgreSQL JDBC Dialect

["Grzegorz Kołakowski (Jira)" <ji...@apache.org>]

Grzegorz Kołakowski created FLINK-36271:
-------------------------------------------

             Summary: Support json and jsonb type in PostgreSQL JDBC Dialect
                 Key: FLINK-36271
                 URL: https://issues.apache.org/jira/browse/FLINK-36271
             Project: Flink
          Issue Type: Improvement
          Components: Connectors / JDBC, Table SQL / JDBC
            Reporter: Grzegorz Kołakowski


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

 
{noformat}
java.lang.UnsupportedOperationException: Doesn't support Postgres type 'jsonb' yet
{noformat}
Json/jsonb field can be returned as VARCHAR when reading the data.

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

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)