Book Image

Apache Hive Essentials. - Second Edition

By : Dayong Du
Book Image

Apache Hive Essentials. - Second Edition

By: Dayong Du

Overview of this book

In this book, we prepare you for your journey into big data by frstly introducing you to backgrounds in the big data domain, alongwith the process of setting up and getting familiar with your Hive working environment. Next, the book guides you through discovering and transforming the values of big data with the help of examples. It also hones your skills in using the Hive language in an effcient manner. Toward the end, the book focuses on advanced topics, such as performance, security, and extensions in Hive, which will guide you on exciting adventures on this worthwhile big data journey. By the end of the book, you will be familiar with Hive and able to work effeciently to find solutions to big data problems
Table of Contents (12 chapters)

The 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, 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...