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 2019/01/07 23:23:10 UTC
[drill-site] branch asf-site updated: doc updates and edits
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 1fed3cd doc updates and edits
1fed3cd is described below
commit 1fed3cd60169a6c9d55253b9e9082fbf7dd89bfe
Author: Bridget Bevens <bb...@maprtech.com>
AuthorDate: Mon Jan 7 15:22:54 2019 -0800
doc updates and edits
---
docs/apache-drill-1-15-0-release-notes/index.html | 6 +++---
docs/create-function-using-jar/index.html | 6 +++---
docs/create-table-as-ctas/index.html | 6 +++---
docs/create-view/index.html | 6 +++---
docs/drop-function-using-jar/index.html | 6 +++---
docs/drop-table/index.html | 6 +++---
docs/drop-view/index.html | 6 +++---
docs/interfaces-introduction/index.html | 6 +++---
docs/querying-system-tables/index.html | 4 ++--
docs/set/index.html | 6 +++---
docs/use/index.html | 6 +++---
feed.xml | 4 ++--
12 files changed, 34 insertions(+), 34 deletions(-)
diff --git a/docs/apache-drill-1-15-0-release-notes/index.html b/docs/apache-drill-1-15-0-release-notes/index.html
index f135649..0a79bc3 100644
--- a/docs/apache-drill-1-15-0-release-notes/index.html
+++ b/docs/apache-drill-1-15-0-release-notes/index.html
@@ -1318,16 +1318,16 @@
<li>New <a href="/docs/querying-system-tables/#querying-the-options-table">system options table</a>. (<a href="https://issues.apache.org/jira/browse/DRILL-6684">DRILL-6684</a>)</li>
<li>Support for <a href="/docs/date-time-functions-and-arithmetic/#timestampadd">TIMESTAMPADD</a> and <a href="/docs/date-time-functions-and-arithmetic/#timestampdiff">TIMESTAMPDIFF</a> datetime functions. (<a href="https://issues.apache.org/jira/browse/DRILL-3610">DRILL-3610</a>)</li>
<li>Ability to <a href="/docs/configuring-custom-acls-to-secure-znodes/">secure znodes with custom ACLs</a> (Access Control Lists) (<a href="https://issues.apache.org/jira/browse/DRILL-5671">DRILL-5671</a>).</li>
-<li>All cast and data type conversion functions return null for an empty string ('') when the <code>drill.exec.functions.cast_empty_string_to_null</code> option is enabled. (<a href="https://issues.apache.org/jira/browse/DRILL-6817">DRILL-6817</a>)</li>
+<li>All <a href="/docs/data-type-conversion/">cast and data type conversion functions</a> return null for an empty string ('') when the <code>drill.exec.functions.cast_empty_string_to_null</code> option is enabled. (<a href="https://issues.apache.org/jira/browse/DRILL-6817">DRILL-6817</a>)</li>
<li><a href="/docs/lexical-structure/">Storage plugin names are case-insensitive</a>. (<a href="https://issues.apache.org/jira/browse/DRILL-6492">DRILL-6492</a>)</li>
<li>Ability to access your AWS access key ID and secret access key using the Credential Provider API for the <a href="/docs/s3-storage-plugin/#using-an-external-provider-for-credentials">S3 storage plugin</a>. (<a href="https://issues.apache.org/jira/browse/DRILL-6662">DRILL-6662</a>)</li>
<li><a href="/docs/configuring-the-drill-shell/">Upgrade to SQLLine 1.6</a> includes the ability to add custom configuration. (<a href="https://issues.apache.org/jira/browse/DRILL-3853">DRILL-3853</a>)</li>
<li><a href="/docs/configuring-the-drill-shell/#sqlline-connection-parameters">New SQLLine connection parameters</a> (<a href="https://issues.apache.org/jira/browse/DRILL-3933">DRILL-3933</a>)</li>
-<li>New option, <code>exec.return_result_set_for_ddl</code>, prevents Drill from returning a result set for DDL statements when set to "false." Useful for clients tools that connect to Drill (via JDBC) if they do not expect a result set. (<a href="https://issues.apache.org/jira/browse/DRILL-6834">DRILL-6834</a>)</li>
+<li>New option, <code>exec.query.return_result_set_for_ddl</code>, <a href="/docs/interfaces-introduction/">prevents Drill from returning a result set for DDL statements</a> when set to "false." Useful for clients tools that connect to Drill (via JDBC) if they do not expect a result set. (<a href="https://issues.apache.org/jira/browse/DRILL-6834">DRILL-6834</a>)</li>
<li><a href="/docs/parquet-filter-pushdown/#parquet-filter-pushdown-for-varchar-and-decimal-data-types">Parquet filter pushdown for VARCHAR and DECIMAL data types</a> (<a href="https://issues.apache.org/jira/browse/DRILL-6744">DRILL-6744</a>)</li>
<li>Improved query performance with the <a href="https://drill.apache.org/docs/sort-based-and-hash-based-memory-constrained-operators/#disabling-the-hash-operators">semi-join functionality</a> inside the Hash-Join operator. (<a href="https://issues.apache.org/jira/browse/DRILL-6735">DRILL-6735</a>)</li>
<li><a href="https://drill.apache.org/docs/lateral-join/">Lateral join</a> functionality is enabled by default. (<a href="https://issues.apache.org/jira/browse/DRILL-6729">DRILL-6729</a>)</li>
-<li>Support JPPD (Join Predicate Push Down). (<a href="https://issues.apache.org/jira/browse/DRILL-6385">DRILL-6385</a>)</li>
+<li>Support JPPD (Join Predicate Push Down). <a href="https://issues.apache.org/jira/browse/DRILL-6385">DRILL-6385</a></li>
<li>Multiple <a href="/docs/planning-and-execution-options/#setting-options-from-the-drill-web-ui">Web UI improvements</a> to simplify the use of options and submit queries, including:
<ul>
diff --git a/docs/create-function-using-jar/index.html b/docs/create-function-using-jar/index.html
index 1c7da2e..c404d5d 100644
--- a/docs/create-function-using-jar/index.html
+++ b/docs/create-function-using-jar/index.html
@@ -1297,7 +1297,7 @@
</div>
- Dec 11, 2018
+ Jan 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1319,8 +1319,8 @@ The name of the JAR file that contains the UDFs.</p>
<ul>
<li><p>Before you issue the CREATE FUNCTION USING JAR command, you must Copy the UDF source and binary JAR files to the DFS staging directory. When you issue this command, Drill uses the JAR file name to register the JAR name in the Dynamic UDF registry (<a href="/docs/persistent-configuration-storage/">persistent store</a>) and then copies the source and binary JAR files to the local UDF directory on each drillbit upon request. </p></li>
-<li><p>By default, Drill returns a result set when you issue DDL statements, such as CREATE FUNCTION USING JAR. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.return_result_set_for_ddl` = false
+<li><p>By default, Drill returns a result set when you issue DDL statements, such as CREATE FUNCTION USING JAR. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.query.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.query.return_result_set_for_ddl` = false
//This option is available in Drill 1.15 and later.
</code></pre></div>
<p>When set to false, Drill returns the affected rows count, and the result set is null.</p></li>
diff --git a/docs/create-table-as-ctas/index.html b/docs/create-table-as-ctas/index.html
index 29fc35a..97369e6 100644
--- a/docs/create-table-as-ctas/index.html
+++ b/docs/create-table-as-ctas/index.html
@@ -1297,7 +1297,7 @@
</div>
- Dec 11, 2018
+ Jan 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1322,8 +1322,8 @@ A SELECT statement that needs to include aliases for ambiguous column names, suc
<h2 id="usage-notes">Usage Notes</h2>
<ul>
-<li><p>By default, Drill returns a result set when you issue DDL statements, such as CTAS. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.return_result_set_for_ddl` = false
+<li><p>By default, Drill returns a result set when you issue DDL statements, such as CTAS. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.query.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.query.return_result_set_for_ddl` = false
//This option is available in Drill 1.15 and later.
</code></pre></div>
<p>When set to false, Drill returns the affected rows count, and the result set is null. </p></li>
diff --git a/docs/create-view/index.html b/docs/create-view/index.html
index abf11e8..b16d4c1 100644
--- a/docs/create-view/index.html
+++ b/docs/create-view/index.html
@@ -1297,7 +1297,7 @@
</div>
- Dec 11, 2018
+ Jan 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1342,8 +1342,8 @@ A SELECT statement that defines the columns and rows in the view.</p>
<h2 id="usage-notes">Usage Notes</h2>
-<p>By default, Drill returns a result set when you issue DDL statements, such as CREATE VIEW. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.return_result_set_for_ddl` = false
+<p>By default, Drill returns a result set when you issue DDL statements, such as CREATE VIEW. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.query.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.query.return_result_set_for_ddl` = false
//This option is available in Drill 1.15 and later.
</code></pre></div>
<p>When set to false, Drill returns the affected rows count, and the result set is null.</p>
diff --git a/docs/drop-function-using-jar/index.html b/docs/drop-function-using-jar/index.html
index 08d3a1e..962155a 100644
--- a/docs/drop-function-using-jar/index.html
+++ b/docs/drop-function-using-jar/index.html
@@ -1297,7 +1297,7 @@
</div>
- Dec 11, 2018
+ Jan 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1319,8 +1319,8 @@ The name of the JAR file that contains the UDFs.</p>
<ul>
<li><p>When you issue the DROP FUNCTION USING JAR command, Drill unregisters the UDFs based on the JAR file name and removes the JAR file from the UDF directory. Drill deletes all UDFs associated with the JAR file from the Dynamic UDF registry (<a href="/docs/persistent-configuration-storage/">persistent store</a>). Drill returns a message with the list of unregistered UDFs. </p></li>
-<li><p>By default, Drill returns a result set when you issue DDL statements, such as DROP FUNCTION USING JAR. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.return_result_set_for_ddl` = false
+<li><p>By default, Drill returns a result set when you issue DDL statements, such as DROP FUNCTION USING JAR. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.query.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.query.return_result_set_for_ddl` = false
//This option is available in Drill 1.15 and later.
</code></pre></div>
<p>When set to false, Drill returns the affected rows count, and the result set is null. </p></li>
diff --git a/docs/drop-table/index.html b/docs/drop-table/index.html
index 24e5c7c..34305db 100644
--- a/docs/drop-table/index.html
+++ b/docs/drop-table/index.html
@@ -1297,7 +1297,7 @@
</div>
- Dec 11, 2018
+ Jan 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1323,8 +1323,8 @@ A unique directory or file name, optionally prefaced by a storage plugin name, s
<h2 id="usage-notes">Usage Notes</h2>
-<p>By default, Drill returns a result set when you issue DDL statements, such as DROP TABLE. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.return_result_set_for_ddl` = false
+<p>By default, Drill returns a result set when you issue DDL statements, such as DROP TABLE. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.query.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.query.return_result_set_for_ddl` = false
//This option is available in Drill 1.15 and later.
</code></pre></div>
<p>When set to false, Drill returns the affected rows count, and the result set is null.</p>
diff --git a/docs/drop-view/index.html b/docs/drop-view/index.html
index afeef6a..dd08961 100644
--- a/docs/drop-view/index.html
+++ b/docs/drop-view/index.html
@@ -1297,7 +1297,7 @@
</div>
- Dec 11, 2018
+ Jan 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1324,8 +1324,8 @@ A unique directory or file name, optionally prefaced by a storage plugin name, s
<h2 id="usage-notes">Usage Notes</h2>
<ul>
-<li><p>By default, Drill returns a result set when you issue DDL statements, such as DROP VIEW. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.return_result_set_for_ddl` = false
+<li><p>By default, Drill returns a result set when you issue DDL statements, such as DROP VIEW. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.query.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.query.return_result_set_for_ddl` = false
//This option is available in Drill 1.15 and later.
</code></pre></div>
<p>When set to false, Drill returns the affected rows count, and the result set is null. </p></li>
diff --git a/docs/interfaces-introduction/index.html b/docs/interfaces-introduction/index.html
index 53bab19..0354b4c 100644
--- a/docs/interfaces-introduction/index.html
+++ b/docs/interfaces-introduction/index.html
@@ -1295,7 +1295,7 @@
</div>
- Dec 11, 2018
+ Jan 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1313,8 +1313,8 @@
<p>*Apache Drill does not have an open source ODBC driver. However, MapR provides an <a href="https://package.mapr.com/tools/MapR-ODBC/MapR_Drill/">ODBC driver</a> developed specifically for connecting Apache Drill to BI tools. MapR also provides a <a href="https://package.mapr.com/tools/MapR-JDBC/MapR_Drill/">JDBC driver</a>. </p>
-<p>**By default, Drill returns a result set when you issue DDL statements, such as CTAS and CREATE VIEW. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.return_result_set_for_ddl` = false
+<p>**By default, Drill returns a result set when you issue DDL statements, such as CTAS and CREATE VIEW. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.query.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.query.return_result_set_for_ddl` = false
//This option is available in Drill 1.15 and later.
</code></pre></div>
<p>When set to false, Drill returns the affected rows count, and the result set is null. </p>
diff --git a/docs/querying-system-tables/index.html b/docs/querying-system-tables/index.html
index 70b0247..a49ef89 100644
--- a/docs/querying-system-tables/index.html
+++ b/docs/querying-system-tables/index.html
@@ -1295,7 +1295,7 @@
</div>
- Dec 10, 2018
+ Jan 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1525,7 +1525,7 @@ The maximum direct memory available to the allocator, in bytes.<br></li>
+---------------------------------------+----------------------------------------------------------------------------------+
| queryId | json |
+---------------------------------------+----------------------------------------------------------------------------------+
- | 23f4e2a7-5d60-a766-0b03-d7a03e99033e | {"id":{"part1":2590944894098909030,"part2":793715042592293694},"type":1,"start":1544232280280,"end":1544232280309,"query":"SELECT * FROM profiles_json LIMIT 0","plan":"00-00 Screen : rowType = RecordType(VARCHAR(65536) queryId, VARCHAR(65536) json): rowcount = 1.0, cumulative cost = {1.1 rows, 2.1 cpu, 1.0 io, 0.0 network, 0.0 memory}, id = 2115\ [...]
+ | 23f4e2a7-5d60-a766-0b03-d7a03e99033e | {"id":{"part1":2590944894098909030,"part2":793715042592293694},"type":1,"start":1544232280280,"end":1544232280309,"query":"SELECT * FROM profiles_json LIMIT 0","plan":"00-00 Screen : rowType = RecordType(VARCHAR(65536) queryId, VARCHAR(65536) json): rowcount = 1.0, cumulative cost = {1.1 rows, 2.1 cpu, 1.0 io, 0.0 network, 0.0 memory}, id = 2115\ [...]
+---------------------------------------+----------------------------------------------------------------------------------+
</code></pre></div>
<p>The profiles_json table provides the query profile in JSON format for all queries, by queryID. </p>
diff --git a/docs/set/index.html b/docs/set/index.html
index b3e9eb3..5b248a9 100644
--- a/docs/set/index.html
+++ b/docs/set/index.html
@@ -1297,7 +1297,7 @@
</div>
- Dec 11, 2018
+ Jan 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1322,8 +1322,8 @@ or float. Use the appropriate value type for each option that you set.</p>
<h2 id="usage-notes">Usage Notes</h2>
<ul>
-<li><p>By default, Drill returns a result set when you issue DDL statements, such as SET. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.return_result_set_for_ddl` = false
+<li><p>By default, Drill returns a result set when you issue DDL statements, such as SET. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.query.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `exec.query.return_result_set_for_ddl` = false
//This option is available in Drill 1.15 and later.
</code></pre></div>
<p>When set to false, Drill returns the affected rows count, and the result set is null. </p></li>
diff --git a/docs/use/index.html b/docs/use/index.html
index 82f3609..89d57ec 100644
--- a/docs/use/index.html
+++ b/docs/use/index.html
@@ -1297,7 +1297,7 @@
</div>
- Dec 11, 2018
+ Jan 7, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1354,8 +1354,8 @@ SCHEMAS to see a list of the configured storage plugins and workspaces. </p>
<hr>
<p><strong>NOTE</strong><br>
-By default, Drill returns a result set when you issue DDL statements, such as USE. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> SET `exec.return_result_set_for_ddl` = false
+By default, Drill returns a result set when you issue DDL statements, such as USE. If the client tool from which you connect to Drill (via JDBC) does not expect a result set when you issue DDL statements, set the <code>exec.query.return_result_set_for_ddl</code> option to false, as shown, to prevent the client from canceling queries: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> SET `exec.query.return_result_set_for_ddl` = false
//This option is available in Drill 1.15 and later.
</code></pre></div>
<p>When set to false, Drill returns the affected rows count, and the result set is null. </p>
diff --git a/feed.xml b/feed.xml
index 74a3eef..e846315 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, 03 Jan 2019 16:56:18 -0800</pubDate>
- <lastBuildDate>Thu, 03 Jan 2019 16:56:18 -0800</lastBuildDate>
+ <pubDate>Mon, 07 Jan 2019 15:20:49 -0800</pubDate>
+ <lastBuildDate>Mon, 07 Jan 2019 15:20:49 -0800</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>