Home | About | Sematext search-lucene.com search-hadoop.com
 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: hive cann't support setting queryTimeout
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