Apache Hive is an open source project under Apache, actually developed by Facebook. Hive is an SQL data warehouse for Apache Hadoop. Hive makes working on Hadoop easier for any developer familiar to SQL language.
Below is a small guide to get you started on Apache Hive. It consists of few concepts and other lab assignments to get you rolling. Its a starting point and you can keep on exploring Hive thereafter.
Hope its helpful.
Download from Slideshare: http://www.slideshare.net/venomPill/hive-guide-confusedcoders