[unixoDBC] [驱动程序管理器]可以打开lib＆＃x27;/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib' ：未找到文件

Question

我试图让Cloudera Impala ODBC在全新的 M1 Mac 上运行。为此，我通过官方MS文档，还遵循 cloudera odbc连接器安装指南。

但是，当尝试连接时，我会收到以下错误：

[Error: [odbc] Error connecting to the database] {
  odbcErrors: [
    {
      state: '01000',
      code: 0,
      message: "[unixODBC][Driver Manager]Can't open lib '/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib' : file not found"
    }
  ]
}

我的ODBC安装：

myuser@computer ~ % odbcinst -j
unixODBC 2.3.11
DRIVERS............: /opt/homebrew/etc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.ini
FILE DATA SOURCES..: /opt/homebrew/etc/ODBCDataSources
USER DATA SOURCES..: /Users/myuser/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

odbcinst.ini

[ODBC Drivers]
Cloudera ODBC Driver for Impala      = Installed
Cloudera ODBC Driver for Apache Hive = Installed

[Cloudera ODBC Driver for Impala]
Description = Cloudera ODBC Driver for Impala
Driver      = /opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib

[Cloudera ODBC Driver for Apache Hive]
Driver = /opt/cloudera/hiveodbc/lib/universal/libclouderahiveodbc.dylib

odbc.ini

[foobarbinbaz]
Driver=/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib
HOST=***
PORT=433
AuthMech=3
UseSASL=0
UID=****
PWD=****
SSL=1
TransportMode=2
HTTPPath=clicervice
CAIssuedCertNamesMismatch=1
TrustedCerts=/opt/cloudera/impalaodbc/lib/universal/cacerts.pem
TSaslTransportBufSize=1000
RowsFetchedPerBlock=10000
SocketTimeout=0
StringColumnLength=32767
UseNativeQuery=0

我检查了什么：

1. 如果文件/opt>/opt/cloudera/impalaodbc/lib/lib/universal/libclouderaimpalaimpalaimpalaimpalaimpalaompalaodbc.dylib dylib >实际上存在（确实）
2. 在我的odbc.ini 中互换 driver cloudera odbc driver for Impala 和/opt/cloudera/cloudera/impalaodbc/lib/universal/universal/libclouderaimpalaimpalaimpalaimpalaodbc.dylibbc.dylib （在这两种情况下，都将搜索路径）
3. 文件/users/myuser/.odbc.ini 实际上是/users/myuser/myuser/library/odbc/的符号链接odbc.ini （但这不应该是问题，对吗
4. ？ /已知 - 驱动器中的事实？view = sql-server-ver15“ rel =“ noreferrer”>已知问题 Microsoft上的文章（但我找不到我的特定问题）
5. sudo chmod -r a+rw cloudera 在/opt 目录中

Answer 1

截至v2.6.11发行了2021-03-26，apache Hive hive 的 cloudera odbc驱动程序在其通用二进制中不包含ARM64组件。我想对于Impala驾驶员也是如此。

$ file /opt/cloudera/hiveodbc/lib/universal/libclouderahiveodbc.dylib
/opt/cloudera/hiveodbc/lib/universal/libclouderahiveodbc.dylib: Mach-O universal binary with 2 architectures: [i386:Mach-O dynamically linked shared library i386
- Mach-O dynamically linked shared library i386] [x86_64]
/opt/cloudera/hiveodbc/lib/universal/libclouderahiveodbc.dylib (for architecture i386): Mach-O dynamically linked shared library i386
/opt/cloudera/hiveodbc/lib/universal/libclouderahiveodbc.dylib (for architecture x86_64):       Mach-O 64-bit dynamically linked shared library x86_64
$ lipo -archs /opt/cloudera/hiveodbc/lib/universal/libclouderahiveodbc.dylib
i386 x86_64

我的系统：

$ sw_vers 
ProductName:    macOS
ProductVersion: 12.5
BuildVersion:   21G72
$ uname -mprsv
Darwin 21.6.0 Darwin Kernel Version 21.6.0: Sat Jun 18 17:07:22 PDT 2022; root:xnu-8020.140.41~1/RELEASE_ARM64_T6000 arm64 arm

直到Cloudera使用ARM64版本更新驱动程序后，该库才能正常工作。

另请参见。