Re: Flink SQL JDBC connector for Postgres can't handle UUID datatype

2022-06-13 Thread Martijn Visser
Hi Aaron, There's currently no support in Flink indeed to insert an UUID data type into Postgres. The Jira ticket you've included [1] is indeed the same issue. It's just that the solution is most likely not to map it as a RAW type, but use a STRING type instead. Is this something where you might w

Flink SQL JDBC connector for Postgres can't handle UUID datatype

2022-06-09 Thread Aaron Weiss
Hey there, We have just started to use the Flink SQL JDBC connector to do some writes to Postgres. Our Postgres table has a UUID column we need to write to through Flink SQL. However, it doesn't appear that the connector supports that type in any way. UUID isn't listed in the Postgres datatypes