Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> self join in pig

Copy link to this message
Re: self join in pig
Also keep in mind that a Pig relation is not aware of the order of records
unless right after the ORDER statement. I guess that you need to use a row
with a preceding row,corrent? Probably you'll need the RANK:
to use as a key for the join.

Best Regards,
Ruslan Al-Fakikh
On Sun, Sep 15, 2013 at 10:10 PM, Shahab Yunus <[EMAIL PROTECTED]>wrote:

> You need to load your data twice and then use it as any other join.
> Self-join is just like any other join to Pig.
> Regards,
> Shahab
> On Sun, Sep 15, 2013 at 1:37 PM, Raj hadoop <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I need to subtract row2 value from row1.  how to get it in Pig?
> >
> > Thanks
> > Rajesh
> >