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, which can be found at https://www.cloudera.com/downloads/connectors/hive/jdbc.html and https://hortonworks.com/downloads/#addons.
We can use these JDBC/ODBC connectors to connect Hive from tools such as the following:
- A command-line utility, such as Beeline, mentioned in Chapter 2, Setting Up the Hive Environment
- An integrated development environment, such as Oracle SQL Developer, also mentioned in Chapter 2, Setting Up the Hive Environment
- Data extraction, transformation, loading, and integration tools, such as Talend Open Studio (https://www.talend.com/products/talend-open-studio/) and Pentaho (https://www.hitachivantara.com/go/pentaho.html)
- Business intelligence, reporting, and visualization tools, such as QlikView (https://www.qlik.com) and Tableau (https://www.tableau.com)
- Data analysis tools, such as Microsoft Excel with Power Query Add-in
Since the setting up connectors is very straightforward, please refer to the websites of the specific tools for more detailed instructions to connect to Hive.