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 (0x005ea000)
libncurses.so.5 => /usr/lib/libncurses.so.5 (0x036b1000)
libpthread.so.0 => /lib/libpthread.so.0 (0x0054e000)
libc.so.6 => /lib/libc.so.6 (0x00110000)
/lib/ld-linux.so.2 (0x003b9000)
[r...@vmlinux3 ~]#
Is there any missing library here?
Thanks and regards
Vaibhav Negi
On Thu, Jan 6, 2011 at 12:17 AM, Ning Zhang <nzh...@fb.com> wrote:
> 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
> >>
>
>
