hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Will Chen (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-15100) HiveSQLException: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier
Date Tue, 01 Nov 2016 06:56:58 GMT

     [ 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)

Mime
View raw message