Hive doesn't support authentication yet. As long as you can read/write HDFS
files, you will be able to run Hive queries.
Thanks,
Ning
On Dec 15, 2009, at 3:57 PM, Kuo, John wrote:
> 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
>
>
>
