Apache Hive is mainly used for batch processing i.e. OLAP and it is not used for OLTP because of the real-time operations of the database.
Instead, hbase is extensively used for transactional processing wherein the response time of the query is not highly interactive i.e. OLTP. Unlike Hive, operations in HBase are run in real-time on the database instead of transforming into MapReduce jobs.
You can even check out the details of Big Data with the Microsoft Azure Data Enginee