Using Temporary Tables

You can use the CREATE TEMPORARY TABLE in the SQL Reference Manual to implement certain queries using multiple steps. In other words, you can:

1. create one or more temporary tables
2. execute queries and store the result sets in the temporary tables
3. execute the main query using the temporary tables as if they were a normal part of the logical schema

   A logical schema consists of a set of tables and referential integrity constraints in a Vertica database. The objects in the logical schema are visible to SQL users. The logical schema does not include projections, which make up the physical schema.

The name "temporary table" may seem like a misnomer. Only the data stored in the table is temporary. The metadata is persistent.

Notes

• Make sure to define all temporary tables used in a query before inserting data into any of them.