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 17:22:45 UTC
[drill-site] branch master updated: Revert "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 b61f895fa Revert "Document the CONCAT_DELIM function."
b61f895fa is described below
commit b61f895fab4021d4f6185e6701729c939d0bddf5
Author: James Turton <ja...@somecomputer.xyz>
AuthorDate: Wed May 11 19:22:32 2022 +0200
Revert "Document the CONCAT_DELIM function."
This reverts commit a4ff3a36390247652dee9586cf6101ddb04424ee.
---
.../sql-functions/040-string-manipulation.md | 21 ---------------------
1 file changed, 21 deletions(-)
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 7f38af40d..454a736dd 100644
--- a/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
+++ b/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
@@ -11,7 +11,6 @@ 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 |
@@ -116,26 +115,6 @@ 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.