[FLINK-9477] FLIP-90: Support SQL 2016 JSON functions in Flink SQL

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Table SQL / API
• Labels: auto-unassigned pull-request-available
• Assignee: Unassigned
• Reporter: Shuyi Chen
• Created: 30/May/18 06:48
• Updated: 06/Dec/21 11:31
• Resolved: 06/Dec/21 11:31

Description

FLIP Link https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=141724550

Issue Links

• duplicates: FLINK-16185 FLIP-90: Support SQL 2016-2017 JSON functions in Table API & SQL
• is blocked by: CALCITE-2266 Implement SQL 2016 JSON functions
• is blocked by: FLINK-10076 Upgrade Calcite dependency to 1.18
• links to: GitHub Pull Request #17508

Sub-Tasks

• Support "IS JSON" for SQL: Resolved
• Support IS JSON for Table API: Closed
• Support JSON_EXISTS: Closed
• Support JSON_VALUE: Closed
• Support JSON_QUERY: Closed
• Support JSON_OBJECT: Closed
• Support a JSON_STRING: Closed
• Support JSON_ARRAY: Closed
• Support JSON_OBJECTAGG: Closed
• Support JSON_ARRAYAGG: Closed
• Add documentation for all JSON function: Closed
• Support JSON_EXISTS / JSON_VALUE methods in pyFlink: Closed
• Support all JSON methods in PyFlink: Closed
• Support STRUCTURED_TYPE for JSON_OBJECT / JSON_ARRAY: Closed