Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of tombrown52@gmail.com
 designates 209.85.212.48 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAJ7QPq6SA7um-mvk4Um9Ur9E_EnF-3Hp2TGJdfhp=0ino2XeyQ@mail.gmail.com>
References: 
 <CAJ7QPq6SA7um-mvk4Um9Ur9E_EnF-3Hp2TGJdfhp=0ino2XeyQ@mail.gmail.com>
Date: Wed, 29 Aug 2012 09:30:57 -0600
Message-ID: 
 <CAHtRq2eh1o68jjkZ6EvYPqEaJkp+MxVjQ_oL8kCEuMpbWDT-ig@mail.gmail.com>
Subject: Re: Convert JSON array to Hive array
From: Tom Brown <tombrown52@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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#Languag=
eManualUDF-getjsonobject

--Tom

On Wed, Aug 29, 2012 at 7:49 AM, Aleksei Udat=C5=A1n=C3=B5i <a.udachny@gmai=
l.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?