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:
<li>Applications in which less responsive time is acceptable</li>
<li>Analysis of data that does not change rapidly</li>