Chapter 10. Working with Other Tools

As one of the earliest and most popular SQL over Hadoop tools, Hive has many use cases of working with other tools to offer an end-to-end data intelligence solution. In this chapter, we will discuss the way Hive works with other big data tools in the following areas:

  • JDBC / ODBC connector
  • HBase
  • Hue
  • HCatalog
  • Zookeeper
  • Oozie
  • Hive roadmap

JDBC / ODBC connector

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:

Get Apache Hive Essentials now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.