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