我有~/.odbc.ini
[DEFAULT]
Driver = myconnection
[myconnection]
Description = PostgreSQL connection to my_db
Driver = PostgreSQL Unicode
Database = staging-**-db
Servername = **.**.**.**
UserName = staging-**-user
Password = ******
Port = 5432
Protocol = 11
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ConnSettings =
我正在试着做一本字典
CREATE DICTIONARY psql_temp4
(
id UInt64,
app String,
name String
)
PRIMARY KEY id
SOURCE(ODBC(CONNECTION_STRING 'DSN=myconnection' TABLE 'django_migrations_copy'))
LIFETIME(MIN 300 MAX 360)
LAYOUT(HASHED())
我得到的错误是
ode: 86, e.displayText() = DB::Exception: Received error from remote server /identifier_quote?connection_string=DSN%3Dmyconnection. HTTP status code: 500 Internal Server Error, body: Error getting identifier quote style from ODBC 'Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = Connection attempt failed: Connection:Not applicable
Server:Not applicable
===========================
ODBC Diagnostic record #1:
===========================
SQLSTATE = IM002
Native Error Code = 0
[unixODBC][Driver Manager]Data source name not found, and no default driver specified
操作系统版本cat/etc/os发布NAME="Ubuntu"VERSION="16.04.6 LTS(Xenial Xerus(">
原因可能是什么?
Ch需要驱动的完整路径
/etc/odbc.ini
[mysqlconn]
DRIVER = /usr/local/lib/libmyodbc5w.so
https://clickhouse.yandex/docs/en/operations/table_engines/odbc/