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.