17.10 - Limit On Request Size - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

The maximum size of the fully expanded text for a view is 2 MB.

Because Vantage expands source text in view definitions to fully qualify object names and to normalize expressions, it is possible for a valid view definition to be created, but to be unusable in practice because of stack overflows in the Syntaxer at execution time. In this case, the system returns an error.