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] [Updated] (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:all-tabpanel ]

Zili Chen updated FLINK-16185:
------------------------------
    Summary: FLIP-90: Support SQL 2016-2017 JSON functions in Table API & SQL  (was: Support JSON functions provides by calcite for blink planner)

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



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