Ross ROSS = Recommend OSS · open-source software intelligence for agents

dropbox/PyHive

Python interface to Hive and Presto. 🐝 observed · 2026-08-28

github.com/dropbox/PyHive · Python · NOASSERTION (other) observed · 2026-08-28

Health v2 · maintenance only

57/100

  • Activity 77
  • Release rhythm 8
  • Longevity 100

Flags: no_license

How is this computed?

round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.

  • gap_med: n/a
  • age_days: 4596
  • days_rel: n/a
  • days_push: 142
  • n_releases_24m: 0

Full methodology

Adoption not part of the score

1693 stars · 545 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

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

library · maturity maintenance

database-driver orm databases big-data developer-tools python hive presto trino dbapi sqlalchemy hiveserver2

2 sources

Member repositories

RepositoryRoleHealth v2
dropbox/PyHivemain57

For agents

markdown · JSON · MCP: product_card(name="dropbox/PyHive")

Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem