- Home
- Query Engine Software
- Apache Hive
Apache Hive
What it is
Apache Hive is a distributed data warehouse system for reading, writing, and managing large datasets with SQL. Its Metastore holds central metadata for tables and partitions and serves clients such as Hive, Impala, and Spark. HiveServer2 allows concurrent clients and supports JDBC and ODBC connections. Hive provides full ACID transactions for ORC tables and insert-only transactions for other formats. The project lists S3, Azure Data Lake, and Google Cloud Storage support, as well as Apache Iceberg tables through a StorageHandler. Named integrations include Spark, Presto, and Impala; Apache Ranger supports authorization, while Apache Atlas handles 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 provides Docker instructions for HiveServer2 and the Metastore. Hive is open source and maintained by Apache Software Foundation volunteers. The project says Hive 3.x reached end of life in October 2024, with no more updates or releases planned for that series.
For and against
For
- SQL-based management of large datasets.
- HiveServer2 supports JDBC and ODBC clients.
- Supports full ACID transactions for ORC tables.
- Storage options include S3 and Azure Data Lake.
- Docker quickstart covers HiveServer2 and Metastore.
Against
- Hive 3.x is end of life.
- Hive 4.2.x requires JDK 21 at minimum.
- Production use is commonly on Linux.
The verdict
Apache Hive provides SQL data warehouse capabilities with metadata management, client connectivity, transactions, and integrations. Users should distinguish the end-of-life 3.x series from the project’s current release requirements.
Who it suits
Apache Hive suits teams managing large datasets with SQL and connecting warehouse clients, storage, and related tools. Linux is commonly used in production, while Mac is commonly used for development.
Plans and prices
Apache Hive
Open-source data warehouse software
Read 4 Oct 2026 · hive.apache.org
On the record
- Authentication
- HiveServer2 supports unauthenticated modes plus Kerberos, LDAP, PAM and pluggable custom authentication.hive.apache.org · read 15 Oct 2026
- Cloud storage
- The homepage lists native support for Amazon S3, Azure Data Lake Storage and Google Cloud Storage.hive.apache.org · read 15 Oct 2026
- Deployment
- The official quickstart provides Docker instructions for running HiveServer2 and the Metastore in a container.hive.apache.org · read 4 Oct 2026
- Developer connectivity
- SourceForge states that Hive provides a command-line tool and JDBC driver for connecting to the system.sourceforge.net · read 15 Oct 2026
- Documentation depth
- The documentation site provides tutorials, administration guides, configuration references and versioned Javadocs.hive.apache.org · read 15 Oct 2026
- Ecosystem integrations
- The project homepage names Spark, Presto and Impala among integrations and says it connects with hundreds of other data-stack tools.hive.apache.org · read 15 Oct 2026
- Execution engines
- Queries can execute through Apache Tez or MapReduce.hive.apache.org · read 15 Oct 2026
- Extensibility
- Hive SQL supports user-defined functions for custom analysis.hive.apache.org · read 15 Oct 2026
- File formats
- Supported formats include text, SequenceFile, RCFile, Avro, ORC, Parquet and custom input/output formats.hive.apache.org · read 15 Oct 2026
- HBase integration
- HiveQL can read and write HBase tables and combine HBase tables with native Hive tables in joins and unions.hive.apache.org · read 15 Oct 2026
- Iceberg
- Hive supports Apache Iceberg tables through its StorageHandler.hive.apache.org · read 4 Oct 2026
- Iceberg integration
- Hive Iceberg tables support Parquet, ORC and Avro file formats and both Iceberg table format versions 1 and 2.hive.apache.org · read 15 Oct 2026
- 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.hive.apache.org · read 15 Oct 2026
- 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.hive.apache.org · read 4 Oct 2026
- 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.hive.apache.org · read 15 Oct 2026
- Licence
- The source repository is distributed under the Apache License 2.0.github.com · read 15 Oct 2026
- Limit: deployment and maintenance
- TrustRadius reviewers report that deployment, maintenance and support require substantial effort after infrastructure is established.trustradius.com · read 15 Oct 2026
- 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.trustradius.com · read 15 Oct 2026
