Starting Drill on Windows
Start the Drill shell using the sqlline command. Complete the following steps to launch the Drill shell:
- Open Command Prompt.
- Navigate to the Drill installation folder.
- Go to the
bindirectory. For example:
- Type the following command on the command line:
sqlline.bat -u "jdbc:drill:zk=local"
You can use the schema option in the sqlline command to specify a storage plugin. Specifying the storage plugin when you start up eliminates the need to specify the storage plugin in the query. For example, this command specifies the
dfs storage plugin:
C:\bin\sqlline sqlline.bat –u "jdbc:drill:zk=local;schema=dfs"
If you start Drill on one network, and then want to use Drill on another network, such as your home network, restart Drill.
Exiting the Drill Shell
To exit the Drill shell, issue the following command: