search

ildus / clickhouse_fdw

ClickHouse FDW for PostgreSQL
Apache License 2.0
261 stars 55 forks source link

ERROR: clickhouse_fdw: error while reading row: unsupported type in binary protocol #102

Closed DrivenA closed 1 year ago

DrivenA commented 1 year ago

Hi! After I imported the clickhouse table data into my external table in a postgresql database, I got an error when I tried to query the table: ERROR: clickhouse_fdw: error while reading row: unsupported type in binary protocol. Later I found that the problem was in two columns, latitude and longtitude. They are defined as Decimal(12,8) type in the clickhouse database. How should I solve this problem? I cannot perform any query operations on this column.

DrivenA commented 1 year ago

When I want to query this field, it appears ERROR: clickhouse_fdw: error while reading row: unsupported type in binary protocol

DrivenA commented 1 year ago

I tried changing the protocol used, changing the binary protocol to the default protocol: CREATE SERVER clickhouse_svr2 FOREIGN DATA WRAPPER clickhouse_fdw OPTIONS(dbname '', host '', port *', driver 'http'); No error occurred. But I don't know what problems this would cause.