Created 02-21-2016 09:43 PM
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.
Created 02-21-2016 10:43 PM
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
Created 02-21-2016 09:50 PM
If you have ambari you can add the properties via: services->HDFS->configs->advanced->custom core-site
Add the below properties
hadoop.proxyuser.hive.hosts=* hadoop.proxyuser.hive.groups=*
Than restart all the affected the services.
Created 02-21-2016 10:30 PM
I already have these property added. Let me give you the brief This were running fine until i restarted my aws server and its dns chnaged and I see these errors.
Write now I am getting below errors :
org.apache.ambari.view.hive.client.HiveClientException: H060 Unable to open Hive session: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
Created 02-21-2016 09:51 PM
Restart hive service
Created 02-21-2016 10:43 PM
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
Created 02-21-2016 10:53 PM
Thank you very much for your help.. It is working now..
Will you be able to answer my question? you mentioned to add property hadoop.proxyuser.hive.hosts=* but hontor document says to add hadoop.proxyuser.root.hosts=* I have added both but not sure why and which one is working.
Created 02-22-2016 07:06 AM
Good question.. Not sure how is it related to protocol version ! at least the error message is definitely wrong. This is the only workaround I got.
The issue is related to restrict access to the Hive metastore service by allowing it to impersonate only a subset of Kerberos users. This can be done by setting the hadoop.proxyuser.hive.groups property in core-site.xml on the Hive metastore host.
The issue has something to do with org.apache.thrift.protocol client_protocol, My reasoning was to give the hive user a wildcard privilege like the root.There is a jira out there as I see it resolved your problem then you can accept it as an answer cheers!
Created 02-22-2016 07:33 AM
Created 02-24-2016 06:09 AM
Is this problem still persistent ? If my proposed solution resolved your issue then could you accept my answer !
Created 05-09-2016 01:40 AM
Hello all,
I am having a similar issue here. Everything was working fine on HIVE until I have installed HBase and Ambari Metrics services. I performed pretty much all the changes proposed on this post and the documentation and still getting the error below:
Any ideias here appreciated!
H060 Unable to open Hive session: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
org.apache.ambari.view.hive.client.HiveClientException: H060 Unable to open Hive session: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out org.apache.ambari.view.hive.client.HiveClientException: H060 Unable to open Hive session: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out at org.apache.ambari.view.hive.client.Connection$2.body(Connection.java:488) at org.apache.ambari.view.hive.client.Connection$2.body(Connection.java:475) at org.apache.ambari.view.hive.client.HiveCall.call(HiveCall.java:101) at org.apache.ambari.view.hive.client.Connection.openSession(Connection.java:475) at org.apache.ambari.view.hive.client.Connection.getOrCreateSessionByTag(Connection.java:523) at org.apache.ambari.view.hive.resources.browser.HiveBrowserService.databases(HiveBrowserService.java:87) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497)
Created 01-27-2017 02:11 PM
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/2.5.0.0-1245/0/hive-log4j.properties Exception in thread "main" java.lang.RuntimeException: java.lang.IllegalArgumentException: java.net.UnknownHostException: sandbox at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:523) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:680) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:624) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:233) at org.apache.hadoop.util.RunJar.main(RunJar.java:148) Caused by: java.lang.IllegalArgumentException: java.net.UnknownHostException: sandbox at org.apache.hadoop.security.SecurityUtil.buildTokenService(SecurityUtil.java:411) at org.apache.hadoop.hdfs.NameNodeProxies.createNonHAProxy(NameNodeProxies.java:311) at org.apache.hadoop.hdfs.NameNodeProxies.createProxy(NameNodeProxies.java:176) at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:688) at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:629) at org.apache.hadoop.hdfs.DistributedFileSystem.initialize(DistributedFileSystem.java:159) at org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:2761) at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:99) at org.apache.hadoop.fs.FileSystem$Cache.getInternal(FileSystem.java:2795) at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:2777) at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:386) at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:179) at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:506) ... 8 more Caused by: java.net.UnknownHostException: sandbox ... 21 more
Thanks