Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Apache Hive

hive.apache.org

  • Free plan
  • Open source
  • Windows
  • macOS
  • Linux
  • API
  • Self-hosted
7.9 Club score Visit hive.apache.org

What Apache Hive is

Apache Hive is a distributed data warehouse system for reading, writing, and managing large datasets with SQL. Its Metastore centralizes table and partition metadata and serves clients such as Hive, Impala, and Spark. HiveServer2 supports concurrent clients through JDBC and ODBC. Hive supports full ACID transactions for ORC tables and insert-only transactions for other formats, and can use storage including S3, Azure Data Lake, and Google Cloud Storage. Apache Iceberg tables are supported through a StorageHandler. Named integrations include Spark, Presto, and Impala; Apache Ranger and Apache Atlas can support authorization, lineage, and governance. Security options described by the project include Kerberos, fine-grained access control, and audit logging, with LDAP, PAM, and custom authentication also listed for HiveServer2. A quickstart gives Docker instructions for HiveServer2 and the Metastore. Hive is open source, listed as free, and run by Apache Software Foundation volunteers. The project commonly uses Linux in production and Mac for development. Its 3.x release series reached end of life in October 2024, with no further updates or releases planned for that line.

Who it suits

Hive suits teams that need SQL access to large datasets and a data warehouse they can deploy themselves. Its listed integrations and security options may also suit environments using Spark, Impala, or Apache governance tools.

Good to know, and what to watch

  • SQL for reading, writing, and managing large datasets.
  • HiveServer2 supports concurrent JDBC and ODBC clients.
  • Supports ACID transactions for ORC tables.
  • Supports S3, Azure Data Lake, and Google Cloud Storage.
  • Open-source software listed as free.
  • Hive 3.x is end of life with no further updates.
  • Production use is commonly on Linux.
  • Current prerequisites include Java, Maven, Protobuf, Hadoop, and Tez.

Apache Hive

Free

Open source

Getting started

  1. Open the Apache Hive website
  2. Follow the Docker quickstart for HiveServer2 and the Metastore
  3. Prepare a supported environment and required Java, Hadoop, Tez, Maven, and Protobuf versions
  4. Connect clients through JDBC or ODBC
  5. Configure storage such as S3, Azure Data Lake, or Google Cloud Storage

Limits to check

Apache Hive is free and open source, but the 3.x release line is end of life and will receive no further updates or releases. Hive 4.2.x requires JDK 21 at minimum and works with Hadoop 3.4.1 and Tez 0.10.5.

The Club's review

Apache Hive is a distributed SQL warehouse for organizations managing large datasets across data-lake storage. It suits teams that need one metadata catalog shared by several query engines and can accommodate a substantial open-source deployment. The main trade-off is operational complexity: Java, Hadoop and Tez versions, plus release-line compatibility, need deliberate planning.

Overview

Hive separates storage and compute and supports S3, Azure Data Lake and Google Cloud Storage. That makes it practical for organizations that want SQL over data distributed across environments rather than a database tied to one storage system. Its fault-tolerant architecture is a strong fit for large-scale warehousing, while the prerequisite stack makes it less convenient than a self-contained service.

The project is an Apache Software Foundation top-level project maintained by volunteers, with mailing lists and community channels for participation. That community model suits teams comfortable operating open source; companies seeking a different support arrangement should account for that before choosing Hive.

Key features

SQL access and shared metadata

HiveServer2 handles multiple concurrent clients and provides JDBC and ODBC connectivity, so applications and analytics tools can use established SQL interfaces. Hive Metastore centralizes metadata for tables and partitions and serves Hive, Impala and Spark. This shared catalog is particularly valuable when several processing engines must see consistent definitions.

Transactions and storage

Hive supports full ACID transactions for ORC tables and insert-only transactions for other formats. Teams needing updates and deletes should therefore assess whether ORC fits their storage design; other formats have a narrower transaction model. Support for Iceberg tables through its StorageHandler extends Hive into modern lakehouse layouts.

Integration and governance

