I believe the "get_json_object" function will be suitable (though I've never personally tried it in the exact context you describe.)
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-getjsonobject --Tom On Wed, Aug 29, 2012 at 7:49 AM, Aleksei Udatšnõi <a.udac...@gmail.com> wrote: > 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?
