[jira] [Created] (CALCITE-2975) Add the JSON_REMOVE function

["Forward Xu (JIRA)" <ji...@apache.org>]

Forward Xu created CALCITE-2975:
-----------------------------------

             Summary: Add the JSON_REMOVE function
                 Key: CALCITE-2975
                 URL: https://issues.apache.org/jira/browse/CALCITE-2975
             Project: Calcite
          Issue Type: New Feature
            Reporter: Forward Xu


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:

{code:java}
SELECT JSON_REMOVE(v, '$[1]') AS c1
 FROM (VALUES ('["a", ["b", "c"], "d"]')) AS t(v);
{code}

RESULT:

||c1||
|["a", "d"]|






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)