Why is Hive not good for OLTP

Question

I have read in lots of blogs and PPTs and discussions that Hive is not good for OLTP. But because of it's distributed feature, I thought it would be better to use Hive for OLTP such as banking systems. Why do people tell it is not good?

Answer 1

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 DP-203 Certification Course