hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tom Brown <tombrow...@gmail.com>
Subject Re: Convert JSON array to Hive array
Date Wed, 29 Aug 2012 15:30:57 GMT
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.udachny@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?

Mime
View raw message