Grokbase Groups Pig user June 2010
FAQ
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';

?

Search Discussions

  • Dmitriy Ryaboy at Jun 21, 2010 at 9:41 pm
    Join on book key.
    -D
    On Mon, Jun 21, 2010 at 11:12 AM, Syed Wasti 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';

    ?

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categoriespig, hadoop
postedJun 21, '10 at 6:13p
activeJun 21, '10 at 9:41p
posts2
users2
websitepig.apache.org

2 users in discussion

Syed Wasti: 1 post Dmitriy Ryaboy: 1 post

People

Translate

site design / logo © 2021 Grokbase