Hive is mainly used for Datawarehouse applications. Hive used Hadoop and MapReduce that put some restrictions on use cases for Hive.
Some of the main use cases for Hive are:
Read the full book at www.amazon.com
<li>Applications in which less responsive time is acceptable</li> <li>Analysis of data that does not change rapidly</li>