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)
