O'Reilly logo

HP Vertica - Architecture and SQL by Leslie Nolander, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11 – Temporary Tables

“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

There are three types of Temporary Tables

Derived Table

•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

Local Temporary Table

•Created by the User and materialized with an INSERT/SELECT

•Table and Data are deleted only after a User Logs off the session

•Can be session specific or seen across different sessions

Global Temporary Table

•Table definition is created by a User and the table definition is permanent

•Materialized with an INSERT/SELECT

•When User ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required