Python Driver for Apache Drill.
Schema-free SQL Query Engine for Hadoop, NoSQL and Cloud Storage
- Free software: MIT license
- Documentation: https://pydrill.readthedocs.org.
- Python 2/3 compatibility,
- Mapping Results to internal python types,
- Compatibility with Pandas data frame,
from pydrill.client import PyDrill drill = PyDrill(host='localhost', port=8047) print drill.is_active() yelp_reviews = drill.query(''' SELECT * FROM `dfs.root`.`./Users/macbookair/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_review.json` LIMIT 5 ''') for result in yelp_reviews: print result['type'], result['date']