This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new a17000bd67c [fix] correct small errors in string, struct, and system
function docs (#3714)
a17000bd67c is described below
commit a17000bd67caaf73d7e503b6dd40eebb582f9f98
Author: boluor <[email protected]>
AuthorDate: Wed May 20 08:59:43 2026 -0700
[fix] correct small errors in string, struct, and system function docs
(#3714)
## Summary
Fixes 28 small documentation issues across the string, struct, and
system function references. Each item below is independent.
### string-functions
- **ascii.md / auto-partition-name.md / char-length.md /
cut-to-first-significant-subdomain.md / format-number.md / length.md /
ngram-search.md / regexp-extract-all.md** — frontmatter `description`
was truncated mid-sentence; completed each.
- **count_substrings.md** — two list items were both numbered `7.`;
renumbered the second to `8.`.
- **char.md** — three result-table headers showed `char('utf8', ...)`
while the queries used `CHAR(...)`; headers now match the queries.
- **is-uuid.md** — the result-table header omitted the curly braces that
were in the query; header now includes them.
- **mask-last-n.md** — the query used `'Helloṭṛ123'` while the result
header and output used `'Hello你好123'`; query aligned with the displayed
result.
- **parse-url.md / protocol.md** — a Chinese `## 相关命令` section (with
Chinese body and full-width `。`) was sitting in English docs; translated
to `## See Also` with English body.
- **position.md / repeat.md / reverse.md** — each file had a complete
duplicate Description/Syntax/Parameters/Examples block appended at the
end; the trailing duplicate was removed.
- **quote.md** — escape note contradicted itself (claimed both `\\` →
`\\\\` and `\\\\` → `\\`); removed the bad bullet. Also, `quote(\"It's a
test\")` showed `'It's a test'` (single quote unescaped) in the output;
corrected to `'It\\'s a test'`.
- **parse-data-size.md** — prose listed units up to ZB/YB but the table
stops at EB; aligned prose with the table.
- **hamming_distance.md / levenshtein.md** — legacy frontmatter (`title:
…` only, no `language`/`description`) updated to the standard JSON form
used by sibling docs.
- **regexp-count.md** — typo `is n the total count` corrected; typos
`paratemer`/`usr` corrected to `parameter`/`user`; the
quadruple-backslash pattern `[\\\\\\\\.:;]` simplified to `[\\\\.:;]`.
- **regexp-extract-or-null.md** — example query pattern had
`([[]ower:]]+)` while the error message referenced `([[:lower:]+)`;
query updated to match the error.
- **regexp.md** — the greedy / non-greedy example invoked
`REGEXP_EXTRACT(...)` instead of `REGEXP(...)`; corrected. A stray `~`
on its own line after `## Description` (and a leading `~ ` in the
frontmatter description) removed.
- **soundex.md** — examples were numbered 1-7 then jumped to 9;
corrected to 8.
- **url-decode.md / url-encode.md** — result blocks were fenced as
```sql; corrected to ```text. url-encode.md also had a duplicate `##
Required Parameters` heading; removed.
- **frontmatter descriptions** that referenced function names without
underscores (e.g. `REGEXPREPLACEONE`, `MASKLASTN`, `PARSEURL`,
`CHARLENGTH`, ...) corrected to the canonical underscored form
(`REGEXP_REPLACE_ONE`, `MASK_LAST_N`, `PARSE_URL`, `CHAR_LENGTH`, ...).
### system-functions
- **database.md** — `SELECT database(), schema()` showed both
result-table headers as `database()`; second header corrected to
`schema()`.
### struct-functions
- **named-struct.md / struct.md / struct-element.md** — frontmatter
`language: \"en-US\"` → `\"en\"`.
## Test plan
- [ ] CI doc build passes
- [ ] Spot-check the affected pages render correctly (completed
descriptions, no duplicate trailing blocks, corrected result-table
headers, no stray punctuation, language metadata in struct docs)
---
.../scalar-functions/string-functions/ascii.md | 2 +-
.../string-functions/auto-partition-name.md | 2 +-
.../string-functions/char-length.md | 2 +-
.../scalar-functions/string-functions/char.md | 6 +--
.../string-functions/count_substrings.md | 6 +--
.../cut-to-first-significant-subdomain.md | 2 +-
.../string-functions/format-number.md | 2 +-
.../string-functions/hamming_distance.md | 6 ++-
.../scalar-functions/string-functions/length.md | 2 +-
.../string-functions/levenshtein.md | 6 ++-
.../string-functions/mask-last-n.md | 2 +-
.../string-functions/ngram-search.md | 2 +-
.../string-functions/parse-data-size.md | 2 +-
.../scalar-functions/string-functions/parse-url.md | 6 +--
.../scalar-functions/string-functions/position.md | 42 -------------------
.../scalar-functions/string-functions/protocol.md | 4 +-
.../scalar-functions/string-functions/quote.md | 3 +-
.../string-functions/regexp-extract-all.md | 2 +-
.../string-functions/regexp-replace-one.md | 2 +-
.../scalar-functions/string-functions/regexp.md | 2 +-
.../scalar-functions/string-functions/repeat.md | 48 ----------------------
.../string-functions/replace-empty.md | 2 +-
.../scalar-functions/string-functions/reverse.md | 47 ---------------------
.../string-functions/split-by-regexp.md | 2 +-
.../string-functions/split-by-string.md | 2 +-
.../scalar-functions/string-functions/to-base64.md | 2 +-
.../string-functions/url-decode.md | 2 +-
.../string-functions/url-encode.md | 4 +-
.../struct-functions/named-struct.md | 2 +-
.../struct-functions/struct-element.md | 2 +-
.../scalar-functions/struct-functions/struct.md | 2 +-
.../scalar-functions/string-functions/ascii.md | 2 +-
.../string-functions/auto-partition-name.md | 2 +-
.../string-functions/char-length.md | 2 +-
.../scalar-functions/string-functions/char.md | 6 +--
.../string-functions/count_substrings.md | 6 +--
.../cut-to-first-significant-subdomain.md | 2 +-
.../string-functions/format-number.md | 2 +-
.../string-functions/hamming_distance.md | 6 ++-
.../scalar-functions/string-functions/length.md | 2 +-
.../string-functions/levenshtein.md | 6 ++-
.../string-functions/mask-last-n.md | 2 +-
.../string-functions/ngram-search.md | 2 +-
.../string-functions/parse-data-size.md | 2 +-
.../scalar-functions/string-functions/parse-url.md | 6 +--
.../scalar-functions/string-functions/position.md | 42 -------------------
.../scalar-functions/string-functions/protocol.md | 4 +-
.../scalar-functions/string-functions/quote.md | 3 +-
.../string-functions/regexp-extract-all.md | 2 +-
.../string-functions/regexp-replace-one.md | 2 +-
.../scalar-functions/string-functions/regexp.md | 2 +-
.../scalar-functions/string-functions/repeat.md | 48 ----------------------
.../string-functions/replace-empty.md | 2 +-
.../scalar-functions/string-functions/reverse.md | 47 ---------------------
.../string-functions/split-by-regexp.md | 2 +-
.../string-functions/split-by-string.md | 2 +-
.../scalar-functions/string-functions/to-base64.md | 2 +-
.../string-functions/url-decode.md | 2 +-
.../string-functions/url-encode.md | 4 +-
.../struct-functions/named-struct.md | 2 +-
.../struct-functions/struct-element.md | 2 +-
.../scalar-functions/struct-functions/struct.md | 2 +-
62 files changed, 86 insertions(+), 350 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/ascii.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/ascii.md
index 0f67eeaa219..1054a1beec7 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/ascii.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/ascii.md
@@ -2,7 +2,7 @@
{
"title": "ASCII",
"language": "en",
- "description": "Returns the ASCII code value of the first character in a
string. This function only processes the first character of the string,"
+ "description": "Returns the ASCII code value of the first character in a
string. This function only processes the first character of the string,
returning only the ASCII value of the first character for multi-character
strings."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
index 4216764057e..78b487e3d98 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
@@ -2,7 +2,7 @@
{
"title": "AUTO_PARTITION_NAME",
"language": "en",
- "description": "The AUTOPARTITIONNAME function is used to generate
partition names for auto partitions."
+ "description": "The AUTO_PARTITION_NAME function is used to generate
partition names for auto partitions. It supports two modes: RANGE mode
generates partition names based on time units, and LIST mode generates
partition names based on string values."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/char-length.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/char-length.md
index da75d298eaf..2fde6df3cd4 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/char-length.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/char-length.md
@@ -2,7 +2,7 @@
{
"title": "CHAR_LENGTH",
"language": "en",
- "description": "The CHARLENGTH function calculates the number of
characters (not bytes) in a string. For multi-byte characters (such as Chinese
characters),"
+ "description": "The CHAR_LENGTH function calculates the number of
characters (not bytes) in a string. For multi-byte characters (such as Chinese
characters), it returns the number of characters."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/char.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/char.md
index 9bb914a3596..521a7407b77 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/char.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/char.md
@@ -42,7 +42,7 @@ SELECT CHAR(68, 111, 114, 105, 115);
```
```text
+--------------------------------------+
-| char('utf8', 68, 111, 114, 105, 115) |
+| CHAR(68, 111, 114, 105, 115) |
+--------------------------------------+
| Doris |
+--------------------------------------+
@@ -54,7 +54,7 @@ SELECT CHAR(15049882, 15179199, 14989469);
```
```text
+--------------------------------------------+
-| char('utf8', 15049882, 15179199, 14989469) |
+| CHAR(15049882, 15179199, 14989469) |
+--------------------------------------------+
| 多睿丝 |
+--------------------------------------------+
@@ -66,7 +66,7 @@ SELECT CHAR(255);
```
```text
+-------------------+
-| char('utf8', 255) |
+| CHAR(255) |
+-------------------+
| NULL |
+-------------------+
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
index ce3b7c43646..6c77b28de78 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
@@ -2,7 +2,7 @@
{
"title": "COUNT_SUBSTRINGS",
"language": "en",
- "description": "The COUNTSUBSTRINGS function counts the number of
occurrences of a specified substring within a string."
+ "description": "The COUNT_SUBSTRINGS function counts the number of
occurrences of a specified substring within a string."
}
---
@@ -121,7 +121,7 @@ SELECT count_substrings('éèêëìíîïðñòó éèêëìíîïðñòó', 'é
+------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+
```
-7. Start position out of range
+8. Multi-byte Chinese substring with start position
```sql
SELECT count_substrings('你好，世界！你好，世界！', '世界', 0),
count_substrings('你好，世界！你好，世界！', '世界', 30);
@@ -132,4 +132,4 @@ SELECT count_substrings('你好，世界！你好，世界！', '世界', 0),
+-----------------------------------------------------------------------+------------------------------------------------------------------------+
| 0 |
0 |
+-----------------------------------------------------------------------+------------------------------------------------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/cut-to-first-significant-subdomain.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/cut-to-first-significant-subdomain.md
index 56618db0756..f5bc25333fe 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/cut-to-first-significant-subdomain.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/cut-to-first-significant-subdomain.md
@@ -2,7 +2,7 @@
{
"title": "CUT_TO_FIRST_SIGNIFICANT_SUBDOMAIN",
"language": "en",
- "description": "The CUTTOFIRSTSIGNIFICANTSUBDOMAIN function extracts the
effective part of a domain from a URL,"
+ "description": "The CUT_TO_FIRST_SIGNIFICANT_SUBDOMAIN function extracts
the effective part of a domain from a URL, including the top-level domain up to
the first significant subdomain."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/format-number.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/format-number.md
index 3a334f20eb1..1c4cea6d993 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/format-number.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/format-number.md
@@ -2,7 +2,7 @@
{
"title": "FORMAT_NUMBER",
"language": "en",
- "description": "The FORMATNUMBER function formats numerical values into
strings with unit symbols. Supported units are: K (thousand), M (million), B
(billion),"
+ "description": "The FORMAT_NUMBER function formats numerical values into
strings with unit symbols. Supported units are: K (thousand), M (million), B
(billion), T (trillion), Q (quadrillion)."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/hamming_distance.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/hamming_distance.md
index d3cc1f50297..babc5c1a27d 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/hamming_distance.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/hamming_distance.md
@@ -1,5 +1,9 @@
---
-title: HAMMING_DISTANCE
+{
+ "title": "HAMMING_DISTANCE",
+ "language": "en",
+ "description": "The HAMMING_DISTANCE function returns the number of
positions at which two strings of equal length differ."
+}
---
## Description
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/length.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/length.md
index f694d4243a6..8a38f996a09 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/length.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/length.md
@@ -2,7 +2,7 @@
{
"title": "LENGTH",
"language": "en",
- "description": "The LENGTH function returns the byte length of a string
(in bytes). This function calculates the number of bytes a string occupies in
UTF-8 encoding,"
+ "description": "The LENGTH function returns the byte length of a string
(in bytes). This function calculates the number of bytes a string occupies in
UTF-8 encoding, not the number of characters."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/levenshtein.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/levenshtein.md
index 9c161ed4c04..b23bfd29b5d 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/levenshtein.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/levenshtein.md
@@ -1,5 +1,9 @@
---
-title: LEVENSHTEIN
+{
+ "title": "LEVENSHTEIN",
+ "language": "en",
+ "description": "The LEVENSHTEIN function returns the Levenshtein edit
distance between two strings."
+}
---
## Description
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
index 89b236bc10d..905d9d811d5 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
@@ -2,7 +2,7 @@
{
"title": "MASK_LAST_N",
"language": "en",
- "description": "The MASKLASTN function is used to mask the last N bytes of
a string. It replaces uppercase letters with X, lowercase letters with x,"
+ "description": "The MASK_LAST_N function is used to mask the last N bytes
of a string. It replaces uppercase letters with X, lowercase letters with x,"
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/ngram-search.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/ngram-search.md
index 95c37ead5aa..deb9eecedf5 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/ngram-search.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/ngram-search.md
@@ -2,7 +2,7 @@
{
"title": "NGRAM_SEARCH",
"language": "en",
- "description": "The NGRAMSEARCH function calculates the N-gram similarity
between two strings. The similarity ranges from 0 to 1,"
+ "description": "The NGRAM_SEARCH function calculates the N-gram similarity
between two strings. The similarity ranges from 0 to 1, where higher values
indicate more similar strings."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/parse-data-size.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/parse-data-size.md
index 939ab408a65..2b180f3dc32 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/parse-data-size.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/parse-data-size.md
@@ -2,7 +2,7 @@
{
"title": "PARSE_DATA_SIZE",
"language": "en",
- "description": "The PARSEDATASIZE function parses a string with storage
units (such as \"1.5GB\") and converts it to a numeric value in bytes."
+ "description": "The PARSE_DATA_SIZE function parses a string with storage
units (such as \"1.5GB\") and converts it to a numeric value in bytes."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/parse-url.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/parse-url.md
index b3bd3bca203..24bbf2149cd 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/parse-url.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/parse-url.md
@@ -2,7 +2,7 @@
{
"title": "PARSE_URL",
"language": "en",
- "description": "The PARSEURL function is mainly used to parse URL strings
and extract various components from them, such as protocols, hosts, paths,
query parameters,"
+ "description": "The PARSE_URL function is mainly used to parse URL strings
and extract various components from them, such as protocols, hosts, paths,
query parameters,"
}
---
@@ -56,6 +56,6 @@ SELECT parse_url ('https://doris.apache.org/', null);
+----------------------------------------------+
```
-## 相关命令
+## See Also
-如果想获取 QUERY 中的特定
Parameter，可使用[extract_url_parameter](./extract-url-parameter.md)。
+If you want to extract a specific parameter from the QUERY, use
[extract_url_parameter](./extract-url-parameter.md).
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/position.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/position.md
index 69f4c1ed199..7c7ff828613 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/position.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/position.md
@@ -164,45 +164,3 @@ SELECT POSITION('123' IN '456123789'), POSITION('-',
'phone: 123-456-7890', 11);
+------------------------------+-------------------------------------------+
```
-## Description
-
-The POSITION function is used to find the position of a substring within a
string (counting from 1).
-
-If the substring is not found, the function returns 0.
-
-## Syntax
-
-```sql
-POSITION ( <substr> IN <str> )
-
-POSITION ( <substr>, <str> [, <pos>] )
-```
-
-## Parameters
-
-| Parameter | Description
|
-| --------- |
------------------------------------------------------------------------------------------
|
-| `substr` | The substring to search for
|
-| `str` | The string to be searched
|
-| `pos` | If this parameter is specified, the position of substr is
searched from the string starting with the pos subscript |
-
-## Return value
-
-The position of substr in str (counting from 1).
-If substr is not found, returns 0.
-
-```sql
-SELECT POSITION('bar' IN 'foobarbar'),
- POSITION('bar', 'foobarbar'),
- POSITION('bar', 'foobarbar', 5),
- POSITION('xbar', 'foobar');
-```
-
-```text
-
-+----------------------------------+--------------------------------+-----------------------------------+----------------------------------+
-| position('bar' in 'foobarbar') | position('bar', 'foobarbar') |
position('bar', 'foobarbar', 5) | position('xbar', 'foobar') |
-+----------------------------------+--------------------------------+-----------------------------------+----------------------------------+
-| 4 | 4 |
7 | 0 |
-+----------------------------------+--------------------------------+-----------------------------------+----------------------------------+
-```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/protocol.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/protocol.md
index fa39fd44bb8..bd21e0165e0 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/protocol.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/protocol.md
@@ -54,6 +54,6 @@ SELECT protocol(null);
+----------------+
```
-## 相关命令
+## See Also
-If you want to extract other parts of the URL, you can use
[parse_url](./parse-url.md)。
+If you want to extract other parts of the URL, you can use
[parse_url](./parse-url.md).
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/quote.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/quote.md
index 4c8bb7ccbdd..d8aef0bec57 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/quote.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/quote.md
@@ -30,7 +30,6 @@ Special cases:
- If input is NULL, returns the string 'NULL' (without quotes)
- Single quotes `'` are escaped to `\'`
- Backslashes `\` are escaped to `\\`
-- `\\` is escaped to `\`
- Empty string returns `''`
## Examples
@@ -55,7 +54,7 @@ SELECT quote("It's a test");
+----------------------+
| quote("It's a test") |
+----------------------+
-| 'It's a test' |
+| 'It\'s a test' |
+----------------------+
```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all.md
index f383cfa0966..5786ec2a5d1 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all.md
@@ -2,7 +2,7 @@
{
"title": "REGEXP_EXTRACT_ALL",
"language": "en",
- "description": "The REGEXPEXTRACTALL function is used to perform a regular
expression match on a given string str and extract all the parts that match the
first sub "
+ "description": "The REGEXP_EXTRACT_ALL function is used to perform a
regular expression match on a given string str and extract all the parts that
match the first sub-pattern of the specified pattern."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace-one.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace-one.md
index 843791e21d6..2d308c9e9ca 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace-one.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace-one.md
@@ -2,7 +2,7 @@
{
"title": "REGEXP_REPLACE_ONE",
"language": "en",
- "description": "The REGEXPREPLACEONE function is a powerful tool designed
to perform regular expression matching on a given string."
+ "description": "The REGEXP_REPLACE_ONE function is a powerful tool
designed to perform regular expression matching on a given string."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp.md
index 63a2d32d0b3..6948176c1f9 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/regexp.md
@@ -7,7 +7,7 @@
---
## Description
-~
+
Performs a regular expression match on the string str, returning true if the
match succeeds, otherwise false. pattern is the regular expression pattern.
It should be noted that when handling character set matching, Utf-8 standard
character classes should be used. This ensures that functions can correctly
identify and process various characters from different languages.
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/repeat.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/repeat.md
index f68c02a7a3e..89ca0b8529b 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/repeat.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/repeat.md
@@ -161,51 +161,3 @@ SELECT REPEAT('ṭṛìṭṛì', 3);
+--------------------------------------------------+
```
-## Description
-
-The REPEAT function is used to repeat a string a specified number of times.
-
-## Syntax
-
-```sql
-REPEAT( <str>, <count> )
-```
-
-## Parameters
-
-| Parameter | Description
|
-|-----------|---------------------------------------------------------------------------------------------------------------------------|
-| `<str>` | The string to be repeated.
|
-| `<count>` | The number of times to repeat. It must be a non-negative
integer. If it is less than 1, an empty string will be returned. |
-
-## Return Value
-
-Returns the string repeated the specified number of times. Special cases:
-
-- If any Parameter is NULL, NULL will be returned.
-
-## Examples
-
-```sql
-SELECT repeat("a", 3);
-```
-
-```text
-+----------------+
-| repeat('a', 3) |
-+----------------+
-| aaa |
-+----------------+
-```
-
-```sql
-SELECT repeat("a", -1);
-```
-
-```text
-+-----------------+
-| repeat('a', -1) |
-+-----------------+
-| |
-+-----------------+
-```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/replace-empty.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/replace-empty.md
index 48dd6498557..7c4d2e8e4d2 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/replace-empty.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/replace-empty.md
@@ -2,7 +2,7 @@
{
"title": "REPLACE_EMPTY",
"language": "en",
- "description": "The REPLACEEMPTY function is used to replace a part of
characters in a string with other characters. Unlike the REPLACE function,"
+ "description": "The REPLACE_EMPTY function is used to replace a part of
characters in a string with other characters. Unlike the REPLACE function,"
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
index 53292db7469..e1892f149b8 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
@@ -156,50 +156,3 @@ SELECT REVERSE('level'), REVERSE('12321');
+------------------+-------------------+
```
-## Description
-
-The REVERSE function is used to reverse the order of characters in a string or
the order of elements in an array.
-
-## Syntax
-
-```sql
-REVERSE( <seq> )
-```
-
-## Parameters
-
-| Parameter | Description |
-|-----------|----------------|
-| `<seq>` | The string or array whose order needs to be reversed. |
-
-## Return Value
-
-Returns the string or array with the reversed order. Special cases:
-
-- If any Parameter is NULL, NULL will be returned.
-
-## Examples
-
-```sql
-SELECT reverse('hello');
-```
-
-```text
-+------------------+
-| REVERSE('hello') |
-+------------------+
-| olleh |
-+------------------+
-```
-
-```sql
-SELECT reverse(['hello', 'world']);
-```
-
-```text
-+-----------------------------+
-| reverse(['hello', 'world']) |
-+-----------------------------+
-| ["world", "hello"] |
-+-----------------------------+
-```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/split-by-regexp.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/split-by-regexp.md
index fff9ea294a8..13426164f60 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/split-by-regexp.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/split-by-regexp.md
@@ -2,7 +2,7 @@
{
"title": "SPLIT_BY_REGEXP/REGEXP_SPLIT_TO_ARRAY",
"language": "en",
- "description": "The SPLITBYREGEXP function splits a string into an array
of strings based on a specified regular expression pattern. Unlike
SPLITBYSTRING,"
+ "description": "The SPLIT_BY_REGEXP function splits a string into an array
of strings based on a specified regular expression pattern. Unlike
SPLITBYSTRING,"
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/split-by-string.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/split-by-string.md
index bae133aed42..4da6a234778 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/split-by-string.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/split-by-string.md
@@ -2,7 +2,7 @@
{
"title": "SPLIT/SPLIT_BY_STRING",
"language": "en",
- "description": "The SPLITBYSTRING function splits an input string into an
array of strings based on a specified delimiter string."
+ "description": "The SPLIT_BY_STRING function splits an input string into
an array of strings based on a specified delimiter string."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
index 5211b428f5a..d1ab82607f4 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
@@ -2,7 +2,7 @@
{
"title": "TO_BASE64",
"language": "en",
- "description": "The TOBASE64 function converts an input string to Base64
encoded format. Base64 is an encoding method based on 64 printable characters,"
+ "description": "The TO_BASE64 function converts an input string to Base64
encoded format. Base64 is an encoding method based on 64 printable characters,"
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/url-decode.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/url-decode.md
index ac78a15c496..9de9c7a4e4e 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/url-decode.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/url-decode.md
@@ -30,7 +30,7 @@ The decoded value
```sql
select
url_decode('https%3A%2F%2Fdoris.apache.org%2Fzh-CN%2Fdocs%2Fsql-manual%2Fsql-functions%2Fstring-functions');
```
-```sql
+```text
+------------------------------------------------+
|
url_decode('https%3A%2F%2Fdoris.apache.org%2Fzh-CN%2Fdocs%2Fsql-manual%2Fsql-functions%2Fstring-functions')
|
+------------------------------------------------+
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/url-encode.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/url-encode.md
index 34434194f24..8363c413cfd 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/url-encode.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/url-encode.md
@@ -16,8 +16,6 @@ Use UTF-8 encoding to complete the URL encoding of the
provided text. Typically
URL_ENCODE( <str> )
```
-## Required Parameters
-
## Required Parameters
| Parameters | Description |
|------|------|
@@ -34,7 +32,7 @@ UTF-8 encoding completes the URL encoding of the provided text
select URL_ENCODE('Doris Q&A');
```
-```sql
+```text
+-------------------------+
| url_encode('Doris Q&A') |
+-------------------------+
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/struct-functions/named-struct.md
b/docs/sql-manual/sql-functions/scalar-functions/struct-functions/named-struct.md
index 928bfeb3cf9..c0bac001b89 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/struct-functions/named-struct.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/struct-functions/named-struct.md
@@ -1,7 +1,7 @@
---
{
"title": "NAMED_STRUCT",
- "language": "en-US",
+ "language": "en",
"description": "Constructs and returns a struct based on given field names
and values. The function accepts an even number of parameters,"
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/struct-functions/struct-element.md
b/docs/sql-manual/sql-functions/scalar-functions/struct-functions/struct-element.md
index eb55b18cb55..ffaf65c9da2 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/struct-functions/struct-element.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/struct-functions/struct-element.md
@@ -1,7 +1,7 @@
---
{
"title": "STRUCT_ELEMENT",
- "language": "en-US",
+ "language": "en",
"description": "Returns a specific field within a struct data column. The
function supports accessing fields in a struct through field position (index)
or field name."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/struct-functions/struct.md
b/docs/sql-manual/sql-functions/scalar-functions/struct-functions/struct.md
index e6a6d4cd172..21683790947 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/struct-functions/struct.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/struct-functions/struct.md
@@ -1,7 +1,7 @@
---
{
"title": "STRUCT | Struct Functions",
- "language": "en-US",
+ "language": "en",
"description": "Constructs and returns a struct based on given values. The
function accepts one or more parameters and returns a struct containing all
input elements.",
"sidebar_label": "STRUCT"
}
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ascii.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ascii.md
index 0f67eeaa219..1054a1beec7 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ascii.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ascii.md
@@ -2,7 +2,7 @@
{
"title": "ASCII",
"language": "en",
- "description": "Returns the ASCII code value of the first character in a
string. This function only processes the first character of the string,"
+ "description": "Returns the ASCII code value of the first character in a
string. This function only processes the first character of the string,
returning only the ASCII value of the first character for multi-character
strings."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
index 4216764057e..78b487e3d98 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
@@ -2,7 +2,7 @@
{
"title": "AUTO_PARTITION_NAME",
"language": "en",
- "description": "The AUTOPARTITIONNAME function is used to generate
partition names for auto partitions."
+ "description": "The AUTO_PARTITION_NAME function is used to generate
partition names for auto partitions. It supports two modes: RANGE mode
generates partition names based on time units, and LIST mode generates
partition names based on string values."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/char-length.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/char-length.md
index da75d298eaf..2fde6df3cd4 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/char-length.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/char-length.md
@@ -2,7 +2,7 @@
{
"title": "CHAR_LENGTH",
"language": "en",
- "description": "The CHARLENGTH function calculates the number of
characters (not bytes) in a string. For multi-byte characters (such as Chinese
characters),"
+ "description": "The CHAR_LENGTH function calculates the number of
characters (not bytes) in a string. For multi-byte characters (such as Chinese
characters), it returns the number of characters."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/char.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/char.md
index 9bb914a3596..521a7407b77 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/char.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/char.md
@@ -42,7 +42,7 @@ SELECT CHAR(68, 111, 114, 105, 115);
```
```text
+--------------------------------------+
-| char('utf8', 68, 111, 114, 105, 115) |
+| CHAR(68, 111, 114, 105, 115) |
+--------------------------------------+
| Doris |
+--------------------------------------+
@@ -54,7 +54,7 @@ SELECT CHAR(15049882, 15179199, 14989469);
```
```text
+--------------------------------------------+
-| char('utf8', 15049882, 15179199, 14989469) |
+| CHAR(15049882, 15179199, 14989469) |
+--------------------------------------------+
| 多睿丝 |
+--------------------------------------------+
@@ -66,7 +66,7 @@ SELECT CHAR(255);
```
```text
+-------------------+
-| char('utf8', 255) |
+| CHAR(255) |
+-------------------+
| NULL |
+-------------------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
index ce3b7c43646..6c77b28de78 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/count_substrings.md
@@ -2,7 +2,7 @@
{
"title": "COUNT_SUBSTRINGS",
"language": "en",
- "description": "The COUNTSUBSTRINGS function counts the number of
occurrences of a specified substring within a string."
+ "description": "The COUNT_SUBSTRINGS function counts the number of
occurrences of a specified substring within a string."
}
---
@@ -121,7 +121,7 @@ SELECT count_substrings('éèêëìíîïðñòó éèêëìíîïðñòó', 'é
+------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+
```
-7. Start position out of range
+8. Multi-byte Chinese substring with start position
```sql
SELECT count_substrings('你好，世界！你好，世界！', '世界', 0),
count_substrings('你好，世界！你好，世界！', '世界', 30);
@@ -132,4 +132,4 @@ SELECT count_substrings('你好，世界！你好，世界！', '世界', 0),
+-----------------------------------------------------------------------+------------------------------------------------------------------------+
| 0 |
0 |
+-----------------------------------------------------------------------+------------------------------------------------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/cut-to-first-significant-subdomain.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/cut-to-first-significant-subdomain.md
index 56618db0756..f5bc25333fe 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/cut-to-first-significant-subdomain.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/cut-to-first-significant-subdomain.md
@@ -2,7 +2,7 @@
{
"title": "CUT_TO_FIRST_SIGNIFICANT_SUBDOMAIN",
"language": "en",
- "description": "The CUTTOFIRSTSIGNIFICANTSUBDOMAIN function extracts the
effective part of a domain from a URL,"
+ "description": "The CUT_TO_FIRST_SIGNIFICANT_SUBDOMAIN function extracts
the effective part of a domain from a URL, including the top-level domain up to
the first significant subdomain."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/format-number.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/format-number.md
index 3a334f20eb1..1c4cea6d993 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/format-number.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/format-number.md
@@ -2,7 +2,7 @@
{
"title": "FORMAT_NUMBER",
"language": "en",
- "description": "The FORMATNUMBER function formats numerical values into
strings with unit symbols. Supported units are: K (thousand), M (million), B
(billion),"
+ "description": "The FORMAT_NUMBER function formats numerical values into
strings with unit symbols. Supported units are: K (thousand), M (million), B
(billion), T (trillion), Q (quadrillion)."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/hamming_distance.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/hamming_distance.md
index d3cc1f50297..babc5c1a27d 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/hamming_distance.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/hamming_distance.md
@@ -1,5 +1,9 @@
---
-title: HAMMING_DISTANCE
+{
+ "title": "HAMMING_DISTANCE",
+ "language": "en",
+ "description": "The HAMMING_DISTANCE function returns the number of
positions at which two strings of equal length differ."
+}
---
## Description
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/length.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/length.md
index f694d4243a6..8a38f996a09 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/length.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/length.md
@@ -2,7 +2,7 @@
{
"title": "LENGTH",
"language": "en",
- "description": "The LENGTH function returns the byte length of a string
(in bytes). This function calculates the number of bytes a string occupies in
UTF-8 encoding,"
+ "description": "The LENGTH function returns the byte length of a string
(in bytes). This function calculates the number of bytes a string occupies in
UTF-8 encoding, not the number of characters."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/levenshtein.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/levenshtein.md
index 9c161ed4c04..b23bfd29b5d 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/levenshtein.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/levenshtein.md
@@ -1,5 +1,9 @@
---
-title: LEVENSHTEIN
+{
+ "title": "LEVENSHTEIN",
+ "language": "en",
+ "description": "The LEVENSHTEIN function returns the Levenshtein edit
distance between two strings."
+}
---
## Description
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
index 89b236bc10d..905d9d811d5 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
@@ -2,7 +2,7 @@
{
"title": "MASK_LAST_N",
"language": "en",
- "description": "The MASKLASTN function is used to mask the last N bytes of
a string. It replaces uppercase letters with X, lowercase letters with x,"
+ "description": "The MASK_LAST_N function is used to mask the last N bytes
of a string. It replaces uppercase letters with X, lowercase letters with x,"
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ngram-search.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ngram-search.md
index 95c37ead5aa..deb9eecedf5 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ngram-search.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ngram-search.md
@@ -2,7 +2,7 @@
{
"title": "NGRAM_SEARCH",
"language": "en",
- "description": "The NGRAMSEARCH function calculates the N-gram similarity
between two strings. The similarity ranges from 0 to 1,"
+ "description": "The NGRAM_SEARCH function calculates the N-gram similarity
between two strings. The similarity ranges from 0 to 1, where higher values
indicate more similar strings."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/parse-data-size.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/parse-data-size.md
index 939ab408a65..2b180f3dc32 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/parse-data-size.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/parse-data-size.md
@@ -2,7 +2,7 @@
{
"title": "PARSE_DATA_SIZE",
"language": "en",
- "description": "The PARSEDATASIZE function parses a string with storage
units (such as \"1.5GB\") and converts it to a numeric value in bytes."
+ "description": "The PARSE_DATA_SIZE function parses a string with storage
units (such as \"1.5GB\") and converts it to a numeric value in bytes."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/parse-url.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/parse-url.md
index b3bd3bca203..24bbf2149cd 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/parse-url.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/parse-url.md
@@ -2,7 +2,7 @@
{
"title": "PARSE_URL",
"language": "en",
- "description": "The PARSEURL function is mainly used to parse URL strings
and extract various components from them, such as protocols, hosts, paths,
query parameters,"
+ "description": "The PARSE_URL function is mainly used to parse URL strings
and extract various components from them, such as protocols, hosts, paths,
query parameters,"
}
---
@@ -56,6 +56,6 @@ SELECT parse_url ('https://doris.apache.org/', null);
+----------------------------------------------+
```
-## 相关命令
+## See Also
-如果想获取 QUERY 中的特定
Parameter，可使用[extract_url_parameter](./extract-url-parameter.md)。
+If you want to extract a specific parameter from the QUERY, use
[extract_url_parameter](./extract-url-parameter.md).
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
index 69f4c1ed199..7c7ff828613 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
@@ -164,45 +164,3 @@ SELECT POSITION('123' IN '456123789'), POSITION('-',
'phone: 123-456-7890', 11);
+------------------------------+-------------------------------------------+
```
-## Description
-
-The POSITION function is used to find the position of a substring within a
string (counting from 1).
-
-If the substring is not found, the function returns 0.
-
-## Syntax
-
-```sql
-POSITION ( <substr> IN <str> )
-
-POSITION ( <substr>, <str> [, <pos>] )
-```
-
-## Parameters
-
-| Parameter | Description
|
-| --------- |
------------------------------------------------------------------------------------------
|
-| `substr` | The substring to search for
|
-| `str` | The string to be searched
|
-| `pos` | If this parameter is specified, the position of substr is
searched from the string starting with the pos subscript |
-
-## Return value
-
-The position of substr in str (counting from 1).
-If substr is not found, returns 0.
-
-```sql
-SELECT POSITION('bar' IN 'foobarbar'),
- POSITION('bar', 'foobarbar'),
- POSITION('bar', 'foobarbar', 5),
- POSITION('xbar', 'foobar');
-```
-
-```text
-
-+----------------------------------+--------------------------------+-----------------------------------+----------------------------------+
-| position('bar' in 'foobarbar') | position('bar', 'foobarbar') |
position('bar', 'foobarbar', 5) | position('xbar', 'foobar') |
-+----------------------------------+--------------------------------+-----------------------------------+----------------------------------+
-| 4 | 4 |
7 | 0 |
-+----------------------------------+--------------------------------+-----------------------------------+----------------------------------+
-```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/protocol.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/protocol.md
index fa39fd44bb8..bd21e0165e0 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/protocol.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/protocol.md
@@ -54,6 +54,6 @@ SELECT protocol(null);
+----------------+
```
-## 相关命令
+## See Also
-If you want to extract other parts of the URL, you can use
[parse_url](./parse-url.md)。
+If you want to extract other parts of the URL, you can use
[parse_url](./parse-url.md).
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/quote.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/quote.md
index 4c8bb7ccbdd..d8aef0bec57 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/quote.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/quote.md
@@ -30,7 +30,6 @@ Special cases:
- If input is NULL, returns the string 'NULL' (without quotes)
- Single quotes `'` are escaped to `\'`
- Backslashes `\` are escaped to `\\`
-- `\\` is escaped to `\`
- Empty string returns `''`
## Examples
@@ -55,7 +54,7 @@ SELECT quote("It's a test");
+----------------------+
| quote("It's a test") |
+----------------------+
-| 'It's a test' |
+| 'It\'s a test' |
+----------------------+
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all.md
index f383cfa0966..5786ec2a5d1 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all.md
@@ -2,7 +2,7 @@
{
"title": "REGEXP_EXTRACT_ALL",
"language": "en",
- "description": "The REGEXPEXTRACTALL function is used to perform a regular
expression match on a given string str and extract all the parts that match the
first sub "
+ "description": "The REGEXP_EXTRACT_ALL function is used to perform a
regular expression match on a given string str and extract all the parts that
match the first sub-pattern of the specified pattern."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace-one.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace-one.md
index 843791e21d6..2d308c9e9ca 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace-one.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace-one.md
@@ -2,7 +2,7 @@
{
"title": "REGEXP_REPLACE_ONE",
"language": "en",
- "description": "The REGEXPREPLACEONE function is a powerful tool designed
to perform regular expression matching on a given string."
+ "description": "The REGEXP_REPLACE_ONE function is a powerful tool
designed to perform regular expression matching on a given string."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp.md
index 63a2d32d0b3..6948176c1f9 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/regexp.md
@@ -7,7 +7,7 @@
---
## Description
-~
+
Performs a regular expression match on the string str, returning true if the
match succeeds, otherwise false. pattern is the regular expression pattern.
It should be noted that when handling character set matching, Utf-8 standard
character classes should be used. This ensures that functions can correctly
identify and process various characters from different languages.
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/repeat.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/repeat.md
index f68c02a7a3e..89ca0b8529b 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/repeat.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/repeat.md
@@ -161,51 +161,3 @@ SELECT REPEAT('ṭṛìṭṛì', 3);
+--------------------------------------------------+
```
-## Description
-
-The REPEAT function is used to repeat a string a specified number of times.
-
-## Syntax
-
-```sql
-REPEAT( <str>, <count> )
-```
-
-## Parameters
-
-| Parameter | Description
|
-|-----------|---------------------------------------------------------------------------------------------------------------------------|
-| `<str>` | The string to be repeated.
|
-| `<count>` | The number of times to repeat. It must be a non-negative
integer. If it is less than 1, an empty string will be returned. |
-
-## Return Value
-
-Returns the string repeated the specified number of times. Special cases:
-
-- If any Parameter is NULL, NULL will be returned.
-
-## Examples
-
-```sql
-SELECT repeat("a", 3);
-```
-
-```text
-+----------------+
-| repeat('a', 3) |
-+----------------+
-| aaa |
-+----------------+
-```
-
-```sql
-SELECT repeat("a", -1);
-```
-
-```text
-+-----------------+
-| repeat('a', -1) |
-+-----------------+
-| |
-+-----------------+
-```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/replace-empty.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/replace-empty.md
index 48dd6498557..7c4d2e8e4d2 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/replace-empty.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/replace-empty.md
@@ -2,7 +2,7 @@
{
"title": "REPLACE_EMPTY",
"language": "en",
- "description": "The REPLACEEMPTY function is used to replace a part of
characters in a string with other characters. Unlike the REPLACE function,"
+ "description": "The REPLACE_EMPTY function is used to replace a part of
characters in a string with other characters. Unlike the REPLACE function,"
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
index 53292db7469..e1892f149b8 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
@@ -156,50 +156,3 @@ SELECT REVERSE('level'), REVERSE('12321');
+------------------+-------------------+
```
-## Description
-
-The REVERSE function is used to reverse the order of characters in a string or
the order of elements in an array.
-
-## Syntax
-
-```sql
-REVERSE( <seq> )
-```
-
-## Parameters
-
-| Parameter | Description |
-|-----------|----------------|
-| `<seq>` | The string or array whose order needs to be reversed. |
-
-## Return Value
-
-Returns the string or array with the reversed order. Special cases:
-
-- If any Parameter is NULL, NULL will be returned.
-
-## Examples
-
-```sql
-SELECT reverse('hello');
-```
-
-```text
-+------------------+
-| REVERSE('hello') |
-+------------------+
-| olleh |
-+------------------+
-```
-
-```sql
-SELECT reverse(['hello', 'world']);
-```
-
-```text
-+-----------------------------+
-| reverse(['hello', 'world']) |
-+-----------------------------+
-| ["world", "hello"] |
-+-----------------------------+
-```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/split-by-regexp.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/split-by-regexp.md
index fff9ea294a8..13426164f60 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/split-by-regexp.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/split-by-regexp.md
@@ -2,7 +2,7 @@
{
"title": "SPLIT_BY_REGEXP/REGEXP_SPLIT_TO_ARRAY",
"language": "en",
- "description": "The SPLITBYREGEXP function splits a string into an array
of strings based on a specified regular expression pattern. Unlike
SPLITBYSTRING,"
+ "description": "The SPLIT_BY_REGEXP function splits a string into an array
of strings based on a specified regular expression pattern. Unlike
SPLITBYSTRING,"
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/split-by-string.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/split-by-string.md
index bae133aed42..4da6a234778 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/split-by-string.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/split-by-string.md
@@ -2,7 +2,7 @@
{
"title": "SPLIT/SPLIT_BY_STRING",
"language": "en",
- "description": "The SPLITBYSTRING function splits an input string into an
array of strings based on a specified delimiter string."
+ "description": "The SPLIT_BY_STRING function splits an input string into
an array of strings based on a specified delimiter string."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
index 5211b428f5a..d1ab82607f4 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
@@ -2,7 +2,7 @@
{
"title": "TO_BASE64",
"language": "en",
- "description": "The TOBASE64 function converts an input string to Base64
encoded format. Base64 is an encoding method based on 64 printable characters,"
+ "description": "The TO_BASE64 function converts an input string to Base64
encoded format. Base64 is an encoding method based on 64 printable characters,"
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/url-decode.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/url-decode.md
index ac78a15c496..9de9c7a4e4e 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/url-decode.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/url-decode.md
@@ -30,7 +30,7 @@ The decoded value
```sql
select
url_decode('https%3A%2F%2Fdoris.apache.org%2Fzh-CN%2Fdocs%2Fsql-manual%2Fsql-functions%2Fstring-functions');
```
-```sql
+```text
+------------------------------------------------+
|
url_decode('https%3A%2F%2Fdoris.apache.org%2Fzh-CN%2Fdocs%2Fsql-manual%2Fsql-functions%2Fstring-functions')
|
+------------------------------------------------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/url-encode.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/url-encode.md
index 34434194f24..8363c413cfd 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/url-encode.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/url-encode.md
@@ -16,8 +16,6 @@ Use UTF-8 encoding to complete the URL encoding of the
provided text. Typically
URL_ENCODE( <str> )
```
-## Required Parameters
-
## Required Parameters
| Parameters | Description |
|------|------|
@@ -34,7 +32,7 @@ UTF-8 encoding completes the URL encoding of the provided text
select URL_ENCODE('Doris Q&A');
```
-```sql
+```text
+-------------------------+
| url_encode('Doris Q&A') |
+-------------------------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/named-struct.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/named-struct.md
index 928bfeb3cf9..c0bac001b89 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/named-struct.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/named-struct.md
@@ -1,7 +1,7 @@
---
{
"title": "NAMED_STRUCT",
- "language": "en-US",
+ "language": "en",
"description": "Constructs and returns a struct based on given field names
and values. The function accepts an even number of parameters,"
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/struct-element.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/struct-element.md
index eb55b18cb55..ffaf65c9da2 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/struct-element.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/struct-element.md
@@ -1,7 +1,7 @@
---
{
"title": "STRUCT_ELEMENT",
- "language": "en-US",
+ "language": "en",
"description": "Returns a specific field within a struct data column. The
function supports accessing fields in a struct through field position (index)
or field name."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/struct.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/struct.md
index e6a6d4cd172..21683790947 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/struct.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/struct-functions/struct.md
@@ -1,7 +1,7 @@
---
{
"title": "STRUCT | Struct Functions",
- "language": "en-US",
+ "language": "en",
"description": "Constructs and returns a struct based on given values. The
function accepts one or more parameters and returns a struct containing all
input elements.",
"sidebar_label": "STRUCT"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
