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 >
