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

Reply via email to