On this page

    Connecting Apache Hive to Arctic preview

    To connect Apache Hive to Arctic, use the configuration instructions provided in Project Nessie for Hive via Iceberg and edit the following information:

    • The full url of the Nessie API Endpoint to Nessie: Replace the example URL in the configuration with the Nessie API Endpoint.
    • The authentication type: Set the Nessie authentication type to BEARER.
    • The authentication token: Provide the personal access token you generated in your Dremio Cloud organization. If you have not created a personal access token, see Personal Access Tokens for information about how Dremio Cloud uses these tokens and how to generate one.

    Replace the following properties in the Project Nessie configuration example:

    • Replace <catalog_name> with a unique value that is valid in Apache Hive (for example, nessie).

    note:

    Project Nessie uses the example catalog name of nessie.

    • Replace <project-id> with the Project ID of the Arctic project.
      For example: 06eg3b55-cc99-4c96-9acb-6f0ce010a81e

    To obtain the Arctic project ID:

    1. Sign in to Dremio Cloud.

    2. From the side navigation bar, select an Arctic project.

    3. Select the Settings (gear) icon.

    4. From the General Information tab, copy the Project ID and replace 〈project-id〉.

    • Replace <personal-access-token> with your personal access token. See Creating a Token to learn how to generate one.
      For example: RDViJJHrS/u+JAwrzQVV2+kAuLxiNkbTgdWQKQhAUS72o2BMKuRWDnjuPEjACw==

      # Full url of the Nessie API endpoint to Nessie
      SET iceberg.catalog.<catalog_name>.uri=https://nessie.dremio.cloud/v1/projects/<project-id>;
        
      # Nessie authentication type and token, which are needed to access your Dremio Cloud project
      SET iceberg.catalog.<catalog_name>.authentication.type = "BEARER";
      SET iceberg.catalog.<catalog_name>.authentication.token = "<personal-access-token>";
      

    Create and Read Tables in Apache Hive

    To create tables in Apache Hive, see Create tables in the Project Nessie website.

    To write and read tables in Apache Hive, see Writing and reading tables in the Project Nessie website.

    To learn more about the available Data Definition Language (DDL) commands in Apache Hive and the SQL queries you can run, see DDL commands in the Apache Iceberg documentation.