Apache Hive JDBC Drivers

Version 0.12 of the Apache Hive JDBC drivers are included with ADS. These four Apache Hive JDBC Driver files are found in the <ADS_INSTALL>/lib/drivers folder:

hive-exec.jar
hive-jdbc.jar
hive-metastore.jar
hive-service.jar

Contents

• Updating Apache Hive JDBC Drivers
• Determining What Hive JDBC Driver Version Is In Use
• Connecting to a Hortonworks Distribution of Hive
• Connecting to a Cloudera Distribution of Hive
• Connecting to a Mapr Distribution of Hive

Aqua Data Studio allows connecting to Apache, Mapr, Hortonworks and Cloudera Hive distributions. It is important that the four files which come by default within <ADS_INSTALL>/lib/drivers be removed and replaced with the same named files which came with your server distribution from Hortonworks, Cloudera or Mapr. Only one distribution can be used at a time, so you cannot have files from more than one distribution in <ADS_INSTALL>/lib/drivers.

Once your distribution drivers are in place in <ADS_INSTALL>/lib/drivers, edit your server properties for a registered server. The appropriate distribution name must be selected in the Distribution dropdown in the Location section of the Server Properties > General tab.

For Aqua Data Studio to show you which drivers are in use for your distribution, you must connect to your distribution at least once before they appear in the About Aqua Data Studio > JDBC Drivers tab.

Determining What Hive JDBC Driver Version Is In Use

Because the Apache Hive drivers are loaded dynamically, you must connect at least once to your distribution to see what version is listed within the About Aqua Data Studio > JDBC Drivers dialog.

In the screenshot at the top of this page the two drivers listed are for Hiveserver1 and Hiveserver2 connections:

Hiveserver1 = org.apache.hadoop.hive.jdbc.HiveDriver
Hiveserver2 = org.apache.hive.jdbc.HiveDriver

Updating Apache Hive JDBC Drivers

The following four files for Apache's Hive distribution from within <ADS_INSTALL>/lib/drivers should be removed and replaced with your updated Apache Hive JDBC drivers.

hive-exec.jar
hive-jdbc.jar
hive-metastore.jar
hive-service.jar

1. Shut down Aqua Data Studio.
2. Copy the drivers from your Apache Hive Distribution:

   hive-exec-x.xx.x.jar
   hive-jdbc-x.xx.x.jar
   hive-metastore-x.xx.x.jar
   hive-service-x.xx.x.jar

3. Rename the Apache Hive JDBC drivers to:

   hive-exec.jar
   hive-jdbc.jar
   hive-metastore.jar
   hive-service.jar

4. Delete the Apache Hive drivers with these names which came preinstalled in <ADS_INSTALL>/lib/drivers

   Note: Renaming them is not sufficient, you must either delete these files or move them to a directory outside of [ADS_HOME]

5. Copy the files you renamed in step 3 and paste them into <ADS_INSTALL>/lib/drivers.
6. Restart Aqua Data Studio.

Once you've renamed the Apache Hive drivers to the filenames above and placed them in <ADS_INSTALL>/lib/drivers, set the Server Properties > General tab Distribution dropdown to Apache Hive and connect.

Connecting to a Hortonworks Distribution of Hive

The following four files for Apache's Hive distribution from within <ADS_INSTALL>/lib/drivers should be removed and replaced with Hortonworks JDBC drivers.

hive-exec.jar
hive-jdbc.jar
hive-metastore.jar
hive-service.jar

1. Shut down Aqua Data Studio.
2. Copy the Hortonworks JDBC drivers from your Hortonworks Distribution:

   hive-exec-x.xx.x.x.x.x.x-xx.jar
   hive-jdbc-x.xx.x.x.x.x.x-xx.jar
   hive-metastore-x.xx.x.x.x.x.x-xx.jar
   hive-service-x.xx.x.x.x.x.x-xx.jar

3. Rename the Hortwonworks drivers to:

   hive-exec.jar
   hive-jdbc.jar
   hive-metastore.jar
   hive-service.jar

4. Delete the Apache Hive drivers with these names which came preinstalled in <ADS_INSTALL>/lib/drivers

   Note: Renaming them is not sufficient, you must either delete these files or move them to a directory outside of [ADS_HOME]

5. Copy the files you renamed in step 3 and paste them into <ADS_INSTALL>/lib/drivers.
6. Restart Aqua Data Studio.

Once you've renamed the Hortonworks drivers to the filenames above and placed them in <ADS_INSTALL>/lib/drivers, set the Server Properties > General tab Distribution dropdown to Hortonworks and connect.

Connecting to a Cloudera Distribution of Hive

The following four files for Apache's Hive distribution from within <ADS_INSTALL>/lib/drivers should be removed and replaced with Cloudera JDBC drivers.

hive-exec.jar
hive-jdbc.jar
hive-metastore.jar
hive-service.jar

1. Shut down Aqua Data Studio.
2. Copy the Cloudera JDBC drivers from your Cloudera Distribution
   

   hive-exec-x.xx.x-xxxx.x.x.jar
   hive-jdbc-x.xx.x-xxxx.x.x.jar
   hive-metastore-x.xx.x-xxxx.x.jar
   hive-service-x.xx.x-xxxx.x.x.jar

3. Rename the Cloudera drivers to:

   hive-exec.jar
   hive-jdbc.jar
   hive-metastore.jar
   hive-service.jar

4. Delete the Apache Hive drivers with these names which came preinstalled in <ADS_INSTALL>/lib/drivers

   Note: Renaming them is not sufficient, you must either delete these files or move them to a directory outside of [ADS_HOME]

5. Copy the files you renamed in step 3 and paste them into <ADS_INSTALL>/lib/drivers.
6. Restart Aqua Data Studio.

Once you've renamed the Cloudera drivers to the filenames above and placed them in <ADS_INSTALL>/lib/drivers, set the Server Properties > General tab Distribution dropdown to Cloudera and connect.

Connecting to a Mapr Distribution of Hive

The following four files for Apache's Hive distribution from within <ADS_INSTALL>/lib/drivers should be removed and replaced with Mapr JDBC drivers.

hive-exec.jar
hive-jdbc.jar
hive-metastore.jar
hive-service.jar

1. Shut down Aqua Data Studio.
2. Copy the Mapr JDBC drivers from your Mapr Distribution:

   hive-exec-x-xx.x.jar
   hive-jdbc-x.xx.x.jar
   hive-metastore-x.xx.x.jar
   hive-service-x.xx.x.jar

3. Rename the Mapr drivers to:

   hive-exec.jar
   hive-jdbc.jar
   hive-metastore.jar
   hive-service.jar

4. Delete the Apache Hive drivers with these names which came preinstalled in <ADS_INSTALL>/lib/drivers

   Note: Renaming them is not sufficient, you must either delete these files or move them to a directory outside of [ADS_HOME]

5. Copy the files you renamed in step 3 and paste them into <ADS_INSTALL>/lib/drivers.
6. Restart Aqua Data Studio.

Once you've renamed the Mapr drivers to the filenames above and placed them in <ADS_INSTALL>/lib/drivers, set the Server Properties > General tab Distribution dropdown to Mapr and connect.