Apache Hive
Apache Hive
Setup Guide
Follow these steps to connect Apache Hive to your CData Connect account:
-
Open the Connections page of the CData Connect dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Apache Hive into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Enter the Transport Mode to use for communicating with the Hive server: HTTP or BINARY.
-
For HTTP transport mode only, enter the HTTP Path, available in the ‘hive.server2.thrift.http.path’ property of your Hive configuration file (hive.site.xml).
-
Select an Auth Scheme for use in connecting to Apache Hive. Select the option that matches the configuration of the HiveServer2. Follow the relevant instructions below.
Authentication Methods
Plain
-
Enter the following information:
-
User—the Apache Hive username for authentication.
-
Password—the user password.
-
Port—the port for connecting to the Apache Hive server. If using HTTP transport mode, set Port to the value in the ‘hive.server2.thrift.http.port’ property of the Hive configuration file (hive.site.xml).
-
Server—the host name or IP address of the server hosting HiveServer2.
-
Database—(optional) the Apache Hive database to use. If left empty, the connection uses the default Apache Hive database.
-
-
At the top of the CData Connect Add Apache Hive Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
-
In Apache Hive, add the CData Connect static IP addresses to your connection whitelist.
LDAP
-
Enter the following information:
-
User—the Apache Hive username for authentication.
-
Password—the user password.
-
Port—the port for connecting to the Apache Hive server. If using HTTP transport mode, set Port to the value in the ‘hive.server2.thrift.http.port’ property of the Hive configuration file (hive.site.xml).
-
Server—the host name or IP address of the server hosting HiveServer2.
-
Database—(optional) the Apache Hive database to use. If left empty, the connection uses the default Apache Hive database.
-
-
At the top of the CData Connect Add Apache Hive Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
-
In Apache Hive, add the CData Connect static IP addresses to your connection whitelist.
More Information
For more information about interactions between CData Connect and Apache Hive, see this information page.