Using Apache HiveQL
Also available as:
PDF

Create a temporary table

Create a temporary table to improve performance by storing data outside HDFS for intermediate use, or reuse, by a complex query.

Temporary table data persists only during the current Apache Hive session. Hive drops the table at the end of the session. If you use the name of a permanent table to create the temporary table, the permanent table is inaccessible during the session unless you drop or rename the temporary table. You can create a temporary table having the same name as another user's temporary table because user sessions are independent. Temporary tables do not support partitioned columns and indexes.
  1. Create a temporary table having one string column.
    CREATE TEMPORARY TABLE tmp1 (c1 string);
  2. Create a temporary table using the CREATE TABLE AS SELECT (CTAS) statement.
    CREATE TEMPORARY TABLE tmp2 AS SELECT c2, c3, c4 where (c3 = 5);
    Hive supports CREATE TEMPORARY TABLE LIKE also.