Apache Hive JDBC Drivers (Revision #10)

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
  • Using Simba JDBC Drivers to Connect to Cloudera
• 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. Move the Apache Hive drivers which came preinstalled in <ADS_INSTALL>/lib/drivers into a folder outside of <ADS_INSTALL> (this allows putting them back later if needed).

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

4. Paste the files you copied in step 2 into <ADS_INSTALL>/lib/drivers.
5. Restart Aqua Data Studio.

Once you've pasted the Apache Hive JDBC drivers in <ADS_INSTALL>/lib/drivers and restarted Aqua Data Studio, set the Server Properties > General tab Location Connection Type (choose HiveServer 1 or HiveServer 2) and 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. Move the Apache Hive drivers which came preinstalled in <ADS_INSTALL>/lib/drivers into a folder outside of <ADS_INSTALL> (this allows putting them back later if needed).

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

4. Paste the files you copied in step 2 into <ADS_INSTALL>/lib/drivers.
5. Restart Aqua Data Studio.

Once you've pasted the Hortonworks JDBC drivers in <ADS_INSTALL>/lib/drivers and restarted Aqua Data Studio, set the Server Properties > General tab Location Connection Type (choose HiveServer 1 or HiveServer 2) and 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. Move the Apache Hive drivers which came preinstalled in <ADS_INSTALL>/lib/drivers into a folder outside of <ADS_INSTALL> (this allows putting them back later if needed).

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

4. Paste the files you copied in step 2 into <ADS_INSTALL>/lib/drivers.
5. Restart Aqua Data Studio.

Once you've pasted the Cloudera JDBC drivers in <ADS_INSTALL>/lib/drivers and restarted Aqua Data Studio, set the Server Properties > General tab Location Connection Type (choose HiveServer 1 or HiveServer 2) and Distribution dropdown to Cloudera and connect.

Cloudera Hive - Impala

If connecting to Cloudera Hive Impala ensure you choose Connection Type: Impala. Picking Impala from the Connection Type dropdown forces the Distribution dropdown to Cloudera.

Using Simba JDBC Drivers to Connect to Cloudera

It is possible to connect to Cloudera by using the Simba JDBC Drivers which come bundled with Cloudera. The following four files for Apache's Hive distribution from within <ADS_INSTALL>/lib/drivers should be removed and replaced with Simba JDBC drivers.

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

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

   TCLIServiceClient.jar
   ImpalaJDBC4.jar
   HiveJDBC4.jar
   hive_service.jar
   hive_metastore.jar

3. Move the Apache Hive drivers which came preinstalled in <ADS_INSTALL>/lib/drivers into a folder outside of <ADS_INSTALL> (this allows putting them back later if needed).

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

4. Paste the files you copied in step 2 into <ADS_INSTALL>/lib/drivers.
5. Restart Aqua Data Studio.

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. Move the Apache Hive drivers which came preinstalled in <ADS_INSTALL>/lib/drivers into a folder outside of <ADS_INSTALL> (this allows putting them back later if needed).

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

4. Paste the files you copied in step 2 into <ADS_INSTALL>/lib/drivers.
5. Restart Aqua Data Studio.

Once you've pasted the Mapr JDBC drivers in <ADS_INSTALL>/lib/drivers and restarted Aqua Data Studio, set the Server Properties > General tab Location Connection Type (choose HiveServer 1 or HiveServer 2) and  Distribution dropdown to Mapr and connect.