Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
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
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.
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
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
hive-exec-x.xx.x.jar
hive-jdbc-x.xx.x.jar
hive-metastore-x.xx.x.jar
hive-service-x.xx.x.jar
Note: Renaming them is not sufficient, you must either delete these files or move them to a directory outside of [ADS_INSTALL]
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.
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
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
Note: Renaming them is not sufficient, you must either delete these files or move them to a directory outside of [ADS_INSTALL]
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.
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
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
Note: Renaming them is not sufficient, you must either delete these files or move them to a directory outside of [ADS_INSTALL]
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, or could be downloaded from the Cloudera website. 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
(for those using Impala and HiveServer2)
TCLIServiceClient.jar
ImpalaJDBC4.jar
HiveJDBC4.jar
hive_service.jar
hive_metastore.jar
(for those only using Impala)
TCLIServiceClient.jar
ImpalaJDBC4.jar
hive_service.jar
hive_metastore.jar
(for those only using HiveServer2)
TCLIServiceClient.jar
HiveJDBC4.jar
hive_service.jar
hive_metastore.jar
Note: Renaming them is not sufficient, you must either delete these files or move them to a directory outside of [ADS_INSTALL]
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
hive-exec-x-xx.x.jar
hive-jdbc-x.xx.x.jar
hive-metastore-x.xx.x.jar
hive-service-x.xx.x.jar
Note: Renaming them is not sufficient, you must either delete these files or move them to a directory outside of [ADS_INSTALL]
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.