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

Reply via email to