Teradata Database Message 5509 - 5509 - Analytics Database - Teradata Vantage

Message

Global temporary table cannot be created WITH DATA.

Explanation

If GLOBAL TEMPORARY is specified in a CREATE TABLE statement, only the definition of the base temporary table is created. A temporary table for data storage is materialized only when the user references the base temporary table, so 'WITH DATA' may not be specified for global temporary tables.

Generated By

Syntaxer.

For Whom

User.

Notes

None

Remedy

Change 'WITH DATA' to 'WITH NO DATA' and re-submit query.