You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@pig.apache.org by Ajay <aj...@gmail.com> on 2014/07/30 13:25:55 UTC

Merge data in pig

I have following rows.
(int, int, int, int)
X, A, 1, 15
X, A, 2, 13
X, A, 3, 11
......
Y, B, 1, 14
Y, B, 2, 10,
....
Z, C, 1, 30
...


I want to merge them to
X, A, 15, 13, 11
Y, B, 14, 10, 0
Z, C, 30, 0, 0

Third field/column will vary from 1-10, if row doesn't exist corresponding
entry in new modified data will be 0.

Please help.

Ajay Dubey


<http://www.google.com/imgres?imgurl=http://admissions.iiit.ac.in/logo_name.gif&imgrefurl=http://admissions.iiit.ac.in/admission_procedure.php&usg=__9ccHkzRxJdf9UV-7HNUbLjy0KYQ=&h=91&w=324&sz=19&hl=en&start=18&sig2=W2CiCzBOQyPJFhCggrbDSA&zoom=1&tbnid=5zVpQ8aNlkzftM:&tbnh=63&tbnw=226&ei=qP53TLSJDsnQccn7qOcF&prev=/images%3Fq%3DIIIT-H%26hl%3Den%26sa%3DX%26prmdo%3D1%26biw%3D1307%26bih%3D576%26tbs%3Disch:1&itbs=1&iact=hc&vpx=152&vpy=322&dur=876&hovh=72&hovw=259&tx=164&ty=45&oei=o_53TOanCYfKcIyU-eIF&esq=2&page=2&ndsp=19&ved=1t:429,r:13,s:18>