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