.@decide.com]
> Sent: Friday, June 10, 2011 9:31 PM
> To: user@hive.apache.org
> Subject: Re: left outer join on same table
>
>
>
> The condition T2.field6='yyy;' is tested after the outer join. As a
> result you won't see any non-matching results.
>
&g
I think you can also move the condition T2.field6='yyy' into the ON clause.
From: Igor Tatarinov [mailto:i...@decide.com]
Sent: Friday, June 10, 2011 9:31 PM
To: user@hive.apache.org
Subject: Re: left outer join on same table
The condition T2.field6='yyy;' is tested
The condition T2.field6='yyy;' is tested after the outer join. As a
result you won't see any non-matching results.
You'll need a subquery to enforce that condition. Alternatively, adding ' OR
T2.field6 IS NULL' might work for you too. Just make sure to use parens
around the OR clause. But that'
