Re: HiveServer2 Goes down while parallel Query execution

2015-10-11 Thread Vineet Mishra
What about the case when even the HS2 Service restart is also not working. So my bad is that after restarting HS2 the health is good(green) but still I cannot query the data. Any quick thoughts/input? Thanks! On Sun, Oct 11, 2015 at 9:58 PM, Edward Capriolo < edward.capri...@huffingtonpost.com>

Re: HiveServer2 Goes down while parallel Query execution

2015-10-10 Thread Vineet Mishra
Hi Edward, I am not sure whether you meant HiverServer2 or HS1 as I could see that HS2 is preferable over HS1 https://cwiki.apache.org/confluence/display/Hive/HiveServer and didn't heard about any such reliability issue of HS2. Moreover I am making multiple JDBC Connection to fire parallel query

Re: HiveServer2 Goes down while parallel Query execution

2015-10-10 Thread Vineet Mishra
Any update on this? URGENT CALL! On Oct 10, 2015 9:25 AM, "Vineet Mishra" wrote: > Hi Jimmy, > > Any prominent reason for it run out of worker thread when maximum query > fired at a time fired are only 8. > > I am trying to open multiple session on different connection, so each > thread correspo

Re: HiveServer2 Goes down while parallel Query execution

2015-10-09 Thread Vineet Mishra
Hi Jimmy, Any prominent reason for it run out of worker thread when maximum query fired at a time fired are only 8. I am trying to open multiple session on different connection, so each thread corresponds to one connection. Thanks! On Sat, Oct 10, 2015 at 1:22 AM, Jimmy Xiang wrote: > Could i

Re: HiveServer2 Goes down while parallel Query execution

2015-10-09 Thread Jimmy Xiang
Could it be because HS2 runs out of worker threads? Are you trying to open multiple sessions on the same connection? Thanks, Jimmy On Fri, Oct 9, 2015 at 12:34 PM, Vineet Mishra wrote: > Any idea about this? > > Frequent Connectivity issue to HiveServer2 > > 2015-10-10 00:23:11,070 [main] ERR

Re: HiveServer2 Goes down while parallel Query execution

2015-10-09 Thread Vineet Mishra
Any idea about this? Frequent Connectivity issue to HiveServer2 2015-10-10 00:23:11,070 [main] ERROR (HiveConnection.java:439) - Error opening session org.apache.thrift.transport.TTransportException at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) at org.apa

Re: HiveServer2 Goes down while parallel Query execution

2015-10-09 Thread Vineet Mishra
This looks out to be the issue https://issues.apache.org/jira/browse/HIVE-2314 Any workaround or resolution to the same. Thanks! On Fri, Oct 9, 2015 at 1:24 PM, Vineet Mishra wrote: > Hi All, > > I am trying to connect to HiveServer2 to query some data in parallel and > landing up into some w

HiveServer2 Goes down while parallel Query execution

2015-10-09 Thread Vineet Mishra
Hi All, I am trying to connect to HiveServer2 to query some data in parallel and landing up into some weird exception, stack trace mentioned below java.sql.SQLException: Error while cleaning up the server resources at org.apache.hive.jdbc.HiveConnection.close(HiveConnection.java:569) at com.sd.dw