Using Apache Hive
Also available as:

Configure temporary table storage

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.
  1. Configure Hive to store temporary table data in memory or on SSD by setting
    • Store data in memory.
    • Store data on SSD.
  2. Create and use temporary tables.
    Hive drops temporary tables at the end of the session.