Thanks Stephen,
Will start a cluster today to see if it helps.
Peter
Date: Mon, 6 May 2013 00:05:45 -0700
Subject: Re: Hive QL - NOT IN, NOT EXIST
From: java...@gmail.com
To: user@hive.apache.org
Hi Peter, Looks like mapjoin does not work with outer join so streamtable is
instead a possible
n you use MAPJOIN on left outer join?
>
> Peter
>
> --
> Date: Sun, 5 May 2013 21:44:37 -0700
>
> Subject: Re: Hive QL - NOT IN, NOT EXIST
> From: java...@gmail.com
> To: user@hive.apache.org
>
>
>
> @Peter Does the query plan demons
feed table
contains 3 million rows.
SELECT uuid from feed f WHERE f.uuid NOT IN (SELECT uuid FROM message);
> Date: Sun, 5 May 2013 20:25:15 -0700
> From: michaelma...@yahoo.com
> Subject: Re: Hive QL - NOT IN, NOT EXIST
> To: user@hive.apache.org
>
>
> --- On Sun, 5/5/13, Peter
feed f WHERE f.uuid NOT IN (SELECT uuid FROM message);
>
> > Date: Sun, 5 May 2013 20:25:15 -0700
> > From: michaelma...@yahoo.com
> > Subject: Re: Hive QL - NOT IN, NOT EXIST
> > To: user@hive.apache.org
>
> >
> >
> > --- On Sun, 5/5/13, Peter
; From: michaelma...@yahoo.com
> Subject: Re: Hive QL - NOT IN, NOT EXIST
> To: user@hive.apache.org
>
>
> --- On Sun, 5/5/13, Peter Chu wrote:
>
> > I am wondering if there is any way to do this without resorting to
> > using left outer join and finding nulls.
>
--- On Sun, 5/5/13, Peter Chu wrote:
> I am wondering if there is any way to do this without resorting to
> using left outer join and finding nulls.
I have found this to be an acceptable substitute. Is it not working for you?
Hi, I am trying to write a hive query to find the equivalent of NOT IN / NOT
EXIST in SQL.
However, Hive does not support this. It does have Left Semi Join which serves
as IN but NOT does not support.
I am wondering if there is any way to do this without resorting to using left
outer join and f