Session handle was closed unexpectedly

[lu...@china-inv.cn]

Hi, All,

We are using Hive 1.1.0 on CDH 5.12 and I'm new to Hive.

Our client app imports data from Oracle DB to Hive.

The logic is like this:
   get a connection to hive then
   execute some SQL statement  //the error occurs here

After importing several tables successfully, we got following error thrown 
by Hiveserver2:

Caused by: org.apache.hive.service.cli.HiveSQLException: Invalid 
SessionHandle: SessionHandle [26eaeddc-ce90-4c6f-8a67-a6a886a7defe]
        at org.apache.hive.service.cli.session.SessionManager.getSession(
SessionManager.java:432)
        at 
org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:282)
        at 
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:501)
        at 
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)
        at 
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)
        at 
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
        at 
org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
        at 
org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor.process(HadoopThriftAuthBridge.java:746)
        at 
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
        at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)

It looks like the session was closed by the Hive server, but I don't find 
any related log in the Hive log files. (the log level is set to 'DEBUG')

I know the Hive server will close the expired session, but I didn't see 
the related log.

Is there any other cases that the session handler will be closed (i.e. The 
SessionMananger.closeSession() is called)?

and does anyone know how to debug this issue?

Thanks 

Boying


 
本邮件内容包含保密信息。如阁下并非拟发送的收件人，请您不要阅读、保存、对外
披露或复制本邮件的任何内容，或者打开本邮件的任何附件。请即回复邮件告知发件
人，并立刻将该邮件及其附件从您的电脑系统中全部删除，不胜感激。

 
This email message may contain confidential and/or privileged information. 
If you are not the intended recipient, please do not read, save, forward, 
disclose or copy the contents of this email or open any file attached to 
this email. We will be grateful if you could advise the sender immediately 
by replying this email, and delete this email and any attachment or links 
to this email completely and immediately from your computer system.