ClickHouse / clickhouse-odbc

ODBC driver for ClickHouse
https://clickhouse.tech
Apache License 2.0
239 stars 84 forks source link

Data parsing issue using odbc driver in Tableau Desktop #395

Closed tarunparmar closed 1 year ago

tarunparmar commented 2 years ago

I build the driver using source on my company mac and was able to connect to Clickhouse after registering the driver with ODBC manager , then I used custom sql to extract data and noticed that some columns dont parse correct. The data look normal in dbeaver (SQL application/developer).

I tested both 1.1.9 and 1.1.10 release to see same outcome.

image
Enmk commented 1 year ago

Hi @tarunparmar ! What is the encoding of the data in clickhouse? What results do you get when you select via clickhouse client?

tarunparmar commented 1 year ago

The tableau server clickhouse driver needed an upgrade.