Hi,
I have data in a file which has schema, say like this: (stud_id, Physics,
Chemistry, Bio, CS)
I need to generate an output which should contain (stud_id , xml_payload)
for each record in my relation.
The type of dynamic xml i need to generate is like this:
<stud xmlns: www.w3.org .... ... >
<stud_id> A-12 </stud_id>
<subjects>
<marks>
<phy> 98 </phy>
<chem>96 </chem>
</marks>
</subjects>
</stud>
<stud xmlns: www.w3.org .... >
<stud_id> A-102 </stud_id>
<subjects>
<marks>
<phy> 98 </phy>
<chem>96 </chem>
<CS> 100</CS>
</marks>
</subjects>
</stud>
Any suggestions on how to proceed on this? I am bit new to pig.
Thanks & Regards,
Dipesh