Cloudera Docs

Configuring metastore location and HTTP mode

In addition to the database properties you need to set in Cloudera Private Cloud Base, you must configure the metastore URI property. This property defines one or more metastore locations.

  • The following components are running:
    • HiveServer
    • Hive Metastore
    • A database for the metastore, such as the default MySQL Server
    • Hive clients
  • Minimum Required Role: Configurator (also provided by Cluster Administrator, Full Administrator)
  1. In Clusters > Hive Metastore > Configuration, search for hive-site.xml.
  2. In the Hive Metastore Server Advanced Configuration Snippet (Safety Valve), which you use to change properties in hive-site.xml, click and add the hive.metastore.uris property using the following syntax: thrift://<n.n.n.n>:9083
    Substitute for <n.n.n.n> an IP address or fully qualified domain name (FQDN) of the metastore host.
    Only the Hive Metastore Server Default Group in hive-site.xml should define this property.
  3. Optional: If you choose to use a local/embedded metastore server, set the hive.metastore.uris to an empty value.
    Firstly, you add this property in the allowlist so that you can make changes. Go to Clusters > Hive on Tez > Configuration and add the property name and its value in the Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml field:

    Name: hive.security.authorization.sqlstd.confwhitelist.append

    Value: hive.metastore.uris

    You can then set the property from the Beeline session by adding --hiveconf hive.metastore.uris=' ' to the connection string or by setting the property value to empty from Hive Metastore Server Advanced Configuration Snippet (Safety Valve) for hive-site.xml.