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

Reply via email to