Disregard last email.
Sorry... didn't fully understand the question.
On Mon, Jun 2, 2014 at 8:44 AM, Pradeep Gollakota <pradeep...@gmail.com>
wrote:
> 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
>>
>
>
