Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-15100

HiveSQLException: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.1
    • Fix Version/s: None
    • Component/s: HiveServer2
    • Labels:
      None

      Description

      I am using hue + hiveserver2.
      First I execute sql through Hue, this can be done correctly. But when I export the result as csv file or excel file, an exception will appear in hiveserver2.log:

      2016-11-01 14:54:11,622 WARN [HiveServer2-Handler-Pool: Thread-47]: thrift.ThriftCLIService (ThriftCLIService.java:FetchResults(681)) - Error fetching results:
      org.apache.hive.service.cli.HiveSQLException: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=feb55386-72f0-445c-9774-dd8780acf442]
      at org.apache.hive.service.cli.operation.OperationManager.getOperation(OperationManager.java:154)
      at org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:456)
      at org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:672)
      at org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1557)
      at org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1542)
      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:285)
      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:745)

      I add a few session related configurations:

      hive.server2.idle.operatoin.timeout = 1 day
      hive.server2.idle.session.timeout = 3 days
      hive.server2.session.check.interval = 1 hour

      And my operations log config like this:

      hive.server2.loggging.operation.enabled=true
      hive.server2.loggging.operation.log.location=/tmp/hive/operation_logs

      I try to remove all files in my operation_logs dir(/tmp/hive/operation_logs), and clean all session data in hue tables(beeswax_session, django_session), then restart hiveserver2 and hue. But nothing getting better..

      Begging for ur help~

      Thanks.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              WillCup Will Chen
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated: