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 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
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 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 s
Once you start a hive query, and abort your script it does not kill your
job on hadoop
so you will need to find that job on hadoop cluster and kill it.
On Fri, Jul 12, 2013 at 5:20 PM, Manickam P wrote:
> Hi,
>
> Thanks for your reply. I need one more info also.
> I put hive queries in hql fil
Hi,
Thanks for your reply. I need one more info also. I put hive queries in hql
file and using shell script i started executing it in background mode. even if
i kill the script process it is keep on executing queries. How to kill the hive
query execution which is in hql file?
Thanks,
Manickam
Manickam,
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
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
