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: For example, if you need to make changes to a development database before production, you can make the changes in the table editor in development and then run the saved script in production when ready.Version 1.1 of the Apache Hive JDBC drivers are included with ADS. From there you can commit the changes to the database or save the changes to a script, which can be quite useful. When you're finished making updates, you can see your additions, updates and deletions in different colors. Another feature I found particularly useful is the table editor, which allows you to make changes to the data without immediately updating the database. The product also comes with a useful feature that lets you visually create or modify any schema objects, along with functionality to script these objects. Aside from this, I found automation and auto-completion a huge time saver. One shortcoming I noticed when using ADS with SQL Server is that when auto-completion inserts a table with a space in its name, it does not automatically put brackets around it. This does take some getting used to, since it is specific to the product. To make auto-completion work properly you will have to learn to separate your SQL statements with "GO" or a "/," which the program requires. As you type, auto-completion brings up the tables, views, synonyms and their columns. The query analyzer's automation feature saves a large amount of typing by generating the majority of your SQL, leaving you to fill in the specifics with the auto-completion feature. The automation and auto-completion are a huge benefit, in my opinion, because these features will save a considerable amount of typing (and typos) as you create SQL code. However, the documentation does say that updated drivers from the vendor may be required in specific configurations.įor the developer, ADS includes a nice query analyzer that features syntax highlighting, automation, auto-completion and multi-grid result sets that can be sorted. The product comes equipped with all the JDBC drivers required to connect to the supported databases, along with a generic JDBC and generic ODBC driver. I then tested the product against SQL Server and Oracle databases. I downloaded the software from the AquaFold Web site and installed it in just a few minutes on a Windows XP machine with no problems. ADS is a query and administration tool that allows developers and administrators to do common tasks easily on any of the supported database platforms.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |