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 for information about supported versions of Apache Hive. See Limitations on the Use of Apache Hive with Oracle Business Intelligence for information about using Apache Hive data sources.

To configure the DataDirect Connect ODBC Driver to connect to Apache Hive:

1. Open the obis.properties file. You can find this file at:

   BI_DOMAIN/config/fmwconfig/bienv/obis

2. Locate the LD_LIBRARY_PATH variable. Note the following:

   • 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. For example, to update the variable for the driver on Linux:

   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. In obis.properties file, either above or below the LD_LIBRARY_PATH variable, create the HADOOP_DLL variable to point to the DataDirect driver.

   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. You can find this file at:

   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