Apache Hive is a query and analysis engine which is built on top of Apache Hadoop and uses MapReduce Programming Model. It provides an abstraction layer to query big-data using the SQL syntax by implementing traditional SQL queries using the Java API. The main components of the Hive are as follows: · Metastore · Driver · Compiler · Optimizer · Executor · Client In this Book, I have included Images along with explanation and programs executed on Cloudera.