I'm afraid of there's no build-in function on the hand. But you can write a UDF[1] to convert the JSON array string to Flink's array. [1] https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/functions/udfs/
Best regards, Yuxia ----- 原始邮件 ----- 发件人: "Abhishek Rai" <abhis...@netspring.io> 收件人: "User" <user@flink.apache.org>, "Jordan Hannel" <jor...@netspring.io> 发送时间: 星期三, 2022年 7 月 13日 上午 3:02:15 主题: Parsing a JSON array string as a Flink SQL Array data type Hello! I'm trying to use the new JSON functions in Flink 1.15 to parse JSON input data. In particular, using JSON_QUERY, I'm able to extract out JSON array elements from a larger JSON record. However, this function returns the JSON array as a string. I'd like to run this array through the SQL UNNEST operator, which takes an ARRAY data type as an input, not a string. So how do I convert a string encoded JSON array to a Flink SQL Array data type, so I can use it with UNNEST? Unfortunately, I'm not able to locate any documentation on this. Thanks for your help! Abhishek
