morrySnow commented on code in PR #1851: URL: https://github.com/apache/doris-website/pull/1851#discussion_r1921842791
########## docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint.md: ########## @@ -24,57 +24,72 @@ specific language governing permissions and limitations under the License. --> -## get_json_bigint -### Description -#### Syntax +## Description -`INT get_json_bigint(VARCHAR json_str, VARCHAR json_path)` +Parses and obtains the integer (BIGINT) content of the specified path within the json string. +## Syntax -Parse and retrieve the big integer content of the specified path in the JSON string. -Where json_path must start with the $symbol and use. as the path splitter. If the path contains..., double quotation marks can be used to surround it. -Use [] to denote array subscripts, starting at 0. -The content of path cannot contain ",[and]. -If the json_string format is incorrect, or the json_path format is incorrect, or matches cannot be found, NULL is returned. +` GET_JSON_BIGINT( <json_str>, <json_path>)` Review Comment: ````suggestion ```sql GET_JSON_BIGINT( <json_str>, <json_path>) ``` ```` ########## docs/sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint.md: ########## @@ -24,57 +24,72 @@ specific language governing permissions and limitations under the License. --> -## get_json_bigint -### Description -#### Syntax +## Description -`INT get_json_bigint(VARCHAR json_str, VARCHAR json_path)` +Parses and obtains the integer (BIGINT) content of the specified path within the json string. +## Syntax -Parse and retrieve the big integer content of the specified path in the JSON string. -Where json_path must start with the $symbol and use. as the path splitter. If the path contains..., double quotation marks can be used to surround it. -Use [] to denote array subscripts, starting at 0. -The content of path cannot contain ",[and]. -If the json_string format is incorrect, or the json_path format is incorrect, or matches cannot be found, NULL is returned. +` GET_JSON_BIGINT( <json_str>, <json_path>)` -In addition, it is recommended to use the jsonb type and jsonb_extract_XXX function performs the same function. +## 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. | -Exception handling is as follows: -- if the field specified by json_path does not exist, return NULL -- if datatype of the field specified by json_path is not the same with type of json_extract_t, return t if it can be cast to t else NULL +## Usage Notes Review Comment: 放到返回值下面吧 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
