Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Hive Query


+
Manickam P 2013-07-12, 11:13
+
Nitin Pawar 2013-07-12, 11:30
+
Manickam P 2013-07-12, 11:50
Copy link to this message
-
Re: Hive Query
Nitin Pawar 2013-07-12, 11:51
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 <[EMAIL PROTECTED]> wrote:

> 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 P
>
>
> ------------------------------
> Date: Fri, 12 Jul 2013 17:00:38 +0530
> Subject: Re: Hive Query
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
>
> 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 want to use subquery inside in clause then you may take a look at
> left join
>
>
> On Fri, Jul 12, 2013 at 4:43 PM, 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
>
>
>
>
> --
> Nitin Pawar
>

--
Nitin Pawar
+
Dean Wampler 2013-07-12, 13:46
+
Edward Capriolo 2013-07-12, 14:12