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 2022/05/11 13:32:11 UTC
[drill-site] branch master updated: Document the CONCAT_DELIM function.
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 a4ff3a363 Document the CONCAT_DELIM function.
a4ff3a363 is described below
commit a4ff3a36390247652dee9586cf6101ddb04424ee
Author: James Turton <ja...@somecomputer.xyz>
AuthorDate: Wed May 11 15:31:49 2022 +0200
Document the CONCAT_DELIM function.
---
.../sql-functions/040-string-manipulation.md | 21 +++++++++++++++++++++
1 file changed, 21 insertions(+)
diff --git a/_docs/en/sql-reference/sql-functions/040-string-manipulation.md b/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
index 454a736dd..7f38af40d 100644
--- a/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
+++ b/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
@@ -11,6 +11,7 @@ You can use the following string functions in Drill queries:
| [BYTE_SUBSTR]({{ site.baseurl }}/docs/string-manipulation/#byte_substr) | BINARY or VARCHAR |
| [CHAR_LENGTH]({{ site.baseurl }}/docs/string-manipulation/#char_length) | INTEGER |
| [CONCAT]({{ site.baseurl }}/docs/string-manipulation/#concat) | VARCHAR |
+| [CONCAT_DELIM]({{ site.baseurl }}/docs/string-manipulation/#concat_delim) | VARCHAR |
| [ILIKE]({{ site.baseurl }}/docs/string-manipulation/#ilike) | BOOLEAN |
| [INITCAP]({{ site.baseurl }}/docs/string-manipulation/#initcap) | VARCHAR |
| [LENGTH]({{ site.baseurl }}/docs/string-manipulation/#length) | INTEGER |
@@ -115,6 +116,26 @@ Concatenates arguments.
Alternatively, you can use the [string concatenation operation]({{ site.baseurl }}/docs/operators/#string-concatenate-operator) to concatenate strings.
+## CONCAT_DELIM
+Concatenates arguments inserting the provided delimiter between each pair. Null arguments are eliminated.
+
+### CONCAT_DELIM Syntax
+
+ CONCAT_DELIM(delimiter [, string [, ...] )
+
+### CONCAT_DELIM Example
+
+ SELECT CONCAT_DELIM('&', 'cat', null, 'mat') FROM (VALUES(1));
+
+ |-------------------|
+ | EXPR$0 |
+ |-------------------|
+ | cat&mat |
+ |-------------------|
+ 1 row selected (0.134 seconds)
+
+Alternatively, you can use the [string concatenation operation]({{ site.baseurl }}/docs/operators/#string-concatenate-operator) to concatenate strings.
+
## ILIKE
Performs a case-insensitive comparison of the input string with a pattern and returns
true in the case of a match.