Re: HIVE ODBC test fails at testing with isql

2011-01-06 Thread Ning Zhang
I guess libodbc.so is the one you renamed from libodbchive.so? If so can you ldd libodbc.so and see what other .so files are linked? You can follow the links and do the ldd check for all necessary .so files (libodbchive.so, libhiveclient.so and libthrift.so). Also please make sure all these .so

Re: HIVE ODBC test fails at testing with isql

2011-01-06 Thread vaibhav negi
Hi, Thanks for the tips carl, but still it doesn't run .. now i will try it on another server some other day. Thanks and Regards Vaibhav Negi On Thu, Jan 6, 2011 at 1:10 PM, Carl Steinbach wrote: > Hi Vaibhav, > > ror output when i run isql hive > > > > [-]SQL_SUCCESS > > [-]hEnv = $

Re: HIVE ODBC test fails at testing with isql

2011-01-05 Thread Carl Steinbach
Hi Vaibhav, ror output when i run isql hive > > [-]SQL_SUCCESS > [-]hEnv = $09BF20A0 phDbc = $0804E2FC > [-]SQL_SUCCESS > [ISQL]ERROR: Could not SQLConnect > Did you remember to start the HiveServer process? Do you have the driver configured to use the right IP address and port numbe

Re: HIVE ODBC test fails at testing with isql

2011-01-05 Thread vaibhav negi
HI Ning , output of ldd isql is :- [r...@vmlinux3 ~]# ldd /usr/local/bin/isql linux-gate.so.1 => (0x00d7a000) libodbc.so.1 => /usr/local/lib/libodbc.so.1 (0x0045c000) libdl.so.2 => /lib/libdl.so.2 (0x00548000) libreadline.so.5 => /usr/lib/libreadline.so.5 (0x005ea

Re: HIVE ODBC test fails at testing with isql

2011-01-05 Thread Ning Zhang
It looks like isql cannot find the dynamically linked libraries. Can you ldd isql and see if all dynamically linked libraries are correct? On Jan 5, 2011, at 5:29 AM, vaibhav negi wrote: > Hi Carl, > > Downloaded the patched version of unixODBC from the given link and > installed successfully

Re: HIVE ODBC test fails at testing with isql

2011-01-05 Thread vaibhav negi
Hi Carl, Downloaded the patched version of unixODBC from the given link and installed successfully . libodbchive.so gets generated in /usr/local/lib . But still the error persists. error output when i run isql hive [-]SQL_SUCCESS [-]hEnv = $09BF20A0 phDbc = $0804E2FC [-]SQL_SUCCESS

Re: HIVE ODBC test fails at testing with isql

2011-01-05 Thread Carl Steinbach
Hi Vaibhav, > i cannot find libodbchive.so in /usr/local/lib . So i defined odbc hive > driver as libodbc.so . Is that the problem? > > libodbc.so is the ODBC DriverManager library provided by unixODBC. You should not rename or symlink this file. I think your problem is that you forgot to patch t

HIVE ODBC test fails at testing with isql

2011-01-04 Thread vaibhav negi
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:1 and specified this information in odbc.ini. odbcinst -j output unixODBC 2.3.0