Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Apache Hive
Apache Hive

107
44
+ 1
0
HBase
HBase

193
156
+ 1
12
Add tool

Apache Hive vs HBase: What are the differences?

What is Apache Hive? Data Warehouse Software for Reading, Writing, and Managing Large Datasets. Hive facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage.

What is HBase? The Hadoop database, a distributed, scalable, big data store. 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 Hive and HBase are primarily classified as "Big Data" and "Databases" tools respectively.

Apache Hive and HBase are both open source tools. It seems that HBase with 2.91K GitHub stars and 2.01K forks on GitHub has more adoption than Apache Hive with 2.62K GitHub stars and 2.58K GitHub forks.

According to the StackShare community, HBase has a broader approval, being mentioned in 54 company stacks & 18 developers stacks; compared to Apache Hive, which is listed in 27 company stacks and 12 developer stacks.

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.

What is HBase?

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.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Apache Hive?
Why do developers choose HBase?
    Be the first to leave a pro
      Be the first to leave a con
        Be the first to leave a con
        Jobs that mention Apache Hive and HBase as a desired skillset
        What companies use Apache Hive?
        What companies use HBase?

        Sign up to get full access to all the companiesMake informed product decisions

        What tools integrate with Apache Hive?
        What tools integrate with HBase?

        Sign up to get full access to all the tool integrationsMake informed product decisions

        What are some alternatives to Apache Hive and HBase?
        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.
        Presto
        Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
        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.
        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.
        Druid
        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
        Decisions about Apache Hive and HBase
        No stack decisions found
        Interest over time
        Reviews of Apache Hive and HBase
        No reviews found
        How developers use Apache Hive and HBase
        Avatar of Pinterest
        Pinterest uses HBaseHBase

        The final output is inserted into HBase to serve the experiment dashboard. We also load the output data to Redshift for ad-hoc analysis. For real-time experiment data processing, we use Storm to tail Kafka and process data in real-time and insert metrics into MySQL, so we could identify group allocation problems and send out real-time alerts and metrics.

        Avatar of Axibase
        Axibase uses HBaseHBase
        • Raw storage engine
        • Replication
        • Fault-tolerance
        Avatar of Mehdi TAZI
        Mehdi TAZI uses HBaseHBase

        Range scan and HDFS Buffering system

        Avatar of anerudhbalaji
        anerudhbalaji uses HBaseHBase

        Primary datastore

        How much does Apache Hive cost?
        How much does HBase cost?
        Pricing unavailable
        Pricing unavailable
        News about Apache Hive
        More news
        News about HBase
        More news