JDBC/ODBC is one of the most common ways for Hive to work with other tools. Hadoop vendors, such as Cloudera and Hortonworks, offer free Hive JDBC/ODBC drivers so that Hive can be connected through these drivers; these can be found at the following links:
For Cloudera, the link is http://www.cloudera.com/content/cloudera/en/downloads/connectors/hive.html
For Hortonworks, the link is http://hortonworks.com/hdp/addons/
We can use these JDBC/ODBC connectors to connect Hive to tools such as the following:
A command-line utility such as Beeline, mentioned in Chapter 2, Setting Up the Hive Environment
Integrated development environment such as Oracle SQL Developer, mentioned in Chapter 2, Setting Up the Hive Environment
Data extraction, transformation, loading, and integration tools, such as Talend Open Studio
Business intelligence reporting tools, such as JasperReports and QlikView
Data analysis tools such as Microsoft Excel 2013
Data visualization tools such as Tableau
Since...