Friday, September 2, 2016

Quickstart for SQL workbench connecting to Apache Drill cluster

Goal:

This is a quick start for using SQL workbench connecting to Apache Drill cluster.

Env:

Drill 1.6
SQL workbench Build 121 for Mac

Solution:

1. Download and Install SQL workbench for Mac from above link 

2. Download and copy the MapR Drill JDBC driver jar file to Mac

Following this MapR Doc link to get the download link for latest MapR Drill JDBC driver.
For example, current MapR Drill JDBC driver link is:
http://package.mapr.com/tools/MapR-JDBC/MapR_Drill/MapRDrill_jdbc_v1.4.0.1000/DrillJDBC41.zip

Download and unzip the jars into below location on your mac for example:
/Users/hzu/Downloads/maprdrilljdbc
Please note, all the jars from the zip file is needed in the next steps.

3. Add Drill JDBC Driver to SQL workbench

Click "Manage Driver" button and then "Create a new entry" to add Drill JDBC Driver:

4. Create a new Profile using above Drill JDBC Driver


And click "test" connection button:

 5. Open the Profile and run queries

6. Click "Show Dbtree" button to list all tables

7. Click "Database Explorer" button to explorer each table



No comments:

Post a Comment

Popular Posts