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)