Apache Hive
hive.apache.org
- Free plan
- Open source
- Windows
- macOS
- Linux
- API
- Self-hosted
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.
Plans
Every plan and priceApache Hive
Open source
Getting started
- Open the Apache Hive website
- Follow the Docker quickstart for HiveServer2 and the Metastore
- Prepare a supported environment and required Java, Hadoop, Tez, Maven, and Protobuf versions
- Connect clients through JDBC or ODBC
- 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.