Cloudera Docs

Configuring a temporary staging directory for Hive connectors

By default, the temporary staging directory for the Hive connector on Ozone is disabled. Enabling this directory can improve performance and stability during complex data operations by providing a dedicated space for intermediate data processing.

If you are using Cloudera Data Warehouse 1.5.5 SP2 or later, you can manually enable and configure this staging directory. This process involves adding specific configuration properties to your Hive connector before deploying your Trino Virtual Warehouse.

  1. Log in to the Cloudera Data Warehouse service and click Federation Connectors.
    The Federation Connectors page is displayed that lists all the currently configured connectors.
  2. In the Hive connector, click, > Edit Configuration.
    The Configuration Details page is displayed that lists the hive configuration details.
  3. Under the Key tab, click to add the following configuration:
    • hive.temporary-staging-directory-enabled
    • hive.temporary-staging-directory-path


  4. Click Test Connection to verify if the modified configurations are correct to establish a successful connection to the data source.
  5. After the connection is successful, click Apply Changes.