How to: |
The following components are needed to use the adapter for Hadoop/Hive/Impala:
The location of Java must be specified in an environment variable.
If you are using Linux, add a line to your profile with the location where Java is installed. For example:
export JAVA_HOME=/usr/lib/jvm/jre-1.7.0
If you have JDK installed:
export JAVA_HOME=/usr/lib/jvm/jdk-1.7.0
If you are using Windows, right-click Computer and click Properties. Then click Advanced System Settings and click Environment Variables. Add the locations to your PATH variable. For example:
C:\Program Files\Java\jdk7\bin\server;C:\Program Files\Java\jdk7\bin;
The location of the JDBC driver jar files must be specified to the server. If you are running the server on the same system as the Impala server, you can specify their location. If you are running the server on another system, copy the files listed below to a 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:
or
From the Data Management Console, expand the Workspace folder.
The Java Services Configuration page opens.
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.
C:\jdbc\hive-jdbc-1.2.0-standalone.jar
For the Apache Hive JDBC Driver:
/hive_home/lib/hive-jdbc-standalone.jar /hadoop_home/hadoop-common.jar
If your Hive server is Kerberos enabled, also add:
/hadoop_home/client/hadoop-auth.jar
For Cloudera Impala
Download the JDBC driver from Cloudera. Go to the Downloads page at http://www.cloudera.com/downloads.html.
Click the link for Impala JDBC Driver downloads. For your operating system, select your OS Version and click the Download Now link.
This will download a file called impala_jdbc_2.5.34.zip (the numbers will change with new releases). It contains two more .zip files. Unzip the file Cloudera_Impala_JDBC41_2.5.34.zip to a location on your system (the 41 in the name indicates JDBC 4.1, which supports Java 1.7 or later). These 15 jar files constitute the Cloudera Impala JDBC driver.
Add the names of all of them to your CLASSPATH or IBI_CLASSPATH as described above.
WebFOCUS | |
Feedback |