hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gemini alex <gemini5201...@gmail.com>
Subject Re: Re: Re: hive cann't support setting queryTimeout
Date Mon, 09 Apr 2012 01:34:13 GMT
did you close your resultset?


在 2012年3月26日 下午4:21,王锋 <wfeng1982@163.com>写道:

> 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" <nitinpawar432@gmail.com> 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, 王锋 <wfeng1982@163.com> 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 <badqiu@gmail.com> 写道:
>>
>> hive jdbc里面还有好多方法没有实现。具体自己查看源代码吧。
>>
>> 在 2012年3月26日 下午3:15,王锋 <wfeng1982@163.com>写道:
>>
>>> 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
>
>
>
>

Mime
View raw message