Srv1.Ftt.Local :) SELECT * FROM odbc('DSN=BigQuery', 'product-analytics.test.ya3') Received exception from server

Question

Srv1.Ftt.Local :) SELECT * FROM odbc('DSN=BigQuery', 'product-analytics.test.ya3') Received exception from server

(version 22.1.3):
Code: 86. DB::Exception: Received from localhost:9000. DB::Exception: Received error from remote server /columns_info?connection_string=......
HTTP status code: 500 Internal Server Error, body: Error getting columns from ODBC 'std::exception. Code: 1001, type: nanodbc::database_error, e.what() = ../contrib/nanodbc/nanodbc/nanodbc.cpp:1046: HY00: [Simba][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function: [Simba][DSI] An error occurred while attempting to retrieve the error message for key 'LibsLoadErr' with message parameters ['""'] and component ID 3: Message not found in file "/opt/SimbaODBCDriverforGoogleBigQuery_2.4.3.1012-Linux/lib/en-US/ODBCMessages.xml" (version 22.1.3.7 (official build))'
. (RECEIVED_ERROR_FROM_REMOTE_IO_SERVER)

#backend #clickhouse #database #devops #programming #russian

0

15.03.2022

6 ответов

39 просмотров

azadevlab Автор вопроса

Роман Болдырев
odbc(connection_settings, external_database, exter...

пробовал и так тоже, всё равно ошибка srv1.ftt.local :) select * from odbc('DSN=BigQuery;databaseName=product-analytics', 'db_tha', 'day_results') Received exception from server (version 22.1.3): Code: 86. DB::Exception: Received from localhost:9000. DB::Exception: Received error from remote server /columns_info?connection_string=DSN%3DBigQuery%3BdatabaseName%3Dproduct-analytics&schema=db_tha&table=day_results&external_table_functions_use_nulls=true. HTTP status code: 500 Internal Server Error, body: Error getting columns from ODBC 'std::exception. Code: 1001, type: nanodbc::database_error, e.what() = ../contrib/nanodbc/nanodbc/nanodbc.cpp:1046: HY00: [Simba][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function: [Simba][DSI] An error occurred while attempting to retrieve the error message for key 'LibsLoadErr' with message parameters ['""'] and component ID 3: Message not found in file "/opt/SimbaODBCDriverforGoogleBigQuery_2.4.3.1012-Linux/lib/en-US/ODBCMessages.xml" (version 22.1.3.7 (official build))' . (RECEIVED_ERROR_FROM_REMOTE_IO_SERVER)

0

15.03.2022

Роман Болдырев

azadevlab
пробовал и так тоже, всё равно ошибка srv1.ftt.lo...

А коннективность вообще проверяли, работает с командной строки ? isql <DSN> <user name> <password>

0

15.03.2022

Slach [altinity]

жалуется на сам ODBC драйвер не могут найти функцию SQLGetPrivateProfileString https://stackoverflow.com/questions/65336260/simba-athena-odbc-unable-to-use-sqlgetprivateprofilestring-functions

0

15.03.2022

azadevlab Автор вопроса

Роман Болдырев
А коннективность вообще проверяли, работает с кома...