Apache Hive
An overview of the Hive integration with Secoda
Last updated
An overview of the Hive integration with Secoda
Last updated
There are two main ways of integration Apache Hive to Secoda.
Direct connection to Apache Hive
Using MySQL metastore
1. Create Role for Secoda
To ensure controlled access, we'll begin by creating a dedicated role for Secoda in Hive:
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:
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 to the list of allowed IPs.
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 to the list of allowed IPs on your MySQL server.