Hive can be configured to provide User Authentication, which ensures that only authorized users can communicate with Hive.  Hackolade provides support for basic authentication.  It is planned to provide support for LDAP, Kerberos and SASL, but these protocols are not yet available at this time.


The Hackolade connection settings must match the configuration of the hive-site.xml for the HiveServer2 setup.


1) Transport mode

In the options tab, choose the transport mode, either binary (default) or http


<property>

<name>hive.server2.transport.mode</name>

<value>MODE</value>

</property> 




If the chosen transport mode is http, then the HTTP path must be specified:

<property>

<name>hive.server2.thrift.http.path</name>

<value>hive2</value>

</property>


2) Host name and port number

In the connection tab, first give a friendly name to the connection settings.  This name is only used in Hackolade to help manage multiple connections.



Set the host name of the machine the Hive is running (e.g. localhost, 0.0.0.0, hive.example.com etc.)  corresponding to:

<property>

<name>hive.server2.thrift.bind.host</name>

<value>hive.example.com</value>

</property>


The port number must correspond to the port number in

<property>

<name>hive.server2.thrift.port</name>

<value>10001</value>

</property>


if in binary transport mode, or to the port number in

<property>

<name>hive.server2.thrift.http.port</name>

<value>10001</value>

</property>

if in http transport mode.

3) Authentication

Currently hackolade only support NOSASL authentication.  The protocols Plain SASL, LDAP, and Kerberos will be introduced at a later time.


<property>

<name>hive.server2.authentication</name>

<value>nosasl</value>

</property>