hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dean Wampler <deanwamp...@gmail.com>
Subject Re: Hive Query
Date Fri, 12 Jul 2013 13:46:52 GMT
Use a semi-join, which is more or less the same thing.. You might also see
if the having clause will help.

dean

On Fri, Jul 12, 2013 at 6:13 AM, Manickam P <manickam.p@outlook.com> wrote:

> Hi,
>
> I need to run hive query like select * from employee where employee_id IN
> (100,102). I came to know that hive does not support IN clause.
> Then what is the effective replacement for this? i need to execute around
> 250 inputs.  I'm using hive 0.9.0 version.
>
> Please guide me.
>
>
> Thanks,
> Manickam P
>



-- 
Dean Wampler, Ph.D.
@deanwampler
http://polyglotprogramming.com

Mime
View raw message