Postgresql push uuid field to Clickhouse data type error

[kolykhalov]

I am trying to push data from PG-12 to Clickhouse and it gives me error:

SQL Error [HV004]: ERROR: cannot convert constant value to clickhouse value Hint: Constant value data type: 2950

Sherlocking gave me error in uuid, excepting this field passes on to data transfer. If I cast it to text it gives error, that target field is uuid not text. I am confused. Which data type casting is appropriate here or maybe what am I doing wrong here? Please advise. Thanks beforehands.

[kolykhalov]

As a temporary solution I converted target uuid column to text, and cast uuid to to text in PG on insert, now everything works but it is not the required solution. I would prefer to stick to native uuid rather than text.

[ildus]

I will need some workflow to reproduce, could you provide sql script and table definitions?