Frank, I had a similar issue with JSONB data-type in Postgres and ended up extending the existing Postgres connector with capabilities to write more data-types. Feel free to reach out to me in private and I can point you in the right direction and share the code if needed.
On Wed, Feb 22, 2023 at 10:39 AM Martijn Visser <martijnvis...@apache.org> wrote: > Hi Frank, > > There's currently no workaround for this as far as I know. I'm looping in > Timo who at one point wanted to work on > https://issues.apache.org/jira/browse/FLINK-29267 to mitigate this. > > Best regards, > > Martijn > > On Mon, Feb 13, 2023 at 9:16 AM Frank Lyaruu <flya...@gmail.com> wrote: > >> HI Flink community, I'm trying to use a JDBC dataset from Postgres. That >> dataset contains a column of the postgres type UUID. >> I don't know how to 'type' this column in SQL. >> >> If I try: >> CREATE TABLE my_table (id: STRING) WITH (<jdbc stuff>) >> >> I get this error: >> java.lang.ClassCastException: class java.util.UUID cannot be cast to >> class java.lang.String (java.util.UUID) >> >> So it isn't STRING, but it does seem to have recognized the UUID type and >> created a java.util.UUID instance >> I see a merged-and-reverted ticket about this here: >> https://issues.apache.org/jira/browse/FLINK-19869 >> >> It mentions using BinaryRawValueData for now, but can someone help me >> figure out what that would look like in Flink SQL? >> >> regards Frank >> > -- Best Regards, Yuval Itzchakov.
