You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by dz...@apache.org on 2021/09/20 12:00:06 UTC
[drill-site] branch master updated: Update edit page links from
drill/gh-pages to drill-site/master.
This is an automated email from the ASF dual-hosted git repository.
dzamo pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/master by this push:
new 25c6997 Update edit page links from drill/gh-pages to drill-site/master.
25c6997 is described below
commit 25c69973ab4bcb8696e797bb94967231b59afb1c
Author: James Turton <ja...@somecomputer.xyz>
AuthorDate: Mon Sep 20 13:59:35 2021 +0200
Update edit page links from drill/gh-pages to drill-site/master.
---
README.md | 2 +-
.../configuration-options/020-start-up-options.md | 41 ++++++++++++++++------
.../sql-reference/sql-commands/071-lateral-join.md | 4 ++-
.../sql-functions/021-data-type-functions.md | 4 ++-
_layouts/docpage.html | 2 +-
5 files changed, 39 insertions(+), 14 deletions(-)
diff --git a/README.md b/README.md
index a8bbb9b..7caac9c 100644
--- a/README.md
+++ b/README.md
@@ -1,4 +1,4 @@
-**N.B.** As of 2021-08-27, documentation is no longer kept in drill/gh-pages. All documentation, including both the source Markdown and the generated HTML is now kept in this repository.
+**N.B.** As of 2021-08-27, documentation is no longer kept in drill/gh-pages. All documentation, including both the source Markdown and the generated HTML is now kept in this repository. To contribute documentation please send a pull request containing your edits to the master branch of this repository.
The Apache Drill website is built by [Jekyll](http://jekyllrb.com/) from Markdown sources in designated branches of this repository. The build process flows from left to right in the following table.
diff --git a/_docs/en/configure-drill/configuration-options/020-start-up-options.md b/_docs/en/configure-drill/configuration-options/020-start-up-options.md
index 3ec7280..49151ea 100644
--- a/_docs/en/configure-drill/configuration-options/020-start-up-options.md
+++ b/_docs/en/configure-drill/configuration-options/020-start-up-options.md
@@ -47,7 +47,10 @@ You can configure start-up options for each Drillbit in `<drill_home>/conf/drill
The summary of start-up options, also known as boot options, lists default values. The following descriptions provide more detail on key options that are frequently reconfigured:
* **store.parquet.complex.batch.num_records**
- Introduced in Drill 1.15. Sets batch sizing (number of rows per batch) for the Parquet reader. The default value is 4,000 rows. If rows are large and queries return out-of-memory errors, reduce the value. You can set this option at the system level in `<drill_home>/conf/drill-override.conf` or at the session level using the SET command, as shown:
+
+**Introduced in release:** 1.15.
+
+Sets batch sizing (number of rows per batch) for the Parquet reader. The default value is 4,000 rows. If rows are large and queries return out-of-memory errors, reduce the value. You can set this option at the system level in `<drill_home>/conf/drill-override.conf` or at the session level using the SET command, as shown:
SET `store.parquet.complex.batch.num_records`=2000;
|-------|---------------------------------------------------|
@@ -56,8 +59,11 @@ The summary of start-up options, also known as boot options, lists default value
| true | store.parquet.complex.batch.num_records updated. |
|-------|---------------------------------------------------|
-* **drill.exec.http.ssl_enabled**
- Introduced in Drill 1.2. Enables or disables [HTTPS support]({{site.baseurl}}/docs/configuring-web-console-and-rest-api-security/#https-support). Settings are TRUE and FALSE, respectively. The default is FALSE.
+* **drill.exec.http.ssl_enabled**
+
+**Introduced in release:** 1.2.
+
+Enables or disables [HTTPS support]({{site.baseurl}}/docs/configuring-web-console-and-rest-api-security/#https-support). Settings are TRUE and FALSE, respectively. The default is FALSE.
* **drill.exec.sys.store.provider.class**
Defines the persistent storage (PStore) provider. The [PStore]({{site.baseurl}}/docs/persistent-configuration-storage) holds configuration and profile data.
@@ -65,24 +71,39 @@ The summary of start-up options, also known as boot options, lists default value
* **drill.exec.buffer.size**
Defines the amount of memory available, in terms of record batches, to hold data on the downstream side of an operation. Drill pushes data downstream as quickly as possible to make data immediately available. This requires Drill to use memory to hold the data pending operations. When data on a downstream operation is required, that data is immediately available so Drill does not have to go over the network to process it. Providing more memory to this option increases the speed at which [...]
-* **drill.exec.spill.fs**
- Introduced in Drill 1.11. The default file system on the local machine into which the Sort, Hash Aggregate, and Hash Join operators spill data. This is the recommended option to use for spilling. You can configure this option so that data spills into a distributed file system, such as hdfs. For example, "hdfs:///". The default setting is "file:///". See [Sort-Based and Hash-Based Memory Constrained Operators]({{site.baseurl}}/docs/sort-based-and-hash-based-memory-constrained-operators/ [...]
+* **drill.exec.spill.fs**
+
+**Introduced in release:** 1.11.
+
+The default file system on the local machine into which the Sort, Hash Aggregate, and Hash Join operators spill data. This is the recommended option to use for spilling. You can configure this option so that data spills into a distributed file system, such as hdfs. For example, "hdfs:///". The default setting is "file:///". See [Sort-Based and Hash-Based Memory Constrained Operators]({{site.baseurl}}/docs/sort-based-and-hash-based-memory-constrained-operators/) for more information.
* **drill.exec.spill.directories**
- Introduced in Drill 1.11. The list of directories into which the Sort, Hash Aggregate, and Hash Join operators spill data. The list must be an array with directories separated by a comma, for example ["/fs1/drill/spill" , "/fs2/drill/spill" , "/fs3/drill/spill"]. This is the recommended option for spilling to multiple directories. The default setting is ["/tmp/drill/spill"]. See [Sort-Based and Hash-Based Memory Constrained Operators]({{site.baseurl}}/docs/sort-based-and-hash-based-mem [...]
+
+**Introduced in release:** 1.11.
+
+The list of directories into which the Sort, Hash Aggregate, and Hash Join operators spill data. The list must be an array with directories separated by a comma, for example ["/fs1/drill/spill" , "/fs2/drill/spill" , "/fs3/drill/spill"]. This is the recommended option for spilling to multiple directories. The default setting is ["/tmp/drill/spill"]. See [Sort-Based and Hash-Based Memory Constrained Operators]({{site.baseurl}}/docs/sort-based-and-hash-based-memory-constrained-operators/) [...]
* **drill.exec.zk.connect**
Provides Drill with the ZooKeeper quorum to use to connect to data sources. Change this setting to point to the ZooKeeper quorum that you want Drill to use. You must configure this option on each Drillbit node.
* **drill.exec.profiles.store.inmemory**
- Introduced in Drill 1.11. When set to TRUE, enables Drill to store query profiles in memory instead of writing the query profiles to disk. When set to FALSE, Drill writes the profile for each query to disk, which is either the local file system or a distributed file system, such as HDFS. For sub-second queries, writing the query profile to disk is expensive due to the interactions with the file system. Enable this option if you want Drill to store the profiles of sub-second queries in [...]
+
+**Introduced in release:** 1.11.
+
+When set to TRUE, enables Drill to store query profiles in memory instead of writing the query profiles to disk. When set to FALSE, Drill writes the profile for each query to disk, which is either the local file system or a distributed file system, such as HDFS. For sub-second queries, writing the query profile to disk is expensive due to the interactions with the file system. Enable this option if you want Drill to store the profiles of sub-second queries in memory instead of writing th [...]
* **drill.exec.profiles.store.capacity**
- Introduced in Drill 1.11. Sets the maximum number of most recent profiles to retain in memory when the `drill.exec.profiles.store.inmemory` option is enabled. Default is 1000.
+
+**Introduced in release:** 1.11.
+
+Sets the maximum number of most recent profiles to retain in memory when the `drill.exec.profiles.store.inmemory` option is enabled. Default is 1000.
* **drill.exec.storage.action\_on\_plugins\_override\_file**
- Introduced in Drill 1.14. Determines what happens to the [`storage-plugins-override.conf`]({{site.baseurl}}/docs/configuring-storage-plugins/#configuring-storage-plugins-with-the-storage-plugins-override.conf-file) file after Drill successfully updates storage plugin configurations. If you do not want Drill to apply the configurations after restarting, set the option to `"rename"` or `"remove"`. This option accepts the following values:
+
+**Introduced in release:** 1.14.
+
+Determines what happens to the [`storage-plugins-override.conf`]({{site.baseurl}}/docs/configuring-storage-plugins/#configuring-storage-plugins-with-the-storage-plugins-override.conf-file) file after Drill successfully updates storage plugin configurations. If you do not want Drill to apply the configurations after restarting, set the option to `"rename"` or `"remove"`. This option accepts the following values:
- `"none"` - (Default) The file remains in the directory after Drill uses the file.
- `"rename"` - The `storage-plugins-override.conf` file name is changed to `storage-plugins-override-[current_timestamp].conf` after Drill uses the file.
- - `"remove"` - The file is removed after Drill uses the file for the first time.
\ No newline at end of file
+ - `"remove"` - The file is removed after Drill uses the file for the first time.
diff --git a/_docs/en/sql-reference/sql-commands/071-lateral-join.md b/_docs/en/sql-reference/sql-commands/071-lateral-join.md
index 3bc330a..f8b8efc 100644
--- a/_docs/en/sql-reference/sql-commands/071-lateral-join.md
+++ b/_docs/en/sql-reference/sql-commands/071-lateral-join.md
@@ -4,7 +4,9 @@ slug: "LATERAL Join"
parent: "SQL Commands"
---
-Starting in Drill 1.15, the lateral join functionality is enabled by default. If you are running earlier versions of Drill, use the [SET]({{site.baseurl}}/docs/set/) command to enable the `planner.enable_unnest_lateral` option.
+**Introduced in release:** 1.15
+
+The lateral join functionality is enabled by default. If you are running earlier versions of Drill, use the [SET]({{site.baseurl}}/docs/set/) command to enable the `planner.enable_unnest_lateral` option.
A lateral join is essentially a foreach loop in SQL. A lateral join is represented by the keyword LATERAL with an inner subquery in the FROM clause, as shown in the following simple representation:
diff --git a/_docs/en/sql-reference/sql-functions/021-data-type-functions.md b/_docs/en/sql-reference/sql-functions/021-data-type-functions.md
index d5db800..4faf705 100644
--- a/_docs/en/sql-reference/sql-functions/021-data-type-functions.md
+++ b/_docs/en/sql-reference/sql-functions/021-data-type-functions.md
@@ -4,7 +4,9 @@ slug: "Data Type Functions"
parent: "SQL Functions"
---
-Starting in Drill 1.14, Drill supports the following functions that return data type information:
+**Introduced in release:** 1.14
+
+Drill supports the following functions that return data type information:
**sqlTypeOf()**
Returns the data type of a column (using the SQL names) whether the column is NULL or not. You can use the SQL name in a CAST statement, for example:
diff --git a/_layouts/docpage.html b/_layouts/docpage.html
index 08190ac..56ac1ca 100644
--- a/_layouts/docpage.html
+++ b/_layouts/docpage.html
@@ -11,7 +11,7 @@ title: Documentation
<div class="main-content">
{% if page.relative_path %}
- <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/{{ page.relative_path }}" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+ <a class="edit-link" href="https://github.com/apache/drill-site/blob/master/{{ page.relative_path }}" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
{% endif %}
<div class="int_title left">