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 >
