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 01d676e13 Automatic Site Publish by Buildbot
01d676e13 is described below

commit 01d676e13e383b6c3553e8a61b9370512d8a6d7b
Author: buildbot <[email protected]>
AuthorDate: Wed May 11 13:35:08 2022 +0000

    Automatic Site Publish by Buildbot
---
 output/docs/string-manipulation/index.html    | 26 ++++++++++++++++++++++++++
 output/feed.xml                               |  4 ++--
 output/zh/docs/string-manipulation/index.html | 26 ++++++++++++++++++++++++++
 output/zh/feed.xml                            |  4 ++--
 4 files changed, 56 insertions(+), 4 deletions(-)

diff --git a/output/docs/string-manipulation/index.html 
b/output/docs/string-manipulation/index.html
index c1d9c288b..bb7f73fbc 100644
--- a/output/docs/string-manipulation/index.html
+++ b/output/docs/string-manipulation/index.html
@@ -1478,6 +1478,10 @@
       <td><a href="/docs/string-manipulation/#concat">CONCAT</a></td>
       <td>VARCHAR</td>
     </tr>
+    <tr>
+      <td><a 
href="/docs/string-manipulation/#concat_delim">CONCAT_DELIM</a></td>
+      <td>VARCHAR</td>
+    </tr>
     <tr>
       <td><a href="/docs/string-manipulation/#ilike">ILIKE</a></td>
       <td>BOOLEAN</td>
@@ -1661,6 +1665,28 @@ SELECT 
CONVERT_FROM(BYTE_SUBSTR(row_key,6,length(row_key)),'UTF8') FROM root.`my
 
 <p>Alternatively, you can use the <a 
href="/docs/operators/#string-concatenate-operator">string concatenation 
operation</a> to concatenate strings.</p>
 
+<h2 id="concat_delim">CONCAT_DELIM</h2>
+<p>Concatenates arguments inserting the provided delimiter between each pair. 
Null arguments are eliminated.</p>
+
+<h3 id="concat_delim-syntax">CONCAT_DELIM Syntax</h3>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre 
class="highlight"><code>CONCAT_DELIM(delimiter [, string [, ...] )
+</code></pre></div></div>
+
+<h3 id="concat_delim-example">CONCAT_DELIM Example</h3>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre 
class="highlight"><code>SELECT CONCAT_DELIM('&amp;', 'cat', null, 'mat') FROM 
(VALUES(1));
+
+|-------------------|
+| EXPR$0            |
+|-------------------|
+| cat&amp;mat           |
+|-------------------|
+1 row selected (0.134 seconds)
+</code></pre></div></div>
+
+<p>Alternatively, you can use the <a 
href="/docs/operators/#string-concatenate-operator">string concatenation 
operation</a> to concatenate strings.</p>
+
 <h2 id="ilike">ILIKE</h2>
 <p>Performs a case-insensitive comparison of the input string with a pattern 
and returns
 true in the case of a match.</p>
diff --git a/output/feed.xml b/output/feed.xml
index 6dee3ecad..d7dc8cc9c 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, 03 May 2022 17:00:30 +0000</pubDate>
-    <lastBuildDate>Tue, 03 May 2022 17:00:30 +0000</lastBuildDate>
+    <pubDate>Wed, 11 May 2022 13:32:33 +0000</pubDate>
+    <lastBuildDate>Wed, 11 May 2022 13:32:33 +0000</lastBuildDate>
     <generator>Jekyll v3.9.1</generator>
     
       <item>
diff --git a/output/zh/docs/string-manipulation/index.html 
b/output/zh/docs/string-manipulation/index.html
index 00a1a69c0..697a2622b 100644
--- a/output/zh/docs/string-manipulation/index.html
+++ b/output/zh/docs/string-manipulation/index.html
@@ -1478,6 +1478,10 @@
       <td><a href="/zh/docs/string-manipulation/#concat">CONCAT</a></td>
       <td>VARCHAR</td>
     </tr>
+    <tr>
+      <td><a 
href="/zh/docs/string-manipulation/#concat_delim">CONCAT_DELIM</a></td>
+      <td>VARCHAR</td>
+    </tr>
     <tr>
       <td><a href="/zh/docs/string-manipulation/#ilike">ILIKE</a></td>
       <td>BOOLEAN</td>
@@ -1661,6 +1665,28 @@ SELECT 
CONVERT_FROM(BYTE_SUBSTR(row_key,6,length(row_key)),'UTF8') FROM root.`my
 
 <p>Alternatively, you can use the <a 
href="/zh/docs/operators/#string-concatenate-operator">string concatenation 
operation</a> to concatenate strings.</p>
 
+<h2 id="concat_delim">CONCAT_DELIM</h2>
+<p>Concatenates arguments inserting the provided delimiter between each pair. 
Null arguments are eliminated.</p>
+
+<h3 id="concat_delim-syntax">CONCAT_DELIM Syntax</h3>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre 
class="highlight"><code>CONCAT_DELIM(delimiter [, string [, ...] )
+</code></pre></div></div>
+
+<h3 id="concat_delim-example">CONCAT_DELIM Example</h3>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre 
class="highlight"><code>SELECT CONCAT_DELIM('&amp;', 'cat', null, 'mat') FROM 
(VALUES(1));
+
+|-------------------|
+| EXPR$0            |
+|-------------------|
+| cat&amp;mat           |
+|-------------------|
+1 row selected (0.134 seconds)
+</code></pre></div></div>
+
+<p>Alternatively, you can use the <a 
href="/zh/docs/operators/#string-concatenate-operator">string concatenation 
operation</a> to concatenate strings.</p>
+
 <h2 id="ilike">ILIKE</h2>
 <p>Performs a case-insensitive comparison of the input string with a pattern 
and returns
 true in the case of a match.</p>
diff --git a/output/zh/feed.xml b/output/zh/feed.xml
index d14b90fea..0dca30f03 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, 03 May 2022 17:00:30 +0000</pubDate>
-    <lastBuildDate>Tue, 03 May 2022 17:00:30 +0000</lastBuildDate>
+    <pubDate>Wed, 11 May 2022 13:32:33 +0000</pubDate>
+    <lastBuildDate>Wed, 11 May 2022 13:32:33 +0000</lastBuildDate>
     <generator>Jekyll v3.9.1</generator>
     
       <item>

Reply via email to