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)
