Running a Drill Query from SQuirreL

Query sample data in Drill to verify that the SQuirreL client is successfully connected to the cluster through the Drill JDBC driver.

About this task

Run a test query on sample data to test the Drill connection.

To query sample data with Squirrel, complete the following steps:

Procedure

  1. Click the SQL tab.
  2. Enter the following query in the query box: SELECT * FROM cp.`employee.json`;
  3. Press Ctrl+Enter to run the query. The query results display.

Results

You have successfully run a Drill query from the SQuirreL client!