Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL. At the same time this language also allows traditional map/reduce programmers to plug in their custom mappers and reducers when it is inconvenient or inefficient to express this logic in HiveQL.
Last time, I downloaded Impala and tested it. However, I didn't want to talk about it but it's good for using it to learn and test.
Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties
Hive history file=/tmp/cloudera/hive_job_log_cloudera_201211010525_336972305.txt
hive> show databases
Time taken: 8.265 seconds
If you are interested Hive, you can start to learn from link. Maybe, It's good idea to read some book which was written about it. So, i mention book titles Programming Hive Data Warehouse and Query Language for Hadoop By Edward Capriolo, Dean Wampler, Jason Rutherglen. You will begin with Hive from newbie to intermediate.
For readers, you should know a bit about Hadoop, SQL-92 and XML. However, you can download virtualbox (impala) and install, then run hive to practice from book examples, even through you have no idea about Hadoop. Practice and practice! I still believe there is a best way for learning. This book still gathers case studies which are interesting. Somehow, I read this book, there is helpful for me understand about Hive and how to learn, install, configure and use it further. I could learn many command-line for Hive and HiveQL. I could follow command and HiveQL for test by myself. I could learn some parameters about Hive, that's useful for tuning and etc. If you are thinking and planing to implement Hive and find out book. This book might help you.
Something in book should adjust, that might be URL links in a book because some links have not worked. Totally, the detail in book is valuable for Hive learning.
About the Author, they have experienced many years with Software Development and Big Data.
Edward Capriolo (@edwardcapriolo)
Dean Wampler (@deanwampler)