[
https://issues.apache.org/jira/browse/FLINK-37374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dawid Wysakowicz resolved FLINK-37374.
--------------------------------------
Resolution: Implemented
Implemented in
af136b40affdd2d75b0b9db7d11ae6a47db3c6c1..2f172c113c2f2d8e7bc5eb6938598dc5a20fec65
> Support JSON built-in function for JSON_ARRAY
> ---------------------------------------------
>
> Key: FLINK-37374
> URL: https://issues.apache.org/jira/browse/FLINK-37374
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / API
> Reporter: Gustavo de Morais
> Assignee: Gustavo de Morais
> Priority: Major
> Labels: pull-request-available
> Fix For: 2.1.0
>
>
> It is currently not possible to declare a SQL string that contains existing
> JSON as valid JSON for JSON_OBJECT. Something like
> {code:java}
> JSON_OBJECT(KEY 'K' VALUE '\{"value": 42}') returns {"{"value": 42}"}
> {code}
> Where the value is a string a not a json object.
> We should support the JSON() function, at least initial support for it until
> this function returns the JSON datatype. We already implemented it for
> JSON_OBJECT and this would support it for JSON_ARRAY.
>
> Example:
> {code:java}
> jsonArray(json('{"value": 42}'))
> JSON_ARRAY(JSON('{"value": 42}'))
> // [{"value":42}]{code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
