Apache Drill dialect for SQLAlchemy.
The primary purpose of this is to have a working dialect for Apache Drill that can be used with Apache Superset.
Obviously, a working, robust dialect for Drill serves other purposes as well, but most of the iterative planning for this REPO will be based on working with Superset. Other changes will gladly be incorporated, as long as it doesn't hurt Superset integration.
Installing the dialect is straightforward. Simply:
- Clone or download this repository
- Navigate to the directory where you cloned the repo
- Run the python
Examples are shown below
git clone https://github.com/JohnOmernik/sqlalchemy-drill cd sqlalchemy-drill python3 setup.py install
To use Drill with SQLAlchemy you will need to craft a connection string in the format below:
To connect to Drill running on a local machine running in embedded mode you can use the following connection string.
Usage with Superset
For a complete tutorial on how to use Superset with Drill, read the tutorial on @cgivre's blog available here: http://thedataist.com/visualize-anything-with-superset-and-drill/.
Current Status/Development Approach
Currently we can connect to drill, and issue queries for most visualizations and get results. We also enumerate table columns for some times of tables. Here are things that are working as some larger issues to work out. (Individual issues are tracked under issues)
- Connection to Drill via the databases tab in Superset succeeds
- Table lists in the connection for some reason only show the first two qualifiers of drill tables. So if in the schema dfs.root you have two tables, table1 and table2, instead of showing table1 and table2 or dfs.root.table1 and dfs.root.table2, it will just show dfs.root and dfs.root. This is tracked in issue: https://github.com/JohnOmernik/sqlalchemy-drill/issues/3
- You can do basic queries for most types of viz/tables
- There may be issues with advanced queries/joins. As you learn about new ones, please track in issues
to drillpy and pydrill for code used in creating the
drilldbapi.py code for connecting!
Get the superset repo and then in
FROM supersetimage(not sure it's name) RUN git clone https://github.com/JohnOmernik/sqlalchemy-drill && cd sqlalchemy-drill && python3 setup.py install CMD["superset"]