Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE integration with Hive fails

Received Response
1
Views
4
Comments
3051183
3051183 Rank 1 - Community Starter
edited Aug 13, 2024 7:06PM in Oracle Analytics Cloud and Server

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)

Answers

  • rmoff
    rmoff Rank 6 - Analytics Lead

    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)

      

    That just means your BI Server is down (or, you've misconfigured the AnalyticsWeb ODBC.ini entry) -- Presentation Services can't connect to the BI Server to execute the query.

  • 3051183
    3051183 Rank 1 - Community Starter

    Hi,

    Thank you for your response...

    My BI Server is up and running good..

    ODBC.ini was updated with below configuration set up, not sure where it went wrong...

    [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=

    Thanks...

  • 3051183
    3051183 Rank 1 - Community Starter

    Any Idea... on it..

  • 923551
    923551 Rank 3 - Community Apprentice

    Don't know if that can fix your issue, but we did solve our connection problem by using the Cloudera

    ODBC driver for the Admintool connection but the Merant drivers 7.1.5 on the system running the

    BI Server (in our case Linux RHEL).