[jira] [Created] (FLINK-19869) Support java.util.UUID as RAW type in PostgresCatalog and handle it in PostgresRowConverter

["Jingwei Zhang (Jira)" <ji...@apache.org>]

Jingwei Zhang created FLINK-19869:
-------------------------------------

             Summary: Support java.util.UUID as RAW type in PostgresCatalog and handle it in PostgresRowConverter
                 Key: FLINK-19869
                 URL: https://issues.apache.org/jira/browse/FLINK-19869
             Project: Flink
          Issue Type: Improvement
          Components: Connectors / JDBC
    Affects Versions: 1.11.2
            Reporter: Jingwei Zhang


Problem:
UUID is not a SQL standard type. But it is supported by Postgres as an internal type which postgres client will help to convert to java.util.UUID when queried. However, it seems flink doesn't support it as a sql extension in PostgresCatalog. There is no uuid serializer provided for it, either.  So if I want to filter a result set and put the filter result back to a table with same schema with uuid column type in it. I will have problem. 

Proposal:
Handle UUID in postgres as a SQL extension. Use the DataTypes.RAW to wrap its original class info and its serializer so as to expose it as a RAW JDBCType(only in postgres) in PostgresCatalog.
And meanwhile, for PostgresRowConverter, we could use BinaryRawValueData to handle those SQL extension for byte serialization/deserialization. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)