Running a Drill Query from SQuirreL

About this task

Once SQuirreL is successfully connected to your cluster through the Drill JDBC Driver, you can issue queries from the SQuirreL client. Run a test query on some sample data included in the Drill installation 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 following query results display.

Results

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