[CALCITE-2975] Implement JSON_REMOVE function

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Labels: pull-request-available
• Assignee: Forward Xu
• Reporter: Forward Xu
• Created: 03/Apr/19 02:47
• Updated: 24/Jun/19 15:02
• Resolved: 16/May/19 14:30

Description

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"]

Issue Links

• links to: GitHub Pull Request #1146