Hive Create Temporary Table

Hive Temporary Tables  are used to store intermediate or Temporary complex query results which we don’t want to store it inside database tables permanently,  the Temporary table exists only on the particular session or Terminal window,  where it is being created  and used, once you close the session/terminal  you will not be able to see the temp table in the Database or any where else and we cannot locate the temporary table once we close our session/terminal.

How to Create Temporary Table?

We have to use Temporary keyword  with Hive Create Table.


In the following video i have demonstrated how to create and use the temporary table,
Let us create and see the difference between normal table and temp table in hive.