Apache Hive is a data warehouse system for Hadoop that runs SQL like queries called HQL (Hive query language) which gets internally converted to map-reduce jobs. The hive was developed by Facebook. It supports Data definition Language, Data Manipulation Language, and user-defined functions. This tutorial provides basic and advanced concepts of Hive and it is designed for beginners as well as for professionals.