Named integrations include Spark, Presto and Impala. Apache Ranger provides authorization, while Apache Atlas is described for lineage and governance. Kerberos authentication, fine-grained access control and audit logging support controlled deployments; HiveServer2 also documents LDAP, PAM and custom authentication options. These choices help organizations with established identity and governance requirements, but they add configuration responsibility.

Deployment and compatibility

The official quickstart supports running HiveServer2 and Metastore in Docker containers. Production use is commonly on Linux, while Mac is commonly used for development; Windows is also listed as a platform. Current installation prerequisites include Java 8, Maven 3.6.3, Protobuf 2.5, Hadoop 3.3.6 and Tez. Hive 4.2.x instead requires JDK 21 and works with Hadoop 3.4.1 and Tez 0.10.5, so the selected release must be matched to its dependency set. The 3.x line reached end of life in October 2024 and will receive no further updates or releases.

Pricing

Apache Hive is free and open source. The Apache Hive plan costs nothing and provides the open-source data warehouse software. There are no paid tiers or seat charges stated. Its hybrid deployment model, separate storage and compute, data-lake support and streaming ingestion make the software suitable for teams prepared to supply their own infrastructure and operations; organizations wanting a managed service should compare alternatives instead.

Platforms

Hive is available through APIs and supports Linux, macOS, Windows and self-hosted deployment. Linux is the practical production target described by the installation guidance, with Mac positioned mainly for development. Container instructions can simplify an initial HiveServer2 and Metastore setup, but they do not remove the need to manage compatible Java, Hadoop and Tez versions.

Who it's for

Choose Hive when a data platform needs SQL over large datasets, a central catalog shared by Hive, Spark and Impala, and connections to cloud data-lake storage. It is also a strong candidate for organizations that require Kerberos, fine-grained authorization or audit logging and have the engineering capacity to run an open-source warehouse. It is less suitable for teams that want a turnkey, vendor-operated warehouse or cannot maintain version-sensitive infrastructure, especially if they are considering the unsupported 3.x line.

Pros and cons

Pros

  • Shared metadata: Hive Metastore gives multiple engines a common table and partition catalog.
  • Broad connectivity: HiveServer2 supports concurrent clients plus JDBC and ODBC.
  • Lake-oriented storage: S3, Azure Data Lake, Google Cloud Storage and Iceberg support preserve storage flexibility.
  • Enterprise controls: Kerberos, fine-grained access control, audit logging, Ranger and Atlas cover identity and governance needs.
  • No license fee: The software is free and open source.

Cons

  • Operational prerequisites: Java, Hadoop, Tez, Maven and Protobuf requirements demand careful environment management.
  • Uneven transaction coverage: Full ACID applies to ORC, while other formats support insert-only transactions.
  • Release risk: Hive 3.x is end of life, so adopters must plan around a supported release and its newer JDK requirements.
  • Self-managed responsibility: The free software leaves deployment, security configuration and ongoing operations to the user.

Alternatives

For a broader comparison, see Data Warehouse Software, Query Engine Software and OLAP Databases.

  • Exasol is worth considering when you want a freemium option with paid, pay-as-you-go compute plans.
  • Databend fits teams seeking a freemium warehouse with a free self-hosted Community plan and a paid Dedicated option.
  • Oracle Autonomous AI Lakehouse suits readers wanting an always-free lakehouse option alongside commercial capacity.
  • Teradata VantageCloud is an alternative for organizations evaluating a commercial lake and analytics platform.
  • Databricks Notebooks is aimed at web-based notebook workflows, including a limited free edition.
  • Firebolt offers a free self-hosted Core edition for teams that prefer that deployment model.
  • Snowflake CoCo is a paid platform with a free trial rather than a free product.
  • Yellowbrick Data Warehouse is a paid option with on-demand monthly billing.

Verdict

Apache Hive is a compelling choice for technically capable organizations that need open-source SQL warehousing, shared metadata and broad data-lake and engine integration without a license fee. Look elsewhere if you want managed operations, a simpler dependency footprint or a release path that avoids the 3.x end-of-life concern.

