Hello,
I have a Postgres table with the primary key column "id" of type "uuid".
I created one Flink SINK table, keeping the "id" column of type VARCHAR. and this SINK table refers to the above postgres table.
and creating a job like the one below -
insert into sink_table
select UUID() as id, ........ from....
Now, facing issue as SINK table has id as VARCHAR and postgrs as UUID.
Is there any way to apply cast while loading data
or either I create SINK table using "uuid" type column - not sure if this data type is supported by FLINK.