[jira] [Created] (FLINK-37175) Support JSON built-in function for JSON_OBJECT

[Gustavo de Morais (Jira)]

Gustavo de Morais created FLINK-37175:
-----------------------------------------

             Summary: Support JSON built-in function for JSON_OBJECT
                 Key: FLINK-37175
                 URL: https://issues.apache.org/jira/browse/FLINK-37175
             Project: Flink
          Issue Type: New Feature
          Components: Table SQL / API
            Reporter: Gustavo de Morais
             Fix For: 2.0.0


It is currently not possible to declare a SQL string that contains existing 
JSON as valid JSON for JSON_OBJECT. If you do something like {{JSON_OBJECT(KEY 
'K' VALUE '\{"value": 42}'), you'll have a string, \{"K", "{"value": 42}"}, as 
output, an 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}

{code}
{{jsonObject(JsonOnNull.NULL, "nested", json('\{"value": 42}'))}}
{{JSON_OBJECT(KEY 'K' VALUE JSON('\{"value": 42}'))}}
{{// \{"nested":{"value":42}}}}
{code:java}

{code}
{{}}

{{}}

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)