Starting the Web Console

Apr 19, 2018

The Drill Web Console is one of several client interfaces you can use to access Drill.

To open the Drill Web Console, launch a web browser, and go to one of the following URLs depending on the configuration of HTTPS support:

  • http://<IP address or host name>:8047
    Use this URL when HTTPS support is disabled (the default).
  • https://<IP address or host name>:8047
    Use this URL when HTTPS support is enabled.
  • http://localhost:8047
    Use this URL when running ./drill-embedded.

Drill 1.2 and Later

If user authentication is not enabled, all the Web Console controls appear to users as well as administrators:

Web Console

Note: As of Drill 1.12, users must enter a username to issue queries through the Query page in the Drill Web Console if user impersonation is enabled and authentication is disabled. To re-run a query from the Profiles page, users must also submit a username. See REST API for more information.

Note: As of Drill 1.13, an administrator can configure FORM and/or SPNEGO authentication mechanisms. The Drill Web Console provides two possible log in options for a user depending on the configuration. If a user selects FORM, s/he must enter their username and password to access restricted pages in the Drill Web Console. The user is authenticated through PAM. If the user selects SPNEGO, the user is automatically logged in if they are an authenticated Kerberos user. If accessing a protected page directly, the user is redirected to the authentication log in page.

If user authentication is enabled, Drill prompts you for a user name/password:

Web Console Login

If an administrator logs in, all the Web Console controls appear: Query, Profiles, Storage, Metrics, Threads, and Options. The Profiles page for administrators contains the profiles of all queries executed on a cluster. Only administrators can see and use the Storage tab to view, update, or add a new storage plugin configuration. Only administrators can see and use the Threads tab, which provides information about threads running in Drill.

Web Console Admin View

If a user, who is not an administrator, logs in, the Web Console controls are limited to Query, Metrics, and Profiles. The Profiles tab for a non-administrator user contains the profiles of all queries the user issued either through ODBC, JDBC, or the Web Console.

Web Console User View