Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> can hive handle concurrent JDBC statements?


Copy link to this message
-
can hive handle concurrent JDBC statements?
Hi All,
I am writing a java program to run concurrent JDBC statements. But it
failed with:
org.apache.thrift.TApplicationException: execute failed: out of sequence
response
The steps are:
1. open a connection to "jdbc:derby://hiveHost:port/commonDb"
2. run select statement at the same time:
    String sql = "select * from " + tableName;
    ResultSet rs1 = stmt.executeQuery(sql);
    ResultSet rs2 = stmt.executeQuery(sql);
while(rs1.next() & rs2.next())
{
String s1 = rs1.getString(1);
String s2 = rs2.getString(1);
System.out.println(s1+" | "+s2);
}
My question is can hive handle concurrent JDBC statements?

Thanks,
- Bing
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB