question Ambari Hive view cannot connect when using http transport mode in Archives of Support Questions (Read Only)

Ambari Hive view cannot connect when using http transport mode

nkanov — Fri, 16 Sep 2022 09:52:05 GMT

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.

Re: Ambari Hive view cannot connect when using http transport mode

abajwa — Wed, 09 Dec 2015 15:54:45 GMT

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.

Re: Ambari Hive view cannot connect when using http transport mode

abajwa — Wed, 09 Dec 2015 22:46:36 GMT

@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)

Re: Ambari Hive view cannot connect when using http transport mode

nkanov — Wed, 09 Dec 2015 22:49:52 GMT

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