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)
