Post it on https://gist.github.com/ and email out the gist.
Regards, Dan On Mar 18, 2012 12:33 PM, "rakesh sharma" <rakesh_sharm...@hotmail.com> wrote: > > All indentations get removed when message comes back from > user@pig.apache.org. Any idea how I can make it work. > > > From: rakesh_sharm...@hotmail.com > > To: user@pig.apache.org > > Subject: RE: Selective removal of data from a relation > > Date: Sun, 18 Mar 2012 18:26:01 +0000 > > > > > > I am sorry for so many re-sends. Resending in Rich text format... > > Hi All, > > I have two relations "mix" and "child_parent". Relation "mix" contains > rows of ids. Each Id can be a parent or a child. Another relation > "child-parent" has rows of children and associated parents. It may not have > data for every child existing in relation "mix". Also, it can have some > data for which there is no matching data in relation "mix". I need to > remove all children from relation "mix" whose parent exists in the > relation. Here is an example to show what I am trying to achieve:mix = load > "all_data" as (id:chararray);dump mix; > > 13469 > > child_parent = load "mapping" as (childId:chararray, > parentId:chararray);dump child_parent; > > (3 1)(6 1)(9 15) > > Children "3" and "6" has matching parent "1". Hence, 3 and 6 need to be > removed from "all_data". However, child "9" will stay as its parent "15" > does not exist in "all_data". The outcome will be:149I am having hard time > in solving it due to lack of experience with pig. Any help/suggestion will > be highly appreciated. > > Thanks,Rakesh >
