Re: Closing long running hive query forcefully

2013-03-18 Thread wzc
' select /* myid bla bla*/ x,y,z ' I can't run above command using cli nor "hive -f", could you explain how to add comment in hive query? 2013/2/8 Edward Capriolo > That is a good way to do it. We do it with comment sometimes. > > select /* myid bla bla*/ x,y,z > > Edward > > On Thu, Feb 7, 201

Re: Closing long running hive query forcefully

2013-02-12 Thread Kugathasan Abimaran
Hi All, I have filed a feature enhancement bug on jira : https://issues.apache.org/jira/browse/HIVE-4017 On Thu, Feb 7, 2013 at 10:01 PM, Edward Capriolo wrote: > That is a good way to do it. We do it with comment sometimes. > > select /* myid bla bla*/ x,y,z > > Edward > > On Thu, Feb 7, 2013 a

Re: Closing long running hive query forcefully

2013-02-07 Thread Edward Capriolo
That is a good way to do it. We do it with comment sometimes. select /* myid bla bla*/ x,y,z Edward On Thu, Feb 7, 2013 at 11:12 AM, Gabor Makrai wrote: > Hi, > > We solved this problem in the following way (this is really not a simple > solution): > - start hive query in a different thread > -

Re: Closing long running hive query forcefully

2013-02-07 Thread Gabor Makrai
Hi, We solved this problem in the following way (this is really not a simple solution): - start hive query in a different thread - we generated an unique id for the query and used the SET key=value; command (before the long query command) to give this unique id to the MR jobs related to the query

Re: Closing long running hive query forcefully

2013-02-07 Thread Nitin Pawar
hive waits till the hadoop job is completed. so unless you kill the job of jdbc connection is dropped I don't see any other way to reduce the load on application. best when you think its long enough, you will need to find a way to kill the hadoop job. That will automatically release the resources