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 Hue/Ambari Hive view

Hue ( is short for Hadoop User Experience. It is a web interface for making the Hadoop ecosystem easier to use. For Hive users, it offers a unified web interface for easily accessing both HDFS and Hive in an interactive environment. Hue is installed in CDH by default, and it can also be installed in other Hadoop distributions. In addition, Hue adds more programming-friendly features to Hive, such as:

  • Highlights HQL keywords
  • Autocompletes HQL queries
  • Offers live progress and logs for Hive and MapReduce jobs
  • Submits several queries and checks progress later
  • Browses data in Hive tables through a web-user interface
  • Navigates through the metadata
  • Registers UDF and adds files/archives through a web-user interface
  • Saves, exports, and shares query results
  • Creates various charts from query results

The following is a screenshot of the Hive editor...