Skip to main content

Apache Hive 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 Arctic catalog 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:

  • Set the location of the Nessie server using the iceberg.catalog.nessie.uri variable with the Arctic catalog API Endpoint.
    For example: https://nessie.dremio.cloud/v1/repositories/80d313e4-fa73-4252-a757-e50174f86000

To obtain the Arctic catalog API Endpoint:

  1. Sign in to Dremio Cloud.

  2. Click the Organization This is the icon that represents the Organization settings. icon in the side navigation bar.

  3. On the Organization page, select the option to see the Arctic Catalogs.

  4. On the Arctic Catalogs (Preview) page, hover over the Arctic Catalog and click the Catalog Settings This is the icon that represents the Catalog settings. icon that appears next to Arctic Catalog.

  5. Under General Information in the sidebar, copy the Catalog Endpoint.

  • Replace <arctic-catalog-api-endpoint> with the actual Catalog Endpoint that you copied earlier.

  • 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==


Hive Configuration
# Full url of the Nessie API endpoint to Nessie
SET iceberg.catalog.nessie.uri=<arctic-catalog-api-endpoint>;

# Nessie authentication type and token, which are needed to access your Dremio Cloud project
SET iceberg.catalog.nessie.authentication.type = "BEARER";
SET iceberg.catalog.nessie.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.