[
https://issues.apache.org/jira/browse/FLINK-13836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16936915#comment-16936915
]
François Lacombe commented on FLINK-13836:
------------------------------------------
Given problem isn't on Flink SQL side but in the JDBCTypeUtil that doesn't
support upstream java.util.UUID objects.
I have to convert them to String in Flink logic and then attempt to write them
in PgSQL which doesn't work.
How Am I supposed to know when to add a surrounding UUID(...) if my field is a
string?
Why JDBCTypeUtil can't handle them?
> Improve support of java.util.UUID for JDBCTypeUtil
> --------------------------------------------------
>
> Key: FLINK-13836
> URL: https://issues.apache.org/jira/browse/FLINK-13836
> Project: Flink
> Issue Type: Improvement
> Components: Connectors / JDBC
> Affects Versions: 1.8.0
> Reporter: François Lacombe
> Priority: Major
>
> Currently, JDBCTypeUtil used by JDBCAppendTableSinkBuilder dones't support
> UUID types with java.util.UUID in Java.
> Could it be possible to handle that as to allow to write UUID directly to
> postgresql please?
>
> java.lang.IllegalArgumentException: Unsupported type:
> GenericType<java.util.UUID>
> at
> org.apache.flink.api.java.io.jdbc.JDBCTypeUtil.typeInformationToSqlType(JDBCTypeUtil.java:91)
> at
> org.apache.flink.api.java.io.jdbc.JDBCAppendTableSinkBuilder.setParameterTypes(JDBCAppendTableSinkBuilder.java:103)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
