Syntaxer | SQL Request and Transaction Processing | VantageCloud Lake - Syntaxer - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

The Syntaxer checks the request parcel for high-level syntax. If no errors are detected, the Syntaxer converts the request parcels into a skeletal parse tree called the SynTree or Black Tree. When this process completes, the Parser passes the SynTree to the DPL component (see Dynamically Parameterized Requests), and then to the Resolver.

A parse tree is a data structure used by the SQL Parser to represent a request parcel in a form that is simple to annotate with descriptive and statistical information derived from the Data Dictionary and from derived statistics.

The parse tree also permits a relatively simple transformation of the request parcel by Query Rewrite and the Optimizer into an execution plan.