Preparing the Apache Phoenix Environment

How to:

Configure the Java CLASSPATH

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

Java. To use this Java-based adapter, you must have Java, Version 1.8 or later, installed. 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.8.0
```
If you have JDK installed:
```
export JAVA_HOME=/usr/lib/jvm/jdk-1.8.0
```
If you are using Windows, right-click Computer and select Properties. Then click Advanced System Settings and click Environment Variables. Add the locations to your PATH variable. For example:
```
C:\Program Files\Java\jdk-8\bin\server;C:\Program Files\Java\jdk-8\bin;
```
JDBC Driver. The JDBC driver consists of a jar file distributed with Apache Phoenix. If you are installing the server on the same system where Apache Phoenix is installed, you can point to the jar file as described in the next section. If you are installing the server on some other system, copy the file to a location of your choice.

Procedure: How to Configure the Java CLASSPATH

The location of the Apache Phoenix JDBC Driver 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 DataMigrator or WebFOCUS Reporting Server IBI_CLASSPATH variable as follows:

From the Web Console menu bar, select Workspace

or

From the Data Management Console, expand the Workspace folder.
Expand the Java Services folder. Right-click DEFAULT and click Properties.

The Java Services Configuration page opens.
Click on the chevrons to expand Class path.
In the IBI_CLASSPATH box, enter the full location of the jar file. For example:
```
/usr/lib/phoenix/phoenix-client.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 Apache Phoenix installed, copy the jar file to a location on that system.
- For a server running on Windows, use Windows syntax for directory names. For example:
```
 C:\phoenix\phoenix-client.jar
```
- If your Hadoop cluster is Kerberos enabled, add the name of the directory containing the configuration files hbase-site.xml and core-site.xml. By default, if the server is installed on the same system where Hadoop or HBase were installed, these files are located in the /etc/hbase/conf directory. If the server is installed on a different system, use the name of the directory where you copied the configuration files. For example:
  - For a Linux system:
    /etc/hbase/conf
  - For a Windows system:
    c:\phoenix
Scroll down and click the Save and Restart Java Services button.