Configuring Hive in Cloudera Data Warehouse

Configuring Hive performance in the Cloud is rarely, if ever, required relative to the extensive performance tuning typical in a bare metal environment. You might occasionally want to configure Hive properties unrelated to performance, such as HiveServer (HS2) administration or logging level properties.

Changing one of the vast array of configuration parameters from Cloudera Data Warehouse is recommended only when following Cloudera instructions. For example, you follow instructions in a compaction alert or the product documentation that describes the property and value to change, and how to do it.

In Cloudera Data Warehouse, if you have required permissions, you can configure Hive, Hive metastore, or HiveServer properties from a Database Catalog or Virtual Warehouse. In this task, you see how to change a property and add a property from the Database Catalog, and then from a Virtual Warehouse.

  • You have the appropriate Admin role to make the configuration change.
  1. Click CDW Overview > Database Catalogs > Options > Edit > Configurations > Metastore.
  2. From the drop-down, select a configuration category, for example hive-site.
  3. Change, or set, the property value.
  4. Click + to add a property to hive-site, for example.
  5. Enter the name of the property you want to add, the equals symbol, and one or more comma-separated values.
    Do not use single or double quotation marks to enclose the property or value.
  6. Click Add.
  7. Save, and restart the Database Catalog.
  8. Click Virtual Warehouses, and select a Hive Virtual Warehouse.
  9. Click Actions > Edit > Metastore > HiveServer2.
  10. Search for a specific property, or view categories of properties by selecting a category in the dropdown.