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

Switch to Threaded View
Pig >> mail # user >> join with sum


Copy link to this message
-
Re: join with sum
See the COGROUP operator

--jacob
@thedatachef

Sent from my iPhone

On Jan 30, 2011, at 5:10 AM, Cam Bazz <[EMAIL PROTECTED]> wrote:

> Hello,
>
> Lets say I have two tables like
>
> A:
> 1,11
> 2,15
>
> and
>
> B:
> 1,10
> 4,11
> 5,10
>
> and joinin them
>
> J = JOIN A by $0 FULL, B by $0
>
> I get J:
>
> 1,11,1,21
> 2,16,,
> ,,4,11
> ,,5,10
>
> which is a full outer join:
>
> what I need is:
>
> 1,31
> 2,16
> 4,11
> 5,10
>
> so I want to join by key, and then sum some fields.
>
> the regular sum operator is for group or agregate summing and can  
> not do it.
>
> any ideas / recomendation / help greatly appreciated.
>
> best.
> c.b.