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