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.

  1. Follow instructions in Amazon documentation to create a MySQL instance with Amazon RDS.
  2. Set up MySQL as a backend database for Hive metastore using the hostname, username, and password configured during your RDS setup.
  3. Configure Hive, Impala, and Spark to use Amazon S3.