[jira] [Created] (FLINK-23933) flink-json formats support a option to parse nested json as a String

["Shengnan YU (Jira)" <ji...@apache.org>]

Shengnan YU created FLINK-23933:
-----------------------------------

             Summary: flink-json formats support a option to parse nested json as a String
                 Key: FLINK-23933
                 URL: https://issues.apache.org/jira/browse/FLINK-23933
             Project: Flink
          Issue Type: Improvement
          Components: Formats (JSON, Avro, Parquet, ORC, SequenceFile)
    Affects Versions: 1.13.2
            Reporter: Shengnan YU


When use Flink SQL to read message with nested json, eg. \{"a":{"b":111, "c":"xxx"}, "d":12345}，The nested field must be specified ROW or MAP in the table schema.
{code:sql}
CREATE TABLE input(
    a ROW(`b`: BIGINT, `c` VARCHAR),
    d BIGINT
)
WITH ( 
    'format' = 'json',
    // ... 
);
{code}
I'd like to create a option to allow we read the json-object type value as a String.
{code:sql}
CREATE TABLE input (
    a VARCHAR,
    d VARCHAR
)
WITH ( 
 'format' = 'json',
 'json.forceStringFields' = 'a,d'
 // ... 
);
{code}



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