This is an automated email from the ASF dual-hosted git repository.
git-site-role 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 d3bfa7a51 Automatic Site Publish by Buildbot
d3bfa7a51 is described below
commit d3bfa7a516f86f9e9cf8045e452122d8b411d4ae
Author: buildbot <[email protected]>
AuthorDate: Fri Mar 3 14:27:08 2023 +0000
Automatic Site Publish by Buildbot
---
output/docs/data-type-conversion/index.html | 15 ++++++++++++---
output/docs/date-time-functions-and-arithmetic/index.html | 4 ++--
output/docs/file-system-storage-plugin/index.html | 14 +++++++-------
output/feed.xml | 4 ++--
output/zh/docs/data-type-conversion/index.html | 15 ++++++++++++---
.../zh/docs/date-time-functions-and-arithmetic/index.html | 4 ++--
output/zh/docs/file-system-storage-plugin/index.html | 14 +++++++-------
output/zh/feed.xml | 4 ++--
8 files changed, 46 insertions(+), 28 deletions(-)
diff --git a/output/docs/data-type-conversion/index.html
b/output/docs/data-type-conversion/index.html
index d04f58a2b..a1a8f5201 100644
--- a/output/docs/data-type-conversion/index.html
+++ b/output/docs/data-type-conversion/index.html
@@ -2115,7 +2115,7 @@ use in your Drill queries as described in this
section:</p>
<td>DECIMAL</td>
</tr>
<tr>
- <td><a
href="/docs/data-type-conversion/#to_timestamp">TO_TIMESTAMP</a>(VARCHAR,
format)</td>
+ <td><a
href="/docs/data-type-conversion/#to_timestamp">TO_TIMESTAMP</a>(VARCHAR [,
format])</td>
<td>TIMESTAMP</td>
</tr>
<tr>
@@ -2620,7 +2620,7 @@ SELECT TO_NUMBER('12345', '##0.##E0') FROM (VALUES(1));
<p><em>expression</em> is a character string enclosed in single quotation
marks or a UNIX epoch timestamp, not enclosed in single quotation marks.</p>
-<p><em>‘format’</em> is a character string that specifies the format of
<em>expression</em>. Only use this option when the <em>expression</em> is a
character string, not a UNIX epoch timestamp.</p>
+<p><em>‘format’</em> is an optional character string that specifies the format
of <em>expression</em>. Only use this option when the <em>expression</em> is a
character string, not a UNIX epoch timestamp. If <em>expression</em> is a
character string and <em>format</em> is not provided then the function will use
a set of heuristics to try to detect the date format automatically. If that
attempt fails then null is returned.</p>
<h3 id="to_timestamp-usage-notes">TO_TIMESTAMP Usage Notes</h3>
<p>Specify a format using patterns defined in <a
href="http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html";>Joda
DateTimeFormat class</a>. The TO_TIMESTAMP function takes a Unix epoch
timestamp. The TO_DATE function takes a UNIX epoch timestamp in
milliseconds.</p>
@@ -2663,7 +2663,7 @@ FROM (VALUES(1));
1 row selected (0.148 seconds)
</code></pre></div></div>
-<p>Convert an ISO-8601 timestamp string to a timestamp. The ISO-8601 format
differs from the ANSI SQL timestamp format and must be explicitly parsed. Note
the escaped single quotes (‘’) required to place the separator character ‘T’
into the format string.</p>
+<p>Convert an ISO-8601 timestamp string to a timestamp. The ISO-8601 format
differs from the ANSI SQL timestamp format and cannot be cast but must be
explicitly parsed. Note the escaped single quotes (‘’) required to place the
separator character ‘T’ into the format string.</p>
<div class="language-sql highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="k">select</span> <span
class="n">to_timestamp</span><span class="p">(</span><span
class="s1">'2023-02-24T11:21:55'</span><span class="p">,</span> <span
class="s1">'YYYY-MM-dd</span><span class="se">''</span><span
class="s1">T</span><span class="se">''</span><span
class="s1">HH:mm:ss'</span><span class="p">);</span>
</code></pre></div></div>
@@ -2672,6 +2672,15 @@ FROM (VALUES(1));
1 row selected (0.163 seconds)
</code></pre></div></div>
+<p>Use TO_TIMESTAMP with automatic format detection to parse an IS0-8601
timestamp.</p>
+
+<div class="language-sql highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="k">select</span> <span
class="n">to_timestamp</span><span class="p">(</span><span
class="s1">'2023-02-24T11:21:55'</span><span class="p">);</span>
+</code></pre></div></div>
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>EXPR$0 2023-02-24 11:21:55.0
+
+1 row selected (0.151 seconds)
+</code></pre></div></div>
+
<h2 id="enabling-time-zone-offset">Enabling Time Zone Offset</h2>
<p>Starting in Drill 1.16, the <code class="language-plaintext
highlighter-rouge">store.hive.maprdb_json.read_timestamp_with_timezone_offset</code>
option enables Drill to read timestamp values with a timezone offset when
using the hive plugin with the Drill native MaprDB JSON reader enabled through
the <code class="language-plaintext
highlighter-rouge">store.hive.maprdb_json.optimize_scan_with_native_reader
option</code>. The <code class="language-plaintext highlighter-rouge">store.hiv
[...]
diff --git a/output/docs/date-time-functions-and-arithmetic/index.html
b/output/docs/date-time-functions-and-arithmetic/index.html
index 97cbc82fc..06eedd69e 100644
--- a/output/docs/date-time-functions-and-arithmetic/index.html
+++ b/output/docs/date-time-functions-and-arithmetic/index.html
@@ -2300,11 +2300,11 @@ SELECT ISDATE('foobar');
<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>component FROM (timestamp | time | date | interval)
</code></pre></div></div>
-<p><em>component</em> is one of the following time units: year, month, day,
hour, minute, second.</p>
+<p><em>component</em> is one of the following time units: year, quarter,
month, week, day, dayofweek, dayofyear, epoch, hour, minute, second.</p>
<h3 id="extract-usage-notes">EXTRACT Usage Notes</h3>
-<p>The extract function supports the following time units: YEAR, MONTH, DAY,
HOUR, MINUTE, SECOND.</p>
+<p>The extract function supports the following time units: YEAR, QUARTER,
MONTH, WEEK, DAY, DAYOFWEEK, DAYOFYEAR, EPOCH, HOUR, MINUTE, SECOND.</p>
<h3 id="extract-examples">EXTRACT Examples</h3>
diff --git a/output/docs/file-system-storage-plugin/index.html
b/output/docs/file-system-storage-plugin/index.html
index ec4d92f83..18590be68 100644
--- a/output/docs/file-system-storage-plugin/index.html
+++ b/output/docs/file-system-storage-plugin/index.html
@@ -1595,17 +1595,17 @@ full file path name to the <code
class="language-plaintext highlighter-rouge">do
<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>SELECT * FROM dfs.`/users/max/drill/json/donuts.json`
WHERE type='frosted';
</code></pre></div></div>
+<h2 id="mount-and-unmount-commands">Mount and unmount commands</h2>
+
+<p><strong>Introduced in release: 1.21</strong></p>
+
+<p>drill.exec.storage.file.enable_mount_commands</p>
+
<h2 id="configuration-options-in-core-sitexml">Configuration options in
core-site.xml</h2>
<h3
id="drillexecrecursive_file_listing_max_size">drill.exec.recursive_file_listing_max_size</h3>
-<p>Use this property to set a limit on the numer of files that Drill
-will list by recursing into a DFS directory tree. When the limit is
-encountered the initiating operation will fail with an error. The
-intended application of this limit is to allow admins to protect their
-Drillbits from an errant or malicious SELECT * FROM dfs.huge_workspace
-LIMIT 10 query, which will cause an OOM given a big enough workspace of
-files. Defaults to 0 which means no limit.</p>
+<p>Use this property to set a limit on the numer of files that Drill will list
by recursing into a DFS directory tree. When the limit is encountered the
initiating operation will fail with an error. The intended application of this
limit is to allow admins to protect their Drillbits from an errant or malicious
<code class="language-plaintext highlighter-rouge">SELECT * FROM
dfs.huge_workspace LIMIT 10</code> query, which will cause an OOM given a big
enough workspace of files. Defaults t [...]
diff --git a/output/feed.xml b/output/feed.xml
index e034cb8f6..7a6c090e4 100644
--- a/output/feed.xml
+++ b/output/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Fri, 03 Mar 2023 11:55:14 +0000</pubDate>
- <lastBuildDate>Fri, 03 Mar 2023 11:55:14 +0000</lastBuildDate>
+ <pubDate>Fri, 03 Mar 2023 14:25:00 +0000</pubDate>
+ <lastBuildDate>Fri, 03 Mar 2023 14:25:00 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
diff --git a/output/zh/docs/data-type-conversion/index.html
b/output/zh/docs/data-type-conversion/index.html
index ab607c62b..7271c346d 100644
--- a/output/zh/docs/data-type-conversion/index.html
+++ b/output/zh/docs/data-type-conversion/index.html
@@ -2115,7 +2115,7 @@ use in your Drill queries as described in this
section:</p>
<td>DECIMAL</td>
</tr>
<tr>
- <td><a
href="/zh/docs/data-type-conversion/#to_timestamp">TO_TIMESTAMP</a>(VARCHAR,
format)</td>
+ <td><a
href="/zh/docs/data-type-conversion/#to_timestamp">TO_TIMESTAMP</a>(VARCHAR [,
format])</td>
<td>TIMESTAMP</td>
</tr>
<tr>
@@ -2620,7 +2620,7 @@ SELECT TO_NUMBER('12345', '##0.##E0') FROM (VALUES(1));
<p><em>expression</em> is a character string enclosed in single quotation
marks or a UNIX epoch timestamp, not enclosed in single quotation marks.</p>
-<p><em>‘format’</em> is a character string that specifies the format of
<em>expression</em>. Only use this option when the <em>expression</em> is a
character string, not a UNIX epoch timestamp.</p>
+<p><em>‘format’</em> is an optional character string that specifies the format
of <em>expression</em>. Only use this option when the <em>expression</em> is a
character string, not a UNIX epoch timestamp. If <em>expression</em> is a
character string and <em>format</em> is not provided then the function will use
a set of heuristics to try to detect the date format automatically. If that
attempt fails then null is returned.</p>
<h3 id="to_timestamp-usage-notes">TO_TIMESTAMP Usage Notes</h3>
<p>Specify a format using patterns defined in <a
href="http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html";>Joda
DateTimeFormat class</a>. The TO_TIMESTAMP function takes a Unix epoch
timestamp. The TO_DATE function takes a UNIX epoch timestamp in
milliseconds.</p>
@@ -2663,7 +2663,7 @@ FROM (VALUES(1));
1 row selected (0.148 seconds)
</code></pre></div></div>
-<p>Convert an ISO-8601 timestamp string to a timestamp. The ISO-8601 format
differs from the ANSI SQL timestamp format and must be explicitly parsed. Note
the escaped single quotes (‘’) required to place the separator character ‘T’
into the format string.</p>
+<p>Convert an ISO-8601 timestamp string to a timestamp. The ISO-8601 format
differs from the ANSI SQL timestamp format and cannot be cast but must be
explicitly parsed. Note the escaped single quotes (‘’) required to place the
separator character ‘T’ into the format string.</p>
<div class="language-sql highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="k">select</span> <span
class="n">to_timestamp</span><span class="p">(</span><span
class="s1">'2023-02-24T11:21:55'</span><span class="p">,</span> <span
class="s1">'YYYY-MM-dd</span><span class="se">''</span><span
class="s1">T</span><span class="se">''</span><span
class="s1">HH:mm:ss'</span><span class="p">);</span>
</code></pre></div></div>
@@ -2672,6 +2672,15 @@ FROM (VALUES(1));
1 row selected (0.163 seconds)
</code></pre></div></div>
+<p>Use TO_TIMESTAMP with automatic format detection to parse an IS0-8601
timestamp.</p>
+
+<div class="language-sql highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="k">select</span> <span
class="n">to_timestamp</span><span class="p">(</span><span
class="s1">'2023-02-24T11:21:55'</span><span class="p">);</span>
+</code></pre></div></div>
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>EXPR$0 2023-02-24 11:21:55.0
+
+1 row selected (0.151 seconds)
+</code></pre></div></div>
+
<h2 id="enabling-time-zone-offset">Enabling Time Zone Offset</h2>
<p>Starting in Drill 1.16, the <code class="language-plaintext
highlighter-rouge">store.hive.maprdb_json.read_timestamp_with_timezone_offset</code>
option enables Drill to read timestamp values with a timezone offset when
using the hive plugin with the Drill native MaprDB JSON reader enabled through
the <code class="language-plaintext
highlighter-rouge">store.hive.maprdb_json.optimize_scan_with_native_reader
option</code>. The <code class="language-plaintext highlighter-rouge">store.hiv
[...]
diff --git a/output/zh/docs/date-time-functions-and-arithmetic/index.html
b/output/zh/docs/date-time-functions-and-arithmetic/index.html
index f1bd27e32..9bf79f788 100644
--- a/output/zh/docs/date-time-functions-and-arithmetic/index.html
+++ b/output/zh/docs/date-time-functions-and-arithmetic/index.html
@@ -2300,11 +2300,11 @@ SELECT ISDATE('foobar');
<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>component FROM (timestamp | time | date | interval)
</code></pre></div></div>
-<p><em>component</em> is one of the following time units: year, month, day,
hour, minute, second.</p>
+<p><em>component</em> is one of the following time units: year, quarter,
month, week, day, dayofweek, dayofyear, epoch, hour, minute, second.</p>
<h3 id="extract-usage-notes">EXTRACT Usage Notes</h3>
-<p>The extract function supports the following time units: YEAR, MONTH, DAY,
HOUR, MINUTE, SECOND.</p>
+<p>The extract function supports the following time units: YEAR, QUARTER,
MONTH, WEEK, DAY, DAYOFWEEK, DAYOFYEAR, EPOCH, HOUR, MINUTE, SECOND.</p>
<h3 id="extract-examples">EXTRACT Examples</h3>
diff --git a/output/zh/docs/file-system-storage-plugin/index.html
b/output/zh/docs/file-system-storage-plugin/index.html
index 57bfec468..ea2ae65c5 100644
--- a/output/zh/docs/file-system-storage-plugin/index.html
+++ b/output/zh/docs/file-system-storage-plugin/index.html
@@ -1595,17 +1595,17 @@ full file path name to the <code
class="language-plaintext highlighter-rouge">do
<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>SELECT * FROM dfs.`/users/max/drill/json/donuts.json`
WHERE type='frosted';
</code></pre></div></div>
+<h2 id="mount-and-unmount-commands">Mount and unmount commands</h2>
+
+<p><strong>Introduced in release: 1.21</strong></p>
+
+<p>drill.exec.storage.file.enable_mount_commands</p>
+
<h2 id="configuration-options-in-core-sitexml">Configuration options in
core-site.xml</h2>
<h3
id="drillexecrecursive_file_listing_max_size">drill.exec.recursive_file_listing_max_size</h3>
-<p>Use this property to set a limit on the numer of files that Drill
-will list by recursing into a DFS directory tree. When the limit is
-encountered the initiating operation will fail with an error. The
-intended application of this limit is to allow admins to protect their
-Drillbits from an errant or malicious SELECT * FROM dfs.huge_workspace
-LIMIT 10 query, which will cause an OOM given a big enough workspace of
-files. Defaults to 0 which means no limit.</p>
+<p>Use this property to set a limit on the numer of files that Drill will list
by recursing into a DFS directory tree. When the limit is encountered the
initiating operation will fail with an error. The intended application of this
limit is to allow admins to protect their Drillbits from an errant or malicious
<code class="language-plaintext highlighter-rouge">SELECT * FROM
dfs.huge_workspace LIMIT 10</code> query, which will cause an OOM given a big
enough workspace of files. Defaults t [...]
diff --git a/output/zh/feed.xml b/output/zh/feed.xml
index efb0d0402..108813be0 100644
--- a/output/zh/feed.xml
+++ b/output/zh/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/zh/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Fri, 03 Mar 2023 11:55:14 +0000</pubDate>
- <lastBuildDate>Fri, 03 Mar 2023 11:55:14 +0000</lastBuildDate>
+ <pubDate>Fri, 03 Mar 2023 14:25:00 +0000</pubDate>
+ <lastBuildDate>Fri, 03 Mar 2023 14:25:00 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
