Skip to main content

Python Driver for Apache Drill.

Project description

pydrill Documentation Status

Python Driver for Apache Drill.

Schema-free SQL Query Engine for Hadoop, NoSQL and Cloud Storage


  • Python 2/3 compatibility,
  • Support for all rest API calls inluding profiles/options/metrics docs with full list.
  • Mapping Results to internal python types,
  • Compatibility with Pandas data frame,
  • Drill Authentication using PAM,


Version from

$ pip install pydrill

Latest version from git:

$ pip install git+git://

Sample usage

from pydrill.client import PyDrill

drill = PyDrill(host='localhost', port=8047)

if not drill.is_active():
    raise ImproperlyConfigured('Please run Drill first')

yelp_reviews = drill.query('''

for result in yelp_reviews:
    print("%s: %s" %(result['type'], result['date']))

# pandas dataframe

df = yelp_reviews.to_dataframe()
print(df[df['stars'] > 3])


0.3.4 (2017-04-24)

  • Updated pypi listing long_description

0.3.3 (2017-04-24)

  • Fix pypi installation

0.3.2 (2017-04-18)

  • Support for dtype on to_dataframe

0.3.1 (2017-03-06)

  • Support for Drill Authentication using PAM

0.3 (2017-02-15)

  • requests response encoding (utf-8)
  • support Python 3.6 support

0.1.1 (2016-05-21)

  • Anaconda requirements fixed

0.1.0 (2016-05-19)

  • First minor release
  • Updated docs

0.0.2 (2016-04-24)

  • First release on PyPI.
  • Implementation of metrics/storage/options/stats
  • Builds are tested by docker container with Apache Drill running
  • support for pandas with ResultQuery.to_dataframe

0.0.1 (2015-12-28)

  • Project start

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for pydrill, version 0.3.4
Filename, size File type Python version Upload date Hashes
Filename, size pydrill-0.3.4.tar.gz (23.1 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page