What are the limitations of Hive?

Here are few limitations of Hive:

  • Hive does not support insert and update functions at a row-level, which makes it unsuitable for OLTP systems.
  • Hive does not support real-time processing.
  • Hive queries have high latency due to the start-up overhead of the MapReduce job.