:user@hive.apache.org>"
mailto:user@hive.apache.org>>
Subject: Re: Query difference between 2 tables
select x from t1 left outer join t2 on t1.x = t2.x where t2.x is null
should work.
Thanks,
Gunther.
On Tue, Jul 22, 2014 at 11:01 AM, Brenden Cobb
mailto:brenden.c...@humedica.com
select x from t1 left outer join t2 on t1.x = t2.x where t2.x is null
should work.
Thanks,
Gunther.
On Tue, Jul 22, 2014 at 11:01 AM, Brenden Cobb
wrote:
> Hi-
>
> I'm stuck on Hive .10 right now and I'm trying to figure out how to
> accomplish the equivalent of a not exists or minus statem
Hi-
I'm stuck on Hive .10 right now and I'm trying to figure out how to accomplish
the equivalent of a not exists or minus statement:
Select x from t1 where x not in ( select x from t2)
I know this kind of subquery is available in .13 but would like to find a
workaround.
Appreciate any sugges
