Configuring the DataDirect Connect ODBC Driver for Apache Hive Database

The name of the DataDirect ODBC driver file to connect to a Apache Hive is libARhive27.so.

See System Requirements and Certification and Limitations on the Use of Apache Hive with Oracle Business Intelligence.

1. Open the obis.properties file located in:

   BI_DOMAIN/config/fmwconfig/bienv/obis

2. Locate the LD_LIBRARY_PATH variable, use the following information:

   • For Solaris, Linux, and HP-UX, the library path variable is LD_LIBRARY_PATH.

   • For AIX, the library path variable is LIBPATH.

   For example, to set the library path variable for the driver on Linux:

   LD_LIBRARY_PATH=$ORACLE_HOME/bi/bifoundation/server/bin,
   $ORACLE_HOME/bi/bifoundation/web/bin,
   $ORACLE_HOME/clients/epm/Essbase/EssbaseRTC/bin,
   $ORACLE_HOME/bi/bifoundation/odbc/lib,
   $ORACLE_INSTANCE,
   $ORACLE_HOME/lib
   

3. If necessary, update the LD_LIBRARY_PATH variable to include the DataDirect driver path.

   To update the variable for the driver on Linux, review the following example:

   LD_LIBRARY_PATH=$ORACLE_HOME/bi/common/ODBC/Merant/7.1.5/lib,
   $ORACLE_HOME/bi/bifoundation/server/bin,
   $ORACLE_HOME/bi/bifoundation/web/bin,
   $ORACLE_HOME/clients/epm/Essbase/EssbaseRTC/bin,
   $ORACLE_HOME/bi/bifoundation/odbc/lib,
   $ORACLE_INSTANCE,
   $ORACLE_HOME/lib
   

4. In obis.properties, locate the PATH variable and if necessary, include the DataDirect driver path.
5. To point to the DataDirect driver, create the HADOOP_DLL variable either above or below the LD_LIBRARY_PATH variable.

   For example:

   HADOOP_DLL=ORACLE_HOME/bi/common/ODBC/Merant/7.1.5/lib/ARhive27.so

6. Save and close the file.
7. Open the odbc.ini file located in:

   BI_DOMAIN/config/fmwconfig/bienv/core

8. Create an entry for the database, ensuring that the ODBC connection name is identical to the data source name specified in the connection pool defined in the repository.

   Ensure that you set the Driver parameter to the file name and location of the DataDirect Connect driver for Hive. You must specify the HostName parameter. You can use the fully qualified host name or the IP address, and the PortNumber parameter.

   In the following example, the Driver parameter is set to the DataDirect Connect driver, and the data source name is Hive.

   [Hive] 
   Driver=/ORACLE_HOME/bi/common/ODBC/Merant/7.1.5/lib/ARhive27.so
   Description=Oracle 7.1 Apache Hive Wire Protocol
   ArraySize=16384
   Database=default
   DefaultLongDataBuffLen=1024
   EnableDescribeParam=0
   HostName=localhost
   LoginTimeout=30
   MaxVarcharSize=2000
   PortNumber=10000
   RemoveColumnQualifiers=0
   StringDescribeType=12
   TransactionMode=0
   UseCurrentSchema=0
   

9. Save and close the odbc.ini file.
10. Restart OBIS1.
11. Create a soft link libARicu27.so pointing to libARicu26.so.

    For example:

    cd //ORACLE_HOME/bi/common/ODBC/Merant/7.1.5/lib/ln -s libARicu26.so libARicu27.so