-
Notifications
You must be signed in to change notification settings - Fork 6.6k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
CH to Teradata via ODBC #64041
Comments
Are you able to use this ODBC driver with the |
From my experience, it make sense to test jdbc bridge as well, it tends to have less strange compatibility problems than odbc. |
@alexey-milovidov I've just tested isql is running ok with my version of odbc driver and server has connected to teradata, select is working okay. But nobody uses isql like a basic client to work with teradata @UnamedRus we have jdbc bridge as well. It's working like a charm with teradata and there were no pain with its deployement. But officially jdbc bridge is archived now in GitHub and it is depreciated AFAIK |
For latest 3+? years it was maintained by community member and right, latest release by him was made 2 years back. BTW, i didn't checked by myself but this community member have some project which works kinda jdbc bridge but via url function |
@virtualb0x can you please share the output of |
LD_PRELOAD is empty. I've read CH is ignoring it? #32457 (comment) @UnamedRus Agree with you about support. May be I will be lucky enough to explain it to users. We are at the start of CH usage. I'll take a look at project you mentioned, thank you |
@den-crane already saw it and tried to. But still no luck :( |
try |
@den-crane It did not make sense:
I've also checked connction with teradata tool:
So I suppose the server is ok with its connection to teradata. The problem is only if I am trying to do it through bridge |
@virtualb0x share:
|
@den-crane
|
@virtualb0x it looks like environments are different for a user and clickhouse-service. For example
|
@den-crane Thank you
in /etc/default/clickhouse and restarting of server did the trick. It works now |
Describe the unexpected behaviour
We've got a teradata installation where we've created a one-column table, consists of numbers only
DDL is:
I also installed teradata odbc driver on linux machine where CH Is running and configured it
The isql -v is running:
I've connected to CH via clickhouse_client and wanted to get data from this table via odbc:
Сreating table:
Getting result:
But then I receive an error:
Wanted to see data
clickhouse-odbc-brigde
Expected behavior
Wanted to see data
Error message and/or stacktrace
MEssage in server/brigde log:
Additional context
Will be appreciate for any help or ideas. More than a week I can't force it
The text was updated successfully, but these errors were encountered: