JSON Format

    The JSON format allows to read and write JSON data based on an JSON schema. Currently, the JSON schema is derived from table schema.

    In order to use the Json format the following dependencies are required for both projects using a build automation tool (such as Maven or SBT) and SQL Client with SQL JAR bundles.

    2.   user_id BIGINT,
    3.   item_id BIGINT,
    4.   behavior STRING,
    5.   ts TIMESTAMP(3)
    6. ) WITH (
    7.  'connector' = 'kafka',
    8.  'topic' = 'user_behavior',
    9.  'properties.bootstrap.servers' = 'localhost:9092',
    10.  'properties.group.id' = 'testGroup',
    11.  'json.fail-on-missing-field' = 'false',
    12.  'json.ignore-parse-errors' = 'true'
    13. )

    Currently, the JSON schema is always derived from table schema. Explicitly defining an JSON schema is not supported yet.

    The following table lists the type mapping from Flink type to JSON type.