Unfortunately get_json_object return the string and not a Hive array.
On Wed, Aug 29, 2012 at 5:30 PM, Tom Brown <tombrow...@gmail.com> wrote: > 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?
