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 <dfade...@pragsis.com
<mailto:dfade...@pragsis.com>> wrote:
Hello everyone,
When I run a jdbc example from
https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBCClientSampleCode
against 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