![]() 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: Hiveserver2 = .HiveDriverĪnother way to determine what JDBC driver you are using is to right click on your hive server listed in the Aqua Data Studio schema window and select Server Support Information. In the screenshot at the top of this page the driver listed is for a Hiveserver2 connection: 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īecause 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. 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. ![]() Connecting to a Hortonworks Distribution of Hive.Determining What Hive JDBC Driver Version Is In Use.See above for file locations by operating system. 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.0.1 of the Apache Hive JDBC drivers are included with ADS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |