Greenplum SQL Parser Support in GSP

Explore the Greenplum SQL Parser product page

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

Syntax Coverage Corpus

GSP tests Greenplum syntax against 154 documented constructs grouped into 43 categories, each cross-referenced to the documentation that defines it (152 distinct source pages).

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 Greenplum 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	148 of 154 (96%)	460 of 487 (94%)
SELECT (queries)	8 of 8 (100%)	22 of 22 (100%)
DML (INSERT / UPDATE / DELETE / MERGE)	9 of 9 (100%)	35 of 35 (100%)
Stored procedures	5 of 7 (71%)	15 of 18 (83%)

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 154 constructs

Construct	Category	Parses	Specified in
ALTER AGGREGATE	ALTER	all 3	Greenplum docs
ALTER COLLATION	ALTER	all 2	Greenplum docs
ALTER CONVERSION	ALTER	all 2	Greenplum docs
ALTER DATABASE	ALTER	all 1	Greenplum docs
ALTER DEFAULT PRIVILEGES	ALTER	all 5	Greenplum docs
ALTER DOMAIN	ALTER	all 6	Greenplum docs
ALTER EXTENSION	ALTER	all 3	Greenplum docs
ALTER EXTERNAL TABLE	ALTER	all 3	Greenplum docs
ALTER FOREIGN DATA WRAPPER	ALTER	all 2	Greenplum docs
ALTER FOREIGN TABLE	ALTER	all 2	Greenplum docs
ALTER FUNCTION	ALTER	all 4	Greenplum docs
ALTER GROUP	ALTER	all 2	Greenplum docs
ALTER INDEX	ALTER	all 4	Greenplum docs
ALTER LANGUAGE	ALTER	all 2	Greenplum docs
ALTER MATERIALIZED VIEW	ALTER	all 1	Greenplum docs
ALTER OPERATOR	ALTER	all 1	Greenplum docs
ALTER OPERATOR CLASS	ALTER	all 1	Greenplum docs
ALTER OPERATOR FAMILY	ALTER	all 2	Greenplum docs
ALTER PROTOCOL	ALTER	all 2	Greenplum docs
ALTER RESOURCE GROUP	ALTER	all 5	Greenplum docs
ALTER RESOURCE QUEUE	ALTER	all 6	Greenplum docs
ALTER ROLE	ALTER	all 12	Greenplum docs
ALTER SCHEMA	ALTER	all 2	Greenplum docs
ALTER SEQUENCE	ALTER	all 1	Greenplum docs
ALTER SERVER	ALTER	all 2	Greenplum docs
ALTER TABLE	ALTER	9 of 19	Greenplum docs
ALTER TABLESPACE	ALTER	all 2	Greenplum docs
ALTER TEXT SEARCH CONFIGURATION	ALTER	all 1	Greenplum docs
ALTER TEXT SEARCH DICTIONARY	ALTER	all 3	Greenplum docs
ALTER TEXT SEARCH PARSER	ALTER	all 2	Greenplum docs
ALTER TEXT SEARCH TEMPLATE	ALTER	all 2	Greenplum docs
ALTER TYPE	ALTER	all 6	Greenplum docs
ALTER USER	ALTER	all 1	Greenplum docs
ALTER USER MAPPING	ALTER	all 1	Greenplum docs
ALTER VIEW	ALTER	all 6	Greenplum docs
ANALYZE	ANALYZE	all 1	Greenplum docs
BEGIN	BEGIN	all 2	Greenplum docs
CHECKPOINT	CHECKPOINT	all 1	Greenplum docs
CLOSE	CLOSE	all 1	Greenplum docs
CLUSTER	CLUSTER	all 6	Greenplum docs
COMMENT	COMMENT	25 of 35	Greenplum docs
COMMIT	COMMIT	all 1	Greenplum docs
COPY	COPY	all 10	Greenplum docs
CREATE AGGREGATE	CREATE	all 3	Greenplum docs
CREATE CAST	CREATE	all 1	Greenplum docs
CREATE COLLATION	CREATE	all 2	Greenplum docs
CREATE CONVERSION	CREATE	all 1	Greenplum docs
CREATE DATABASE	CREATE	all 3	Greenplum docs
CREATE DOMAIN	CREATE	all 1	Greenplum docs
CREATE EXTENSION	CREATE	all 2	Greenplum docs
CREATE EXTERNAL TABLE	CREATE	all 6	Greenplum docs
CREATE FOREIGN DATA WRAPPER	CREATE	all 3	Greenplum docs
CREATE FOREIGN TABLE	CREATE	all 1	Greenplum docs
CREATE FUNCTION	CREATE	10 of 11	Greenplum docs
CREATE GROUP	CREATE	all 1	Greenplum docs
CREATE INDEX	CREATE	all 8	Greenplum docs
CREATE LANGUAGE	CREATE	all 3	Greenplum docs
CREATE MATERIALIZED VIEW	CREATE	all 2	Greenplum docs
CREATE OPERATOR	CREATE	all 2	Greenplum docs
CREATE OPERATOR CLASS	CREATE	all 1	Greenplum docs
CREATE OPERATOR FAMILY	CREATE	all 1	Greenplum docs
CREATE PROTOCOL	CREATE	all 1	Greenplum docs
CREATE RESOURCE GROUP	CREATE	all 4	Greenplum docs
CREATE RESOURCE QUEUE	CREATE	all 6	Greenplum docs
CREATE ROLE	CREATE	all 7	Greenplum docs
CREATE RULE	CREATE	all 1	Greenplum docs
CREATE SCHEMA	CREATE	all 3	Greenplum docs
CREATE SEQUENCE	CREATE	all 4	Greenplum docs
CREATE SERVER	CREATE	all 1	Greenplum docs
CREATE TABLE	CREATE	all 8	Greenplum docs
CREATE TABLE AS	CREATE	all 3	Greenplum docs
CREATE TABLESPACE	CREATE	all 2	Greenplum docs
CREATE TEXT SEARCH CONFIGURATION	CREATE	all 1	—
CREATE TEXT SEARCH DICTIONARY	CREATE	all 1	Greenplum docs
CREATE TEXT SEARCH PARSER	CREATE	all 1	Greenplum docs
CREATE TEXT SEARCH TEMPLATE	CREATE	all 1	Greenplum docs
CREATE TYPE	CREATE	all 10	Greenplum docs
CREATE USER	CREATE	all 2	Greenplum docs
CREATE USER MAPPING	CREATE	all 1	Greenplum docs
CREATE VIEW	CREATE	2 of 3	Greenplum docs
DEALLOCATE	DEALLOCATE	all 1	Greenplum docs
DECLARE	DECLARE	all 1	Greenplum docs
DELETE	DELETE	all 4	Greenplum docs
DISCARD	DISCARD	5 of 8	Greenplum docs
DO	DO	1 of 3	Greenplum docs
DROP AGGREGATE	DROP	all 2	Greenplum docs
DROP CAST	DROP	all 1	Greenplum docs
DROP COLLATION	DROP	all 1	Greenplum docs
DROP CONVERSION	DROP	all 1	Greenplum docs
DROP DATABASE	DROP	all 1	Greenplum docs
DROP DOMAIN	DROP	all 1	Greenplum docs
DROP EXTENSION	DROP	all 2	Greenplum docs
DROP EXTERNAL TABLE	DROP	all 1	Greenplum docs
DROP FOREIGN DATA WRAPPER	DROP	all 1	Greenplum docs
DROP FOREIGN TABLE	DROP	all 1	Greenplum docs
DROP FUNCTION	DROP	all 1	Greenplum docs
DROP GROUP	DROP	all 2	Greenplum docs
DROP INDEX	DROP	all 1	Greenplum docs
DROP LANGUAGE	DROP	all 1	Greenplum docs
DROP MATERIALIZED VIEW	DROP	all 1	Greenplum docs
DROP OPERATOR	DROP	all 3	Greenplum docs
DROP OPERATOR CLASS	DROP	all 1	Greenplum docs
DROP OPERATOR FAMILY	DROP	all 1	Greenplum docs
DROP OWNED	DROP	all 1	Greenplum docs
DROP PROTOCOL	DROP	all 2	Greenplum docs
DROP RESOURCE GROUP	DROP	all 2	Greenplum docs
DROP RESOURCE QUEUE	DROP	all 2	Greenplum docs
DROP ROLE	DROP	all 1	Greenplum docs
DROP RULE	DROP	all 1	Greenplum docs
DROP SCHEMA	DROP	all 1	Greenplum docs
DROP SEQUENCE	DROP	all 1	Greenplum docs
DROP SERVER	DROP	all 1	Greenplum docs
DROP TABLE	DROP	all 1	Greenplum docs
DROP TABLESPACE	DROP	all 1	Greenplum docs
DROP TEXT SEARCH CONFIGURATION	DROP	all 1	Greenplum docs
DROP TEXT SEARCH DICTIONARY	DROP	all 1	Greenplum docs
DROP TEXT SEARCH PARSER	DROP	all 1	Greenplum docs
DROP TEXT SEARCH TEMPLATE	DROP	all 2	Greenplum docs
DROP TYPE	DROP	all 1	Greenplum docs
DROP USER	DROP	all 2	Greenplum docs
DROP USER MAPPING	DROP	all 1	Greenplum docs
DROP VIEW	DROP	all 1	Greenplum docs
END	END	all 1	Greenplum docs
EXECUTE	EXECUTE	all 2	Greenplum docs
EXPLAIN	EXPLAIN	all 4	Greenplum docs
FETCH	FETCH	all 5	Greenplum docs
GRANT	GRANT	all 3	Greenplum docs
INSERT	INSERT	all 7	Greenplum docs
LOAD	LOAD	all 1	Greenplum docs
LOCK	LOCK	all 10	Greenplum docs
MOVE	MOVE	all 6	Greenplum docs
PREPARE	PREPARE	all 4	Greenplum docs
REASSIGN OWNED	REASSIGN OWNED	all 1	Greenplum docs
REFRESH MATERIALIZED VIEW	REFRESH MATERIALIZED VIEW	all 2	Greenplum docs
REINDEX	REINDEX	all 2	Greenplum docs
RELEASE SAVEPOINT	RELEASE SAVEPOINT	all 6	Greenplum docs
RESET	RESET	all 1	Greenplum docs
REVOKE	REVOKE	all 3	Greenplum docs
ROLLBACK	ROLLBACK	all 1	Greenplum docs
ROLLBACK TO SAVEPOINT	ROLLBACK TO SAVEPOINT	all 8	—
SAVEPOINT	SAVEPOINT	all 13	Greenplum docs
SELECT	SELECT	all 15	Greenplum docs
SELECT INTO	SELECT	all 1	Greenplum docs
SET	SET	all 5	Greenplum docs
SET CONSTRAINTS	SET	all 1	Greenplum docs
SET ROLE	SET	all 2	Greenplum docs
SET SESSION AUTHORIZATION	SET	all 2	Greenplum docs
SET TRANSACTION	SET	all 2	Greenplum docs
SHOW	SHOW	all 3	Greenplum docs
START TRANSACTION	START TRANSACTION	all 1	Greenplum docs
TRUNCATE	TRUNCATE	all 2	—
UPDATE	UPDATE	all 11	Greenplum docs
VACUUM	VACUUM	all 4	Greenplum docs
VALUES	VALUES	all 6	Greenplum docs

Key Features Supported

• Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
• Greenplum-specific functions and data types
• Massively parallel processing (MPP) features
• Window functions and analytical queries
• External table operations
• Distributed query optimizations