[GitHub] [calcite] XuQianJin-Stars opened a new pull request #1146: [CALCITE-2975] Add the JSON_REMOVE function

[GitBox <gi...@apache.org>]

XuQianJin-Stars opened a new pull request #1146: [CALCITE-2975] Add the JSON_REMOVE function
URL: https://github.com/apache/calcite/pull/1146
 
 
   `JSON_REMOVE`(json_doc, path[, path] ...)
   
   Removes data from a JSON document and returns the result. Returns NULL if any argument is NULL. An error occurs if the json_doc argument is not a valid JSON document or any path argument is not a valid path expression or is $ or contains a * or ** wildcard.
   The path arguments are evaluated left to right. The document produced by evaluating one path becomes the new value against which the next path is evaluated.
   It is not an error if the element to be removed does not exist in the document; in that case, the path does not affect the document.
   JSON_REMOVE SQL:
   ```
   SELECT JSON_REMOVE(v, '$[1]') AS c1
    FROM (VALUES ('["a", ["b", "c"], "d"]')) AS t(v);
   ```
   RESULT:
   
   | c1         |
   | ---------- |
   | ["a", "d"] |
   

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services