The verdict

Apache Hive provides SQL data warehousing with broad storage, integration, and security options. The 3.x end-of-life notice matters to teams selecting a release line.

Questions people ask

Is Apache Hive free?

Yes. The Apache Hive plan costs nothing and is open-source data warehouse software.

Which operating systems are supported?

The listed platforms are API, Linux, macOS, self-hosted, and Windows. The installation manual says Linux is common for production and Mac for development.

Can Hive connect to standard SQL tools?

Yes. HiveServer2 supports multiple concurrent clients and provides JDBC and ODBC connectivity.

Which storage systems and integrations are documented?

Hive documents S3, Azure Data Lake, and Google Cloud Storage, and supports Apache Iceberg tables through a StorageHandler. Named integrations include Spark, Presto, and Impala.

What security and governance options are available?

The project describes Kerberos, fine-grained access control, audit logging, LDAP, PAM, and custom authentication. Apache Ranger and Apache Atlas support authorization, lineage, and governance.

What the maker publishes

Authentication
HiveServer2 supports unauthenticated modes plus Kerberos, LDAP, PAM and pluggable custom authentication. source
Cloud storage
The homepage lists native support for Amazon S3, Azure Data Lake Storage and Google Cloud Storage. source
Deployment
The official quickstart provides Docker instructions for running HiveServer2 and the Metastore in a container. source
Developer connectivity
SourceForge states that Hive provides a command-line tool and JDBC driver for connecting to the system. source
Documentation depth
The documentation site provides tutorials, administration guides, configuration references and versioned Javadocs. source
Ecosystem integrations
The project homepage names Spark, Presto and Impala among integrations and says it connects with hundreds of other data-stack tools. source
Execution engines
Queries can execute through Apache Tez or MapReduce. source
Extensibility
Hive SQL supports user-defined functions for custom analysis. source
File formats
Supported formats include text, SequenceFile, RCFile, Avro, ORC, Parquet and custom input/output formats. source
HBase integration
HiveQL can read and write HBase tables and combine HBase tables with native Hive tables in joins and unions. source
Iceberg
Hive supports Apache Iceberg tables through its StorageHandler. source
Iceberg integration
Hive Iceberg tables support Parquet, ORC and Avro file formats and both Iceberg table format versions 1 and 2. source
Installation requirements
The current manual installation guide lists Java 8, Maven 3.6.3, Protobuf 2.5, Hadoop 3.3.6 and Tez as prerequisites. source
Integrations
The project site names Spark, Presto, and Impala as integrations; it also describes Apache Ranger for authorization and Apache Atlas for lineage and governance. source
Latest release news
Hive 4.2.1 was announced on August 24, 2026, fixing three security vulnerabilities involving Metastore partition paths, HiveServer2 SAML bearer authentication and Avro schema URLs. source
Licence
The source repository is distributed under the Apache License 2.0. source
Limit: deployment and maintenance
TrustRadius reviewers report that deployment, maintenance and support require substantial effort after infrastructure is established. source
Limit: latency and workload fit
TrustRadius reviewers mention slow complex joins, dependence on external storage and memory, poor fit for small datasets and limited OLTP suitability. source
Limit: query latency
G2 reviewers repeatedly identify high latency, especially for complex or real-time queries. source
Limit: transactional features
G2 reviewers report that Hive is not suitable for OLTP and lacks or limits row-level update and delete operations. source
Low-latency capability
Hive LLAP is documented as providing sub-second query retrieval with persistent query infrastructure and caching. source
Maker founding and headquarters
LinkedIn lists the Apache Software Foundation as founded in 1999 and headquartered in Wilmington, Delaware. source
Maker identity
The Apache Software Foundation is a nonprofit open-source software organization with 5,001–10,000 employees listed on LinkedIn. source
Metadata service
Hive Metastore provides a central metadata repository used in data-lake architectures. source

Checked against the maker's pages on 15 Oct 2026.