“I cannot imagine any condition which would cause this ship to founder. Modern shipbuilding has gone beyond that.”
- E. I. Smith, Captain of the Titanic
Exists only within a query
Materialized by a SELECT Statement inside a query
Space comes from the User’s Spool space
Deleted when the query ends
Hive automatically deletes all temporary tables at the end of theuser's session. Tables are stored in the user's scratch directory andnot in the Hive warehouse directory. Scratch acts as the datasandbox for a user, located by default in /tmp/hive-<username>.
The two types of Temporary tables are Derived and Temporary.