Cloudera Docs

Hive service query archive

The hive.server2.webui.max.historic.queries parameter controls the size of the Hive service query archive (Completed Queries). This parameter has a default value of 25.

  1. Log in to Cloudera Manager
  2. Navigate to Clusters > HIVE_ON_TEZ > Configuration
  3. Search for hive_service_config_safety_valve
  4. Add a new safety valve using the icon.
  5. Provide the following details:
    1. Name: hive.server2.webui.max.historic.queries
    2. Value: <value-to-set>
    3. Description: Optional, for example, the maximum number of completed queries to display on the HiveServer2 UI.
  6. Click Save Changes
  7. Perform Stale Configuration Actions. For more information, see the Stale configuration documentation.