Gustavo de Morais created FLINK-37374:
-----------------------------------------
Summary: 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
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 \{"K", "{"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.
Example:
{code:java}
jsonObject(JsonOnNull.NULL, "nested", json('{"value": 42}'))
JSON_OBJECT(KEY 'K' VALUE JSON('{"value": 42}'))
// {"nested":{"value":42}}{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
