Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

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