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