O'Reilly logo

Apache Hive Essentials by Dayong Du

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required