Is it same with https://issues.apache.org/jira/browse/HIVE-6866 ?
On Tue, Apr 29, 2014 at 8:26 PM, Dima Fadeyev <[email protected]> wrote: > Hi, Chinna. Thanks for your reply. > > Yes, modifying code solves the problem. This is what my code looks like (a > piece of it): > > Connection con = > DriverManager.getConnection("jdbc:hive2://localhost:10000/default", "hive", > "hive"); > Statement stmt = con.createStatement(); > String tableName = "testHiveDriverTable"; > stmt.execute("drop table if exists " + tableName); > //stmt.close(); > > When I uncomment the last line, the number of hive-server2 threads doesn't > keep incrementing to infinity. However I'm investigating the issue where > the code is not really my code. Is there a way to correct this behavior > from within hive-server2 without changing the client's code? > > El 29/04/14 14:05, Chinna Rao Lalam escribió: > > Hi, > > In your code if more connections and statements are created?. If so, > closed those connections? > After use close unused connections and statements. > > > Hope It Helps, > Chinna > > > On Tue, Apr 29, 2014 at 3:47 PM, Dima Fadeyev <[email protected]>wrote: > >> Hello everyone, >> >> When I run a jdbc example from >> https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBCClientSampleCodeagainst >> my hive server, the number of hive-server2 threads increments. If I >> execute it long enough I either start seeing exceptions >> >> Exception in thread "main" java.sql.SQLException: >> org.apache.thrift.TApplicationException: Internal error processing >> ExecuteStatement >> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:203) >> at HiveJdbcClient.main(HiveJdbcClient.java:24) >> Caused by: org.apache.thrift.TApplicationException: Internal error >> processing ExecuteStatement >> at >> org.apache.thrift.TApplicationException.read(TApplicationException.java:108) >> at >> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71) >> at >> org.apache.hive.service.cli.thrift.TCLIService$Client.recv_ExecuteStatement(TCLIService.java:213) >> at >> org.apache.hive.service.cli.thrift.TCLIService$Client.ExecuteStatement(TCLIService.java:200) >> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:197) >> ... 1 more >> >> or I bump into a limit of connections with Zookeeper (each hive-server2 >> thread maintains a connection with Zookeeper. I have hive.support.concurrency >> enabled). >> >> In either case I can't connect to hive server after that. >> >> I've tried this on hive 0.10 (cdh 4.4) and hive 0.12 (cdh 5.0 and hdp >> 2.0.6) with same results. >> >> Please, could anyone help me resolve this. >> Thanks in advance. >> >> >> > > > -- > Hope It Helps, > Chinna > > > -- Regards Shengjun
