# Connect to a Hive Metastore

1. To connect to a Hive catalog, open your workspace and click on the button in the sidebar.
2. Click ***Create Catalog***
3. Start by giving your catalog a name and pick ***Hive*** as the metastore type**.**
4. Select the **cloud resource** if you have created a serverless workspace. 
5. To set up the connection, provide:
   1. Hive IP address/Domain Name
   2. Hive Port
   3. When asked whether the Hive metastore and S3 data source exist in the same AWS Account as the e6data workspace:
      1. If yes, select **Yes** and proceed to step 6.
      2. If not, select **No** and configure cross-account access (coming soon), provide the requested details of the target catalog, and proceed to step 6.
   4. If the Hive catalog is hosted on a public IP, you will be asked to acknowledge that the security risks involved.
6. Once ready, Click ***Validate***.
7. Next, choose the databases/schemas you want to run the queries on from your metastore. This selection can be changed later.
8. To enable automatic catalog updates, toggle on the auto-refresh option and set the desired time interval for catalog updates. Remember, you can always adjust this selection and interval later.
9. If you do not require auto-refresh for your catalog, you can proceed to the next step.
10. If all the settings are correct, click on ***Create***.
11. You will be redirected to your catalog listing screen. Successful creation will change your catalog status from **PENDING** to <mark style="color:green;">**ACTIVE.**</mark>
    * In case the catalog has not been created there will be an error that you can see on hovering over the status bar. We have listed the errors that you can encounter while creating a catalog on the [catalog errors.](/product-documentation/error-codes/catalog-errors.md)

<figure><img src="/files/dm63T6jhtlluEfT3woSX" alt="" width="563"><figcaption><p>Hive Catalog in Cloud Prem Workspace</p></figcaption></figure>

<figure><img src="/files/gj6qALWmg8ka3wuBpOvb" alt=""><figcaption><p>Hive Catalog in Serverless Workspace</p></figcaption></figure>

{% hint style="info" %}
After creating a serverless workspace, please provision the necessary cloud resources to configure the catalog.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.e6data.com/product-documentation/catalogs/create-catalogs/hive-metastore/connect-to-a-hive-metastore.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.