Manickam P 2013-07-12, 11:13
-Re: Hive Query
Nitin Pawar 2013-07-12, 11:30
How does support the in clause
what hive does not support is "subquery inside in clause"
you can perfectly run the query you have written but currently as per my
knowledge hive does not let you do this "select * from table where coln in
(select coln from table where coln=blah)"
if you want to use subquery inside in clause then you may take a look at
On Fri, Jul 12, 2013 at 4:43 PM, Manickam P <[EMAIL PROTECTED]> wrote:
> 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.
> Manickam P
Manickam P 2013-07-12, 11:50
Nitin Pawar 2013-07-12, 11:51
Dean Wampler 2013-07-12, 13:46
Edward Capriolo 2013-07-12, 14:12