Connecting to Apache Drill

Drill is an Apache open-source SQL query engine for high-performance analysis on the semi-structured data coming from Big Data applications.

Before you start

To connect to Drill, you must gather the following:

• the correct authentication type (basic or none)
• username and password if using basic authentication
• the correct connection type (Direct to Drillbit embedded mode or Zookeeper Quorum distributed mode)
• host and port for Drillbit or each node if using distributed mode

  In distributed mode, host and port information must be entered in the Quorum field in comma-delimited format:

   <host name/ip address> : <port number>, <host name/ip address> : <port number>, . . .

• name of the Drillbit cluster if using distributed mode

For help gathering the connection prerequisites, contact the Apache Drill administrator in your organization. If your administrator cannot help you, you or your administrator should contact Apache Drill Support.

For advanced connection properties, see the Apache Drill online help on Configuring ODBC on Windows.

Create a Drill connection

1. From the Analytics main menu, select Import > Database and application.
2. From the New Connections tab, in the ACL Connectors section, select Apache Drill.

   Tip

   You can filter the list of available connectors by entering a search string in the Filter connections box. Connectors are listed alphabetically.

3. In the Data Connection Settings panel, enter the connection settings and at the bottom of the panel, click Save and Connect.

   You can accept the default Connection Name, or enter a new one.

The connection for Apache Drill is saved to the Existing Connections tab. In the future, you can reconnect to Apache Drill from the saved connection.

Once the connection is established, the Data Access window opens to the Staging Area and you can begin importing data. For help importing data from Apache Drill, see Import data using the Data Access window .