Hi everyone, today I came across with a particular query that I don't know how to model in PIG. Part of my data looks like this:
Id1 Id2 Sc Va P1 P2 --------- --------- ----- --------- ----- ---- 770011 990201 401 1e-125 100 65 990201 770011 440 1e-125 100 42 770011 770083 524 1e-120 89 12 770083 770011 494 1e-120 39 100 990201 770083 341 1e-125 73 41 770083 990201 421 1e-125 90 85 . . . what I would like to retrieve is something like this: 770011 990201 770083 because they are records actually related. Any kind of ideas are highly appreciated. Thanks in advanced. Renato M.
