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 <manicka...@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