search

ClickHouse / clickhouse-odbc

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

OracleBI Clickhouse connection with odbc driver string datatype problem #389

Open ufukaslan86 opened 2 years ago

ufukaslan86 commented 2 years ago

hi,

we want to connect oracle bi 12c 2.1.4.0 version to clickhouse using odbc driver. We did configurations and connected to clickhouse default db with oracle bi. we fetch data types of numbers and dates but we can't fetch string data types.

clickhouse-odbc-1.1.10-Linux.tar.gz libclickhouseodbc.so

odbc.ini file info

[ClickHouse] Driver=/u01/middleware/bi/modules/oracle.bi.datadirect.odbc/7.1.6/lib/libclickhouseodbc.so

Optional settings:

Description = ClickHouse server = 10.0.157.81 database = default

uid = default

port = 8123

sslmode = require

Timeout=300000

odbcinst.ini file info

[ClickHouse] Driver=/u01/middleware/bi/modules/oracle.bi.datadirect.odbc/7.1.6/lib/libclickhouseodbc.so Setup=/u01/middleware/bi/modules/oracle.bi.datadirect.odbc/7.1.6/lib/libclickhouseodbc.so

Sample Analyses with date and numeric data type columns sampleDateNumber

Sample Analyses with string and numeric data type columns, looks no value it doesn't gives any error. stringDataType

With dbeaver screenshot. stringColumnValues

traceon commented 2 years ago

Could you please enable driver tracing and post traces separately for the scenario with Sample Analyses with string and numeric data type columns and with dbeaver.

ufukaslan86 commented 2 years ago

odbctrace10.zip

this is obi's trace file. dbeaver uses jdbc connection and has no error.

ufukaslan86 commented 2 years ago

do you still want me to attach dbeaver 's trace file.

Enmk commented 1 year ago

Hi @ufukaslan86 ! Were you able to resolve the issue?

ufukaslan86 commented 1 year ago

nope. issue is continue. we found a workaround with using fixedstring datatype. but this is not our answer.