Aihua Xu created HIVE-17353:
-------------------------------
Summary: The ResultSets are not accessible if running multiple
queries within the same HiveStatement
Key: HIVE-17353
URL: https://issues.apache.org/jira/browse/HIVE-17353
Project: Hive
Issue Type: Bug
Components: JDBC
Affects Versions: 3.0.0
Reporter: Aihua Xu
Assignee: Aihua Xu
The following queries would fail,
{noformat}
ResultSet rs1 =
stmt.executeQuery("select * from testMultipleResultSets1");
ResultSet rs2 =
stmt.executeQuery("select * from testMultipleResultSets2");
rs1.next();
rs2.next();
{noformat}
with the exception:
{noformat}
[HiveServer2-Handler-Pool: Thread-208]: Error fetching results:
org.apache.hive.service.cli.HiveSQLException: Invalid OperationHandle:
OperationHandle [opType=EXECUTE_STATEMENT,
getHandleIdentifier()=8a1c4fe5-e80b-4d9a-b673-78d92b3baaa8]
at
org.apache.hive.service.cli.operation.OperationManager.getOperation(OperationManager.java:177)
at
org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:462)
at
org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:691)
at
org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1553)
at
org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1538)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
at
org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
