Creating an HCatalog Connection

You can create an HCatalog Connection shared resource if you want to build a connection between the plug-in and HCatalog.

Prerequisites

The HCatalog Connection shared resource is available at the Resources level. Ensure that you have created a project, as described in Creating a Project.

Procedure

  1. Expand the created project in the Project Explorer view.
  2. Right-click the Resources folder and click New > HCatalog Connection.
  3. The resource folder, package name, and resource name of the shared resource are provided by default. You can change these default configurations accordingly. Click Finish to open the HCatalog Connection shared resource editor.
  4. In the HCatalog Url field, specify the WebHCat URL used to connect to HCatalog.
  5. In the User Name field, specify the unique user name used to connect to HCatalog.
  6. Next to the HDFS Connection field, click to select an HDFS connection.
  7. Click Test Connection to validate the connection.
  8. Optional: If you want to connect to a Kerberized WebHCat server, select the Enable Kerberos check box, and then set up a connection to the Kerberized WebHCat server.
    Note: If your server uses the AES-256 encryption, you must install Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files on your machine. For more details, see Installing JCE Policy Files.
    1. From the Kerberos Method list, select a Kerberos authentication method:
      • Keytab: specify a keytab file to authorize access to WebHCat.
      • Cached: use the cached credentials to authorize access to WebHCat.
      • Password: specify a password for the Kerberos principal.
    2. In the Kerberos Principal field, specify the Kerberos principal name used to connect to WebHCat.
    3. If you select Keytab as the authentication method, specify the keytab used to connect to WebHCat in the Kerberos Keytab field.
    4. Click Test Connection to validate the connection.

What to do next

After an HCatalog connection is established, you can click the Database and Table tab to introspect databases and tables existing in HCatalog. See Database and Table for more information.