Cloudera Docs

Configure temporary table storage

In CDP Data Center, 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.

CDP Data Center only

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