Apache Drill

https://drill.apache.org/

Apache Drill is a schema-free SQL query engine for Hadoop and NoSQL.

Installation

Required packages: sqlalchemy-drill

Drivers

SQLAlchemy (REST)Recommended

JDBC

ODBC

PyPI Package: sqlalchemy-drill

drill+sadrill://{username}:{password}@{host}:{port}/{storage_plugin}?use_ssl=True

Connection Examples

Local embedded mode

drill+sadrill://localhost:8047/dfs?use_ssl=False

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 50/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Help improve this documentation by editing the engine spec:

Edit drill.py