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?
 

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?
>
>
>
>
>
>
>
>

Hi Weng,

are you using hiveserver ?

Thanks,
Nitin
you can not set a query

On Mon, Mar 26, 2012 at 12:45 PM, 王锋 <[EMAIL PROTECTED]> wrote:

> 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

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?
 

yes

At 2012-03-26 15:26:49,"Nitin Pawar" <[EMAIL PROTECTED]> wrote:
Hi Weng,
are you using hiveserver ?
Thanks,
Nitin
you can not set a query
On Mon, Mar 26, 2012 at 12:45 PM, 王锋 <[EMAIL PROTECTED]> wrote:

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

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

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

did you close your resultset?
在 2012年3月26日 下午4:21��王锋 <[EMAIL PROTECTED]>写道：

> 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
>
>
>
>