Hive Connection

This topic describes how to authenticate to Hive and configure any necessary connection properties in the Hive connection connector.

Connection Configuration #

Each connection property available in the Hive connector is explained below.

Connection Name #

The name of the connection to be created should be provided. This is the name that will display on the list of available connections.

Scope #

Define the connection scope to customize their accessibility.

• Organization: Accessible to organization users across all Gathr projects for usage in applications.

• Project: Accessible to organization users limited to projects that are specified by the connection owner for usage in applications.

• Private: Accessible only to the connection owner for usage in applications.

Connection Type #

Select if the connection is SSL enabled or not.

If SSL is enabled, provide the following details:

• SSH Key: Provide the SSH key file path.

• SSH Host: Provide the SSH host.

• SSH User: Provide the SSH user.

MetaStore URI #

Thrift URI to connect to HIVE Metastore service.

Warehose Directory #

Path of warehouse Directory located on HDFS file System.

Hive Server2 URL #

Connection URL for the HiveServer2.

Example: jdbc:hive2://hostname:port.

HiveServer2 Password #

Password for HiveServer2 JDBC connection. If there is no password, leave it blank.

FileSystem URI #

HDFS File System URI

UserName #

HDFS Username authorized to access the services.

HA Enabled #

Check this option, if Name Node of HDFS is HA enabled and provide the below details:

• Name Node1 Name

• Name Node1 RPC Address

• Name Node2 Name

• Name Node2 RPC Address

• Name Services

Kerberos Enabled #

Check this option, if Kerberos is enabled.

KeyTab Select Option #

Select the option to specify the KeyTab file path or upload the KeyTab file.

• Specify KeyTab File Path: Provide the path to the KeyTab file.

• Upload KeyTab File: Upload the KeyTab file.

KeyTab File Path #

Provide the path to the KeyTab file.

Upload KeyTab File #

Upload the KeyTab file.

Table Administration #

Enable this if you want to create table in Hive.

Click on the Create button to create the connection.

After entering all the details, click on the TEST button.

If the connection service identification and authentication details are provided correctly, a success message stating “connection available” is generated.

Click on the CREATE button to save the changes.

If the details are incorrect or the server is down, you will get a message “Connection unavailable”.