Set up Amazon RDS as a Hive metastore
In CDP Data Center, you can set up RDS as a Hive metastore using MySQL as a backend database. Other clusters that want to use the metastore do so without setting up a backend database.
- Follow instructions in Amazon documentation to create a MySQL instance with Amazon RDS.
- Set up MySQL as a backend database for Hive metastore using the hostname, username, and password configured during your RDS setup.
- Configure Hive, Impala, and Spark to use Amazon S3.