Features of Hive – Limitations of Hive

In this article, we will study various features of Apache Hive. The article enlisted various key-features of Apache Hive. You will also see some of the limitations in Apache Hive. Before learning Hive features and limitations, we will first see the introduction to Apache Hive. After Hive introduction, you will see various Hive features and limitations.

Features of Apache Hive

Keeping you updated with latest technology trends, Join TechVidvan on Telegram

Introduction to Apache Hive

Apache Hive is a tool for processing structured data stored in a Hadoop Distributed File System. Apache Hive is a data warehouse infrastructure. It resides on the top of Apache Hadoop and makes analyzing and querying easy. Hive was initially developed by Facebook and later on Apache Software Foundation took it up. Apache Software Foundation then developed Hive as an open source tool under the name Apache Hive. Many different companies use Apache Hive.

Let us now see various features of Apache Hive.

Features of Apache Hive

The Various key-features of Apache Hive are:

  1. Open-source: Apache Hive is an open-source tool. We can use it free of cost.
  2. Query large datasets: Hive can query and manage huge datasets stored in Hadoop Distributed File System.
  3. Multiple-users: Multiple users can query the data using Hive Query Language simultaneously.
  4. Backward compatible: Apache Hive perfectly fits the low level interface requirement of Apache Hadoop.
  5. Partitioning and Bucketing: Apache Hive supports partitioning and bucketing of data at the table level to improve performance.
  6. File-formats: Hive provides support for various file formats such as textFile, ORC, Avro Files, SequenceFile, Parquet, RCFile, LZO Compression etc.
  7. Hive Query Language: Hive uses Hive Query Language which is similar to SQL. We do not require any knowledge of programming languages to work with Hive. Only the knowledge of basic SQL query is enough to work with Hive.
  8. Built-In function: Hive provides various Built-In functions.
  9. User-Defined Functions: It also provides support for User-Defined Functions for the tasks like data cleansing and filtering. We can define UDFs according to our requirements
  10. External Table: Apache Hive supports external tables. This allows us to process data without actually storing data in HDFS.
  11. Fast: Hive is a fast, scalable, extensible tool and uses familiar concepts.
  12. Warehouse: Apache Hive is a distributed data warehouse tool.
  13. Table Structure: Table structure in Hive is similar to table structure in RDBMS.
  14. ETL support: Hive supports ETL operations. Hive is an effective ETL tool.
  15. Storage: Hive allows us to access files stored in HDFS and other similar data storage systems such as HBase.
  16. OLAP: Hive is designed for OLAP (Online Analytical Processing).
  17. Client application: Hive can support client applications written in PHP, Python, Java, C++ and Ruby.
  18. Rule Based Optimizer: Hive has a rule based optimizer for optimizing logical plans.
  19. Ad-hoc queries: Hive allows us to run Ad-hoc queries which are the loosely typed command or query whose value depends on some variable for the data analysis.
  20. Data Visualization: Hive can be used for Data Visualization. Integrating Hive with Apache Tez will provide the real time processing capabilities.

Let us now study some limitations of Apache Hive.

Limitations of Apache Hive

Some of the limitations of Apache Hive are:

  1. Hive is not designed for the OLTP (Online transaction processing). We can use it for OLAP.
  2. It does not offer real-time queries.
  3. It provides limited subquery support.
  4. Latency of Hive is generally very high.


I hope after reading this article you clearly understood the various features of Hive. Hive features make it the most popular data querying tool. The article had also explained some of the limitations of Apache Hive.

Still if you are having any query related to Hive, then ask us in the comment box.

Leave a Reply

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

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.