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