PyHive is a collection of Python DB-API and SQLAlchemy interfaces for Presto and Hive.
First install this package to register it with SQLAlchemy (see setup.py
).
Note: query generation functionality is not exhaustive or fully tested, but there should be no problem with raw SQL.
Install using
pip install pyhive[hive]
for the Hive interface andpip install pyhive[presto]
for the Presto interface.
PyHive works with
- Python 2.7
- For Presto: Presto install
- For Hive: HiveServer2 daemon
There's also a third party Conda package.
Run the following in an environment with Hive/Presto:
./scripts/make_test_tables.sh
virtualenv --no-site-packages env
source env/bin/activate
pip install -e .
pip install -r dev_requirements.txt
py.test
WARNING: This drops/creates tables named one_row
, one_row_complex
, and many_rows
, plus a database called pyhive_test_database
.