Re: [Flink SQL] Leniency of JSON parsing

2021-03-17 Thread Magri, Sebastian
Magri, Sebastian > *Sent:* Friday, March 12, 2021 18:50 > *To:* Timo Walther ; ro...@apache.org > *Cc:* user > *Subject:* Re: [Flink SQL] Leniency of JSON parsing > Hi Roman! > > Seems like that option is no longer available. > > Best Regards, > Sebastian > -

Re: [Flink SQL] Leniency of JSON parsing

2021-03-16 Thread Timo Walther
2021 18:50 *To:* Timo Walther ; ro...@apache.org *Cc:* user *Subject:* Re: [Flink SQL] Leniency of JSON parsing Hi Roman! Seems like that option is no longer available. Best Regards, Sebastian *From:* Roman Khachatryan

Re: [Flink SQL] Leniency of JSON parsing

2021-03-12 Thread Magri, Sebastian
: user Subject: Re: [Flink SQL] Leniency of JSON parsing Hi Roman! Seems like that option is no longer available. Best Regards, Sebastian From: Roman Khachatryan Sent: Friday, March 12, 2021 16:59 To: Magri, Sebastian ; Timo Walther Cc: user Subject: Re: [Flin

Re: [Flink SQL] Leniency of JSON parsing

2021-03-12 Thread Magri, Sebastian
Hi Roman! Seems like that option is no longer available. Best Regards, Sebastian From: Roman Khachatryan Sent: Friday, March 12, 2021 16:59 To: Magri, Sebastian ; Timo Walther Cc: user Subject: Re: [Flink SQL] Leniency of JSON parsing Hi Sebastian, Did you

Re: [Flink SQL] Leniency of JSON parsing

2021-03-12 Thread Roman Khachatryan
Hi Sebastian, Did you try setting debezium-json-map-null-key-mode to DROP [1]? I'm also pulling in Timo who might know better. [1] https://ci.apache.org/projects/flink/flink-docs-stable/dev/table/connectors/formats/debezium.html#debezium-json-map-null-key-mode Regards, Roman On Fri, Mar 12,

[Flink SQL] Leniency of JSON parsing

2021-03-12 Thread Magri, Sebastian
I'm trying to extract data from a Debezium CDC source, in which one of the backing tables has an open schema nested JSON field like this: "objectives": { "items": [ { "id": 1, "label": "test 1" "size": 1000.0 }, { "id":