FAQ
Hi ,

We have hive 0.7 installed from cdh3u1 , and have the hive server running
on port 10000. On Red hat 64 bit OS


Seems like I did every thing OK, but not able to connect, Need help
resolving this issue connecting to Hive Server from Microstrategy, any help
is appreciated !

On our Microstrategy Intelligence server the following file have been
configured.
Placed the 32-bit connector lib files from
https://ccp.cloudera.com/display/con/Cloudera+Connector+for+MicroStrategy+Download

Odbc.ini and odbcinst.ini file is as here :

[Hive-Cloudera-Server]
Driver=/opt/apps/mstr/clouderaconnector/lib/libhiveodbc.so.1
Description=Cloudera Hive ODBC Driver
Host=10.49.xxx.xxx
Port=10000
Database=
FRAMED=0
Trace=Yes
TraceFile=/tmp/odbc.log


[ClouderaHive]
Driver=/opt/apps/mstr/clouderaconnector/lib/libhiveodbc.so.1
Description=Cloudera Hive ODBC Driver
Setup=/opt/apps/mstr/clouderaconnector/lib/libhiveodbc.so.1
APILevel=2
ConnectFunctions=YYY
DriverODBCVer=1.0
FileUsage=0
SQLLevel=1

The error I get when trying to connect is as below:

.connect -d Hive-Cloudera-Server -u hive -p hive;
Connect failed.
Error type: Odbc error. Odbc operation attempted: SQLDriverConnect.
[IM003:0: on HDBC] [DataDirect][ODBC lib] Specified driver could not be
loaded

Did a ldd on this file and below is the output.

ldd libhiveodbc.so.1.0.0
linux-gate.so.1 => (0x006ac000)
libthrift.so.0 => not found
libssl.so.6 => not found
librt.so.1 => /lib/librt.so.1 (0x0038a000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00a8a000)
libiodbcinst.so.2 => not found
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x006b6000)
libc.so.6 => /lib/libc.so.6 (0x00baa000)
/lib/ld-linux.so.2 (0x00b6b000)

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
groupscm-users @
categorieshadoop
postedMay 7, '13 at 11:57p
activeMay 8, '13 at 6:19p
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

ASA: 1 post Vinithra Varadharajan: 1 post

People

Translate

site design / logo © 2022 Grokbase