Apache Hive logo
Data Warehouse Software for Reading, Writing, and Managing Large Datasets

What is Apache Hive?

Hive facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage.
Apache Hive is a tool in the Big Data Tools category of a tech stack.
Apache Hive is an open source tool with 2.6K GitHub stars and 2.5K GitHub forks. Here’s a link to Apache Hive's open source repository on GitHub

Who uses Apache Hive?

16 companies use Apache Hive in their tech stacks, including Repro, Eyereturn Marketing, and sovrn Holdings.

10 developers use Apache Hive.

Apache Hive Integrations

HBase, Mode, Hadoop, SQLFlow, and Apache Spark are some of the popular tools that integrate with Apache Hive. Here's a list of all 5 tools that integrate with Apache Hive.

Why developers like Apache Hive?

Here’s a list of reasons why companies and developers use Apache Hive
Top Reasons
Be the first to leave a pro

Apache Hive's features

  • Built on top of Apache Hadoop
  • Tools to enable easy access to data via SQL
  • Support for extract/transform/load (ETL), reporting, and data analysis
  • Access to files stored either directly in Apache HDFS and HBase
  • Query execution using Apache Hadoop MapReduce, Tez or Spark frameworks

Apache Hive Alternatives & Comparisons

What are some alternatives to Apache Hive?
Apache HBase is an open-source, distributed, versioned, column-oriented store modeled after Google' Bigtable: A Distributed Storage System for Structured Data by Chang et al. Just as Bigtable leverages the distributed data storage provided by the Google File System, HBase provides Bigtable-like capabilities on top of Apache Hadoop.
Apache Spark
Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.
Apache Flink
Apache Flink is an open source system for fast and versatile data analytics in clusters. Flink supports batch and streaming analytics, in one system. Analytical programs can be written in concise and elegant APIs in Java and Scala.
Amazon Athena
Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.
Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.
See all alternatives

Apache Hive's Stats