hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Robertson <timrobertson...@gmail.com>
Subject Re: NOT IN query
Date Wed, 03 Nov 2010 12:22:41 GMT
Please try this in Hive:
select distinct a.id from tableA a LEFT OUTER join tableB b on
a.id=b.id where b.id is null

Cheers,
Tim


On Wed, Nov 3, 2010 at 1:19 PM, Tim Robertson <timrobertson100@gmail.com> wrote:
> In SQL you use a left join:
>
> # so in mysql:
> select distinct a.id from tableA a left join tableB b on a.id=b.id
> where b.id is null
>
> Not sure exactly how that ports to Hive, but it should be something
> along those lines.
>
> HTH,
> Tim
>
>
> On Wed, Nov 3, 2010 at 1:13 PM, איל (Eyal) <eyalb1@gmail.com> wrote:
>> Hi,
>>
>> I have a table A with some values and another table B with some other values
>>
>> How do I get all the distinct values from A that are NOT in B
>>
>> e.g
>>
>> if table A has values 1,2,3,4,1,2,3,5,6,7  and B has values 2,3,4,5,6
>>
>> then the result should be 1,7
>>
>> Thanks
>>   Eyal
>>
>

Mime
View raw message