search

ildus / clickhouse_fdw

ClickHouse FDW for PostgreSQL
Apache License 2.0
254 stars 53 forks source link

could not map type <Bool> #84

Open maxpain opened 2 years ago

maxpain commented 2 years ago

Hello. I'm trying to import schema from clickhouse and getting this error.

IMPORT FOREIGN SCHEMA "fastcup" FROM SERVER clickhouse INTO public;
NOTICE:  clickhouse_fdw: ClickHouse <UInt8> type was translated to <INT2> type for column "round_time", change it to BOOLEAN if needed
NOTICE:  clickhouse_fdw: ClickHouse <UInt8> type was translated to <INT2> type for column "game_mode_id", change it to BOOLEAN if needed

Query 1 ERROR: ERROR:  clickhouse_fdw: could not map type <Bool>
rsurgiewicz commented 12 months ago

I encountered the very same issue