Teradata SQL Parser Support in GSP

Explore the Teradata SQL Parser product page

This page documents the SQL syntax support for Teradata in the General SQL Parser.

Syntax Coverage Corpus

GSP tests Teradata syntax against 47 documented constructs grouped into 22 categories, each cross-referenced to the documentation that defines it (1 distinct source page).

Parse coverage

Measured against GSP Java 4.2.8 on 2026-08-31 (UTC) (artifact sha256 1117856ef134). Each construct below carries the complete set of examples from the Teradata documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.

	Constructs fully parsed	Individual statements parsed
All constructs	45 of 47 (96%)	116 of 118 (98%)
SELECT (queries)	4 of 4 (100%)	40 of 40 (100%)
DML (INSERT / UPDATE / DELETE / MERGE)	5 of 5 (100%)	8 of 8 (100%)
Stored procedures	4 of 4 (100%)	5 of 5 (100%)

Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.

Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview

All 47 constructs

Construct	Category	Parses	Specified in
ABORT	ABORT	all 1	Teradata docs
ALTER	ALTER	all 1	Teradata docs
ALTER TABLE	ALTER	all 2	Teradata docs
ALTER TYPE	ALTER	all 1	Teradata docs
BEGIN	BEGIN	all 7	Teradata docs
BEGIN QUERY LOGGING	BEGIN QUERY LOGGING	all 1	Teradata docs
CALL	CALL	all 3	Teradata docs
COMMIT	COMMIT	all 1	Teradata docs
CREATE AUTHORIZATION	CREATE	all 1	Teradata docs
CREATE CONSTRAINT	CREATE	all 1	Teradata docs
CREATE DATABASE	CREATE	all 1	Teradata docs
CREATE FUNCTION	CREATE	all 4	Teradata docs
CREATE GLOBAL TEMPORARY TABLE	CREATE	all 1	Teradata docs
CREATE GLOP	CREATE	all 1	Teradata docs
CREATE INDEX	CREATE	all 4	Teradata docs
CREATE MACRO	CREATE	all 2	Teradata docs
CREATE MULTISET TABLE	CREATE	all 1	Teradata docs
CREATE PROCEDURE	CREATE	all 2	Teradata docs
CREATE PROFILE	CREATE	all 1	Teradata docs
CREATE RECURSIVE VIEW	CREATE	all 1	Teradata docs
CREATE ROLE	CREATE	all 2	Teradata docs
CREATE SET TABLE	CREATE	all 1	Teradata docs
CREATE TABLE	CREATE	all 7	Teradata docs
CREATE TRANSFORM	CREATE	all 1	Teradata docs
CREATE TRIGGER	CREATE	all 1	Teradata docs
CREATE TYPE	CREATE	all 1	Teradata docs
CREATE USER	CREATE	all 1	Teradata docs
CREATE VIEW	CREATE	all 1	Teradata docs
DECLARE	DECLARE	all 1	Teradata docs
DESCRIBE	DESCRIBE	0 of 1	Teradata docs
DROP TABLE	DROP	all 1	Teradata docs
DROP TRANSFORM	DROP	all 1	Teradata docs
HELP TABLE	HELP	all 1	Teradata docs
INSERT	INSERT	all 4	Teradata docs
INSERT PLAN_DIRECTIVE	INSERT	1 of 2	Teradata docs
MODIFY	MODIFY	all 1	Teradata docs
MODIFY USER	MODIFY	all 1	Teradata docs
RENAME	RENAME	all 4	Teradata docs
REPLACE	REPLACE	all 2	Teradata docs
SELECT	SELECT	all 36	Teradata docs
SET	SET	all 1	Teradata docs
SET SESSION	SET	all 2	Teradata docs
SHOW TABLE	SHOW	all 3	Teradata docs
TRANSLATE	TRANSLATE	all 1	Teradata docs
UPDATE	UPDATE	all 1	Teradata docs
USING	USING	all 1	Teradata docs
WITH RECURSIVE	WITH	all 2	Teradata docs

Key Features Supported

• Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
• Teradata-specific functions and data types
• Stored procedures and user-defined functions
• Window functions and analytical queries
• Parallel processing optimizations
• Advanced data warehousing features