Preparing the Environment

How to:

The following components are needed to use the adapter for Hadoop/Hive/Impala:

Top of page

Procedure: How to Configure the Java CLASSPATH

The location of the Hadoop and Hive jar files must be specified to the server. If you are running the server on the same system as the Hadoop and Hive server, you can specify their location. If you are running the server on another system, copy the files listed below to some location on your system and specify their location.

This can be done in the system CLASSPATH or in the DataMigrator or WebFOCUS Reporting Server IBI_CLASSPATH variable as follows:

  1. From the Web Console menu bar, select Workspace


    From the Data Management Console, expand the Workspace folder.

  2. Expand the Java Services folder. Right-click DEFAULT and select Properties.

    The Java Services Configuration page opens.

  3. Click on the chevrons to expand Class Path

    In the IBI_CLASSPATH box, enter the full location of the Hive and Hadoop files shown below, where hive_home is where Hive is installed and hadoop_home is where Hadoop is installed. You must type them explicitly and cannot use $HIVE_HOME. The file names must be entered one per line.

    If you are installing the adapter on a different system than where Hadoop and Hive are installed, copy the jar files to a location on that system.

    Note: For a server running on Windows, use Windows syntax for directory names. For example:


    For Hive or Impala:

    Use the version numbers that match your installation. In the following example, the version number for Hive is 0.14.0.

  4. Scroll down and click the Save and Restart Java Services button.