Apache Hive : HPL/SQL - CREATE VOLATILE TABLE Statement

Last updated: August 12, 2026

Table of Contents

Apache Hive : HPL/SQL - CREATE VOLATILE TABLE Statement

CREATE VOLATILE TABLE statement allows you to create a temporary table for the current session.

Syntax:

CREATE [SET | MULTISET] VOLATILE TABLE table_name
(
   column_name data_type [NULL | NOT NULL]
   [, ...]
)
[ ON COMMIT DELETE ROWS | ON COMMIT PRESERVE ROWS]

Notes:

  • The volatile table is automatically dropped at the end of session.

For more details how temporary table support is implemented in HPL/SQL, see Native and Managed Temporary Tables.

Example:

Create a managed temporary table and use it in other SQL statements:

SET hplsql.temp.tables = managed;

CREATE VOLATILE TABLE temp1
(
   c1 INT,
   c2 STRING
);

INSERT INTO temp1 SELECT 1, 'A' FROM dual;

SELECT * FROM temp1;

Compatibility: Teradata

See also: