Features of Hive
The best feature is it offers data summarization, query, and analysis in much easier manner.
To process data without actually storing in HDFS, Hive supports external tables.
Moreover, it fits the low-level interface requirement of Hadoop perfectly.
Limitation of Hive
We can not perform real-time queries with Hive. Also, it does not offer row-level updates.
Moreover, for interactive data browsing Hive offers acceptable latency.
Also, we can say Hive is not the right choice for online transaction processing.
