# Apache Hive

{% content-ref url="/pages/UQ3aB9lmwtQMpMxxnBgt" %}
[Apache Hive Metadata Extracted](/integrations/data-warehouses/apache-hive/metadata-extracted.md)
{% endcontent-ref %}

## **Getting Started with Apache Hive**

There are two main ways of integration Apache Hive to Secoda.

1. Direct connection to Apache Hive
2. Using MySQL metastore

### Direct Connection to Hive

**1. Create Role for Secoda**

To ensure controlled access, we'll begin by creating a dedicated role for Secoda in Hive:

```sql
-- Create a new role for Secoda
CREATE ROLE SECODA;

-- Grant read permissions on database
GRANT SELECT ON DATABASE <database_name>.* TO ROLE SECODA;
```

**2. Create User for Secoda**

Creating a user in Hive will depend on the underlying authentication and user management system in place (like LDAP, Kerberos, etc.). Typically, a Hive admin would create users outside of Hive. Once they exist, you can grant roles to them within Hive:

```sql
-- Grant the role to user
GRANT ROLE SECODA TO USER SECODA_USER;
```

**3. Connect Hive to Secoda**

To integrate Secoda with your Hive setup:

* In the Secoda App, select `Add Integration` on the Integrations page.
* Search for and select "Hive".
* Provide the necessary credentials:
  * `User`: The username (as created above).
  * `Password`: The password for the user.
  * `Host`: Hive Server2 host.
  * `Port`: This is usually 10000 but might vary based on your specific setup.

**4. Security: Whitelisting IPs**

The process of whitelisting IPs would be external to Hive. It typically occurs at the level of Hive Server2 or in the underlying infrastructure, such as firewalls or security groups if you're using a cloud platform. Ensure that you add the [Secoda IP address](/faq.md#what-are-the-ip-addresses-for-secoda) to the list of allowed IPs.

### MySQL Metastore Connection

**1. Connect Metastore to Secoda**

To integrate Secoda with your Hive setup:

* In the Secoda App, select `Add Integration` on the Integrations page.
* Search for and select "Hive".
* Provide the necessary credentials:
  * `User`: The username for your MySQL user
  * `Password`: The password for the user.
  * `Host`: MySQL server host.
  * `Port`: This is usually 3306 but could be different
  * `Database`: This is the database for your MySQL metastore
    * Please ensure the user has select access to this database

**2. Security: Whitelisting IPs**

Ensure that you add the [Secoda IP address](/faq.md#what-are-the-ip-addresses-for-secoda) to the list of allowed IPs on your MySQL server.


---

# 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.secoda.co/integrations/data-warehouses/apache-hive.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.