Ambari Hive view cannot connect when using http transport mode

[#1]

I’m using Sandbox 2.3.2 I have configured Hive with hive.server2.transport.mode=http (because of Knox integration). However, the Hive view in Ambari does not seem to like that. When I leave it at the default out of the box settings (port 10000), I get a connection refused, as expected. But when I change the port to 10001, which is the value of hive.server2.thrift.http.port, I get the following:

ERROR [qtp-client-1901] ServiceFormattedException:96 - org.apache.ambari.view.hive.client.HiveClientException: H020 Could not establish connecton to sandbox.hortonworks.com:10001: org.apache.thrift.transport.TTransportException: org.apache.thrift.transport.TTransportException

The UI doesn’t give me a way to define the JDBC URL myself, so I can’t set the proper transport mode. So I’m stuck, at least until Hive can support both modes simultaneously (HIVE-5312). If I can, I'd like to avoid setting up a second Hive instance just so that I can get the view working.

Any help would be appreciated.

[#2 · Accepted solution]

See JIRA here: https://issues.apache.org/jira/browse/AMBARI-13343. This is fixed in Ambari 2.2.0. Until then, you may also want to try the patch provided in the JIRA.

[#3]

@Nikolay Kanov pls do let us know if you do end up trying the patch (you can add a comment similar to this one instead of adding a new answer)

[#4]

Will definitely post the result if I end up trying the patch. Thanks for your answer!