[CALCITE-2867] JSON support

• Type: Task
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Component/s: core
• Assignee: Unassigned
• Reporter: Hongze Zhang
• Created: 25/Feb/19 14:11
• Updated: 29/Apr/19 01:56

Description

Complete JSON support for Calcite.

Issue Links

• is related to: CALCITE-2846 Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

Sub-Tasks

• Implement SQL 2016 JSON functions: Closed
• JSON data type support: Open
• Add the JSON_DEPTH function: Closed
• Add the JSON_TYPE function: Closed
• Add the JSON_PRETTY function: Closed
• Add the JSON_LENGTH function: Closed
• Add the JSON_KEYS function: Closed
• Implement JSON_INSERT, JSON_REPLACE, JSON_SET: Closed
• Implement JSON_TABLE table function: Open
• Combine similar JSON aggregate functions in operator table: Closed
• Add order by clause support for JSON_ARRAYAGG: Closed
• JSON aggregate calls with different null clause get incorrectly merged during converting from SQL to relational algebra: Closed
• Support for JSON key uniqueness constraint: Open
• Support for JSON query quotes behavior: Open
• Support for specifying encoding in JSON representation clause: Open
• Implement JSON_REMOVE function: Closed
• Implement JSON_STORAGE_SIZE function: Closed
• In SQL parser, move JsonValueExpression into Expression: Closed
• Improve null handling of JsonValueExpressionOperator: Closed
• Move MySQL's JSON operators to SqlLibraryOperators: Closed
• Implement JSON_UNQUOTE, JSON_QUOTE function: Open
• Implement JSON_EXTRACT function: Open