You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Zili Chen (Jira)" <ji...@apache.org> on 2020/02/20 12:45:00 UTC

[jira] [Commented] (FLINK-16185) FLIP-90: Support SQL 2016-2017 JSON functions in Table API & SQL

    [ https://issues.apache.org/jira/browse/FLINK-16185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17040930#comment-17040930 ] 

Zili Chen commented on FLINK-16185:
-----------------------------------

Original description

Calcite 1.20 provides several built-in JSON functions(listed below). In order to enrich our builtin UDFs and according to our internal user experiences I'd propose to support those functions for blink planner.

cc [~jark] [~docete] what do you think?

JSON_EXISTS
JSON_QUERY
JSON_OBJECT
JSON_ARRAY
IS_JSON_ARRAY
IS_JSON_OBJECT
IS_JSON_SCALAR
IS_JSON_VALUE
IS_NOT_JSON_ARRAY
IS_NOT_JSON_OBJECT
IS_NOT_JSON_SCALAR
IS_NOT_JSON_VALUE
JSON_VALUE
JSON_VALUE_ANY
JSON_VALUE_EXPRESSION

JSON_OBJECTAGG
JSON_ARRAYAGG

> FLIP-90: Support SQL 2016-2017 JSON functions in Table API & SQL
> ----------------------------------------------------------------
>
>                 Key: FLINK-16185
>                 URL: https://issues.apache.org/jira/browse/FLINK-16185
>             Project: Flink
>          Issue Type: New Feature
>          Components: Table SQL / API
>            Reporter: Zili Chen
>            Priority: Major
>             Fix For: 1.11.0
>
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)