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 <[email protected]>
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
