FOREACH A GENERATE cust_id, cust_name, FLATTEN(cust_address), cust_email;
On Sun, Jun 1, 2014 at 5:54 PM, Rahul Channe <drah...@googlemail.com> wrote:
> Hi All,
>
> I have imported hive table into pig having a complex data type
> (ARRAY<String>). The alias in pig looks as below
>
> grunt> describe A;
> A: {cust_id: int,cust_name: chararray,cust_address: {innertuple:
> (innerfield: chararray)},cust_email: chararray}
>
> grunt> dump A;
>
> (123,phil abc,{(2200),(benjamin avenue),(philadelphia)},t...@gmail.com)
> (124,diego arty,{(44),(atlanta franklin),(florida)},o...@gmail.com)
>
> The cust_address is the ARRAY field from hive. I want to FLATTEN the
> cust_address into different fields.
>
>
> Expected output
> (2200,benjamin avenue,philadelphia)
> (44,atlanta franklin,florida)
>
> please help
>
> Regards,
> Rahul
>
