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 . 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 > [ISQL]ERROR: Could not SQLConnect > > I tried following commands also-- > > export > LD_LIBRARY_PATH=/usr/local/lib/libodbchive.so:/usr/local/lib/libhiveclient.so:/usr/local/lib/libthrift.so > > export LD_PRELOAD=/usr/local/lib/libodbchive.so > > I think i am missing something very important. > > Do i need to copy files in /usr/local/lib/ to /lib ? > > Thanks and Regards > Vaibhav Negi > > > On Wed, Jan 5, 2011 at 3:39 PM, Carl Steinbach <c...@cloudera.com> wrote: > >> 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 >> the unixODBC library before building it. The patch attached to HIVE-1101 >> must >> be applied to the unixODBC-2.2.14 source tree before you build it. This >> patch contains >> the code and Makefile changes that cause unixODBC to build libhiveodbc.so >> >> Thanks. >> >> Carl >>