Page History
...
Info |
---|
All of the example file locations below are for a Linux operating system but can equally apply to a Windows or OSX operating system. See above for file locations by operating system. |
Contents
Table of Contents |
---|
...
Click on About Aqua Data Studio > JDBC Drivers. The Apache Hive drivers are loaded dynamically so you must connect at least once to your distribution to see what version is listed in the JDBC Drivers dialog. Below is an example screenshot of the default Hive drivers.
Click on the Server Support Information dialog. Right-click on your hive server listed in the Aqua Data Studio schema window and select the the Server Support Information dialog. Below is an example screenshot of the default Hive drivers.
Some Some other possible drivers that might be listed in the dialog's shown above include:
- com.amazon.hive.jdbc4.HS2Driver - Amazon driver
- com.amazon.hive.jdbc41.HS2Driver - Amazon driver
- com.cloudera.impala.jdbc4.Driver - Cloudera Impala driver
- com.cloudera.impala.jdbc41.Driver - Cloudera Impala driver
- com.cloudera.hive.jdbc4.HS2Driver - Cloudera Hive driver
- com.cloudera.hive.jdbc41.HS2Driver - Cloudera Hive driver
- com.simba.hive.jdbc4.HS2Driver - Simba(Hortonworks) Hive driver
- com.simba.hive.jdbc41.HS2Driver - Simba(Hortonworks) Hive driver
- org.apache.hive.jdbc.HiveDriver - Apache Hive driver
...
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, HiveServer 2, Impala or Spark SQL) and Distribution drop-down to Apache Hive and connect.
Connecting to a Hortonworks Distribution of Hive
...
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, HiveServer 2, Impala or Spark SQL) and Distribution drop-down to Hortonworks and connect.
Using Simba Hive JDBC Connector Drivers to Connect to Hortonworks
...
Once you've pasted the Simba 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, HiveServer 2, Impala or Spark SQL) and Distribution drop-down to Hortonworks and connect.
Connecting to a Cloudera Distribution of Hive
...
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, HiveServer 2, Impala or Spark SQL) and Distribution drop-down to Cloudera and connect.
Using Cloudera Connector Drivers to Connect to Cloudera
...
Once you've pasted the Cloudera JDBC Connector drivers in <ADS_INSTALL>/lib/drivers and restarted Aqua Data Studio, set the Server Properties > General tab Location Connection Type (choose HiveServer 1, HiveServer 2, Impala or Spark SQL) and Distribution drop-down to Cloudera and connect.
Connecting to a Mapr Distribution of Hive
...
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, HiveServer 2, Impala or Spark SQL) and Distribution drop-down to Mapr and connect.
Connecting to an Amazon EMR Distribution of Hive
...
Info |
---|
Note: When using the Amazon Connector driver version 1.0.4, it is recommended that you add this parameter - ?UseNativeQuery=1 to the Server Properties->Driver->Parameters field. This alleviates an issue related to the way the JDBC drivers handle complex data columns. |
Using Apache Hive JDBC Drivers to Connect to Amazon EMR
...
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, HiveServer 2, Impala or Spark SQL) and Distribution drop-down to Amazon EMR and connect.
OSX Driver Location Navigation
To get to the driver location in OSX, select "Finder". Select "Applications". Locate the Aqua Data Studio app and right click on it. Select "Show Package Contents"