Thanks so much for your response.
Hive server is running, and I have the following in ODBC.sh:
HIVE_DRIVER_PATH='/usr/local/lib'
mstr_append_path LD_LIBRARY_PATH "${HIVE_DRIVER_PATH:?}"
export LD_LIBRARY_PATH
Is there any special setting for Database Instance? It requires a database
login object, but I don't remember HIVE needing a username/password. What
should I put there?
Thanks again for your help.
John
-----Original Message-----
From: Ning Zhang [mailto:[email protected]]
Sent: Monday, December 14, 2009 6:11 PM
To: [email protected]
Subject: Re: HIVE ODBC and MicroStrategy
Have you started the Hive server on your localhost? Also please make sure
/usr/local/lib is in your LD_LIBRARY_PATH.
Ning
On Dec 14, 2009, at 6:04 PM, Kuo, John wrote:
> Hi,
>
> I'm trying to set up HIVE ODBC driver to work with MicroStrategy 8.1.2 on Red
> Hat Linux Enterprise 64bit. I read that there has been some success in
> getting this combination to work. I wonder if anyone can help me.
>
> I have so far been able to compile the 32-bit version of HIVE ODBC driver as
> required by MicroStrategy. However, when I test it, it gave the error of
> "Unknown failed. Unable to connect. Error type: System call error. Error
> communicating with connection process. Find target process dead while waiting
> for reply."
>
> I'm not sure if there's specific way of setting up the ODBC.ini. Here's my
> entry following the wiki page:
>
> [Hive]
> Driver=/usr/local/lib/libodbchive.so
> Description=Hive Driver v1
> DATABASE=default
> HOST=localhost
> PORT=10000
> FRAMED=0
>
> Thanks in advance.
>
> John
