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