I have a Hive column with JSON string like: ["9835","29825","73432","51365","14114","6527","779"]
I want to explode() it and use with the LATERAL VIEW. For that it needs to be a Hive array. Is there any quick way to convert this string into a Hive array?