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 <c...@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 >
