Features Of Apache Hive

Apache Hive has many exciting features. Let's discuss them one by one:

Hive provides data summarization, analysis, and query in a much more relaxed manner.
Hive supports different external tables which make it possible to analyze data without actually storing in Hadoop File System.
Apache Hive fits perfectly with Hadoop's low-level interface specification.
It also supports the partitioning of data at the level of tables to improve performance.
Hive has a rule-based optimizer to optimize logical plans.
It is familiar, scalable, and extensible.
Using HiveQL doesn't require any expertise of programming language, Knowledge of basic SQL queries is enough.
We can efficiently process structured data in Hadoop using Hive.
Querying in Hive is very straightforward as it is a SQL like a language.
We can also run Ad-hoc data analysis queries using Hive.