question HDP 2.3 on AWS H060 Unable to open Hive session in Archives of Support Questions (Read Only)

HDP 2.3 on AWS H060 Unable to open Hive session

charles1 — Tue, 22 Mar 2016 20:57:56 GMT

I've built an HDP 2.3 cluster on AWS, and using Ambari I created a view for Hive, and granted the Ambari admin login permission to that view. However, when logged in as the Ambari admin account, whenever I attempt to access that view this error message is thrown:

H060 Unable to open Hive session: org.apache.thrift.protocol.TProtocolException: Required field 'serverProtocolVersion' is unset!

in the HDFS advance configuration, custom core-site section, these properties have been set:

hadoop.proxyuser.root.hosts=*

hadoop.proxyuser.root.groups=*

hadoop.proxyuser.ec2-user.hosts=*

hadoop.proxyuser.ec2-user.groups=*

Any recommendations to remedy this error are welcome.

Re: HDP 2.3 on AWS H060 Unable to open Hive session

sunile_manjee — Tue, 22 Mar 2016 23:01:55 GMT

Please look at HCC post https://community.hortonworks.com/questions/13820/ambari-hive-view-problem.htm

which is similar to issue you are expereiencing.

Re: HDP 2.3 on AWS H060 Unable to open Hive session

charles1 — Wed, 23 Mar 2016 02:05:52 GMT

@smanjee

Thanks for your recommendation, unfortunately, when browsing to that URL the 'page not found' error is remitted

Re: HDP 2.3 on AWS H060 Unable to open Hive session

charles1 — Fri, 25 Mar 2016 02:54:55 GMT

The root cause of the problem has been remedied. Please consider this matter closed.