Skip to content
Apache Hive › Community connectors › Zero Copy Connectors › Workflow Data Fabric
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Create an Apache Hive connection

Establish a zero copy connection to an Apache Hive data warehouse in Zero Copy Connector Hub.

Before you begin

Role required: df_connection_admin

About this task

Work with your data source admin to create a connection to Apache Hive. For additional information about connecting, refer to the Hive connector documentation.

Note: This connector was developed by the open-source community and made available through the ServiceNow AI Platform for general use. Functionality can vary and might not cover all use cases supported by primary connectors.

Procedure

  1. Navigate to the available community connectors in Zero Copy Connector Hub in one of the following ways:

    • Navigate to All > Zero Copy Connector Hub > Available connectors > Community connectors.
    • Navigate to Admin > Zero Copy Connector Hub > Available connectors > Community connectors.
    • Find the Apache Hive connector and select Connect.

  2. On the form, fill in the fields.

    FieldDescription
    Name and description
    Connection labelUnique name for this connection. This helps in identifying the connection within your system.
    Connection nameSystem-generated name based on the Connection label. This field cannot be modified once the connection is established.
    Short descriptionDescription of the connection explaining what it is about.
    Object storage authentication
    Object storage systemStorage system used. Default is Amazon S3.
    AWS access keyAccess key used to access S3.
    AWS secret keySecret key used to access S3.
    AWS regionAWS region where your S3 bucket is located.

  3. Configure the metastore that you want to use with Apache Hive.

OptionDescription
Hive Thrift
  1. Attach the truststore file using one of the following options:
  2. Upload the truststore file by selecting Attach TrustStore file and selecting the file.
  3. Copy and paste the contents of the truststore file.
  4. Enter the truststore password.
  5. Enter the metastore URI that you want to connect to using the Thrift protocol. For example:

thrift://<host>:<port>

AWS Glue1. Enter the AWS access key to connect to the Glue Catalog. 2. Enter the AWS secret key to use to connect to the Glue Catalog. 3. Enter the AWS region of the Glue Catalog.
  1. Select Connect.

Result

A test connection is made to the external data source, verifying that the connection details are correct and the data source is accessible.

What to do next

If the connection succeeds, configure data steward access on the Access Control tab. See Manage access to an established connection using roles.

If the connection fails, verify the connection details with your data source administrator and try again.