You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2018/12/21 20:16:46 UTC
[drill] branch gh-pages updated: DRILL-6866
This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
The following commit(s) were added to refs/heads/gh-pages by this push:
new 2f2528e DRILL-6866
2f2528e is described below
commit 2f2528e33bd8e9d13684afc869daeb4cca74d26b
Author: Bridget Bevens <bb...@maprtech.com>
AuthorDate: Fri Dec 21 12:15:01 2018 -0800
DRILL-6866
---
.../120-configuring-the-drill-shell.md | 68 +++++++++++++++-------
.../010-installing-the-driver-on-linux.md | 4 +-
2 files changed, 49 insertions(+), 23 deletions(-)
diff --git a/_docs/configure-drill/120-configuring-the-drill-shell.md b/_docs/configure-drill/120-configuring-the-drill-shell.md
index 6b7d3a8..7059133 100644
--- a/_docs/configure-drill/120-configuring-the-drill-shell.md
+++ b/_docs/configure-drill/120-configuring-the-drill-shell.md
@@ -1,16 +1,25 @@
---
title: "Configuring the Drill Shell"
-date: 2016-11-21 22:14:41 UTC
+date: 2018-12-21
parent: "Configure Drill"
----
-After [starting the Drill shell]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x/), you can type queries on the shell command line. At the Drill shell command prompt, typing "help" lists the configuration and other options you can set to manage shell functionality. Apache Drill 1.0 and later formats the resultset output tables for readability if possible. In this release, columns having 70 characters or more cannot be formatted. This document formats all output for readability [...]
+---
+Drill uses SQLLine as the Drill shell. SQLLine is a pure-Java console-based utility for connecting to relational databases and running SQL commands.
+
+Starting in Drill 1.15, Drill uses SQLLine 1.6, which you can customize through the Drill [configuration file, drill-sqlline-override.conf]({{site.baseurl}}/docs/configuring-the-drill-shell/#customizing-sqlline-in-the-drill-sqlline-override.conf-file). Before installing and running Drill with SQLLine 1.6, delete the old SQLLine history file The history file is located in the following location:
+
+
+- $HOME/.sqlline/history (UNIX, Linux, Mac OS)
+- $HOME/sqlline/history (Windows)
+
-Formatting tables takes time, which you might notice if running a huge query using the default `outputFormat` setting, which is `table` of the Drill shell. You can set another, more performant table formatting such as `csv`, as shown in the [examples]({{site.baseurl}}/docs/configuring-the-drill-shell/#examples-of-configuring-the-drill-shell).
+After [starting the Drill shell]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x/), you can run Drill shell commands and queries from the command line. Typing the shell command "!help" lists configuration and other options that you can set to manage shell functionality.
+
+Formatting tables takes time, which you may notice when running a huge query using the default outputFormat. The default outputFormat is “table.” You can set the outputFormat to a more performant table formatting, such as csv, as shown in the [examples]({{site.baseurl}}/docs/configuring-the-drill-shell/#examples-of-configuring-the-drill-shell).
## Drill Shell Commands
-The following table lists the commands that you can run on the Drill command line.
+The following table lists the Drill shell commands that you can run from the command line:
| Command | Description |
|---------------|---------------------------------------------------------------------------------------------------------------------------------------|
@@ -33,15 +42,9 @@ The following table lists the commands that you can run on the Drill command lin
| !tables | List all the tables in the database. |
| !verbose | Show unabbreviated error messages. |
-## Example of Hiding the Password When Starting Drill
-When starting Drill in authentication mode, you can use the **!connect** command as shown in the section, ["User Authentication Process"]({{site.baseurl}}/docs/configuring-user-authentication/#user-authentication-process), instead of using a command such as **sqlline**, **drill-embedded**, or **drill-conf** commands. For example, after running the sqlline script, you enter this command to connect to Drill:
-`sqlline> !connect jdbc:drill:zk=localhost:2181`
-
-When prompted you enter a user name and password, which is hidden as you type it.
-
-## Examples of Configuring the Drill Shell
+### Examples of Configuring the Drill Shell
For example, quit the Drill shell:
@@ -51,21 +54,23 @@ List the current connections.
0: jdbc:drill:zk=local> !list
1 active connection:
- #0 open jdbc:drill:zk=local
+ #0 open jdbc:drill:zk=local
-Set the maximum width of the Drill shell to 10000.
+### Example of Hiding the Password When Starting Drill
- 0: jdbc:drill:zk=local> !set maxwidth 10000
+When starting Drill in authentication mode, you can use the **!connect** command as shown in the section, ["User Authentication Process"]({{site.baseurl}}/docs/configuring-user-authentication/#user-authentication-process), instead of using a command such as **sqlline**, **drill-embedded**, or **drill-conf** commands. For example, after running the sqlline script, you enter this command to connect to Drill:
-Set the output format to CSV to improve performance of a huge query.
+`sqlline> !connect jdbc:drill:zk=localhost:2181`
+
+When prompted you enter a user name and password, which is hidden as you type it.
- 0: jdbc:drill:zk=local> !set outputFormat csv
-## The Set Command Variables
+## Set Command Variables
+The following table lists the set command variables that you can use with the !set command:
| Variable Name | Valid Variable Values | Description |
|-----------------|------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
-| autoCommit | true/false | Enable/disable automatic transaction commit. Should remain enabled (true). |
+| autoCommit | true/false | Enable/disable automatic transaction commit. Should remain enabled (true). Drill performs read-only operations primarily, and autocommit writes. Drill JDBC throws an exception if autoCommit is disabled. |
| autoSave | true/false | Automatically save preferences. |
| color | true/false | Control whether color is used for display. |
| fastConnect | true/false | Skip building table/column list for tab-completion. |
@@ -90,6 +95,27 @@ Set the output format to CSV to improve performance of a huge query.
| trimScripts | true/false | Remove trailing spaces from lines read from script files. |
| verbose | true/false | Show unabbreviated error messages and debug info. |
-### autoCommit
-Drill performs read-only operations primarily, and autocommits writes. Drill JDBC throws an exception if autoCommit is disabled.
+###Examples of the set Command with Variables
+Set the maximum width of the Drill shell to 10000.
+
+ 0: jdbc:drill:zk=local> !set maxwidth 10000
+
+Set the output format to CSV to improve performance of a huge query.
+
+ 0: jdbc:drill:zk=local> !set outputFormat csv
+
+## Customizing SQLLine in the drill-sqlline-override.conf File
+Starting in Drill 1.15, SQLLine (the Drill shell) is upgraded to version 1.6. You can customize SQLLine through the Drill configuration file, `drill-sqlline-override.conf`, located in the `<drill-installation>/conf` directory.
+
+You can customize quotes of the day; the quotes you see at the command prompt when starting Drill, such as “Just Drill it,” and you can override the SQLLine default properties. The SQLLine default properties are those that print when you run `!set` from the Drill shell.
+
+Drill reads the `drill-sqlline-override.conf` file and applies the customizations during start-up. You must restart Drill for the changes to take effect. The file remains in the directory and Drill applies the customizes at each restart.
+
+**Note:** The SQLLine configuration file in the `<drill-installation>/conf` directory is named `drill-sqlline-override-example.conf`. Use this file and the information provided in the file as guidance for the `drill-sqlline-override.conf` file you create and store in the directory with your customizations.
+
+
+
+
+
+
diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
index ce6be57..90b9d90 100644
--- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
+++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md
@@ -1,6 +1,6 @@
---
title: "Installing the Driver on Linux"
-date: 2017-08-18 17:48:00 UTC
+date: 2018-12-21
parent: "Installing the ODBC Driver"
---
Install the Drill ODBC Driver on the machine from which you connect to
@@ -37,7 +37,7 @@ Verify that your system meets the system requirements before you start.
To install the driver, you need Administrator privileges on the computer.
## Step 1: Download the Drill ODBC Driver
-Download the driver from the [download site](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/). The current version is 1.3.8.
+Download the latest driver from the [download site](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/).
## Step 2: Install the Drill ODBC Driver