What are the main limitations of Apache Hive?

Apache Hive is a popular tool in Hadoop eco-system. Some of the limitations of Hive are as follows:

  • OLTP: Hive cannot be used for OLTP applications, since it does not support record level update, insert statements.
  • Data Warehouse: Hive is more suitable for data warehouse applications on Big Data.
  • Latency: Hive queries have higher latency than SQL due to time overhead during start-up.
  • Batch Oriented: Hive is mostly used in Batch-oriented use cases.
  • OLAP: For Online Analytic Processing (OLAP) we can use Hive. We can use HBase also for OLAP processing.

Leave a Reply

Your email address will not be published. Required fields are marked *