Cloudera Docs

Configuring temporary table storage

In Cloudera Base on premises, you can change the storage of temporary table data to meet your system requirements.

By default, Apache Hive stores temporary table data in the default user scratch directory /tmp/hive-[***USERNAME***]. Often, this location is not set up by default to accommodate a large amount of data such as that resulting from temporary tables.

Cloudera Base on premises only

  1. Configure Hive to store temporary table data either in memory or on SSD by setting hive.exec.temporary.table.storage.
    • Store data in memory. hive.exec.temporary.table.storage to memory
    • Store data on SSD. hive.exec.temporary.table.storage to ssd
  2. Create and use temporary tables.
Hive drops temporary tables at the end of the session.