hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Hive Query
Date Fri, 12 Jul 2013 14:12:10 GMT
Hive DOES ssupport in but it is only row wise in. The query you are trying
to do should work.


On Fri, Jul 12, 2013 at 9:46 AM, Dean Wampler <deanwampler@gmail.com> wrote:

> 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