This is an automated email from the ASF dual-hosted git repository.
leonard pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/flink.git
commit cf33d934366a172ace8104b43c7ce833c334b951
Author: Leonard Xu <xbjt...@gmail.com>
AuthorDate: Wed Mar 15 18:17:08 2023 +0800
[hotfix][docs][docs-zh] Use markdown SQL template for SQL functions examples
---
docs/data/sql_functions.yml | 22 +++++++++++-----------
docs/data/sql_functions_zh.yml | 20 ++++++++++----------
2 files changed, 21 insertions(+), 21 deletions(-)
diff --git a/docs/data/sql_functions.yml b/docs/data/sql_functions.yml
index b51e68c0c17..16187c64221 100644
--- a/docs/data/sql_functions.yml
+++ b/docs/data/sql_functions.yml
@@ -533,7 +533,7 @@ temporal:
Note that this function can return `NULL`, and you may have to consider
this case. For example, if you want to filter out late data you can use:
- ```
+ ```sql
WHERE
CURRENT_WATERMARK(ts) IS NULL
OR ts > CURRENT_WATERMARK(ts)
@@ -564,7 +564,7 @@ conditional:
If all arguments are NULL, it returns NULL as well. The return type is
the least restrictive, common type of all of its arguments.
The return type is nullable if all arguments are nullable as well.
- ```
+ ```sql
-- Returns 'default'
COALESCE(NULL, 'default')
@@ -645,7 +645,7 @@ json:
allowed. If the string is valid JSON, but not that type, `false` is
returned. The default is
`VALUE`.
- ```
+ ```sql
-- TRUE
'1' IS JSON
'[]' IS JSON
@@ -678,7 +678,7 @@ json:
If the error behavior is omitted, `FALSE ON ERROR` is assumed as the
default.
- ```
+ ```sql
-- TRUE
SELECT JSON_EXISTS('{"a": true}', '$.a');
-- FALSE
@@ -702,7 +702,7 @@ json:
This function returns a JSON string containing the serialized value. If
the value is `NULL`,
the function returns `NULL`.
- ```
+ ```sql
-- NULL
JSON_STRING(CAST(NULL AS INT))
@@ -741,7 +741,7 @@ json:
When using JSON_VALUE in SQL, the path is a character parameter which is
already single quoted,
so you have to escape the single quotes around property name, such as
`JSON_VALUE('{"a b": "true"}', '$.[''a b'']')`.
- ```
+ ```sql
-- "true"
JSON_VALUE('{"a": true}', '$.a')
@@ -777,7 +777,7 @@ json:
case an error was raised, respectively. By default, in both cases `null`
is returned. Other
choices are to use an empty array, an empty object, or to raise an error.
- ```
+ ```sql
-- '{ "b": 1 }'
JSON_QUERY('{ "a": { "b": 1 } }', '$.a')
-- '[1, 2]'
@@ -822,7 +822,7 @@ json:
`JSON_ARRAY`) are inserted directly rather than as a string. This allows
building nested JSON
structures.
- ```
+ ```sql
-- '{}'
JSON_OBJECT()
@@ -858,7 +858,7 @@ json:
This function is currently not supported in `OVER` windows.
- ```
+ ```sql
-- '{"Apple":2,"Banana":17,"Orange":0}'
SELECT
JSON_OBJECTAGG(KEY product VALUE cnt)
@@ -877,7 +877,7 @@ json:
`JSON_ARRAY`) are inserted directly rather than as a string. This allows
building nested JSON
structures.
- ```
+ ```sql
-- '[]'
JSON_ARRAY()
-- '[1,"2"]'
@@ -904,7 +904,7 @@ json:
This function is currently not supported in `OVER` windows, unbounded
session windows, or hop
windows.
- ```
+ ```sql
-- '["Apple","Banana","Orange"]'
SELECT
JSON_ARRAYAGG(product)
diff --git a/docs/data/sql_functions_zh.yml b/docs/data/sql_functions_zh.yml
index 2aab48e4fdc..2bbb5fe47c2 100644
--- a/docs/data/sql_functions_zh.yml
+++ b/docs/data/sql_functions_zh.yml
@@ -648,7 +648,7 @@ temporal:
TIMESTAMP_LTZ(3)。
请注意，此函数可以返回 `NULL`，您可能必须考虑这种情况。例如，如果您想过滤掉后期数据，您可以使用：
- ```
+ ```sql
WHERE
CURRENT_WATERMARK(ts) IS NULL
OR ts > CURRENT_WATERMARK(ts)
@@ -737,7 +737,7 @@ json:
指定可选类型参数将会限制 JSON 对象所允许的类型。
如果字符串是有效的 JSON，但不是指定的类型，则返回 `false`。默认值为 `VALUE`。
- ```
+ ```sql
-- TRUE
'1' IS JSON
'[]' IS JSON
@@ -770,7 +770,7 @@ json:
如果要忽略错误行为，那么将 `FALSE ON ERROR` 设为默认值。
- ```
+ ```sql
-- TRUE
SELECT JSON_EXISTS('{"a": true}', '$.a');
-- FALSE
@@ -793,7 +793,7 @@ json:
此函数返回一个包含序列化值的 JSON 字符串。如果值为 `NULL`，函数返回 `NULL`。
- ```
+ ```sql
-- NULL
JSON_STRING(CAST(NULL AS INT))
@@ -825,7 +825,7 @@ json:
对于路径表达式中包含特殊字符（如空格），你可以使用`['property']` 获
`["property"]`来引用父对象中指定的属性。请确保在属性名两侧加上单引号或双引号。
当在 SQL 使用 JSON_VALUE
时，路径作为一个字符串参数已经被单引号引用了，因此你必须将属性名上的单引号转义，如`JSON_VALUE('{"a b": "true"}', '$.[''a
b'']')`。
- ```
+ ```sql
-- "true"
JSON_VALUE('{"a": true}', '$.a')
@@ -859,7 +859,7 @@ json:
`onEmpty` 和 `onError` 分别决定路径表达式为空或引发错误时的行为。默认情况下，这两种情况都会返回 `null`。其他选择是
使用空数组、空对象或引发错误。
- ```
+ ```sql
-- '{ "b": 1 }'
JSON_QUERY('{ "a": { "b": 1 } }', '$.a')
-- '[1, 2]'
@@ -901,7 +901,7 @@ json:
值是由另一个 JSON 构造函数调用 (`JSON_OBJECT`，`JSON_ARRAY`)
直接插入所创建，而不是作为一个字符串。它允许构建嵌套的 JSON 结构。
- ```
+ ```sql
-- '{}'
JSON_OBJECT()
@@ -936,7 +936,7 @@ json:
目前在 `OVER` windows 中不支持此函数。
- ```
+ ```sql
-- '{"Apple":2,"Banana":17,"Orange":0}'
SELECT
JSON_OBJECTAGG(KEY product VALUE cnt)
@@ -951,7 +951,7 @@ json:
元素是由另一个 JSON 构造函数调用 (`JSON_OBJECT`，`JSON_ARRAY`)
直接插入所创建，而不是作为一个字符串。它允许构建嵌套的 JSON 结构。
- ```
+ ```sql
-- '[]'
JSON_ARRAY()
-- '[1,"2"]'
@@ -976,7 +976,7 @@ json:
此函数目前不支持 `OVER` windows、未绑定的 session windows 或 hop windows。
- ```
+ ```sql
-- '["Apple","Banana","Orange"]'
SELECT
JSON_ARRAYAGG(product)
