This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 e617ade51c9 update json_extract_xxx (#2629)
e617ade51c9 is described below
commit e617ade51c9fa79aea2b66d3f94167f0b3634c56
Author: Jerry Hu <[email protected]>
AuthorDate: Fri Jul 18 11:47:44 2025 +0800
update json_extract_xxx (#2629)
## Versions
- [x] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
---
.../json-functions/get-json-bigint.md | 71 +---------------
.../json-functions/get-json-double.md | 73 +----------------
.../json-functions/get-json-int.md | 71 +---------------
.../json-functions/get-json-string.md | 81 +------------------
.../json-functions/json-extract-bigint.md | 79 ++++++++++++++++++
.../json-functions/json-extract-bool.md | 79 ++++++++++++++++++
.../json-functions/json-extract-double.md | 79 ++++++++++++++++++
.../json-functions/json-extract-int.md | 79 ++++++++++++++++++
.../json-functions/json-extract-isnull.md | 75 +++++++++++++++++
.../json-functions/json-extract-largeint.md | 78 ++++++++++++++++++
.../json-functions/json-extract-string.md | 94 ++++++++++++++++++++++
.../json-functions/get-json-bigint.md | 87 +-------------------
.../json-functions/get-json-double.md | 79 +-----------------
.../json-functions/get-json-int.md | 71 +---------------
.../json-functions/get-json-string.md | 93 +--------------------
.../json-functions/json-extract-bigint.md | 78 ++++++++++++++++++
.../json-functions/json-extract-bool.md | 78 ++++++++++++++++++
.../json-functions/json-extract-double.md | 79 ++++++++++++++++++
.../json-functions/json-extract-int.md | 79 ++++++++++++++++++
.../json-functions/json-extract-isnull.md | 75 +++++++++++++++++
.../json-functions/json-extract-largeint.md | 78 ++++++++++++++++++
.../json-functions/json-extract-string.md | 93 +++++++++++++++++++++
22 files changed, 1131 insertions(+), 618 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint.md
index 42312aee524..f4a140863ba 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint.md
@@ -7,73 +7,4 @@
## Description
-Parses and obtains the integer (BIGINT) content of the specified path within
the json string.
-
-## Syntax
-
-```sql
-GET_JSON_BIGINT( <json_str>, <json_path>)
-```
-
-## Required Parameters
-| parameters| described|
-|------|------|
-| `<json_str>`| The JSON string from which to extract data is needed. |
-| `<json_path>`| JSON path, specifying the location of the field. Paths can be
denoted in dot notation. |
-
-
-## Return Value
-- Returns the BIGINT value of the field pointed to by the path.
-- Returns NULL if no corresponding field is found in the specified path, or
the field value cannot be converted to type BIGINT.
-
-## Usage Notes
-
-Where `<json_str>` `must start with the $symbol and use. As a path splitter.
If the path contains. , you can use double quotes to enclose it.
-Use [ ] to represent the array index, starting from 0.
-The content of path cannot contain ", [and].
-Returns NULL if the <json_str>format is incorrect, or the <json_path>format is
incorrect, or a match cannot be found.
-In addition, it is recommended to use the jsonb type and the jsonb_extract_XXX
function to achieve the same functionality.
-Special circumstances will be handled as follows:
-- Returns <json_path>NULL if the specified field does not exist in JSON
-- If <json_path>the actual type of the specified field in JSON is inconsistent
with the type specified by json_extract_t, the specified type t will be
returned if it can be losslessly converted to the specified type, and NULL will
be returned if it cannot.
-
-## Examples
-
-1. Get the value with key as "k1"
-```sql
-SELECT get_json_bigint('{"k1":1, "k2":"2"}', "$.k1");
-```
-
-```sql
-+-----------------------------------------------+
-| get_json_bigint('{"k1":1, "k2":"2"}', '$.k1') |
-+-----------------------------------------------+
-| 1 |
-+-----------------------------------------------+
-```
-2. Gets the second element in the array with key "my.key"
-```sql
-SELECT get_json_bigint('{"k1":"v1", "my.key":[1, 1678708107000, 3]}', '$.
"my.key"[1]');
-```
-
-```sql
-+---------------------------------------------------------------------------------+
-| get_json_bigint('{"k1":"v1", "my.key":[1, 1678708107000, 3]}', '$.
"my.key"[1]') |
-+---------------------------------------------------------------------------------+
-|
1678708107000 |
-+---------------------------------------------------------------------------------+
-```
-3. Gets the first element in an array with secondary path k1.key -> k2
-```sql
-SELECT get_json_bigint('{"k1.key":{"k2":[1678708107000, 2]}}', '$.
"k1.key".k2[0]');
-```
-
-```sql
-
-+-----------------------------------------------------------------------------+
-| get_json_bigint('{"k1.key":{"k2":[1678708107000, 2]}}', '$."k1.key".k2[0]') |
-+-----------------------------------------------------------------------------+
-| 1678708107000 |
-+-----------------------------------------------------------------------------+
-
-```
\ No newline at end of file
+Alias of function [`JSON_EXTRACT_BIGINT`](./json-extract-bigint.md).
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-double.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-double.md
index 9ab6a4a8f1b..793acb4c816 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-double.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-double.md
@@ -7,75 +7,4 @@
## Description
-Function is used to extract the value of a field from a JSON document and
convert it to the DOUBLE type. This function returns the value of the field on
the specified path, or returns NULL if the value cannot be converted to type
DOUBLE or the field pointed to by the path does not exist.
-
-## Syntax
-
-```sql
-GET_JSON_DOUBLE( <json_str>, <json_path>)
-```
-
-## Required Parameters
-
-| parameters| described|
-|------|------|
-| `<json_str>`| The JSON string from which to extract data is needed. |
-| `<json_path>`| JSON path, specifying the location of the field. Paths can be
denoted in dot notation. |
-
-## Return Value
-
-- Returns the DOUBLE value of the field pointed to by the path.
-- Returns NULL if no corresponding field is found in the specified path, or
the field value cannot be converted to type DOUBLE.
-
-## Usage Notes
-
-Parses and obtains the floating point content of the specified path within the
json string.
-Where `<json_path>` `must start with the $symbol and use. As a path splitter.
If the path contains. , you can use double quotes to enclose it.
-Use [ ] to represent the array index, starting from 0.
-The content of path cannot contain ", [and].
-Returns NULL if `<json_str>` is incorrectly formatted, or json_path is
incorrectly formatted, or a match cannot be found.
-In addition, it is recommended to use the jsonb type and the jsonb_extract_XXX
function to achieve the same functionality.
-Special circumstances will be handled as follows:
-- Returns NULL if the field specified by json_path does not exist in JSON
-- If the actual type of the field specified by json_path in JSON is
inconsistent with the type specified by json_extract_t, the specified type t is
returned if it can be losslessly converted to the specified type, and NULL is
returned if it cannot.
-
-## Examples
-
-1. Get the value with key as "k1"
-
-```sql
-SELECT get_json_double('{"k1":1.3, "k2":"2"}', "$.k1");
-```
-
-```sql
-+-------------------------------------------------+
-| get_json_double('{"k1":1.3, "k2":"2"}', '$.k1') |
-+-------------------------------------------------+
-| 1.3 |
-+-------------------------------------------------+
-```
-2. Gets the second element in the array with key "my.key"
-
-```sql
-SELECT get_json_double('{"k1":"v1", "my.key":[1.1, 2.2, 3.3]}', '$.
"my.key"[1]');
-```
-
-```sql
-+---------------------------------------------------------------------------+
-| get_json_double('{"k1":"v1", "my.key":[1.1, 2.2, 3.3]}', '$."my.key"[1]') |
-+---------------------------------------------------------------------------+
-| 2.2 |
-+---------------------------------------------------------------------------+
-```
-
-3. Gets the first element in an array with secondary path k1.key -> k2
-```sql
-SELECT get_json_double('{"k1.key":{"k2":[1.1, 2.2]}}', '$."k1.key".k2[0]');
-```
-```sql
-+---------------------------------------------------------------------+
-| get_json_double('{"k1.key":{"k2":[1.1, 2.2]}}', '$."k1.key".k2[0]') |
-+---------------------------------------------------------------------+
-| 1.1 |
-+---------------------------------------------------------------------+
-```
\ No newline at end of file
+Alias of function [`JSON_EXTRACT_DOUBLE`](./json-extract-double.md).
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-int.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-int.md
index 54e3512e7da..8f6732859f2 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-int.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-int.md
@@ -7,73 +7,4 @@
## Description
-Function is used to extract the value of a field from a JSON document and
convert it to type INT. This function returns the value of the field on the
specified path, or returns NULL if the value cannot be converted to type INT or
the field pointed to by the path does not exist.
-
-## Syntax
-
-```sql
-GET_JSON_INT( <json_str>, <json_path>)
-```
-
-## Required Parameters
-
-| parameters| described|
-|------|------|
-| `<json_str>`| The JSON string from which to extract data is needed. |
-| `<json_path>`| JSON path, specifying the location of the field. Paths can be
denoted in dot notation. |
-
-## Usage Notes
-
-Parses and obtains the integer content of the specified path within the json
string.
-Where `<json_path>` `must start with the $symbol and use. As a path splitter.
If the path contains. , you can use double quotes to enclose it.
-Use [ ] to represent the array index, starting from 0.
-The content of path cannot contain ", [and].
-Returns NULL if the <json_str>format is incorrect, or the <json_path>format is
incorrect, or a match cannot be found.
-In addition, it is recommended to use the jsonb type and the jsonb_extract_XXX
function to achieve the same functionality.
-Special circumstances will be handled as follows:
-- Returns <json_path>NULL if the specified field does not exist in JSON
-- If <json_path>the actual type of the specified field in JSON is inconsistent
with the type specified by json_extract_t, the specified type t will be
returned if it can be losslessly converted to the specified type, and NULL will
be returned if it cannot.
-
-## Examples
-
-1. Get the value with key as "k1"
-
-```sql
-SELECT get_json_int('{"k1":1, "k2":"2"}', "$.k1");
-```
-
-```sql
-
-+--------------------------------------------+
-| get_json_int('{"k1":1, "k2":"2"}', '$.k1') |
-+--------------------------------------------+
-| 1 |
-+--------------------------------------------+
-```
-
-2. Gets the second element in the array with key "my.key"
-
-```sql
-SELECT get_json_int('{"k1":"v1", "my.key":[1, 2, 3]}', '$."my.key"[1]');
-```
-
-```sql
-+------------------------------------------------------------------+
-| get_json_int('{"k1":"v1", "my.key":[1, 2, 3]}', '$."my.key"[1]') |
-+------------------------------------------------------------------+
-| 2 |
-+------------------------------------------------------------------+
-
-3. Gets the first element in an array with secondary path k1.key -> k2
-
-```sql
- SELECT get_json_int('{"k1.key":{"k2":[1, 2]}}', '$."k1.key".k2[0]');
- ```
-
- ```sql
-+--------------------------------------------------------------+
-| get_json_int('{"k1.key":{"k2":[1, 2]}}', '$."k1.key".k2[0]') |
-+--------------------------------------------------------------+
-| 1 |
-+--------------------------------------------------------------+
-```
\ No newline at end of file
+Alias of function [`JSON_EXTRACT_INT`](./json-extract-int.md).
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-string.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-string.md
index 8821d2ec160..d4398ea459b 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-string.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-string.md
@@ -7,83 +7,4 @@
## Description
-This function is used to extract a field's value from a JSON document and
convert it to `STRING` type. It returns the field value at the specified path.
If the value cannot be converted to a string, or if the field at the specified
path does not exist, it returns `NULL`.
-
-## Syntax
-
-```sql
-GET_JSON_STRING( <json_str>, <json_path>)
-```
-
-## Required Parameters
-
-| Parameter | Description |
-|-------------|-------------------------------------------------------|
-| `<json_str>` | The JSON string from which data needs to be extracted. |
-| `<json_path>` | JSON path that specifies the field's location. The path can
use dot notation. |
-
-## Return Value
-It returns the `STRING` value of the field at the specified path.
-If the specified path does not point to a valid field or the field value
cannot be converted to a `STRING` type, it returns `NULL`.
-
-## Usage Notes
-
-Parses and retrieves the string content of the specified path in the JSON
string.
-The `<json_path>` must start with the `$` symbol, using `.` as the path
delimiter. If the path contains a `.`, it should be enclosed in double quotes.
-Use `[ ]` to indicate array indices, starting from 0.
-The path should not contain `", [`, and `]`.
-If the `<json_str>` format is incorrect, or if the `<json_path>` format is
invalid, or if no matching field is found, `NULL` is returned.
-
-Additionally, it is recommended to use the `jsonb` type and
`jsonb_extract_XXX` functions to achieve the same functionality.
-
-Special case handling as follows:
-- If the field specified by `<json_path>` does not exist in the JSON, return
`NULL`.
-- If the actual type of the field specified by `<json_path>` differs from the
type expected by `json_extract_t`, if it can be losslessly converted to the
expected type, it will return the specified type. Otherwise, it will return
`NULL`.
-
-## Examples
-
-1. Get the value for key "k1"
-
-```sql
-
-SELECT get_json_string('{"k1":"v1", "k2":"v2"}', "$.k1");
-```
-
-```sql
-+---------------------------------------------------+
-| get_json_string('{"k1":"v1", "k2":"v2"}', '$.k1') |
-+---------------------------------------------------+
-| v1 |
-+---------------------------------------------------+
-```
-2. Get the second element of the array for key "my.key"
-
-``` sql
-SELECT get_json_string('{"k1":"v1", "my.key":["e1", "e2", "e3"]}',
'$."my.key"[1]');
-
-```
-```sql
-+------------------------------------------------------------------------------+
-| get_json_string('{"k1":"v1", "my.key":["e1", "e2", "e3"]}', '$."my.key"[1]')
|
-+------------------------------------------------------------------------------+
-| e2
|
-+------------------------------------------------------------------------------+
-
-```
-3. Get the first element of the array in the secondary path k1.key -> k2
-
-
-```sql
- SELECT get_json_string('{"k1.key":{"k2":["v1", "v2"]}}', '$."k1.key".k2[0]');
-
-```
-
-```sql
-
-+-----------------------------------------------------------------------+
-| get_json_string('{"k1.key":{"k2":["v1", "v2"]}}', '$."k1.key".k2[0]') |
-+-----------------------------------------------------------------------+
-| v1 |
-+-----------------------------------------------------------------------+
-
-```
\ No newline at end of file
+Alias of function [`JSON_EXTRACT_STRING`](./json-extract-string.md).
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
index ed14a933f23..9767fbb6528 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
@@ -5,3 +5,82 @@
}
---
+## Description
+`JSON_EXTRACT_BIGINT` extracts the field specified by `<json_path>` from a
JSON object and converts it to
[`BIGINT`](../../../basic-element/sql-data-types/numeric/BIGINT.md) type.
+
+## Syntax
+```sql
+JSON_EXTRACT_BIGINT(<json_object>, <json_path>)
+```
+
+## Parameters
+- `<json_object>`: JSON type, the target parameter to extract from.
+- `<json_path>`: String type, the JSON path to extract the target element from
the target JSON.
+
+## Return Value
+`Nullable(BIGINT)` Returns the extracted BIGINT value, returns NULL in some
cases
+
+## Usage Notes
+1. If `<json_object>` or `<json_path>` is NULL, returns NULL.
+2. If the element specified by `<json_path>` does not exist, returns NULL.
+3. If the element specified by `<json_path>` cannot be converted to BIGINT,
returns NULL.
+4. Its behavior is consistent with "cast + json_extract", which is equivalent
to:
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as BIGINT)
+ ```
+
+## Examples
+1. Normal parameters
+ ```sql
+ SELECT json_extract_bigint('{"id": 122222222222223, "name": "doris"}',
'$.id');
+ ```
+ ```text
+ +-------------------------------------------------------------------------+
+ | json_extract_bigint('{"id": 122222222222223, "name": "doris"}', '$.id') |
+ +-------------------------------------------------------------------------+
+ | 122222222222223 |
+ +-------------------------------------------------------------------------+
+ ```
+2. Case where path does not exist
+ ```sql
+ SELECT json_extract_bigint('{"id": 122222222222223, "name": "doris"}',
'$.id2');
+ ```
+ ```text
+
+--------------------------------------------------------------------------+
+ | json_extract_bigint('{"id": 122222222222223, "name": "doris"}', '$.id2')
|
+
+--------------------------------------------------------------------------+
+ | NULL
|
+
+--------------------------------------------------------------------------+
+ ```
+3. NULL parameters
+ ```sql
+ SELECT json_extract_bigint('{"id": 122222222222223, "name": "doris"}',
NULl);
+ ```
+ ```text
+ +-----------------------------------------------------------------------+
+ | json_extract_bigint('{"id": 122222222222223, "name": "doris"}', NULl) |
+ +-----------------------------------------------------------------------+
+ | NULL |
+ +-----------------------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_bigint(NULL, '$.id2');
+ ```
+ ```text
+ +------------------------------------+
+ | json_extract_bigint(NULL, '$.id2') |
+ +------------------------------------+
+ | NULL |
+ +------------------------------------+
+ ```
+4. Case where conversion to BIGINT is not possible
+ ```sql
+ SELECT json_extract_bigint('{"id": 123, "name": "doris"}','$.name');
+ ```
+ ```text
+ +--------------------------------------------------------------+
+ | json_extract_bigint('{"id": 123, "name": "doris"}','$.name') |
+ +--------------------------------------------------------------+
+ | NULL |
+ +--------------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bool.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bool.md
index dd0d1fd2652..3549ecd2e91 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bool.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bool.md
@@ -5,3 +5,82 @@
}
---
+## Description
+`JSON_EXTRACT_BOOL` extracts the field specified by `<json_path>` from a JSON
object and converts it to
[`BOOLEAN`](../../../basic-element/sql-data-types/numeric/BOOLEAN.md) type.
+
+## Syntax
+```sql
+JSON_EXTRACT_BOOL(<json_object>, <json_path>)
+```
+
+## Parameters
+- `<json_object>`: JSON type, the target parameter to extract from.
+- `<json_path>`: String type, the JSON path to extract the target element from
the target JSON.
+
+## Return Value
+`Nullable(BOOLEAN)` Returns the extracted BOOLEAN value, returns NULL in some
cases
+
+## Usage Notes
+1. If `<json_object>` or `<json_path>` is NULL, returns NULL.
+2. If the element specified by `<json_path>` does not exist, returns NULL.
+3. If the element specified by `<json_path>` cannot be converted to BOOLEAN,
returns NULL.
+4. Its behavior is consistent with "cast + json_extract", which is equivalent
to:
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as BOOLEAN)
+ ```
+
+## Examples
+1. Normal parameters
+ ```sql
+ SELECT json_extract_bool('{"id": true, "name": "doris"}', '$.id');
+ ```
+ ```text
+ +------------------------------------------------------------+
+ | json_extract_bool('{"id": true, "name": "doris"}', '$.id') |
+ +------------------------------------------------------------+
+ | 1 |
+ +------------------------------------------------------------+
+ ```
+2. Case where path does not exist
+ ```sql
+ SELECT json_extract_bool('{"id": true, "name": "doris"}', '$.id2');
+ ```
+ ```text
+ +-------------------------------------------------------------+
+ | json_extract_bool('{"id": true, "name": "doris"}', '$.id2') |
+ +-------------------------------------------------------------+
+ | NULL |
+ +-------------------------------------------------------------+
+ ```
+3. NULL parameters
+ ```sql
+ SELECT json_extract_bool('{"id": true, "name": "doris"}', NULl);
+ ```
+ ```text
+ +----------------------------------------------------------+
+ | json_extract_bool('{"id": true, "name": "doris"}', NULl) |
+ +----------------------------------------------------------+
+ | NULL |
+ +----------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_bool(NULL, '$.id2');
+ ```
+ ```text
+ +----------------------------------+
+ | json_extract_bool(NULL, '$.id2') |
+ +----------------------------------+
+ | NULL |
+ +----------------------------------+
+ ```
+4. Case where conversion to BOOLEAN is not possible
+ ```sql
+ SELECT json_extract_bool('{"id": 123, "name": "doris"}','$.name');
+ ```
+ ```text
+ +------------------------------------------------------------+
+ | json_extract_bool('{"id": 123, "name": "doris"}','$.name') |
+ +------------------------------------------------------------+
+ | NULL |
+ +------------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-double.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-double.md
index 78bc81de7f0..51a2e420030 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-double.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-double.md
@@ -5,3 +5,82 @@
}
---
+## Description
+`JSON_EXTRACT_DOUBLE` extracts the field specified by `<json_path>` from a
JSON object and converts it to
[`DOUBLE`](../../../basic-element/sql-data-types/numeric/DOUBLE.md) type.
+
+## Syntax
+```sql
+JSON_EXTRACT_DOUBLE(<json_object>, <json_path>)
+```
+
+## Parameters
+- `<json_object>`: JSON type, the target parameter to extract from.
+- `<json_path>`: String type, the JSON path to extract the target element from
the target JSON.
+
+## Return Value
+`Nullable(DOUBLE)` Returns the extracted DOUBLE value, returns NULL in some
cases
+
+## Usage Notes
+1. If `<json_object>` or `<json_path>` is NULL, returns NULL.
+2. If the element specified by `<json_path>` does not exist, returns NULL.
+3. If the element specified by `<json_path>` cannot be converted to DOUBLE,
returns NULL.
+4. Its behavior is consistent with "cast + json_extract", which is equivalent
to:
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as DOUBLE)
+ ```
+
+## Examples
+1. Normal parameters
+ ```sql
+ SELECT json_extract_double('{"id": 123.345, "name": "doris"}', '$.id');
+ ```
+ ```text
+ +-----------------------------------------------------------------+
+ | json_extract_double('{"id": 123.345, "name": "doris"}', '$.id') |
+ +-----------------------------------------------------------------+
+ | 123.345 |
+ +-----------------------------------------------------------------+
+ ```
+2. Case where path does not exist
+ ```sql
+ SELECT json_extract_double('{"id": 123.345, "name": "doris"}', '$.id2');
+ ```
+ ```text
+ +------------------------------------------------------------------+
+ | json_extract_double('{"id": 123.345, "name": "doris"}', '$.id2') |
+ +------------------------------------------------------------------+
+ | NULL |
+ +------------------------------------------------------------------+
+ ```
+3. NULL parameters
+ ```sql
+ SELECT json_extract_double('{"id": 123.345, "name": "doris"}', NULl);
+ ```
+ ```text
+ +---------------------------------------------------------------+
+ | json_extract_double('{"id": 123.345, "name": "doris"}', NULl) |
+ +---------------------------------------------------------------+
+ | NULL |
+ +---------------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_double(NULL, '$.id2');
+ ```
+ ```text
+ +------------------------------------+
+ | json_extract_double(NULL, '$.id2') |
+ +------------------------------------+
+ | NULL |
+ +------------------------------------+
+ ```
+4. Case where conversion to DOUBLE is not possible
+ ```sql
+ SELECT json_extract_double('{"id": 123, "name": "doris"}','$.name');
+ ```
+ ```text
+ +--------------------------------------------------------------+
+ | json_extract_double('{"id": 123, "name": "doris"}','$.name') |
+ +--------------------------------------------------------------+
+ | NULL |
+ +--------------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-int.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-int.md
index 4939e84f9be..4dccd9ef19a 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-int.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-int.md
@@ -5,3 +5,82 @@
}
---
+## Description
+`JSON_EXTRACT_INT` extracts the field specified by `<json_path>` from a JSON
object and converts it to
[`INT`](../../../basic-element/sql-data-types/numeric/INT.md) type.
+
+## Syntax
+```sql
+JSON_EXTRACT_INT(<json_object>, <json_path>)
+```
+
+## Parameters
+- `<json_object>`: JSON type, the target parameter to extract from.
+- `<json_path>`: String type, the JSON path to extract the target element from
the target JSON.
+
+## Return Value
+`Nullable(INT)` Returns the extracted INT value, returns NULL in some cases
+
+## Usage Notes
+1. If `<json_object>` or `<json_path>` is NULL, returns NULL.
+2. If the element specified by `<json_path>` does not exist, returns NULL.
+3. If the element specified by `<json_path>` cannot be converted to INT,
returns NULL.
+4. Its behavior is consistent with "cast + json_extract", which is equivalent
to:
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as INT)
+ ```
+
+## Examples
+1. Normal parameters
+ ```sql
+ SELECT json_extract_int('{"id": 123, "name": "doris"}', '$.id');
+ ```
+ ```text
+ +----------------------------------------------------------+
+ | json_extract_int('{"id": 123, "name": "doris"}', '$.id') |
+ +----------------------------------------------------------+
+ | 123 |
+ +----------------------------------------------------------+
+ ```
+2. Case where path does not exist
+ ```sql
+ SELECT json_extract_int('{"id": 123, "name": "doris"}', '$.id2');
+ ```
+ ```text
+ +-----------------------------------------------------------+
+ | json_extract_int('{"id": 123, "name": "doris"}', '$.id2') |
+ +-----------------------------------------------------------+
+ | NULL |
+ +-----------------------------------------------------------+
+ ```
+3. NULL parameters
+ ```sql
+ SELECT json_extract_int('{"id": 123, "name": "doris"}', NULl);
+ ```
+ ```text
+ +--------------------------------------------------------+
+ | json_extract_int('{"id": 123, "name": "doris"}', NULl) |
+ +--------------------------------------------------------+
+ | NULL |
+ +--------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_int(NULL, '$.id2');
+ ```
+ ```text
+ +---------------------------------+
+ | json_extract_int(NULL, '$.id2') |
+ +---------------------------------+
+ | NULL |
+ +---------------------------------+
+ ```
+4. Case where conversion to INT is not possible
+ ```sql
+ SELECT json_extract_int('{"id": 123, "name": "doris"}','$.name');
+ ```
+ ```text
+ +-----------------------------------------------------------+
+ | json_extract_int('{"id": 123, "name": "doris"}','$.name') |
+ +-----------------------------------------------------------+
+ | NULL |
+ +-----------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-isnull.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-isnull.md
index e063f7076fa..58065c0e736 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-isnull.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-isnull.md
@@ -5,3 +5,78 @@
}
---
+## Description
+`JSON_EXTRACT_ISNULL` determines whether the field specified by `<json_path>`
in a JSON object is a null value.
+
+## Syntax
+```sql
+JSON_EXTRACT_ISNULL(<json_object>, <json_path>)
+```
+
+## Parameters
+- `<json_object>`: JSON type, the target parameter to extract from.
+- `<json_path>`: String type, the JSON path to extract the target element from
the target JSON.
+
+## Return Value
+`Nullable(BOOL)` Returns true if the value is null, otherwise returns false.
+
+## Usage Notes
+1. If `<json_object>` or `<json_path>` is NULL, returns NULL.
+2. If the element specified by `<json_path>` does not exist, returns NULL.
+3. If the element specified by `<json_path>` is not null, returns false.
+
+## Examples
+1. Normal parameters
+ ```sql
+ SELECT json_extract_isnull('{"id": 123, "name": "doris"}', '$.id');
+ ```
+ ```text
+ +-------------------------------------------------------------+
+ | json_extract_isnull('{"id": 123, "name": "doris"}', '$.id') |
+ +-------------------------------------------------------------+
+ | 0 |
+ +-------------------------------------------------------------+
+ ```
+
+ ```sql
+ SELECT json_extract_isnull('{"id": null, "name": "doris"}', '$.id');
+ ```
+ ```text
+ +--------------------------------------------------------------+
+ | json_extract_isnull('{"id": null, "name": "doris"}', '$.id') |
+ +--------------------------------------------------------------+
+ | 1 |
+ +--------------------------------------------------------------+
+ ```
+2. Case where path does not exist
+ ```sql
+ SELECT json_extract_isnull('{"id": null, "name": "doris"}', '$.id2');
+ ```
+ ```text
+ +---------------------------------------------------------------+
+ | json_extract_isnull('{"id": null, "name": "doris"}', '$.id2') |
+ +---------------------------------------------------------------+
+ | NULL |
+ +---------------------------------------------------------------+
+ ```
+3. NULL parameters
+ ```sql
+ SELECT json_extract_isnull('{"id": 123, "name": "doris"}', NULl);
+ ```
+ ```text
+ +-----------------------------------------------------------+
+ | json_extract_isnull('{"id": 123, "name": "doris"}', NULl) |
+ +-----------------------------------------------------------+
+ | NULL |
+ +-----------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_isnull(NULL, '$.id2');
+ ```
+ ```text
+ +------------------------------------+
+ | json_extract_isnull(NULL, '$.id2') |
+ +------------------------------------+
+ | NULL |
+ +------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-largeint.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-largeint.md
index 3a327cd233e..f9b09a658b6 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-largeint.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-largeint.md
@@ -5,3 +5,81 @@
}
---
+## Description
+`JSON_EXTRACT_LARGEINT` extracts the field specified by `<json_path>` from a
JSON object and converts it to
[`LARGEINT`](../../../basic-element/sql-data-types/numeric/LARGEINT.md) type.
+
+## Syntax
+```sql
+JSON_EXTRACT_LARGEINT(<json_object>, <json_path>)
+```
+
+## Parameters
+- `<json_object>`: JSON type, the target parameter to extract from.
+- `<json_path>`: String type, the JSON path to extract the target element from
the target JSON.
+
+## Return Value
+`Nullable(LARGEINT)` Returns the extracted LARGEINT value, returns NULL in
some cases
+
+## Usage Notes
+1. If `<json_object>` or `<json_path>` is NULL, returns NULL.
+2. If the element specified by `<json_path>` does not exist, returns NULL.
+3. If the element specified by `<json_path>` cannot be converted to LARGEINT,
returns NULL.
+4. Its behavior is consistent with "cast + json_extract", which is equivalent
to:
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as LARGEINT)
+ ```
+
+## Examples
+1. Normal parameters
+ ```sql
+ SELECT json_extract_largeint('{"id": 11529215046068469760, "name":
"doris"}', '$.id');
+ ```
+
+--------------------------------------------------------------------------------+
+ | json_extract_largeint('{"id": 11529215046068469760, "name": "doris"}',
'$.id') |
+
+--------------------------------------------------------------------------------+
+ | 11529215046068469760
|
+
+--------------------------------------------------------------------------------+
+ ```
+2. Case where path does not exist
+ ```sql
+ SELECT json_extract_largeint('{"id": 11529215046068469760, "name":
"doris"}', '$.id2');
+ ```
+ ```text
+
+---------------------------------------------------------------------------------+
+ | json_extract_largeint('{"id": 11529215046068469760, "name": "doris"}',
'$.id2') |
+
+---------------------------------------------------------------------------------+
+ | NULL
|
+
+---------------------------------------------------------------------------------+
+ ```
+3. NULL parameters
+ ```sql
+ SELECT json_extract_largeint('{"id": 11529215046068469760, "name":
"doris"}', NULl);
+ ```
+ ```text
+
+------------------------------------------------------------------------------+
+ | json_extract_largeint('{"id": 11529215046068469760, "name": "doris"}',
NULl) |
+
+------------------------------------------------------------------------------+
+ | NULL
|
+
+------------------------------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_largeint(NULL, '$.id2');
+ ```
+ ```text
+ +--------------------------------------+
+ | json_extract_largeint(NULL, '$.id2') |
+ +--------------------------------------+
+ | NULL |
+ +--------------------------------------+
+ ```
+4. Case where conversion to LARGEINT is not possible
+ ```sql
+ SELECT json_extract_largeint('{"id": 123, "name": "doris"}','$.name');
+ ```
+ ```text
+ +----------------------------------------------------------------+
+ | json_extract_largeint('{"id": 123, "name": "doris"}','$.name') |
+ +----------------------------------------------------------------+
+ | NULL |
+ +----------------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-string.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-string.md
index 20833f61674..4c6c0c51880 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-string.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-string.md
@@ -5,3 +5,97 @@
}
---
+## Description
+`JSON_EXTRACT_STRING` extracts the field specified by `<json_path>` from a
JSON object and converts it to
[`STRING`](../../../basic-element/sql-data-types/string-type/STRING.md) type.
+
+## Syntax
+```sql
+JSON_EXTRACT_STRING(<json_object>, <json_path>)
+```
+
+## Parameters
+- `<json_object>`: JSON type, the target parameter to extract from.
+- `<json_path>`: String type, the JSON path to extract the target element from
the target JSON.
+
+## Return Value
+`Nullable(STRING)` Returns the extracted STRING value, returns NULL in some
cases
+
+## Usage Notes
+1. If `<json_object>` or `<json_path>` is NULL, returns NULL.
+2. If the element specified by `<json_path>` does not exist, returns NULL.
+3. If the element specified by `<json_path>` cannot be converted to STRING,
returns NULL.
+4. Its behavior is consistent with "cast + json_extract", which is equivalent
to:
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as STRING)
+ ```
+ So even if the object pointed to by `<json_path>` is not of STRING type,
as long as it supports conversion to STRING type, you can get the converted
value.
+5. The STRING returned here does not contain double quotes (").
+6. For null values in JSON objects, the result is not NULL but the string
"null".
+If you want to check whether an element is null, please use the function
[`JSON_EXTRACT_ISNULL`](./json-extract-isnull.md)。
+
+## Examples
+1. Normal parameters
+ ```sql
+ SELECT json_extract_string('{"id": 123, "name": "doris"}', '$.name');
+ ```
+ ```text
+ +---------------------------------------------------------------+
+ | json_extract_string('{"id": 123, "name": "doris"}', '$.name') |
+ +---------------------------------------------------------------+
+ | doris |
+ +---------------------------------------------------------------+
+ ```
+2. Case where path does not exist
+ ```sql
+ SELECT json_extract_string('{"id": 123, "name": "doris"}', '$.name2');
+ ```
+ ```text
+ +----------------------------------------------------------------+
+ | json_extract_string('{"id": 123, "name": "doris"}', '$.name2') |
+ +----------------------------------------------------------------+
+ | NULL |
+ +----------------------------------------------------------------+
+ ```
+3. NULL parameters
+ ```sql
+ SELECT json_extract_string('{"id": 123, "name": "doris"}', NULl);
+ ```
+ ```text
+ +-----------------------------------------------------------+
+ | json_extract_string('{"id": 123, "name": "doris"}', NULl) |
+ +-----------------------------------------------------------+
+ | NULL |
+ +-----------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_string(NULL, '$.id2');
+ ```
+ ```text
+ +------------------------------------+
+ | json_extract_string(NULL, '$.id2') |
+ +------------------------------------+
+ | NULL |
+ +------------------------------------+
+ ```
+4. Case where other types are converted to STRING
+ ```sql
+ SELECT json_extract_string('{"id": 123, "name": "doris"}','$.id');
+ ```
+ ```text
+ +------------------------------------------------------------+
+ | json_extract_string('{"id": 123, "name": "doris"}','$.id') |
+ +------------------------------------------------------------+
+ | 123 |
+ +------------------------------------------------------------+
+ ```
+5. Null values will be converted to string "null" instead of NULL
+ ```sql
+ SELECT json_extract_string('{"id": null, "name": "doris"}','$.id');
+ ```
+ ```text
+ +-------------------------------------------------------------+
+ | json_extract_string('{"id": null, "name": "doris"}','$.id') |
+ +-------------------------------------------------------------+
+ | null |
+ +-------------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint.md
index 88300d5a488..ffbdef2f888 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint.md
@@ -7,89 +7,4 @@
## 描述
-解析并获取 json 字符串内指定路径的整型 (BIGINT) 内容。
-
-## 语法
-
-` GET_JSON_BIGINT( <json_str>, <json_path>)`
-
-
-## 必选参数
-
-| 参数 | 描述 |
-|------|------|
-| `<json_str>` | 需要从中提取数据的 JSON 字符串。 |
-| `<json_path>` | JSON 路径，指定字段的位置。路径可以使用点号表示法。 |
-
-## 注意事项
-其中 `<json_str>` 必须以 $ 符号作为开头，使用 . 作为路径分割符。如果路径中包含 . ，则可以使用双引号包围。
-使用 [ ] 表示数组下标，从 0 开始。
-path 的内容不能包含 ", [ 和 ]。
-如果 `<json_str>` 格式不对，或 `<json_path>` 格式不对，或无法找到匹配项，则返回 NULL。
-
-另外，推荐使用 jsonb 类型和 jsonb_extract_XXX 函数实现同样的功能。
-
-特殊情况处理如下：
-- 如果 `<json_path>` 指定的字段在 JSON 中不存在，返回 NULL
-- 如果 `<json_path>` 指定的字段在 JSON 中的实际类型和 json_extract_t
指定的类型不一致，如果能无损转换成指定类型返回指定类型 t，如果不能则返回 NULL
-
-## 返回值
-
-- 返回路径指向字段的 BIGINT 值。
-- 如果指定路径没有找到对应的字段，或者字段值无法转换为 BIGINT 类型，返回 NULL。
-
-## 示例
-
-1. 获取 key 为 "k1" 的 value
-
-```sql
-
-SELECT get_json_bigint('{"k1":1, "k2":"2"}', "$.k1");
-
-```
-
-```sql
-
-+-----------------------------------------------+
-| get_json_bigint('{"k1":1, "k2":"2"}', '$.k1') |
-+-----------------------------------------------+
-| 1 |
-+-----------------------------------------------+
-
-```
-
-2. 获取 key 为 "my.key" 的数组中第二个元素
-
-```sql
-
-SELECT get_json_bigint('{"k1":"v1", "my.key":[1, 1678708107000, 3]}',
'$."my.key"[1]');
-
-```
-
-```sql
-
-+---------------------------------------------------------------------------------+
-| get_json_bigint('{"k1":"v1", "my.key":[1, 1678708107000, 3]}',
'$."my.key"[1]') |
-+---------------------------------------------------------------------------------+
-|
1678708107000 |
-+---------------------------------------------------------------------------------+
-
-```
-
-3. 获取二级路径为 k1.key -> k2 的数组中，第一个元素
-```sql
-
-SELECT get_json_bigint('{"k1.key":{"k2":[1678708107000, 2]}}',
'$."k1.key".k2[0]');
-
-```
-
-```sql
-
-+-----------------------------------------------------------------------------+
-| get_json_bigint('{"k1.key":{"k2":[1678708107000, 2]}}', '$."k1.key".k2[0]') |
-+-----------------------------------------------------------------------------+
-| 1678708107000 |
-+-----------------------------------------------------------------------------+
-
-```
-
+函数 [`JSON_EXTRACT_BIGINT`](./json-extract-bigint.md) 的别名。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-double.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-double.md
index 89928ae0666..1af08102dbd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-double.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-double.md
@@ -7,81 +7,4 @@
## 描述
-函数用于从 JSON 文档中提取一个字段的值并将其转换为 `DOUBLE` 类型。该函数会返回指定路径上的字段值，如果该值无法转换为 `DOUBLE`
类型，或者路径指向的字段不存在，则返回 `NULL`。
-
-## 语法
-
-`DOUBLE GET_JSON_DOUBLE( <json_str>, <json_path>)`
-
-
-## 必选参数
-
-| 参数 | 描述 |
-|------|------|
-| `<json_str>` | 需要从中提取数据的 JSON 字符串。 |
-| `<json_path>` | JSON 路径，指定字段的位置。路径可以使用点号表示法。 |
-
-
-## 返回值
-
-- 返回路径指向字段的 DOUBLE 值。
-- 如果指定路径没有找到对应的字段，或者字段值无法转换为 DOUBLE 类型，返回 NULL。
-
-## 注意事项
-
-解析并获取 json 字符串内指定路径的浮点型内容。
-其中 `<json_path>` 必须以 $ 符号作为开头，使用 . 作为路径分割符。如果路径中包含 . ，则可以使用双引号包围。
-使用 [ ] 表示数组下标，从 0 开始。
-path 的内容不能包含 ", [ 和 ]。
-如果 `<json_str>` 格式不对，或 json_path 格式不对，或无法找到匹配项，则返回 NULL。
-
-另外，推荐使用 jsonb 类型和 jsonb_extract_XXX 函数实现同样的功能。
-
-特殊情况处理如下：
-- 如果 json_path 指定的字段在 JSON 中不存在，返回 NULL
-- 如果 json_path 指定的字段在 JSON 中的实际类型和 json_extract_t 指定的类型不一致，如果能无损转换成指定类型返回指定类型
t，如果不能则返回 NULL
-
-## 示例
-
-1. 获取 key 为 "k1" 的 value
-
-```sql
- SELECT get_json_double('{"k1":1.3, "k2":"2"}', "$.k1");
- ```
-
- ```sql
-+-------------------------------------------------+
-| get_json_double('{"k1":1.3, "k2":"2"}', '$.k1') |
-+-------------------------------------------------+
-| 1.3 |
-+-------------------------------------------------+
-```
-
-2. 获取 key 为 "my.key" 的数组中第二个元素
-
-```sql
-SELECT get_json_double('{"k1":"v1", "my.key":[1.1, 2.2, 3.3]}',
'$."my.key"[1]');
-```
-
-```sql
-+---------------------------------------------------------------------------+
-| get_json_double('{"k1":"v1", "my.key":[1.1, 2.2, 3.3]}', '$."my.key"[1]') |
-+---------------------------------------------------------------------------+
-| 2.2 |
-+---------------------------------------------------------------------------+
-```
-
-3. 获取二级路径为 k1.key -> k2 的数组中，第一个元素
-
-```sql
-SELECT get_json_double('{"k1.key":{"k2":[1.1, 2.2]}}', '$."k1.key".k2[0]');
-```
-
-```sql
-+---------------------------------------------------------------------+
-| get_json_double('{"k1.key":{"k2":[1.1, 2.2]}}', '$."k1.key".k2[0]') |
-+---------------------------------------------------------------------+
-| 1.1 |
-+---------------------------------------------------------------------+
-```
-
+函数 [`JSON_EXTRACT_DOUBLE`](./json-extract-double.md) 的别名。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-int.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-int.md
index ff65be34ea6..5d29dde8056 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-int.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-int.md
@@ -7,73 +7,4 @@
## 描述
-函数用于从 JSON 文档中提取一个字段的值并将其转换为 `INT` 类型。该函数会返回指定路径上的字段值，如果该值无法转换为 `INT`
类型，或者路径指向的字段不存在，则返回 `NULL`。
-
-## 语法
-
-`GET_JSON_INT( <json_str>, <json_path>)`
-
-## 必选参数
-
-| 参数 | 描述 |
-|------|------|
-| `<json_str>` | 需要从中提取数据的 JSON 字符串。 |
-| `<json_path>` | JSON 路径，指定字段的位置。路径可以使用点号表示法。 |
-
-## 注意事项
-解析并获取 json 字符串内指定路径的整型内容。
-其中 `<json_path>` 必须以 $ 符号作为开头，使用 . 作为路径分割符。如果路径中包含 . ，则可以使用双引号包围。
-使用 [ ] 表示数组下标，从 0 开始。
-path 的内容不能包含 ", [ 和 ]。
-如果 `<json_str>` 格式不对，或 `<json_path>` 格式不对，或无法找到匹配项，则返回 NULL。
-
-另外，推荐使用 jsonb 类型和 jsonb_extract_XXX 函数实现同样的功能。
-
-特殊情况处理如下：
-- 如果 `<json_path>` 指定的字段在 JSON 中不存在，返回 NULL
-- 如果 `<json_path>` 指定的字段在 JSON 中的实际类型和 json_extract_t
指定的类型不一致，如果能无损转换成指定类型返回指定类型 t，如果不能则返回 NULL
-
-## 示例
-
-1. 获取 key 为 "k1" 的 value
-
-```sql
-SELECT get_json_int('{"k1":1, "k2":"2"}', "$.k1");
-```
-
-```sql
-
-+--------------------------------------------+
-| get_json_int('{"k1":1, "k2":"2"}', '$.k1') |
-+--------------------------------------------+
-| 1 |
-+--------------------------------------------+
-```
-
-2. 获取 key 为 "my.key" 的数组中第二个元素
-
-```sql
-SELECT get_json_int('{"k1":"v1", "my.key":[1, 2, 3]}', '$."my.key"[1]');
-```
-
-```sql
-+------------------------------------------------------------------+
-| get_json_int('{"k1":"v1", "my.key":[1, 2, 3]}', '$."my.key"[1]') |
-+------------------------------------------------------------------+
-| 2 |
-+------------------------------------------------------------------+
-```
-
-3. 获取二级路径为 k1.key -> k2 的数组中，第一个元素
-
-```sql
- SELECT get_json_int('{"k1.key":{"k2":[1, 2]}}', '$."k1.key".k2[0]');
- ```
-
- ```sql
-+--------------------------------------------------------------+
-| get_json_int('{"k1.key":{"k2":[1, 2]}}', '$."k1.key".k2[0]') |
-+--------------------------------------------------------------+
-| 1 |
-+--------------------------------------------------------------+
-```
+函数 [`JSON_EXTRACT_INT`](./json-extract-int.md) 的别名。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-string.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-string.md
index 266d365407b..4a6557d02a8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-string.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/get-json-string.md
@@ -7,95 +7,4 @@
## 描述
-函数用于从 JSON 文档中提取一个字段的值，并将其转换为 `STRING`
类型。该函数返回指定路径上的字段值，如果该值无法转换为字符串，或者路径指向的字段不存在，则返回 `NULL`。
-
-## 语法
-
-` GET_JSON_STRING( <json_str>, <json_path>)`
-
-
-## 必选参数
-
-| 参数 | 描述 |
-|------|------|
-| `<json_str>` | 需要从中提取数据的 JSON 字符串。 |
-| `<json_path>` | JSON 路径，指定字段的位置。路径可以使用点号表示法。 |
-
-
-## 返回值
-返回路径指向字段的 STRING 值。
-如果指定路径没有找到对应的字段，或者字段值无法转换为 STRING 类型，返回 NULL。
-
-## 注意事项
-
-解析并获取 json 字符串内指定路径的字符串内容。
-其中 `<json_path>` 必须以 $ 符号作为开头，使用 . 作为路径分割符。如果路径中包含 . ，则可以使用双引号包围。
-使用 [ ] 表示数组下标，从 0 开始。
-path 的内容不能包含 ", [ 和 ]。
-如果 `<json_str>` 格式不对，或 `<json_path>` 格式不对，或无法找到匹配项，则返回 NULL。
-
-另外，推荐使用 jsonb 类型和 jsonb_extract_XXX 函数实现同样的功能。
-
-特殊情况处理如下：
-- 如果 `<json_path>` 指定的字段在 JSON 中不存在，返回 NULL
-- 如果 `<json_path>` 指定的字段在 JSON 中的实际类型和 json_extract_t
指定的类型不一致，如果能无损转换成指定类型返回指定类型 t，如果不能则返回 NULL
-
-## 示例
-
-1. 获取 key 为 "k1" 的 value
-
-```sql
-
-SELECT get_json_string('{"k1":"v1", "k2":"v2"}', "$.k1");
-
-```
-
-```sql
-
-+---------------------------------------------------+
-| get_json_string('{"k1":"v1", "k2":"v2"}', '$.k1') |
-+---------------------------------------------------+
-| v1 |
-+---------------------------------------------------+
-```
-
-2. 获取 key 为 "my.key" 的数组中第二个元素
-
-```sql
-SELECT get_json_string('{"k1":"v1", "my.key":["e1", "e2", "e3"]}',
'$."my.key"[1]');
-```
-```sql
-+------------------------------------------------------------------------------+
-| get_json_string('{"k1":"v1", "my.key":["e1", "e2", "e3"]}', '$."my.key"[1]')
|
-+------------------------------------------------------------------------------+
-| e2
|
-+------------------------------------------------------------------------------+
-```
-
-3. 获取二级路径为 k1.key -> k2 的数组中，第一个元素
-```sql
- SELECT get_json_string('{"k1.key":{"k2":["v1", "v2"]}}', '$."k1.key".k2[0]');
- ```
-
- ```sql
-
-+-----------------------------------------------------------------------+
-| get_json_string('{"k1.key":{"k2":["v1", "v2"]}}', '$."k1.key".k2[0]') |
-+-----------------------------------------------------------------------+
-| v1 |
-+-----------------------------------------------------------------------+
-```
-
-4. 获取数组中，key 为 "k1" 的所有 value
-```sql
-SELECT get_json_string('[{"k1":"v1"}, {"k2":"v2"}, {"k1":"v3"}, {"k1":"v4"}]',
'$.k1');
-```
-
-```sql
-
-+---------------------------------------------------------------------------------+
-| get_json_string('[{"k1":"v1"}, {"k2":"v2"}, {"k1":"v3"}, {"k1":"v4"}]',
'$.k1') |
-+---------------------------------------------------------------------------------+
-| ["v1","v3","v4"]
|
-+---------------------------------------------------------------------------------+
-```
+函数 [`JSON_EXTRACT_STRING`](./json-extract-string.md) 的别名。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
index 1d14fffbdf8..969ef7e7dfa 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
@@ -5,3 +5,81 @@
}
---
+## 描述
+`JSON_EXTRACT_BIGINT` 从 JSON 对象中提取 `<json_path>` 指定的字段，并将其转换为
[`BIGINT`](../../../basic-element/sql-data-types/numeric/BIGINT.md) 类型。
+
+## 语法
+```sql
+JSON_EXTRACT_BIGINT(<json_object>, <json_path>)
+```
+
+## 参数
+- `<json_object>` JSON 类型，要提取的目标参数。
+- `<json_path>` String 类型，要从目标 JSON 中提取目标元素的 JSON 路径。
+
+## 返回值
+`Nullable(BIGINT)` 返回提取出的 BIGINT 值，某些情况会得到 NULL
+
+## 使用说明
+1. 如果 `<json_object>` 或则 `<json_path>` 为 NULL，返回 NULL。
+2. 如果 `<json_path>` 指定的元素不存在返回 NULL。
+3. 如果 `<json_path>` 指定的元素无法转换为 BIGINT 返回 NULL。
+4. 其行为与 "cast + json_extract" 一致，即等价于：
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as BIGINT)
+ ```
+
+## 示例
+1. 正常参数
+ ```sql
+ SELECT json_extract_int('{"id": 122222222222223, "name": "doris"}',
'$.id');
+ ```
+ +-------------------------------------------------------------------------+
+ | json_extract_bigint('{"id": 122222222222223, "name": "doris"}', '$.id') |
+ +-------------------------------------------------------------------------+
+ | 122222222222223 |
+ +-------------------------------------------------------------------------+
+ ```
+2. 路径不存在的情况
+ ```sql
+ SELECT json_extract_bigint('{"id": 122222222222223, "name": "doris"}',
'$.id2');
+ ```
+ ```text
+
+--------------------------------------------------------------------------+
+ | json_extract_bigint('{"id": 122222222222223, "name": "doris"}', '$.id2')
|
+
+--------------------------------------------------------------------------+
+ | NULL
|
+
+--------------------------------------------------------------------------+
+ ```
+3. NULL 参数
+ ```sql
+ SELECT json_extract_bigint('{"id": 122222222222223, "name": "doris"}',
NULl);
+ ```
+ ```text
+ +-----------------------------------------------------------------------+
+ | json_extract_bigint('{"id": 122222222222223, "name": "doris"}', NULl) |
+ +-----------------------------------------------------------------------+
+ | NULL |
+ +-----------------------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_bigint(NULL, '$.id2');
+ ```
+ ```text
+ +------------------------------------+
+ | json_extract_bigint(NULL, '$.id2') |
+ +------------------------------------+
+ | NULL |
+ +------------------------------------+
+ ```
+4. 无法转换为 BIGINT 的情况
+ ```sql
+ SELECT json_extract_bigint('{"id": 123, "name": "doris"}','$.name');
+ ```
+ ```text
+ +--------------------------------------------------------------+
+ | json_extract_bigint('{"id": 123, "name": "doris"}','$.name') |
+ +--------------------------------------------------------------+
+ | NULL |
+ +--------------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bool.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bool.md
index ac63f0017fd..0776d663e33 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bool.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bool.md
@@ -5,3 +5,81 @@
}
---
+## 描述
+`JSON_EXTRACT_BOOL` 从 JSON 对象中提取 `<json_path>` 指定的字段，并将其转换为
[`BOOLEAN`](../../../basic-element/sql-data-types/numeric/BOOLEAN.md) 类型。
+
+## 语法
+```sql
+JSON_EXTRACT_BOOL(<json_object>, <json_path>)
+```
+
+## 参数
+- `<json_object>` JSON 类型，要提取的目标参数。
+- `<json_path>` String 类型，要从目标 JSON 中提取目标元素的 JSON 路径。
+
+## 返回值
+`Nullable(BOOLEAN)` 返回提取出的 BOOLEAN 值，某些情况会得到 NULL
+
+## 使用说明
+1. 如果 `<json_object>` 或则 `<json_path>` 为 NULL，返回 NULL。
+2. 如果 `<json_path>` 指定的元素不存在返回 NULL。
+3. 如果 `<json_path>` 指定的元素无法转换为 BOOLEAN 返回 NULL。
+4. 其行为与 "cast + json_extract" 一致，即等价于：
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as BOOLEAN)
+ ```
+
+## 示例
+1. 正常参数
+ ```sql
+ SELECT json_extract_bool('{"id": true, "name": "doris"}', '$.id');
+ ```
+ ```text
+ +------------------------------------------------------------+
+ | json_extract_bool('{"id": true, "name": "doris"}', '$.id') |
+ +------------------------------------------------------------+
+ | 1 |
+ +------------------------------------------------------------+
+ ```
+2. 路径不存在的情况
+ ```sql
+ SELECT json_extract_bool('{"id": true, "name": "doris"}', '$.id2');
+ ```
+ +-------------------------------------------------------------+
+ | json_extract_bool('{"id": true, "name": "doris"}', '$.id2') |
+ +-------------------------------------------------------------+
+ | NULL |
+ +-------------------------------------------------------------+
+ ```
+3. NULL 参数
+ ```sql
+ SELECT json_extract_bool('{"id": true, "name": "doris"}', NULl);
+ ```
+ ```text
+ +----------------------------------------------------------+
+ | json_extract_bool('{"id": true, "name": "doris"}', NULl) |
+ +----------------------------------------------------------+
+ | NULL |
+ +----------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_bool(NULL, '$.id2');
+ ```
+ ```text
+ +----------------------------------+
+ | json_extract_bool(NULL, '$.id2') |
+ +----------------------------------+
+ | NULL |
+ +----------------------------------+
+ ```
+4. 无法转换为 BOOLEAN 的情况
+ ```sql
+ SELECT json_extract_bool('{"id": 123, "name": "doris"}','$.name');
+ ```
+ ```text
+ +------------------------------------------------------------+
+ | json_extract_bool('{"id": 123, "name": "doris"}','$.name') |
+ +------------------------------------------------------------+
+ | NULL |
+ +------------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-double.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-double.md
index f486adc9611..7405c06dc94 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-double.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-double.md
@@ -5,3 +5,82 @@
}
---
+## 描述
+`JSON_EXTRACT_DOUBLE` 从 JSON 对象中提取 `<json_path>` 指定的字段，并将其转换为
[`DOUBLE`](../../../basic-element/sql-data-types/numeric/DOUBLE.md) 类型。
+
+## 语法
+```sql
+JSON_EXTRACT_DOUBLE(<json_object>, <json_path>)
+```
+
+## 参数
+- `<json_object>` JSON 类型，要提取的目标参数。
+- `<json_path>` String 类型，要从目标 JSON 中提取目标元素的 JSON 路径。
+
+## 返回值
+`Nullable(DOUBLE)` 返回提取出的 DOUBLE 值，某些情况会得到 NULL
+
+## 使用说明
+1. 如果 `<json_object>` 或则 `<json_path>` 为 NULL，返回 NULL。
+2. 如果 `<json_path>` 指定的元素不存在返回 NULL。
+3. 如果 `<json_path>` 指定的元素无法转换为 DOUBLE 返回 NULL。
+4. 其行为与 "cast + json_extract" 一致，即等价于：
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as DOUBLE)
+ ```
+
+## 示例
+1. 正常参数
+ ```sql
+ SELECT json_extract_double('{"id": 123.345, "name": "doris"}', '$.id');
+ ```
+ ```text
+ +-----------------------------------------------------------------+
+ | json_extract_double('{"id": 123.345, "name": "doris"}', '$.id') |
+ +-----------------------------------------------------------------+
+ | 123.345 |
+ +-----------------------------------------------------------------+
+ ```
+2. 路径不存在的情况
+ ```sql
+ SELECT json_extract_double('{"id": 123.345, "name": "doris"}', '$.id2');
+ ```
+ ```text
+ +------------------------------------------------------------------+
+ | json_extract_double('{"id": 123.345, "name": "doris"}', '$.id2') |
+ +------------------------------------------------------------------+
+ | NULL |
+ +------------------------------------------------------------------+
+ ```
+3. NULL 参数
+ ```sql
+ SELECT json_extract_double('{"id": 123.345, "name": "doris"}', NULl);
+ ```
+ ```text
+ +---------------------------------------------------------------+
+ | json_extract_double('{"id": 123.345, "name": "doris"}', NULl) |
+ +---------------------------------------------------------------+
+ | NULL |
+ +---------------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_double(NULL, '$.id2');
+ ```
+ ```text
+ +------------------------------------+
+ | json_extract_double(NULL, '$.id2') |
+ +------------------------------------+
+ | NULL |
+ +------------------------------------+
+ ```
+4. 无法转换为 DOUBLE 的情况
+ ```sql
+ SELECT json_extract_double('{"id": 123, "name": "doris"}','$.name');
+ ```
+ ```text
+ +--------------------------------------------------------------+
+ | json_extract_double('{"id": 123, "name": "doris"}','$.name') |
+ +--------------------------------------------------------------+
+ | NULL |
+ +--------------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-int.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-int.md
index 7eb80d897b5..933e5902a7f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-int.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-int.md
@@ -5,3 +5,82 @@
}
---
+## 描述
+`JSON_EXTRACT_INT` 从 JSON 对象中提取 `<json_path>` 指定的字段，并将其转换为
[`INT`](../../../basic-element/sql-data-types/numeric/INT.md) 类型。
+
+## 语法
+```sql
+JSON_EXTRACT_INT(<json_object>, <json_path>)
+```
+
+## 参数
+- `<json_object>` JSON 类型，要提取的目标参数。
+- `<json_path>` String 类型，要从目标 JSON 中提取目标元素的 JSON 路径。
+
+## 返回值
+`Nullable(INT)` 返回提取出的 INT 值，某些情况会得到 NULL
+
+## 使用说明
+1. 如果 `<json_object>` 或则 `<json_path>` 为 NULL，返回 NULL。
+2. 如果 `<json_path>` 指定的元素不存在返回 NULL。
+3. 如果 `<json_path>` 指定的元素无法转换为 INT 返回 NULL。
+4. 其行为与 "cast + json_extract" 一致，即等价于：
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as INT)
+ ```
+
+## 示例
+1. 正常参数
+ ```sql
+ SELECT json_extract_int('{"id": 123, "name": "doris"}', '$.id');
+ ```
+ ```text
+ +----------------------------------------------------------+
+ | json_extract_int('{"id": 123, "name": "doris"}', '$.id') |
+ +----------------------------------------------------------+
+ | 123 |
+ +----------------------------------------------------------+
+ ```
+2. 路径不存在的情况
+ ```sql
+ SELECT json_extract_int('{"id": 123, "name": "doris"}', '$.id2');
+ ```
+ ```text
+ +-----------------------------------------------------------+
+ | json_extract_int('{"id": 123, "name": "doris"}', '$.id2') |
+ +-----------------------------------------------------------+
+ | NULL |
+ +-----------------------------------------------------------+
+ ```
+3. NULL 参数
+ ```sql
+ SELECT json_extract_int('{"id": 123, "name": "doris"}', NULl);
+ ```
+ ```text
+ +--------------------------------------------------------+
+ | json_extract_int('{"id": 123, "name": "doris"}', NULl) |
+ +--------------------------------------------------------+
+ | NULL |
+ +--------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_int(NULL, '$.id2');
+ ```
+ ```text
+ +---------------------------------+
+ | json_extract_int(NULL, '$.id2') |
+ +---------------------------------+
+ | NULL |
+ +---------------------------------+
+ ```
+4. 无法转换为 INT 的情况
+ ```sql
+ SELECT json_extract_int('{"id": 123, "name": "doris"}','$.name');
+ ```
+ ```text
+ +-----------------------------------------------------------+
+ | json_extract_int('{"id": 123, "name": "doris"}','$.name') |
+ +-----------------------------------------------------------+
+ | NULL |
+ +-----------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-isnull.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-isnull.md
index 7525c0bd901..6ae61dc52c2 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-isnull.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-isnull.md
@@ -5,3 +5,78 @@
}
---
+## 描述
+`JSON_EXTRACT_ISNULL` 判断 JSON 对象中 `<json_path>` 指定的字段是否是 null 值。
+
+## 语法
+```sql
+JSON_EXTRACT_ISNULL(<json_object>, <json_path>)
+```
+
+## 参数
+- `<json_object>` JSON 类型，要提取的目标参数。
+- `<json_path>` String 类型，要从目标 JSON 中提取目标元素的 JSON 路径。
+
+## 返回值
+`Nullable(BOOL)` 如果值为 null 返回 true，否则返回 false。
+
+## 使用说明
+1. 如果 `<json_object>` 或则 `<json_path>` 为 NULL，返回 NULL。
+2. 如果 `<json_path>` 指定的元素不存在返回 NULL。
+3. 如果 `<json_path>` 指定的元素不是 null 则返回 false。
+
+## 示例
+1. 正常参数
+ ```sql
+ SELECT json_extract_isnull('{"id": 123, "name": "doris"}', '$.id');
+ ```
+ ```text
+ +-------------------------------------------------------------+
+ | json_extract_isnull('{"id": 123, "name": "doris"}', '$.id') |
+ +-------------------------------------------------------------+
+ | 0 |
+ +-------------------------------------------------------------+
+ ```
+
+ ```sql
+ SELECT json_extract_isnull('{"id": null, "name": "doris"}', '$.id');
+ ```
+ ```text
+ +--------------------------------------------------------------+
+ | json_extract_isnull('{"id": null, "name": "doris"}', '$.id') |
+ +--------------------------------------------------------------+
+ | 1 |
+ +--------------------------------------------------------------+
+ ```
+2. 路径不存在的情况
+ ```sql
+ SELECT json_extract_isnull('{"id": null, "name": "doris"}', '$.id2');
+ ```
+ ```text
+ +---------------------------------------------------------------+
+ | json_extract_isnull('{"id": null, "name": "doris"}', '$.id2') |
+ +---------------------------------------------------------------+
+ | NULL |
+ +---------------------------------------------------------------+
+ ```
+3. NULL 参数
+ ```sql
+ SELECT json_extract_isnull('{"id": 123, "name": "doris"}', NULl);
+ ```
+ ```text
+ +-----------------------------------------------------------+
+ | json_extract_isnull('{"id": 123, "name": "doris"}', NULl) |
+ +-----------------------------------------------------------+
+ | NULL |
+ +-----------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_isnull(NULL, '$.id2');
+ ```
+ ```text
+ +------------------------------------+
+ | json_extract_isnull(NULL, '$.id2') |
+ +------------------------------------+
+ | NULL |
+ +------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-largeint.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-largeint.md
index c23c0c7a886..bbbafe0ecfb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-largeint.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-largeint.md
@@ -5,3 +5,81 @@
}
---
+## 描述
+`JSON_EXTRACT_LARGEINT` 从 JSON 对象中提取 `<json_path>` 指定的字段，并将其转换为
[`LARGEINT`](../../../basic-element/sql-data-types/numeric/LARGEINT.md) 类型。
+
+## 语法
+```sql
+JSON_EXTRACT_LARGEINT(<json_object>, <json_path>)
+```
+
+## 参数
+- `<json_object>` JSON 类型，要提取的目标参数。
+- `<json_path>` String 类型，要从目标 JSON 中提取目标元素的 JSON 路径。
+
+## 返回值
+`Nullable(LARGEINT)` 返回提取出的 LARGEINT 值，某些情况会得到 NULL
+
+## 使用说明
+1. 如果 `<json_object>` 或则 `<json_path>` 为 NULL，返回 NULL。
+2. 如果 `<json_path>` 指定的元素不存在返回 NULL。
+3. 如果 `<json_path>` 指定的元素无法转换为 LARGEINT 返回 NULL。
+4. 其行为与 "cast + json_extract" 一致，即等价于：
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as LARGEINT)
+ ```
+
+## 示例
+1. 正常参数
+ ```sql
+ SELECT json_extract_largeint('{"id": 11529215046068469760, "name":
"doris"}', '$.id');
+ ```
+
+--------------------------------------------------------------------------------+
+ | json_extract_largeint('{"id": 11529215046068469760, "name": "doris"}',
'$.id') |
+
+--------------------------------------------------------------------------------+
+ | 11529215046068469760
|
+
+--------------------------------------------------------------------------------+
+ ```
+2. 路径不存在的情况
+ ```sql
+ SELECT json_extract_largeint('{"id": 11529215046068469760, "name":
"doris"}', '$.id2');
+ ```
+ ```text
+
+---------------------------------------------------------------------------------+
+ | json_extract_largeint('{"id": 11529215046068469760, "name": "doris"}',
'$.id2') |
+
+---------------------------------------------------------------------------------+
+ | NULL
|
+
+---------------------------------------------------------------------------------+
+ ```
+3. NULL 参数
+ ```sql
+ SELECT json_extract_largeint('{"id": 11529215046068469760, "name":
"doris"}', NULl);
+ ```
+ ```text
+
+------------------------------------------------------------------------------+
+ | json_extract_largeint('{"id": 11529215046068469760, "name": "doris"}',
NULl) |
+
+------------------------------------------------------------------------------+
+ | NULL
|
+
+------------------------------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_largeint(NULL, '$.id2');
+ ```
+ ```text
+ +--------------------------------------+
+ | json_extract_largeint(NULL, '$.id2') |
+ +--------------------------------------+
+ | NULL |
+ +--------------------------------------+
+ ```
+4. 无法转换为 LARGEINT 的情况
+ ```sql
+ SELECT json_extract_largeint('{"id": 123, "name": "doris"}','$.name');
+ ```
+ ```text
+ +----------------------------------------------------------------+
+ | json_extract_largeint('{"id": 123, "name": "doris"}','$.name') |
+ +----------------------------------------------------------------+
+ | NULL |
+ +----------------------------------------------------------------+
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-string.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-string.md
index 55efeecde73..39e4d9b1682 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-string.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-string.md
@@ -5,3 +5,96 @@
}
---
+## 描述
+`JSON_EXTRACT_STRING` 从 JSON 对象中提取 `<json_path>` 指定的字段，并将其转换为
[`STRING`](../../../basic-element/sql-data-types/string-type/STRING.md) 类型。
+
+## 语法
+```sql
+JSON_EXTRACT_STRING(<json_object>, <json_path>)
+```
+
+## 参数
+- `<json_object>` JSON 类型，要提取的目标参数。
+- `<json_path>` String 类型，要从目标 JSON 中提取目标元素的 JSON 路径。
+
+## 返回值
+`Nullable(STRING)` 返回提取出的 STRING 值，某些情况会得到 NULL
+
+## 使用说明
+1. 如果 `<json_object>` 或则 `<json_path>` 为 NULL，返回 NULL。
+2. 如果 `<json_path>` 指定的元素不存在返回 NULL。
+3. 如果 `<json_path>` 指定的元素无法转换为 STRING 返回 NULL。
+4. 其行为与 "cast + json_extract" 一致，即等价于：
+ ```sql
+ CAST(JSON_EXTRACT(<json_object>, <json_path>) as STRING)
+ ```
+ 所以即使 `<json_path>` 指向的对象不是 STRING 类型，但是只要支持转换为 STRING 类型也能得到转换后的值。
+5. 这里返回的 STRING 是不带有双引号的(")。
+6. 对于 JSON 对象中的 null 值，得到的不是 NULL 而是字符串 null，如果想要判断一个元素是否为 null 请使用函数
[`JSON_EXTRACT_ISNULL`](./json-extract-isnull.md)。
+
+## 示例
+1. 正常参数
+ ```sql
+ SELECT json_extract_string('{"id": 123, "name": "doris"}', '$.name');
+ ```
+ ```text
+ +---------------------------------------------------------------+
+ | json_extract_string('{"id": 123, "name": "doris"}', '$.name') |
+ +---------------------------------------------------------------+
+ | doris |
+ +---------------------------------------------------------------+
+ ```
+2. 路径不存在的情况
+ ```sql
+ SELECT json_extract_string('{"id": 123, "name": "doris"}', '$.name2');
+ ```
+ ```text
+ +----------------------------------------------------------------+
+ | json_extract_string('{"id": 123, "name": "doris"}', '$.name2') |
+ +----------------------------------------------------------------+
+ | NULL |
+ +----------------------------------------------------------------+
+ ```
+3. NULL 参数
+ ```sql
+ SELECT json_extract_string('{"id": 123, "name": "doris"}', NULl);
+ ```
+ ```text
+ +-----------------------------------------------------------+
+ | json_extract_string('{"id": 123, "name": "doris"}', NULl) |
+ +-----------------------------------------------------------+
+ | NULL |
+ +-----------------------------------------------------------+
+ ```
+ ```sql
+ SELECT json_extract_string(NULL, '$.id2');
+ ```
+ ```text
+ +------------------------------------+
+ | json_extract_string(NULL, '$.id2') |
+ +------------------------------------+
+ | NULL |
+ +------------------------------------+
+ ```
+4. 其他类型被转换为 STRING 的情况
+ ```sql
+ SELECT json_extract_string('{"id": 123, "name": "doris"}','$.id');
+ ```
+ ```text
+ +------------------------------------------------------------+
+ | json_extract_string('{"id": 123, "name": "doris"}','$.id') |
+ +------------------------------------------------------------+
+ | 123 |
+ +------------------------------------------------------------+
+ ```
+5. null 值会被转换为字符串 "null" 而不是 NULL
+ ```sql
+ SELECT json_extract_string('{"id": null, "name": "doris"}','$.id');
+ ```
+ ```text
+ +-------------------------------------------------------------+
+ | json_extract_string('{"id": null, "name": "doris"}','$.id') |
+ +-------------------------------------------------------------+
+ | null |
+ +-------------------------------------------------------------+
+ ```
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
