# apache/hive

Apache Hive

Repository: https://github.com/apache/hive
Canonical: https://ross.abutalabs.com/products/apache-hive
Homepage: https://hive.apache.org/
Language: Java
License: Apache-2.0
License Family: permissive
Topics: java, hive, database, sql, apache, big-data, hadoop
Last push: 2026-08-26T13:30:12+00:00

## Health v2 (maintenance only)
Score: 77/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 99, release rhythm 35, longevity 100
- inputs: {"age_days": 6314, "days_push": 7, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 6015, forks 4794 (observed 2026-08-28T04:09:34.280828+00:00)

## What it is
Apache Hive is a distributed, fault-tolerant data warehouse system that enables reading, writing, and managing petabytes of data in distributed storage using SQL. Built on Hadoop with Tez-based query execution, it includes the Hive Metastore as a central metadata repository and supports Iceberg tables, UDFs, and cloud object storage.

## Use cases
- run SQL analytics over petabytes of data in HDFS or S3
- set up a central metadata catalog for a data lake
- perform ETL and reporting on large distributed datasets
- query Iceberg tables with a SQL engine
- extend SQL with custom user-defined functions
- provide a metastore for Spark, Presto, or Trino

## When to choose
- you need SQL analytics at massive scale over distributed storage
- you want a battle-tested, enterprise-proven data warehouse with Kerberos security
- you need a central metastore shared across multiple query engines
- your workloads are OLAP/batch, not transactional

## When to avoid
- you need online transaction processing (OLTP) with low-latency writes
- your datasets are small enough for a single-node database like PostgreSQL
- you want a lightweight embedded analytics engine without Hadoop ecosystem dependencies

## Facets
- artifact type: application
- maturity: active
- function: database, etl, search-engine, analytics
- domain: big-data, databases, analytics
- platform: jvm, cloud
- tags: data-warehouse, sql, hadoop, hive-metastore, tez, iceberg, distributed-sql, olap, data-engineering, docker, linux

## Member repositories
- apache/hive (main) score 77

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:34.280828+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:49:45.775331+00:00, confidence not recorded.
  - readme: https://github.com/apache/hive (fetched 2026-08-28T04:09:34.280828+00:00, sha 338890c780e0)
  - homepage: https://hive.apache.org/ (fetched 2026-08-29T08:45:45.989298+00:00, sha 77a361e38d65)
  - site_page: https://hive.apache.org//docs/latest (fetched 2026-08-29T08:45:45.995811+00:00, sha c15409322f88)
  - site_page: https://hive.apache.org//docs/javadocs (fetched 2026-08-29T08:45:45.998561+00:00, sha 6b683019284f)
  - site_page: https://hive.apache.org/docs/latest/language/languagemanual (fetched 2026-08-29T08:45:46.000309+00:00, sha ff781287ac99)
  - site_page: https://hive.apache.org//development/quickstart (fetched 2026-08-29T08:45:46.001984+00:00, sha cfe506a40198)
  - site_page: https://hive.apache.org//development/designdocs (fetched 2026-08-29T08:45:46.004044+00:00, sha f2a4cb979332)
  - site_page: https://hive.apache.org//general/downloads (fetched 2026-08-29T08:45:45.991895+00:00, sha f84052f18afc)
  - site_page: https://hive.apache.org/community/resources/hivedeveloperfaq (fetched 2026-08-29T08:45:46.005813+00:00, sha c89985c3e4e4)
- Data as of 2026-08-30T08:39:29.467469+00:00.