This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 4c9539e DRILL-6866
4c9539e is described below
commit 4c9539ed4688426c3a2e150c158d9cefc8169937
Author: Bridget Bevens <[email protected]>
AuthorDate: Fri Dec 21 12:21:44 2018 -0800
DRILL-6866
---
docs/configuring-the-drill-shell/index.html | 67 +++++++++++++++++---------
docs/installing-the-driver-on-linux/index.html | 4 +-
feed.xml | 4 +-
3 files changed, 47 insertions(+), 28 deletions(-)
diff --git a/docs/configuring-the-drill-shell/index.html
b/docs/configuring-the-drill-shell/index.html
index c96164d..ee4a6a0 100644
--- a/docs/configuring-the-drill-shell/index.html
+++ b/docs/configuring-the-drill-shell/index.html
@@ -1291,19 +1291,28 @@
</div>
- Nov 21, 2016
+ Dec 21, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
<div class="int_text" align="left">
- <p>After <a
href="/docs/starting-drill-on-linux-and-mac-os-x/">starting the Drill
shell</a>, 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 [...]
+ <p>Drill uses SQLLine as the Drill shell. SQLLine is a pure-Java
console-based utility for connecting to relational databases and running SQL
commands. </p>
-<p>Formatting tables takes time, which you might notice if running a huge
query using the default <code>outputFormat</code> setting, which is
<code>table</code> of the Drill shell. You can set another, more performant
table formatting such as <code>csv</code>, as shown in the <a
href="/docs/configuring-the-drill-shell/#examples-of-configuring-the-drill-shell">examples</a>.
</p>
+<p>Starting in Drill 1.15, Drill uses SQLLine 1.6, which you can customize
through the Drill <a
href="/docs/configuring-the-drill-shell/#customizing-sqlline-in-the-drill-sqlline-override.conf-file">configuration
file, drill-sqlline-override.conf</a>. Before installing and running Drill
with SQLLine 1.6, delete the old SQLLine history file The history file is
located in the following location: </p>
+
+<ul>
+<li>$HOME/.sqlline/history (UNIX, Linux, Mac OS)</li>
+<li>$HOME/sqlline/history (Windows) </li>
+</ul>
+
+<p>After <a href="/docs/starting-drill-on-linux-and-mac-os-x/">starting the
Drill shell</a>, 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. </p>
+
+<p>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 <a
href="/docs/configuring-the-drill-shell/#examples-of-configuring-the-drill-shell">examples</a>.
</p>
<h2 id="drill-shell-commands">Drill Shell Commands</h2>
-<p>The following table lists the commands that you can run on the Drill
command line.</p>
+<p>The following table lists the Drill shell commands that you can run from
the command line:</p>
<table><thead>
<tr>
@@ -1385,15 +1394,7 @@
</tr>
</tbody></table>
-<h2 id="example-of-hiding-the-password-when-starting-drill">Example of Hiding
the Password When Starting Drill</h2>
-
-<p>When starting Drill in authentication mode, you can use the
<strong>!connect</strong> command as shown in the section, <a
href="/docs/configuring-user-authentication/#user-authentication-process">"User
Authentication Process"</a>, instead of using a command such as
<strong>sqlline</strong>, <strong>drill-embedded</strong>, or
<strong>drill-conf</strong> commands. For example, after running the sqlline
script, you enter this command to connect to Drill:</p>
-
-<p><code>sqlline> !connect jdbc:drill:zk=localhost:2181</code> </p>
-
-<p>When prompted you enter a user name and password, which is hidden as you
type it.</p>
-
-<h2 id="examples-of-configuring-the-drill-shell">Examples of Configuring the
Drill Shell</h2>
+<h3 id="examples-of-configuring-the-drill-shell">Examples of Configuring the
Drill Shell</h3>
<p>For example, quit the Drill shell:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">0:
jdbc:drill:zk=local> !quit
@@ -1401,15 +1402,19 @@
<p>List the current connections. </p>
<div class="highlight"><pre><code class="language-text" data-lang="text">0:
jdbc:drill:zk=local> !list
1 active connection:
- #0 open jdbc:drill:zk=local
-</code></pre></div>
-<p>Set the maximum width of the Drill shell to 10000.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> 0:
jdbc:drill:zk=local> !set maxwidth 10000
-</code></pre></div>
-<p>Set the output format to CSV to improve performance of a huge query.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> 0:
jdbc:drill:zk=local> !set outputFormat csv
+ #0 open jdbc:drill:zk=local
</code></pre></div>
-<h2 id="the-set-command-variables">The Set Command Variables</h2>
+<h3 id="example-of-hiding-the-password-when-starting-drill">Example of Hiding
the Password When Starting Drill</h3>
+
+<p>When starting Drill in authentication mode, you can use the
<strong>!connect</strong> command as shown in the section, <a
href="/docs/configuring-user-authentication/#user-authentication-process">"User
Authentication Process"</a>, instead of using a command such as
<strong>sqlline</strong>, <strong>drill-embedded</strong>, or
<strong>drill-conf</strong> commands. For example, after running the sqlline
script, you enter this command to connect to Drill:</p>
+
+<p><code>sqlline> !connect jdbc:drill:zk=localhost:2181</code> </p>
+
+<p>When prompted you enter a user name and password, which is hidden as you
type it.</p>
+
+<h2 id="set-command-variables">Set Command Variables</h2>
+
+<p>The following table lists the set command variables that you can use with
the !set command:</p>
<table><thead>
<tr>
@@ -1421,7 +1426,7 @@
<tr>
<td>autoCommit</td>
<td>true/false</td>
-<td>Enable/disable automatic transaction commit. Should remain enabled
(true).</td>
+<td>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.</td>
</tr>
<tr>
<td>autoSave</td>
@@ -1540,9 +1545,23 @@
</tr>
</tbody></table>
-<h3 id="autocommit">autoCommit</h3>
+<h3 id="examples-of-the-set-command-with-variables">Examples of the set
Command with Variables</h3>
+
+<p>Set the maximum width of the Drill shell to 10000.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> 0:
jdbc:drill:zk=local> !set maxwidth 10000
+</code></pre></div>
+<p>Set the output format to CSV to improve performance of a huge query.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> 0:
jdbc:drill:zk=local> !set outputFormat csv
+</code></pre></div>
+<h2
id="customizing-sqlline-in-the-drill-sqlline-override-conf-file">Customizing
SQLLine in the drill-sqlline-override.conf File</h2>
+
+<p>Starting in Drill 1.15, SQLLine (the Drill shell) is upgraded to version
1.6. You can customize SQLLine through the Drill configuration file,
<code>drill-sqlline-override.conf</code>, located in the
<code><drill-installation>/conf</code> directory. </p>
+
+<p>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 <code>!set</code> from the Drill shell. </p>
+
+<p>Drill reads the <code>drill-sqlline-override.conf</code> 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. </p>
-<p>Drill performs read-only operations primarily, and autocommits writes.
Drill JDBC throws an exception if autoCommit is disabled.</p>
+<p><strong>Note:</strong> The SQLLine configuration file in the
<code><drill-installation>/conf</code> directory is named
<code>drill-sqlline-override-example.conf</code>. Use this file and the
information provided in the file as guidance for the
<code>drill-sqlline-override.conf</code> file you create and store in the
directory with your customizations.</p>
diff --git a/docs/installing-the-driver-on-linux/index.html
b/docs/installing-the-driver-on-linux/index.html
index 762d298..991ad38 100644
--- a/docs/installing-the-driver-on-linux/index.html
+++ b/docs/installing-the-driver-on-linux/index.html
@@ -1293,7 +1293,7 @@
</div>
- Aug 18, 2017
+ Dec 21, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1340,7 +1340,7 @@ application that you use to access Drill. The 64-bit
editions of Linux support
<h2 id="step-1-download-the-drill-odbc-driver">Step 1: Download the Drill ODBC
Driver</h2>
-<p>Download the driver from the <a
href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/";>download site</a>.
The current version is 1.3.8.</p>
+<p>Download the latest driver from the <a
href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/";>download site</a>.
</p>
<h2 id="step-2-install-the-drill-odbc-driver">Step 2: Install the Drill ODBC
Driver</h2>
diff --git a/feed.xml b/feed.xml
index a850376..28b0db1 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Thu, 20 Dec 2018 18:21:08 -0800</pubDate>
- <lastBuildDate>Thu, 20 Dec 2018 18:21:08 -0800</lastBuildDate>
+ <pubDate>Fri, 21 Dec 2018 12:18:07 -0800</pubDate>
+ <lastBuildDate>Fri, 21 Dec 2018 12:18:07 -0800</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>
