[
https://issues.apache.org/jira/browse/FLINK-26818?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17512856#comment-17512856
]
Arindam Bhattacharjee commented on FLINK-26818:
-----------------------------------------------
[~martijnvisser] Then how are we parsing json payload coming from Kafka payload
using SQL API? If you know any workaround, can you please provide me the same
with example?
Thanks in advance again.
> Required Information on parsing complex nested JSON using SQL API
> -----------------------------------------------------------------
>
> Key: FLINK-26818
> URL: https://issues.apache.org/jira/browse/FLINK-26818
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API
> Affects Versions: 1.11.6
> Environment: PROD
> Reporter: Arindam Bhattacharjee
> Priority: Major
> Labels: json, json_array, sql-api
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> Hi Team,
> I need guidance on DDL and DML for nested JSON parsing using FLINK SQL API.
> The sample JSON payload is given below -
> {code:java}
> {
> "success": true,
> "payload": [
> {
> "weekNumber": 40,
> "sortOrder": 1,
> "label": "autumn",
> "numberOfPossibleDays": 3,
> "editable": true,
> "selectedDate": "2020-09-29",
> "deliveryDays": [
> {
> "date": "2020-09-28",
> "contactPerson": null,
> "phoneNumber": null,
> "contactPerson2": null,
> "phoneNumber2": null,
> "selected": false
> },
> {
> "date": "2020-09-29",
> "contactPerson": "John",
> "phoneNumber": "99887744",
> "contactPerson2": "Tom",
> "phoneNumber2": "40040000,
> "selected": true
> },
> {
> "date": "2020-09-30",
> "contactPerson": null,
> "phoneNumber": null,
> "contactPerson2": null,
> "phoneNumber2": null,
> "selected": false
> }
> ]
> },
> {
> "weekNumber": 53,
> "sortOrder": 2,
> "label": "christmas",
> "numberOfPossibleDays": 2,
> "editable": true,
> "selectedDate": "2020-12-29",
> "deliveryDays": [
> {
> "date": "2020-12-28",
> "contactPerson": null,
> "phoneNumber": null,
> "contactPerson2": null,
> "phoneNumber2": null,
> "selected": false
> },
> {
> "date": "2020-12-29",
> "contactPerson": "Doe,
> "phoneNumber": "99999999",
> "contactPerson2": "Foo",
> "phoneNumber2": "44552200",
> "selected": true
> }
> ]
> }
> ]
> } {code}
> I want to know what would be the DDL for this JSON structure and how can I
> select the particular fields using SELECT statement.
>
> Thanks in advance and it will be very helpful for me.
>
> -
> Arindam
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
