acryl-pyhive

library0.6.18pypypi✓ verified 80d ago

A Python interface to Hive (and SparkSQL) via Thrift/HiveServer2. Fork of the original PyHive maintained by Acryl Data. Current version: 0.6.18. Release cadence is irregular; latest releases focus on bug fixes and compatibility.

database data

pip install acryl-pyhive

github ↗package ↗

INSTALL

IMPORT

SIG · ACRYL-PYHIVE

acryl-pyhive

databasepythonv0.6.18

Install

2.0s avg

Import

—

Disk

22MB

Pass rate

10/ 10

Env Coverage10 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v0.6.18 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.95 runs

installs and imports cleanly · install 0.0s · import 0.000s · 23.4MB

glibc

py 3.10–3.95 runs

installs and imports cleanly · install 2.0s · import 0.000s · 24MB

22MB installed

● package 22MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

hive

✓ import pyhive

✗ from pyhive import hive

Connects to Hive and runs a simple query.

from pyhive import hive conn = hive.HiveConnection( host='your-hive-server', port=10000, username='your-username', auth='NONE' ) cursor = conn.cursor() cursor.execute('SELECT 1') print(cursor.fetchone()) cursor.close() conn.close()

Debug

Known issues

breakingIn v0.6.15, the HTTP transport's handling of thrift headers changed; old code relying on mutable headers may break.

fix

Ensure headers are properly set before HTTP calls; do not assume they persist across requests.

affects: <0.6.15

gotchaPython 3.11+ may have issues with sasl library – the dependency now uses pure-sasl as a fallback.

fix

Install pure-sasl if you get import errors related to sasl.

affects: >=0.6.14

deprecatedThe 'database' parameter in HiveConnection is deprecated in favor of specifying schema in SQL.

fix

Use 'USE database_name' or specify schema in your queries.

affects: all?

gotchaDefault auth mechanism may differ from HiveServer2 expectations; using auth='NONE' works for unsecured clusters, but LDAP or KERBEROS require extra setup.

fix

Set auth parameter explicitly: 'NONE', 'LDAP', 'KERBEROS', or 'CUSTOM'.

affects: all

Upgrade

Version history

0.6.18latest on PyPI · released Feb 5, 2026

Audit

Dependencies

thriftrequiredRequired for Hive thrift connection.

pure-saslrequiredRequired for SASL authentication, especially on Python 3.11+.

pyhive[hive]optionalProvides hive dependency extras.

Agent activity

65 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/acryldata/PyHive ↗

packagehttps://pypi.org/project/acryl-pyhive/ ↗