Syntaxer | SQL Request and Transaction Processing | Teradata Vantage - Syntaxer - Analytics Database - Teradata Vantage

SQL Request and Transaction Processing

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
zfm1628111633230.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
evd1472255317510
lifecycle
latest
Product Category
Teradata Vantageā„¢

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 referred to as 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 various 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.