Hi, i built Hive odbc driver following http://wiki.apache.org/hadoop/Hive/HiveODBC and wanted to test it with isql, but i get the following error:
[ISQL]ERROR: Could not SQLAllocEnv I set LD_LIBRARY_PATH so libhiveclient.so can be found correctly. I also tried, dltest libodbchive.so SQLAllocEnv which succeeds with dltest libodbchive.so SQLAllocEnv SUCCESS: Loaded libodbchive.so SUCCESS: Found SQLAllocEnv Location of odbc.ini in my system is /usr/local/unixODBC/etc/odbc.ini and its content is [Hive] Driver = /usr/local/unixODBC/lib/libodbchive.so Description = Hive Driver v1 DATABASE = default HOST = localhost PORT = 10000 FRAMED = 0 Ouput of odbcinst -j is unixODBC 2.2.14 DRIVERS............: /usr/local/unixODBC/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/unixODBC/etc/odbc.ini FILE DATA SOURCES..: /usr/local/unixODBC/etc/ODBCDataSources USER DATA SOURCES..: /root/.odbc.ini SQLULEN Size.......: 4 SQLLEN Size........: 4 SQLSETPOSIROW Size.: 2 And output of odbcinst -q -s -n Hive is: [Hive] Driver=/usr/local/unixODBC/lib/libodbchive.so Description=Hive Driver v1 DATABASE=default HOST=localhost PORT=10000 FRAMED=0 Can anybody help me with this error? Thanks in advance Ariel