Preparing the Apache Drill Environment

The following components are needed to use the adapter for Apache Drill:

Java. To use this Java-based adapter, you must have Java installed. Drill requires Version 1.7 or later. Java can be downloaded from http://www.java.com.
The location of the 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 select Properties. Then select 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;
```
JDBC Drivers
There are two JDBC drivers available for Apache Drill.

The Open Source JDBC Driver is included with Drill. It consists of a single file that can be found after installation at the following location:
```
drill_installation/jars/jdbc-driver/drill-jdbc-all-version.jar
```
where:

drill_installation

Is the location where you installed Apache Drill.

version

Is your driver version.

It can also be downloaded from https://drill.apache.org/docs/using-the-jdbc-driver.

If you are using the Open Source JDBC Driver and are installing the server on the same system where Drill is installed, you can point to the jar files as described in the next section. If you are installing the server on some other system, copy those files to a location of your choice.

The MapR JDBC driver is available from MapR, as explained in step 3 of the following procedure. This driver also supports MapR SASL authentication.

Configure the Java CLASSPATH

The location of the Drill jar files must be specified to the server. If you are running the server on the same system as a Drillbit, you can specify its 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 server IBI_CLASSPATH variable as follows:

Procedure

From the WebFOCUS Reporting Server browser interface, navigate to Workspace

or

From the ibi Data Migrator desktop interface, expand the Workspace folder.
Expand the Java Services folder, then right-click DEFAULT, and select Properties.

The Java Services Configuration page opens.
Click on the chevrons to expand the Class Path.
For the Open Source JDBC Driver

In the IBI_CLASSPATH box, enter the full location of the jar file. For example:
```
drill_installation/jars/jdbc-driver/drill-jdbc-all-version.jar
```
where:

drill_installation

Is the location where you installed Apache Drill.

version

Is your driver version.

If you want to access data stored in HBase or MapR-DB, add an additional jar file. For example:
```
drill_installation/jars/3rdparty/hadoop-common-2.7.0.jar
```
Note: The file names must be entered one per line.

If you are installing the adapter on a different system than where you have Drill 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:
```
C:\Drill\jars\jdbc-driver\drill-jdbc-all-version.jar
```
For the MapR (Simba) JDBC Driver

Download the MapR JDBC Driver from https://maprdocs.mapr.com/home/Drill/drill_jdbc_connector.html from the link for the Drill JDBC Driver provided by MapR. This downloads a file named:
```
MapRDrillJDBC41-version.zip
```
Note: The version changes with new releases.

Unzip the file to a location on your server. The 7 jar files constitute the MapR Drill JDBC Driver.

Add the names of all the jar files to your CLASSPATH or IBI_CLASSPATH, as described above.
Scroll down and click the Save and Restart Java Services button.

Did you find this helpful?

Yes No