Create Hive Connections

Create Hive Connections

Toad allows you to connect to a Hive data warehouse system. Apache Hive is one of the NoSQL data sources supported by Toad.

See also, About Apache Hive Data Sources.

To create a Hive connection

1. Click on the Connections toolbar (ALT+F+N).
2. Select Apache Hive from the Group list.

3. Enter the connection information in the Create New Connection dialog. Review the following for additional information:

   Server tab
   Host	Enter the host name or IP address of the Hive data source.
   Port	Enter the port number.
   Schema	Enter a Hive schema to open upon connection. (HiveServer2 only) After connecting, you can select a different available schema in the Object Explorer.
   Server type	Select the version of HiveServer the host uses, HiveServer1 or HiveServer2.
   Use SSL	(HiveServer2 only) Select to use SSL to connect to Hive.
   HTTP mode	(HiveServer2 only) Select to connect to HiveServer2 running in HTTP mode. Then enter the service endpoint. The default is cliservice.
   Session Initialization	(HiveServer1 only) Enter any Hive session initialization commands. These commands will be executed once, at the start of each connection.
   Category	(Optional) Select an existing category or create a new one. Set Connection Categories
   Authentication tab (HiveServer1)
   Connect with SSH	Select to use SSH to connect to Hive. Then enter a user name and select an authentication method (key file or password).
   SSH user	Enter the user name to log in when using SSH.
   SSH port	Select the SSH port number. The default is 22.
   Authenticate with a key file	Select if the host uses a key file to authenticate the SSH user field. Private key path—Enter the absolute path (including file name) to the private key file on the host (not the client). Pass phrase—Enter your passphrase.
   Authenticate with a password	Select if the host uses a password to authenticate the SSH user field. Password—Enter the password to log in using SSH.
   Authentication tab (HiveServer2)
   Authentication	Select an authentication method. To enter only a user name, select the Username and password method.
   Username	Enter the user name to use for this connection. If using Kerberos authentication, enter your user name in the following format: user@REALM or domain\user.
   Hive host realm	(Kerberos only) Enter the Kerberos realm of the HiveServer2 host. Note: If necessary, contact your IT department to obtain this information. Before you can successfully connect to Hive using Kerberos authentication, the Toad client computer must have a Kerberos Key Distribution Center (KDC) address entry for the Hive host realm. To define the KDC entry, use the following procedure. Open a Windows Command Prompt as Administrator and enter the following command: ksetup /addkdc <REALM> <KDC name> You only need to run this command once for the given realm. To confirm the setting, enter the following command: ksetup. This command should return both the name of the Hive host realm and the KDC name you specified.
   Hive host FQDN	(Kerberos only) Enter the fully-qualified domain name (FQDN) of the HiveServer2 host. Note: If necessary, contact your IT department to obtain this information.
   Service name	(Kerberos only) Enter the service name of the Hive server. The default is hive.
   Note: In NoSQL and Business Intelligence connections, Toad automatically saves the password in the connections.xml file as obfuscated text, as well as in Toad. To add additional password security, use Toad's Master Password feature. Security Options

4. Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.

5. Upon creating an initial connection, Toad automatically maps the data source objects. This process runs in the background, and until it is finished, you may experience a delay when attempting to access these objects.

Tips: 

• Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.
• You can specify a proxy server to use for Business Intelligence and NoSQL connections at Tools | Options | Database | Data Services.

Related Topics

About Apache Hive Data Sources