Configuring Hive Metastore as a REST Catalog

To use the API endpoints provided by REST Catalog, you need to enable it in the Hive Metastore where it is deployed.

Ensure that your Cloudera Runtime is of 7.3.2 version or later in Management Console > Environments > ***YOUR-ENVIRONMENT*** > Data Lake)

  1. Log in to Cloudera Manager and click Clusters > Hive Metastore > Configuration.
  2. Search for Enable REST Catalog Service and enable it to set up the REST Catalog Service in Hive Metastore.
  3. If you use Cloudera Data Sharing with AWS Elastic MapReduce and AWS Athena notebook, add the region of AWS environment to the Hive Metastore configuration.
    1. Check your region in Cloudera Management Console > Environments > [***YOUR_ENVIRONMENT***] > Environment Details.
    2. If your region is different than the default us-west-2, go to Cloudera Manager > Clusters > Hive Metastore > Configuration > Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml .
    3. Add a property with your region.

      <property><name>client.region</name><value>[***CLIENT_REGION_NAME***]</value></property>

  4. Save the changes and restart the Hive Metastore service.

Continue with Editing the Knox topologies.