The following link is to a simple tutorial demonstrating the installation, configuration and use of (getting started with) Hive.
Hive is a data warehouse system for Hadoop that facilitates ad-hoc queries and the analysis of large datasets stored in Hadoop. Hive provides a SQL-like language called HiveQL. Due its SQL-like interface, Hive is increasingly becoming the technology of choice for using Hadoop.
The objective of this tutorial is to get you up and running Hive queries on a real-world dataset.