did you close your resultset?
在 2012年3月26日 下午4:21，王锋 <wfeng1...@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" <nitinpawar...@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, 王锋 <wfeng1...@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 <bad...@gmail.com> 写道： >> >> hive jdbc里面还有好多方法没有实现。具体自己查看源代码吧。 >> >> 在 2012年3月26日 下午3:15，王锋 <wfeng1...@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 > > > >
