RE: Selective removal of data from a relation

2012-03-18 Thread rakesh sharma
Dmitriy, I tried it. However, I don't seem to be getting a handle on it. Some pseudo code will be highly appreciated. Thanks, Rakesh > Date: Sun, 18 Mar 2012 14:27:25 -0700 > Subject: Re: Selective removal of data from a relation > From: dvrya...@gmail.com > To: user@pig.apache.org > > Rakesh,

Re: Selective removal of data from a relation

2012-03-18 Thread Dmitriy Ryaboy
Rakesh, Just like in SQL, this is achieved by doing an outer join and filtering for nulls (a null join key indicates absence of a matching row). D 2012/3/18 rakesh sharma : > > Thanks to Dan for suggesting to post it on gist. Here is the link to the post: > https://raw.github.com/gist/2079527/bf6

RE: Selective removal of data from a relation

2012-03-18 Thread rakesh sharma
Thanks to Dan for suggesting to post it on gist. Here is the link to the post: https://raw.github.com/gist/2079527/bf68dd2f0a7ee3864ef066f126c34880b20b6b04/SelectiveDataRemoval‏ Please take a look and I am sure many of you have solution to this problem. Thanks,Rakesh > Date: Sun, 18 Mar 2012 12:3

RE: Selective removal of data from a relation

2012-03-18 Thread Dan Young
Post it on https://gist.github.com/ and email out the gist. Regards, Dan On Mar 18, 2012 12:33 PM, "rakesh sharma" 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@pi

RE: Selective removal of data from a relation

2012-03-18 Thread rakesh sharma
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 + > > > I am sorry for so

RE: Selective removal of data from a relation

2012-03-18 Thread rakesh sharma
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

RE: Selective removal of data from a relation

2012-03-18 Thread rakesh sharma
Reformatting for clarity 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 "m

Selective removal of data from a relation

2012-03-18 Thread rakesh sharma
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 da