Configuring a table location outside the warehouse root directory

You need to know how to set the property that allows you to establish a common location for tables.

  1. In Cloudera Manager, click Clusters > Hive on Tez > Configuration.
  2. In scope, click Hive on Tez (Service-Wide).
  3. In Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml, click +.
  4. In Name, enter metastore.warehouse.tenant.colocation.
  5. In Value, enter true.
  6. Save changes.
  7. In Cloudera Manager Home, restart Hive on Tez.