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.
-
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
-
Create and use temporary tables.
Hive drops temporary tables at the end of the session.
