Cloudera Docs

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.

Make sure you have the IDBroker Host name before starting the steps.

To find the IDBroker Host, go to Cloudera Manager > Knox > Instances, and copy the hostname for the Role named Knox IDBroker.

  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. Optional: 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. 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 declaring the Knox topologies.