could not map type <Bool>

[maxpain]

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]

I encountered the very same issue

[kolykhalov]

Convert your column in Clickhouse source table\view to UInt8 and tweak your logic to "0/1" processing in postresql (cast to boolean there in new select if you wish). Thus it will import fine.