Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive Query

Copy link to this message
Re: Hive Query
Use a semi-join, which is more or less the same thing.. You might also see
if the having clause will help.


On Fri, Jul 12, 2013 at 6:13 AM, Manickam P <[EMAIL PROTECTED]> 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.