You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@pig.apache.org by Syed Wasti <md...@hotmail.com> on 2010/06/21 20:12:54 UTC

Exists clause in Pig

Hi,
What would be the simple of way of writing the Exist clause (oracle) in pig.

> Select book_key from book
> where exists (select book_key from sales);
> 
> book = LOAD 'data/a.txt';
> sales = LOAD 'data/b.txt';
> 
> ?

Re: Exists clause in Pig

Posted by Dmitriy Ryaboy <dv...@gmail.com>.

Join on book key.
-D

On Mon, Jun 21, 2010 at 11:12 AM, Syed Wasti <md...@hotmail.com> wrote:

> Hi,
> What would be the simple of way of writing the Exist clause (oracle) in
> pig.
>
> > Select book_key from book
> > where exists (select book_key from sales);
> >
> > book = LOAD 'data/a.txt';
> > sales = LOAD 'data/b.txt';
> >
> > ?
>
>