Hi All, i set hive odbc wrapper using directions given in http://wiki.apache.org/hadoop/Hive/HiveODBC . When i test it with isql it says
[ISQL]ERROR: Could not SQLConnect i have hive server started on localhost:10000 and specified this information in odbc.ini. odbcinst -j output unixODBC 2.3.0 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /home/hadoop/.odbc.ini SQLULEN Size.......: 4 SQLLEN Size........: 4 SQLSETPOSIROW Size.: 2 files in /usr/local/lib i cannot find libodbchive.so in /usr/local/lib . So i defined odbc hive driver as libodbc.so . Is that the problem? libhiveclient.a libhiveclient.so -> libhiveclient.so.1.0.0 libhiveclient.so.1.0.0 libodbccr.la libodbccr.so -> libodbccr.so.1.0.0 libodbccr.so.1 -> libodbccr.so.1.0.0 libodbccr.so.1.0.0 libodbcinst.la libodbcinst.so -> libodbcinst.so.1.0.0 libodbcinst.so.1 -> libodbcinst.so.1.0.0 libodbcinst.so.1.0.0 libodbc.la libodbc.so -> libodbc.so.1.0.0 libodbc.so.1 -> libodbc.so.1.0.0 libodbc.so.1.0.0 libthrift.a libthrift.jar libthrift.la libthrift.so -> libthrift.so.0.0.0 libthrift.so.0 -> libthrift.so.0.0.0 libthrift.so.0.0.0 libthriftz.a libthriftz.la libthriftz.so -> libthriftz.so.0.0.0 libthriftz.so.0 -> libthriftz.so.0.0.0 libthriftz.so.0.0.0 Thanks Vaibhav Negi