Postgresql push uuid field to Clickhouse data type error

Asked Jan 13 '21 at 19:47

Active Jan 13 '21 at 19:47

Viewed 295 times

I am trying to push data from PG-12 to Clickhouse via FDW extension ("clickhouse_fdw") 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? Please advise DB gurus :) Thanks beforehands.

asked Jan 13 '21 at 19:47

Ivan Kolyhalov

open an FR against https://github.com/adjust/clickhouse_fdw/issues – Denny Crane Jan 13 '21 at 20:05
I did, but these guys never hurry. Had to solve it temporarily via modifying uuid to text in target table. Everything works, but it's not what is required. – Ivan Kolyhalov Jan 14 '21 at 22:00
1

then probably you can use Null table + MV – Denny Crane Jan 15 '21 at 01:19
Please elaborate, what is "Null table +MV"? – Ivan Kolyhalov Jan 15 '21 at 11:49
1

https://gist.github.com/den-crane/739a51afc304910bb3d81fe6751701ff – Denny Crane Jan 15 '21 at 14:16
thanks got it, but it's a lot of hassle creating views for the task. Still both ways are not the solution unfortunately, hoping to hearing from clickhouse_fdw soon... – Ivan Kolyhalov Jan 15 '21 at 18:31

Postgresql push uuid field to Clickhouse data type error

0 Answers0