• Blog
  • Talend DI
  • Connecting to Hive & other Hadoop 1.x DBs using DBVisualizer
Monday, 21 April 2014 21:37

Connecting to Hive & other Hadoop 1.x DBs using DBVisualizer

Written by
Rate this item
(1 Vote)

While it's perfectly ok to interact with Hive databases using the command line (Hive shell), it's easier to display and visualize large number of columns of data using a GUI. Of the many GUI options that exist, one tool that does the job pretty well is DBVisualizer. It's great not only for Hive databases - but all most popular RMDBs as well. And it doesn't hurt that the DBVisualizer is free!

In this article, we are going to look at how to download, install and configure DBVisualizer to connect to Hadoop 1.x.

+ Download DB Visualizer for your version of O/S- http://www.dbvis.com/download/

+ Install it

+ Download the follwing Hive Jars (Hadoop 1.x) to a directory on your machine. Unzip the file so you can see all the jars. (hadoop-common.jar, hive-jdbc.jar, httpclient.jar, httpcore.jar, slf4j-api.jar)

+ Open DB Visualizer.

+ Go to Tools --> Driver Manager


+ Set the following options as shown below:

    1. Driver Name (left panel) to Hive
    2. Click on the folder (bottom, right) and select ALL the jar files in the Hive Jar Directory (from step above). They will be loaded sequentially – may take a few seconds…
    3. Set URL format to: jdbc:hive://<yourHiveHostName>:10000/
    4. Set Driver Class to: org.apache.hadoop.hive.jdbc.HiveDriver
    5. Close the window.


 + Create a database connection as shown below, by selecting Database à Create Database Connection


 + Name your connection


 + Click on Next.

+ Select your Database driver  – Hive


 + Specify an actual Database instance to connect to. The following screenshot shows a connection to a Hive host server (jdbc:hive://<yourHiveHostServer>:10000)


 + Enter the Hadoop / Hive user that has read-access. Password may not be required.

+ Click on Finish.

+ To connect, either click on the + sign by your connection or right-click and select Connect.

+ To create a query, go to SQL Commander à New SQL Commander


 + Enter a statement and test (click on green forward arrow). Don’t forget to qualify your table names with the Database name (for example: talend_pocs.tblpoc9customerprd)


Read 7391 times Last modified on Thursday, 13 August 2015 18:46
Will Munji

Will Munji is a seasoned data integration, data warehousing and business intelligence (BI) architect & developer who has been working in the DW/BI space for a while. He got his start in BI working on Brio SQR (later Hyperion SQR) and the Crystal Decisions stack (Reports, Analysis & Enterprise) and SAP BusinessObjects / Microsoft BI stacks. He currently focuses on Talend Data Management Suite, Hadoop, SAP BusinessObjects BI stack as well as Jaspersoft and Tableau. He has consulted for many organizations across a variety of industries including healthcare, manufacturing, retail, insurance and banking. At Kindle Consulting, Will delivers DW/BI/Data Integration solutions that range from front-end BI development (dashboards, reports, cube development, T-SQL/ PL/SQL ...) to data services (ETL/ DI development), data warehouse architecture and development, data integration to BI Architecture design and deployment.

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Contact Us

Kindle Consulting, Inc

6595 Roswell Road 
Suite G2025 
Atlanta, GA 30328

Phone: 404.551.5494
Fax: 404.551.5452
Email: info@kindleconsulting.com

Talend Gold Partner