Bindaas Drill Provider

Bindaas supports Drill provider.

First make sure to download, install, and start Apache Drill.

DRILL_HOME/bin/drill-embedded

To test Apache Drill as the data source, first, populate it with sample data.

CREATE TABLE tmp.mytable (N_NAME, N_NATIONKEY) AS SELECT N_NATIONKEY, N_NAME FROM dfs.`/Users/llovizna/Applications/apache-drill-1.13.0/sample-data/nation.parquet`;

Now, you may configure Drill as a data source provider from the Bindaas admin dashboard. The username and password are optional and are required only if you have configured your Drill instance with authorization.

Now you may create a query API to query the sample data we populated in Apache Drill

select * from dfs.tmp.mytable

You may directly query files in Drill. However, they require use of the character "`" which is by default disabled in Bindaas due to its security policies.

You may also configure Drill itself to query data sources such as Mongo, MySQL, or HDFS. Thus, you can interface Bindaas to use Drill as a data source provider to query all these diverse data sources.

Drill's SQL support works fine for query APIs. However, Drill provides limited support for updates. Its updates are written as drop and create. Therefore, currently, Bindaas support for Drill is limited to query APIs.