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.

  1. Ensure that your Cloudera Runtime is of 7.3.1.400 version or later. (Build number 7.3.1.p400. in Management Console > Environments > ***YOUR-ENVIORNMENT*** > Data Lake)

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

    To find the IDBroker Host, go to Management Console > Environments > ***YOUR-ENVIRONMENT*** > Data lake > Nodes, and copy the hostname (FQDN) for the 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. 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 declaring the Knox topologies.