# dropbox/PyHive

Python interface to Hive and Presto. 🐝

Repository: https://github.com/dropbox/PyHive
Canonical: https://ross.abutalabs.com/products/pyhive
Language: Python
License: NOASSERTION
License Family: other
Topics: hive, python, hiveserver2, presto, dbapi, sqlalchemy
Last push: 2026-04-13T16:48:16+00:00

## Health v2 (maintenance only)
Score: 57/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 77, release rhythm 8, longevity 100
- inputs: {"age_days": 4596, "days_push": 142, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1693, forks 545 (observed 2026-08-28T04:05:23.402968+00:00)

## What it is
PyHive is a Python DB-API 2.0 and SQLAlchemy interface collection for Apache Hive, Presto, and Trino. It lets Python applications connect to and query these SQL engines, including asynchronous query execution and authentication options. The project has been donated to Apache Kyuubi.

## Use cases
- query Hive from Python scripts
- connect to Presto with a DB-API cursor
- use SQLAlchemy with Hive or Trino engines
- run asynchronous Hive queries and poll status
- authenticate to Hive over HTTPS with LDAP or basic auth
- fetch logs from running Hive queries

## When to choose
- you need a Python DB-API or SQLAlchemy driver for Hive, Presto, or Trino
- you want asynchronous query execution with log fetching against HiveServer2
- you want a maintained fork path via Apache Kyuubi

## When to avoid
- you need a driver for a different database like Postgres or MySQL
- you want an actively developed standalone project (development moved to Apache Kyuubi)
- you need a high-level analytics client rather than a low-level DB-API driver

## Facets
- artifact type: library
- maturity: maintenance
- function: database-driver, orm
- domain: databases, big-data, developer-tools
- platform: python
- tags: hive, presto, trino, dbapi, sqlalchemy, hiveserver2

## Member repositories
- dropbox/PyHive (main) score 57

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:23.402968+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-30T03:38:11.349363+00:00, confidence not recorded.
  - readme: https://github.com/dropbox/PyHive (fetched 2026-08-28T04:05:23.402968+00:00, sha e2a277fd1a9c)
  - registry_pypi: https://pypi.org/pypi/pyhive/json (fetched 2026-08-29T11:13:06.333632+00:00, sha a7192ca4e8e1)
- Data as of 2026-08-30T08:39:29.467469+00:00.