Support Questions

Find answers, ask questions, and share your expertise

Hive error: H110 Unable to submit statement. Invalid SessionHandle: SessionHandle [a2828a8d-b961-4c20-968e-ff1d52e6fb86] [ERROR_STATUS]

avatar
Rising Star

Hi,

Is this error a common one or specific to a user. I am getting this since morning. Could you please resolve this. Thank you.

1 ACCEPTED SOLUTION

avatar

Have you tried restarting ambari-server (command line as root: "ambari-server restart"). This the JVM where I think the Hive views runs in ...

View solution in original post

10 REPLIES 10

avatar

Set the environment variable HIVE_SERVER to your hive server machine, or use

beeline -u jdbc:hive2://this.is.my.hiveserver.name:10000/default?hive.execution.engine=tez -n hive