hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vaibhav negi <sssssssena...@gmail.com>
Subject Re: HIVE ODBC test fails at testing with isql
Date Thu, 06 Jan 2011 09:52:30 GMT
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 <carl@cloudera.com> wrote:

> 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 number for the HiveServer process?
>
>
> > I tried following commands also--
> >
> > export
> >
> >
> LD_LIBRARY_PATH=/usr/local/lib/libodbchive.so:/usr/local/lib/libhiveclient.so:/usr/local/lib/libthrift.so
> >
>
> LD_LIBRARY_PATH should contain a list of directories, not files, e.g:
>
> export LD_LIBRARY_PATH=/usr/local/lib:$LD_LIBRARY_PATH
>
> export LD_PRELOAD=/usr/local/lib/libodbchive.so
> >
>
> This looks OK, but did you verify that /usr/local/lib/libodbchive.so
> actually exists?
>
>
> > I think i am missing something very important.
> >
> > Do i need to copy files in /usr/local/lib/ to /lib ?
> >
>
> No, don't do this. In fact, when you're experimenting with new software I'd
> recommend that you try to avoid altering the contents of system directories
> like /usr/local, /lib, etc, since this can cause hard to find problems
> weeks
> or months later.
>
> One good way to keep things sane (and what I recommend you try doing now)
> is to create a subdirectory in your home directory (e.g. $HOME/local) and
> install
> all of your test software there. In other words, build unixODBC again, but
> this
> time specify that you want the software installed to $HOME/local by running
> configure with --prefix=$HOME/local
>
> You'll end up with bin, lib and include directories under $HOME/local which
> contain
> the unixODBC driver libs along with the isql executable and various header
> files.
> You will then need to update some of your environment variables as follows:
>
> # Make sure we find isql in ~/local/bin first
> export PATH=~/local/bin:$PATH
>
> # Make sure we use libodbchive.so in ~/local/lib
> export LD_LIBRARY_PATH=~/local/lib:$LD_LIBRARY_PATH
>
> # Load ~/local/lib/libodbchive.so before loading anything else.
> export LD_PRELOAD=~/local/lib/libodbchive.so
>
> Remember that these environment variable settings are specific to the
> task at hand, so you probably don't want to add them to login
> configuration files.
>
> As a final sanity check please use ldd to verify that libodbchive.so
> library
> is
> able to satisfy all of it's dependencies:
>
> % ldd -d -r ~/local/lib/libodbchive.so
>
> Running ldd on isql won't tell you much because isql loads libodbchive.so
> dynamically at runtime using the location of the driver lib specified in
> your
> odbc.ini file.
>
> Hope this helps.
>
> Carl
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message