Connect Hadoop (Hive) to the Knowledge Base

With the Hadoop (Hive) connector, you can connect Hadoop (Hive) to the Knowledge Base.

What you need

• The host, port (default 10000), and database.
• A login method: LDAP (username and password), Kerberos, None, or No SASL.
• A username and password, only for LDAP.
• For Kerberos, extra setup on the server side.

Login methods

Login method	What you provide
LDAP	A username and password.
Kerberos	No username or password. Requires extra setup on the server side.
None	No credentials.
No SASL	No credentials.

Connecting to Hadoop (Hive)

1. Open Project Settings

   In your EKB project, navigate to Settings in the sidebar.

2. Go to Connections

   Select the Connections tab and find the Hadoop (Hive) tile under Databases.

3. Open the Hadoop (Hive) popup

   Click the Hadoop (Hive) tile. A popup appears with the option to connect Hadoop (Hive). Click + Add Connection.

4. Fill in the connection form

   Enter the following details:

   Server

   Field	Required	Description
   Connection Name	Yes	A display name for this connection (e.g. My Hive Connection).
   Host	Yes	The hostname of your Hive server (e.g. hive.example.com).
   Port	Yes	The port your Hive server is listening on. Default is 10000.
   Database	Yes	The name of the database to connect to.

   Authentication

   Field	Description
   Auth Mechanism	The login method: LDAP, Kerberos, None, or No SASL.
   Username	Required only for LDAP.
   Password	Required only for LDAP.
   Kerberos Service Name	Used only for Kerberos. Default is hive.

   Connection type

   Field	Description
   Thrift Transport	SASL (default) or HTTP.
   Use SSL (TLS)	Turn on SSL. This works only with the HTTP transport.
   TLS Certificate Verification	Requires Use SSL (TLS). Choose to trust the server certificate (default), verify the certificate and hostname, or verify the certificate and skip the hostname check.

5. Save the connection

   Click Save. EKB will authenticate using the details provided. If successful, the Hadoop (Hive) tile on the Connections page will display a green dot and a count of your active Hadoop connections.

✓You're now ready to use your Hadoop (Hive) data in the Knowledge Base!

Related

• Connections