Hello Friends,
Recently I was trying to integrate Hive with OBIEE. I was trying to run the reports using Hive database.
Am able to do this successfully in Windows machine using Hive ODBC Driver. But, failed to do the same in Linux machine. Did any one had tried the same, if so please help me out to fix this...
Followed the following steps :
step 1 : Installed "ClouderaHiveODBC-2.5.16.1005-1.el5.x86_64".
step 2 : Added "HiveDSN" in odbc.ini file in "/BIHOME/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup" location.
[HiveDSN]
Description=Cloudera ODBC Driver for Apache Hive (64-bit) DSN
Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
PORT=10000
HOST=[Hive Server]
Schema=[Hive Schema]
ServiceDiscoveryMode=0
ZKNamespace=
HiveServerType=2
AuthMech=3
ThriftTransport=1
UseNativeQuery=0
UID=[Hive user name]
PWD=[Hive password]
KrbHostFQDN=[Hive Server 2 Host FQDN]
KrbServiceName=[Hive Server 2 Kerberos service name]
KrbRealm=[Hive Server 2 Kerberos realm]
SSL=0
TwoWaySSL=0
ClientCert=
ClientPrivateKey=
ClientPrivateKeyPassword=
step 3 : verified variable "LD_LIBRARY_PATH" and added a variable "HADOOP_DLL" under the tag "<ias-component id="coreapplication_obis1" inherit-environment="true"> " in "opmn.xml" in the location "/BIHOME/instances/instance1/config/OPMN/opmn"
<variable id="HADOOP_DLL" value="$ORACLE_HOME/common/ODBC/Merant/7.1.4/lib/ARhive27.so"/>
<variable id="LD_LIBRARY_PATH" value="$ORACLE_HOME/common/ODBC/Merant/7.1.4/lib$
step 4 : Restarted OPMNCTL
step 5 : Changed connection_pool in online rpd.
Error:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 12010] Communication error connecting to remote end point: address = [OBIEE SERVER]; port = 9703. (HY000)
