Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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.

dean

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.
@deanwampler
http://polyglotprogramming.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB