Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> hive cann't support setting queryTimeout


Copy link to this message
-
Re:Re: Re: hive cann't support setting queryTimeout
thanks for Pawar. the metadata store is fine and it was in our mysql safe plateform. When I restart the hiveserver ,it 's ok. but when the hiveserver occurred the question,it has been running about one week, and the mem is about 5g . so I agree 1).

If the large mem of hive cause the question, I need tuning the gc arguments?

At 2012-03-26 16:05:51,"Nitin Pawar" <[EMAIL PROTECTED]> wrote:
Hi,
can you check the logs on hiveserver?
Is your metadata store working fine? Cause this issue comes only if there is a lag with metadata store or hiveserver is overly loaded.
1) are there any queries running in hiveserver? if yes .. then what is memory status of the server?
2) Also check if the metadata store for hive is working fine?
I suspect the first cause we have seen that when there are multiple queries running on query server it takes a lot of time to response.
Thanks,
Nitin
In hive you can not set a query timeout but with jdbc you can set a connection timeout but still that does not solve the problem you are facing
On Mon, Mar 26, 2012 at 12:57 PM, 王锋 <[EMAIL PROTECTED]> wrote:

ya,this morning,we see a serious question. when our system send sql "CREATE DATABASE IF NOT EXISTS dbname" to hiveserver through jdbc, the result had not been returned after several hours. And this is the second time.

是的。 今天凌晨 系统遇到一个问题, 执行 CREATE DATABASE IF NOT EXISTS dbname时,hiveserver 一直没有返回。 不知有没有人碰到过.这是第二次碰到了.

在 2012-03-26 15:18:51,badqiu <[EMAIL PROTECTED]> 写道:

hive jdbc里面还有好多方法没有实现。具体自己查看源代码吧。
在 2012年3月26日 下午3:15,王锋 <[EMAIL PROTECTED]>写道:

Hi,all
when I using hive through jdbc,and execute the code below.
Statement stmt = con.createStatement();
stmt.setQueryTimeout(10);
hive thrown the exception "Method not support." so how can I set the query timeout like using mysql?
And is this an issue for hive?
 

--
Nitin Pawar

NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB