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

• The JDBC/ODBC connector
• The NoSQL database
• The Hue/Ambari Hive view
• HCatalog
• Oozie
• Spark
• Hivemall