- #Aquadatastudio download drivers#
- #Aquadatastudio download driver#
- #Aquadatastudio download windows#
Paste the Hortonworks JDBC driver files you copied in step 2 into /lib/drivers. If connecting to Hortonworks using Kerberos authentication, you'll also need to copy the following libraries:
#Aquadatastudio download drivers#
The following four files for Apache's Hive distribution from within /lib/drivers should be removed and replaced with Hortonworks JDBC drivers.Ĭopy the Hortonworks JDBC drivers from your Hortonworks Distribution: Once you've pasted the Apache Hive JDBC drivers in /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.Ĭonnecting to a Hortonworks Distribution of Hive Paste the Apache Hive JDBC driver files you copied in step 2 into /lib/drivers. Note: Renaming them is not sufficient, you must either delete these files or move them to a directory outside of Move the Apache Hive drivers which came preinstalled in /lib/drivers into a folder outside of (this allows putting them back later if needed). The following four files for Apache's Hive distribution from within /lib/drivers should be removed and replaced with your updated Apache Hive JDBC drivers.Ĭopy the drivers from your Apache Hive Distribution: Below is an example screenshot of the default Hive drivers.Ĭom.2Driver - Amazon driverĬom.2Driver - Amazon driverĬom. - Cloudera Impala driverĬom. - Cloudera Impala driverĬom.2Driver - Cloudera Hive driverĬom.2Driver - Cloudera Hive driverĬom.2Driver - Simba(Hortonworks) Hive driverĬom.2Driver - Simba(Hortonworks) Hive driver Right click on your hive server listed in the Aqua Data Studio schema window and select the Server Support Information dialog. 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.Ĭlick on the Server Support Information dialog. The appropriate distribution name must be selected in the Distribution dropdown in the Location section of the Server Properties > General tab.įor 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.ĭetermining What Hive JDBC Driver Version Is In UseĬlick on About Aqua Data Studio > JDBC Drivers. Once your distribution drivers are in place in /lib/drivers, edit your server properties for a registered server. Only one distribution can be used at a time, so you cannot have files from more than one distribution in /lib/drivers. It is important that the four files which come by default within /lib/drivers be removed and replaced with the same named files which came with your server distribution from Hortonworks, Cloudera or Mapr. Using Apache Hive JDBC Drivers to Connect to Amazon EMRĪqua Data Studio allows connecting to Apache, Mapr, Hortonworks and Cloudera Hive distributions.Connecting to an Amazon EMR Distribution of Hive.Connecting to a Mapr Distribution of Hive.Using Hive JDBC Connector Drivers to Connect to Cloudera.Connecting to a Cloudera Distribution of Hive.Using Hive JDBC Connector Drivers to Connect to Hortonworks.
#Aquadatastudio download windows#
OSX - OSX Driver Location Navigation Aqua Data Studio.app/Contents/Java/drivers/ hive-exec.jar Aqua Data Studio.app/Contents/Java/drivers/ hive-jdbc.jar Aqua Data Studio.app/Contents/Java/drivers/ hive-metastore.jar Aqua Data Studio.app/Contents/Java/drivers/ hive-service.jarĪll of the example file locations below are for a Linux operating system but can equally apply to a Windows or OSX operating system. LINUX /lib/drivers/ hive-exec.jar /lib/drivers/ hive-jdbc.jar /lib/drivers/ hive-metastore.jar /lib/drivers/ hive-service.jar
WINDOWS \lib\drivers\ hive-exec.jar \lib\drivers\ hive-jdbc.jar \lib\drivers\ hive-metastore.jar \lib\drivers\ hive-service.jar These four Apache Hive JDBC Driver files are found in the following locations: Version 1.1.0 of the Apache Hive JDBC drivers are included with ADS.
0 kommentar(er)
