Support Questions

Find answers, ask questions, and share your expertise
Celebrating as our community reaches 100,000 members! Thank you!

HIVE error. -- H060 Unable to open Hive session

Rising Star

I had to restart my AWS server which caused it's public dns changed . so for opening the ambari-server I had to connect to new dns:8080 port, and I was able to connect easily. But when I am connecting to the hive view it is giving below error.

H060 Unable to open Hive session: org.apache.thrift.protocol.TProtocolException:Required field 'serverProtocolVersion'is unset!Struct:TOpenSessionResp(status:TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.


Master Mentor

@Amit Sharma

Gracefully stop all the services using Ambari.

Restart all the services using Ambari @times after reboot of the server you will need to manually start those service that wont be started by Ambari but subsequent Ambari startall /stopall will work correctly.

Keep me posted

View solution in original post



I can't able to open hive session. I get the following error when i tried to open hive session.

Restarted hive and ambari-server but no luck. please help me

hive Logging initialized using configuration in file:/etc/hive/ Exception in thread "main" java.lang.RuntimeException: java.lang.IllegalArgumentException: sandbox at org.apache.hadoop.hive.ql.session.SessionState.start( at at org.apache.hadoop.hive.cli.CliDriver.main( at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke( at sun.reflect.DelegatingMethodAccessorImpl.invoke( at java.lang.reflect.Method.invoke( at at org.apache.hadoop.util.RunJar.main( Caused by: java.lang.IllegalArgumentException: sandbox at at org.apache.hadoop.hdfs.NameNodeProxies.createNonHAProxy( at org.apache.hadoop.hdfs.NameNodeProxies.createProxy( at org.apache.hadoop.hdfs.DFSClient.<init>( at org.apache.hadoop.hdfs.DFSClient.<init>( at org.apache.hadoop.hdfs.DistributedFileSystem.initialize( at org.apache.hadoop.fs.FileSystem.createFileSystem( at org.apache.hadoop.fs.FileSystem.access$200( at org.apache.hadoop.fs.FileSystem$Cache.getInternal( at org.apache.hadoop.fs.FileSystem$Cache.get( at org.apache.hadoop.fs.FileSystem.get( at org.apache.hadoop.fs.FileSystem.get( at org.apache.hadoop.hive.ql.session.SessionState.start( ... 8 more Caused by: sandbox ... 21 more