You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by gi...@apache.org on 2022/09/02 15:44:59 UTC
[drill-site] branch asf-site updated: Automatic Site Publish by Buildbot
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 9d9fe716a Automatic Site Publish by Buildbot
9d9fe716a is described below
commit 9d9fe716a7653e25e8178f0ae2367fb864102c87
Author: buildbot <us...@infra.apache.org>
AuthorDate: Fri Sep 2 15:44:56 2022 +0000
Automatic Site Publish by Buildbot
---
output/docs/data-type-functions/index.html | 12 ++++----
.../date-time-functions-and-arithmetic/index.html | 33 ++++++++++++++++++++++
output/docs/string-manipulation/index.html | 23 +++++++++++++++
output/feed.xml | 4 +--
output/zh/docs/data-type-functions/index.html | 12 ++++----
.../date-time-functions-and-arithmetic/index.html | 33 ++++++++++++++++++++++
output/zh/docs/string-manipulation/index.html | 23 +++++++++++++++
output/zh/feed.xml | 4 +--
8 files changed, 128 insertions(+), 16 deletions(-)
diff --git a/output/docs/data-type-functions/index.html b/output/docs/data-type-functions/index.html
index 208420925..988732f29 100644
--- a/output/docs/data-type-functions/index.html
+++ b/output/docs/data-type-functions/index.html
@@ -1468,16 +1468,16 @@
<p>Drill supports the following functions that return data type information:</p>
-<p><strong>sqlTypeOf()</strong><br />
+<p><strong>sqlTypeOf()</strong>
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:</p>
-<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre class="highlight"><code> sqlTypeOf( CAST(x AS <data type> ))
- //Returns <data type> as the type name. If the type is DECIMAL, the type also includes precision and scale, for example:
-
- DECIMAL(6, 3) **modeOf()** Returns the cardinality (mode) of the column as "NOT NULL", "NULLABLE", or "ARRAY". Drill data types include a cardinality, for example `Optional Int` or `Required VarChar`.
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre class="highlight"><code> sqlTypeOf( CAST(x AS <data type> ))
+ //Returns <data type> as the type name. If the type is DECIMAL, the type also includes precision and scale, for example:
+
+ DECIMAL(6, 3) **modeOf()** Returns the cardinality (mode) of the column as "NOT NULL", "NULLABLE", or "ARRAY". Drill data types include a cardinality, for example `Optional Int` or `Required VarChar`.
</code></pre></div></div>
-<p><strong>drillTypeOf()</strong><br />
+<p><strong>drillTypeOf()</strong>
Similar to typeOf(), but returns the internal Drill names even if the value is NULL.
_____</p>
diff --git a/output/docs/date-time-functions-and-arithmetic/index.html b/output/docs/date-time-functions-and-arithmetic/index.html
index 0b5b94deb..e8bdc6b27 100644
--- a/output/docs/date-time-functions-and-arithmetic/index.html
+++ b/output/docs/date-time-functions-and-arithmetic/index.html
@@ -1512,6 +1512,10 @@
<td><a href="/docs/date-time-functions-and-arithmetic/#date_sub">DATE_SUB</a></td>
<td>DATE, TIMESTAMP</td>
</tr>
+ <tr>
+ <td><a href="/docs/date-time-functions-and-arithmetic/#isdate">ISDATE</a></td>
+ <td>BOOLEAN</td>
+ </tr>
<tr>
<td><a href="/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions">LOCALTIME</a></td>
<td>TIME</td>
@@ -2015,6 +2019,35 @@ SELECT DATE_PART('hour', '23:14:30.076') FROM (VALUES(1));
2 rows selected (0.161 seconds)
</code></pre></div></div>
+<h2 id="isdate">ISDATE</h2>
+<p>Tests whether a character string represents a valid date. The test applied is equivalent
+to asking whether an attempt to cast the string to date would succeed or fail.</p>
+
+<h3 id="isdate-syntax">ISDATE Syntax</h3>
+
+<p><code class="language-plaintext highlighter-rouge">isdate(date_string)</code></p>
+
+<p><em>date_string</em> is a character string possibly representing a valid date.</p>
+
+<h3 id="isdate-examples">ISDATE Examples</h3>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre class="highlight"><code>SELECT ISDATE('1970-01-01');
+|------------|
+| EXPR$0 |
+|------------|
+| true |
+|------------|
+1 row selected (0.098 seconds)
+
+SELECT ISDATE('foobar');
+|------------|
+| EXPR$0 |
+|------------|
+| false |
+|------------|
+1 row selected (0.088 seconds)
+</code></pre></div></div>
+
<h2 id="other-date-and-time-functions">Other Date and Time Functions</h2>
<p>The following examples show how to use these functions:</p>
diff --git a/output/docs/string-manipulation/index.html b/output/docs/string-manipulation/index.html
index 56eafd33b..e047f6260 100644
--- a/output/docs/string-manipulation/index.html
+++ b/output/docs/string-manipulation/index.html
@@ -1494,6 +1494,10 @@
<td><a href="/docs/string-manipulation/#initcap">INITCAP</a></td>
<td>VARCHAR</td>
</tr>
+ <tr>
+ <td><a href="/docs/string-manipulation/#isnumeric">ISNUMERIC</a></td>
+ <td>INTEGER</td>
+ </tr>
<tr>
<td><a href="/docs/string-manipulation/#length">LENGTH</a></td>
<td>INTEGER</td>
@@ -1719,6 +1723,25 @@ true in the case of a match.</p>
1 row selected (0.106 seconds)
</code></pre></div></div>
+<h2 id="isnumeric">ISNUMERIC</h2>
+<p>Returns a 1 if the string argument matches the regular expression <code class="language-plaintext highlighter-rouge">[-+]?\d+(\.\d+)?</code> otherwise a 0.</p>
+
+<h3 id="isnumeric-syntax">ISNUMERIC Syntax</h3>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre class="highlight"><code>ISNUMERIC(string)
+</code></pre></div></div>
+
+<h3 id="isnumeric-examples">ISNUMERIC Examples</h3>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre class="highlight"><code>SELECT ISNUMERIC('3.1415926');
+|--------|
+| EXPR$0 |
+|--------|
+| 1 |
+|--------|
+1 row selected (0.185 seconds)
+</code></pre></div></div>
+
<h2 id="length">LENGTH</h2>
<p>Returns the number of characters in the string.</p>
diff --git a/output/feed.xml b/output/feed.xml
index 271228bba..4d00232b1 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>Tue, 16 Aug 2022 14:38:12 +0000</pubDate>
- <lastBuildDate>Tue, 16 Aug 2022 14:38:12 +0000</lastBuildDate>
+ <pubDate>Fri, 02 Sep 2022 15:42:48 +0000</pubDate>
+ <lastBuildDate>Fri, 02 Sep 2022 15:42:48 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
diff --git a/output/zh/docs/data-type-functions/index.html b/output/zh/docs/data-type-functions/index.html
index eae8ba1f1..400c4919f 100644
--- a/output/zh/docs/data-type-functions/index.html
+++ b/output/zh/docs/data-type-functions/index.html
@@ -1468,16 +1468,16 @@
<p>Drill supports the following functions that return data type information:</p>
-<p><strong>sqlTypeOf()</strong><br />
+<p><strong>sqlTypeOf()</strong>
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:</p>
-<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre class="highlight"><code> sqlTypeOf( CAST(x AS <data type> ))
- //Returns <data type> as the type name. If the type is DECIMAL, the type also includes precision and scale, for example:
-
- DECIMAL(6, 3) **modeOf()** Returns the cardinality (mode) of the column as "NOT NULL", "NULLABLE", or "ARRAY". Drill data types include a cardinality, for example `Optional Int` or `Required VarChar`.
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre class="highlight"><code> sqlTypeOf( CAST(x AS <data type> ))
+ //Returns <data type> as the type name. If the type is DECIMAL, the type also includes precision and scale, for example:
+
+ DECIMAL(6, 3) **modeOf()** Returns the cardinality (mode) of the column as "NOT NULL", "NULLABLE", or "ARRAY". Drill data types include a cardinality, for example `Optional Int` or `Required VarChar`.
</code></pre></div></div>
-<p><strong>drillTypeOf()</strong><br />
+<p><strong>drillTypeOf()</strong>
Similar to typeOf(), but returns the internal Drill names even if the value is NULL.
_____</p>
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 7308a5cb4..8de3c9fbd 100644
--- a/output/zh/docs/date-time-functions-and-arithmetic/index.html
+++ b/output/zh/docs/date-time-functions-and-arithmetic/index.html
@@ -1512,6 +1512,10 @@
<td><a href="/zh/docs/date-time-functions-and-arithmetic/#date_sub">DATE_SUB</a></td>
<td>DATE, TIMESTAMP</td>
</tr>
+ <tr>
+ <td><a href="/zh/docs/date-time-functions-and-arithmetic/#isdate">ISDATE</a></td>
+ <td>BOOLEAN</td>
+ </tr>
<tr>
<td><a href="/zh/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions">LOCALTIME</a></td>
<td>TIME</td>
@@ -2015,6 +2019,35 @@ SELECT DATE_PART('hour', '23:14:30.076') FROM (VALUES(1));
2 rows selected (0.161 seconds)
</code></pre></div></div>
+<h2 id="isdate">ISDATE</h2>
+<p>Tests whether a character string represents a valid date. The test applied is equivalent
+to asking whether an attempt to cast the string to date would succeed or fail.</p>
+
+<h3 id="isdate-syntax">ISDATE Syntax</h3>
+
+<p><code class="language-plaintext highlighter-rouge">isdate(date_string)</code></p>
+
+<p><em>date_string</em> is a character string possibly representing a valid date.</p>
+
+<h3 id="isdate-examples">ISDATE Examples</h3>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre class="highlight"><code>SELECT ISDATE('1970-01-01');
+|------------|
+| EXPR$0 |
+|------------|
+| true |
+|------------|
+1 row selected (0.098 seconds)
+
+SELECT ISDATE('foobar');
+|------------|
+| EXPR$0 |
+|------------|
+| false |
+|------------|
+1 row selected (0.088 seconds)
+</code></pre></div></div>
+
<h2 id="other-date-and-time-functions">Other Date and Time Functions</h2>
<p>The following examples show how to use these functions:</p>
diff --git a/output/zh/docs/string-manipulation/index.html b/output/zh/docs/string-manipulation/index.html
index 2af2b8ed5..4a6f63337 100644
--- a/output/zh/docs/string-manipulation/index.html
+++ b/output/zh/docs/string-manipulation/index.html
@@ -1494,6 +1494,10 @@
<td><a href="/zh/docs/string-manipulation/#initcap">INITCAP</a></td>
<td>VARCHAR</td>
</tr>
+ <tr>
+ <td><a href="/zh/docs/string-manipulation/#isnumeric">ISNUMERIC</a></td>
+ <td>INTEGER</td>
+ </tr>
<tr>
<td><a href="/zh/docs/string-manipulation/#length">LENGTH</a></td>
<td>INTEGER</td>
@@ -1719,6 +1723,25 @@ true in the case of a match.</p>
1 row selected (0.106 seconds)
</code></pre></div></div>
+<h2 id="isnumeric">ISNUMERIC</h2>
+<p>Returns a 1 if the string argument matches the regular expression <code class="language-plaintext highlighter-rouge">[-+]?\d+(\.\d+)?</code> otherwise a 0.</p>
+
+<h3 id="isnumeric-syntax">ISNUMERIC Syntax</h3>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre class="highlight"><code>ISNUMERIC(string)
+</code></pre></div></div>
+
+<h3 id="isnumeric-examples">ISNUMERIC Examples</h3>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre class="highlight"><code>SELECT ISNUMERIC('3.1415926');
+|--------|
+| EXPR$0 |
+|--------|
+| 1 |
+|--------|
+1 row selected (0.185 seconds)
+</code></pre></div></div>
+
<h2 id="length">LENGTH</h2>
<p>Returns the number of characters in the string.</p>
diff --git a/output/zh/feed.xml b/output/zh/feed.xml
index 779cb4844..ee854f6e6 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>Tue, 16 Aug 2022 14:38:12 +0000</pubDate>
- <lastBuildDate>Tue, 16 Aug 2022 14:38:12 +0000</lastBuildDate>
+ <pubDate>Fri, 02 Sep 2022 15:42:48 +0000</pubDate>
+ <lastBuildDate>Fri, 02 Sep 2022 15:42:48 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>