travis.yml for the test environment setup. Please fill out the Dropbox Contributor License Agreement at and note this in your pull request.Ĭhanges must come with tests, with the exception of trivial things like fixing comments.

Hence PyHive also supports pure-sasl via additional extras 'pyhive' which support Python 3.11. Note: 'pyhive' extras uses sasl that doesn’t support Python 3.11, See github issue. Pip install 'pyhive' for the Trino interface Pip install 'pyhive' for the Presto interface Pip install 'pyhive' or pip install 'pyhive' for the Hive interface connect () as con : data = [, ) Requirements create_all ( engine ) inspector = inspect ( engine ) inspector. from sqlalchemy import * from sqlalchemy.engine import create_engine from sqlalchemy.schema import * # Presto engine = create_engine ( 'presto://localhost:8080/hive/default' ) # Trino engine = create_engine ( 'trino+pyhive://localhost:8080/hive/default' ) # Hive engine = create_engine ( 'hive://localhost:10000/default' ) # SQLAlchemy = 2.0 metadata_obj = MetaData () books = Table ( 'books', metadata_obj, Column ( 'id', Integer ), Column ( 'title', String ), Column ( 'primary_author', String )) metadata_obj. execute ( 'SELECT * FROM my_awesome_data LIMIT 10', async_ = True ) SQLAlchemyįirst install this package to register it with SQLAlchemy, see entry_points in setup.py. In Python 3.7 async became a keyword you can use async_ instead: cursor. fetch_logs () for message in logs : print message # If needed, an asynchronous query can be cancelled at any time with: # cursor.cancel() status = cursor. operationState while status in ( TOperationState. execute ( 'SELECT * FROM my_awesome_data LIMIT 10', async = True ) status = cursor.

fetchall () DB-API (asynchronous) from pyhive import hive from TCLIService.ttypes import TOperationState cursor = hive. execute ( 'SELECT * FROM my_awesome_data LIMIT 10' ) print cursor. cursor () # or use nnect or use nnect cursor. Usage DB-API from pyhive import presto # or import hive or import trino cursor = presto.

PyHive is a collection of Python DB-API and

Free for mac instal The Hive