我试着非常仔细地按照安装指南在mac上为R设置Impala Cloudera ODBC驱动程序,但不断收到以下错误消息:
In odbcDriverConnect("DSN=Impala ODBC Driver") :
[RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver
Manager]Data source name not found, and no default driver specified
这正是我所做的。对于下面引用的每个文件,我都确保该文件存在于该位置。
从下载并安装Impala ODBC驱动程序http://www.cloudera.com/content/cloudera/en/downloads/connectors/impala/odbc/impala-odbc-v2-5-23.html
brew install unixodbc
odbcinst -j
unixODBC 2.3.2
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /Users/summerrae/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
指向DYLD库路径变量:
export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:/opt/cloudera/impalaodbc/lib/universal
echo "export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:/opt/cloudera/impalaodbc/lib/universal/" >> ~/.bashrc
编辑/usr/local/etc/odbc.ini:
[ODBC Data Sources]
# Use this name in your connection string
Impala DSN=Impala ODBC Driver
[Impala DSN]
# Driver: The location where the ODBC driver is installed to.
Driver=/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib
# Values for HOST, PORT, Database
HOST=myhost (changed name here for security)
PORT=21050
Database=default
Edited /user/local/etc/odbcinst.ini:
[ODBC Drivers]
Impala ODBC Driver=Installed
[Impala ODBC Driver]
Description=Impala ODBC Driver
Driver=/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib
编辑/opt/cloudera/inpaaodbc/lib/universal/cloudera.impaaodbc.ini:
[Driver]
## - Note that this default DriverManagerEncoding of UTF-15
## is for unixODBC.
DriverManagerEncoding=UTF-16
ErrorMessagesPath=/opt/cloudera/impalaodbc/ErrorMessages/
LogLevel=0
LogPath=
## - Note that the path to your ODBC Driver Manager
## must be specified in DYLD_LIBRARY_PATH.
# unixODBC
ODBCInstLib=libiodbcinst.dylib
已将路径变量导出到~/.bashrc:
#add full path to odbc.ini and add to bashrc
export ODBCINI=/usr/local/etc/odbc.ini
echo "export ODBCINI=/etc/odbc.ini" >> ~/.bashrc
#add directory path to odbcinst.ini and add to bashrc
export ODBCSYSINI=/usr/local/etc/
echo "export ODBCSYSINI=/etc/odbcinst.ini" >> ~/.bashrc
#add full path to cloudera.impalaodbc.ini and add to bashrc
export CLOUDERAIMPALAINI=/opt/cloudera/impalaodbc/lib/universal/cloudera.impalaodbc.ini
echo "export CLOUDERAIMPALAINI=/opt/cloudera/impalaodbc/lib/universal/cloudera.impalaodbc.ini" >> ~/.bashrc
在R:
install.packages("RODBC")
library(RODBC)
#connect using impala DSN
conn <- odbcConnect("Impala DSN")
我已经完成了我能找到的每一个教程,以使它发挥作用。我能够使用Python连接到相同的服务器和参数,我能够使用RImpala连接到相同服务器,但无法获得RImpala包来运行查询,所以我知道连接是有效的。非常感谢您的帮助。谢谢
这是yosemite默认的iODBC驱动程序的问题。我最终重新安装了macos,一切都很好。
作为一种替代方案,我还发现你可以:
安装mac ODBC管理器
- 从下载文件http://www.odbcmanager.net/
- 安装后,从应用程序/实用程序打开程序
- 单击"驱动程序",然后单击"添加"
- 浏览到黑斑羚驱动程序,默认位置为:/opt/cloudera/inplaaodbc/lib/universal/libclouderaimpalaodbc.dylib
- 添加系统DSN
- 添加DSN名称,然后单击"添加"
-
添加以下两个键值对:
主机名称
端口21050
-
点击"确定"
使用您在上面创建的DSN名称与ROBC连接。
您的问题是驱动程序安装指向/usr/local/etc文件夹中的文件进行配置,而您正试图修改驱动程序附带的文件。我也遇到了同样的问题,我只是在/usr/local/etc中配置了.ini文件,可以少连接DNS。