在HIVE中将JSON格式字符串转换为数组

I have a database column that stores JSON format strings. The string itself contains multuple elements like an array. Each element contains multiple key-value pairs. Some value may also contain multiple key-value pairs as well, for example, the "address" attribute below. I have a database column that stores JSON forma