You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Will Chen (JIRA)" <ji...@apache.org> on 2016/11/01 06:56:58 UTC
[jira] [Updated] (HIVE-15100) HiveSQLException: Invalid
OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT,
getHandleIdentifier
[ https://issues.apache.org/jira/browse/HIVE-15100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Will Chen updated HIVE-15100:
-----------------------------
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.
was:
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:
I add a few session related configurations:
And my operations log config like this:
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.
> HiveSQLException: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier
> ---------------------------------------------------------------------------------------------------------
>
> Key: HIVE-15100
> URL: https://issues.apache.org/jira/browse/HIVE-15100
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Affects Versions: 1.2.1
> Reporter: Will Chen
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)