Skip to content

Vertica SQL Parser Support in GSP

Explore the Vertica SQL Parser product page

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

Syntax Coverage Corpus

GSP tests Vertica syntax against 196 documented constructs grouped into 32 categories, each cross-referenced to the documentation that defines it (196 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 Vertica 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 196 of 196 (100%) 446 of 446 (100%)
SELECT (queries) 15 of 15 (100%) 64 of 64 (100%)
DML (INSERT / UPDATE / DELETE / MERGE) 4 of 4 (100%) 14 of 14 (100%)
Stored procedures 9 of 9 (100%) 10 of 10 (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 196 constructs

Construct Category Parses Specified in
ACTIVATE DIRECTED QUERY ACTIVATE DIRECTED QUERY all 1 Vertica docs
ALTER ACCESS POLICY ALTER all 1 Vertica docs
ALTER AUTHENTICATION ALTER all 8 Vertica docs
ALTER DATABASE ALTER all 1 Vertica docs
ALTER FAULT GROUP ALTER all 1 Vertica docs
ALTER FUNCTION (SQL) ALTER all 3 Vertica docs
ALTER FUNCTION (UDF) ALTER all 3 httpswww.vertica.comdocs9.2.xHTMLContentAuthoringSQLReferenceManualStatementsALTERFUNCTION.htmtocpath=SQL%20Reference%20Manual%7CSQL%20Statements%7CALTER%20Statements%7C_____6
ALTER HCATALOG SCHEMA ALTER all 1 Vertica docs
ALTER LIBRARY ALTER all 1 Vertica docs
ALTER LOAD BALANCE GROUP ALTER all 1 Vertica docs
ALTER MODEL ALTER all 1 Vertica docs
ALTER NETWORK ADDRESS ALTER all 2 Vertica docs
ALTER NETWORK INTERFACE ALTER all 1 Vertica docs
ALTER NODE ALTER all 6 Vertica docs
ALTER NOTIFIER ALTER all 1 Vertica docs
ALTER PROFILE ALTER all 1 Vertica docs
ALTER PROFILE RENAME ALTER all 1 Vertica docs
ALTER PROJECTION RENAME ALTER all 1 Vertica docs
ALTER RESOURCE POOL ALTER all 2 Vertica docs
ALTER ROLE RENAME ALTER all 1 Vertica docs
ALTER ROUTING RULE ALTER all 2 Vertica docs
ALTER SCHEMA ALTER all 6 Vertica docs
ALTER SEQUENCE ALTER all 1 Vertica docs
ALTER SESSION ALTER all 5 Vertica docs
ALTER SUBNET ALTER all 1 Vertica docs
ALTER TABLE ALTER all 5 Vertica docs
ALTER USER ALTER all 5 Vertica docs
ALTER VIEW ALTER all 1 Vertica docs
BEGIN BEGIN all 1 Vertica docs
COMMENT ON COLUMN COMMENT ON all 3 Vertica docs
COMMENT ON CONSTRAINT COMMENT ON all 3 Vertica docs
COMMENT ON FUNCTION COMMENT ON all 3 Vertica docs
COMMENT ON LIBRARY COMMENT ON all 3 Vertica docs
COMMENT ON NODE COMMENT ON all 3 Vertica docs
COMMENT ON PROJECTION COMMENT ON all 3 Vertica docs
COMMENT ON SCHEMA COMMENT ON all 3 Vertica docs
COMMENT ON SEQUENCE COMMENT ON all 3 Vertica docs
COMMENT ON TABLE COMMENT ON all 3 Vertica docs
COMMENT ON TRANSFORM FUNCTION COMMENT ON all 2 Vertica docs
COMMENT ON VIEW COMMENT ON all 2 Vertica docs
COMMIT COMMIT all 1 Vertica docs
CONNECT CONNECT all 1 Vertica docs
COPY COPY all 15 Vertica docs
COPY FROM VERTICA COPY all 1 Vertica docs
COPY LOCAL COPY all 1 Vertica docs
CREATE ACCESS POLICY CREATE all 1 Vertica docs
CREATE AGGREGATE FUNCTION CREATE all 3 Vertica docs
CREATE ANALYTIC FUNCTION CREATE all 1 Vertica docs
CREATE AUTHENTICATION CREATE all 5 Vertica docs
CREATE DIRECTED QUERY CREATE all 1 Vertica docs
CREATE EXTERNAL TABLE AS COPY CREATE all 9 Vertica docs
CREATE FAULT GROUP CREATE all 1 Vertica docs
CREATE FILTER CREATE all 2 Vertica docs
CREATE FLEX EXTERNAL TABLE AS COPY CREATE all 1 Vertica docs
CREATE FLEX TABLE CREATE all 2 Vertica docs
CREATE FUNCTION (SQL Functions) CREATE all 1 Vertica docs
CREATE FUNCTION (UDF) CREATE all 2 Vertica docs
CREATE HCATALOG SCHEMA CREATE all 3 Vertica docs
CREATE LIBRARY CREATE all 3 Vertica docs
CREATE LOAD BALANCE GROUP CREATE all 8 Vertica docs
CREATE LOCAL TEMPORARY VIEW CREATE all 1 Vertica docs
CREATE LOCATION CREATE all 4 Vertica docs
CREATE NETWORK ADDRESS CREATE all 3 Vertica docs
CREATE NETWORK INTERFACE CREATE all 1 Vertica docs
CREATE NOTIFIER CREATE all 2 Vertica docs
CREATE PARSER CREATE all 2 Vertica docs
CREATE PROCEDURE CREATE all 1 Vertica docs
CREATE PROFILE CREATE all 1 Vertica docs
CREATE PROJECTION CREATE all 5 Vertica docs
CREATE PROJECTION (Live Aggregate Projections) CREATE all 1 Vertica docs
CREATE PROJECTION (UDTFs) CREATE all 1 Vertica docs
CREATE RESOURCE POOL CREATE all 4 Vertica docs
CREATE ROLE CREATE all 1 Vertica docs
CREATE ROUTING RULE CREATE all 1 Vertica docs
CREATE SCHEMA CREATE all 5 Vertica docs
CREATE SEQUENCE CREATE all 1 Vertica docs
CREATE SOURCE CREATE all 2 Vertica docs
CREATE SUBNET CREATE all 1 Vertica docs
CREATE TABLE CREATE all 7 Vertica docs
CREATE TEMPORARY TABLE CREATE all 2 Vertica docs
CREATE TEXT INDEX CREATE all 1 Vertica docs
CREATE TRANSFORM FUNCTION CREATE all 1 Vertica docs
CREATE USER CREATE all 1 Vertica docs
CREATE VIEW CREATE all 1 Vertica docs
DEACTIVATE DIRECTED QUERY DEACTIVATE DIRECTED QUERY all 1 Vertica docs
DELETE DELETE all 3 Vertica docs
DISCONNECT DISCONNECT all 1 Vertica docs
DROP ACCESS POLICY DROP all 2 Vertica docs
DROP AGGREGATE FUNCTION DROP all 1 Vertica docs
DROP ANALYTIC FUNCTION DROP all 1 Vertica docs
DROP AUTHENTICATION DROP all 2 Vertica docs
DROP DIRECTED QUERY DROP all 1 Vertica docs
DROP FAULT GROUP DROP all 1 Vertica docs
DROP FILTER DROP all 1 Vertica docs
DROP FUNCTION DROP all 1 Vertica docs
DROP LIBRARY DROP all 1 Vertica docs
DROP LOAD BALANCE GROUP DROP all 2 Vertica docs
DROP MODEL DROP all 1 Vertica docs
DROP NETWORK ADDRESS DROP all 2 Vertica docs
DROP NETWORK INTERFACE DROP all 1 Vertica docs
DROP NOTIFIER DROP all 2 Vertica docs
DROP PARSER DROP all 1 Vertica docs
DROP PROCEDURE DROP all 1 Vertica docs
DROP PROFILE DROP all 1 Vertica docs
DROP PROJECTION DROP all 2 Vertica docs
DROP RESOURCE POOL DROP all 1 Vertica docs
DROP ROLE DROP all 2 Vertica docs
DROP ROUTING RULE DROP all 1 Vertica docs
DROP SCHEMA DROP all 2 Vertica docs
DROP SEQUENCE DROP all 1 Vertica docs
DROP SOURCE DROP all 1 Vertica docs
DROP SUBNET DROP all 1 Vertica docs
DROP TABLE DROP all 4 Vertica docs
DROP TEXT INDEX DROP all 1 Vertica docs
DROP TRANSFORM FUNCTION DROP all 2 Vertica docs
DROP USER DROP all 2 Vertica docs
DROP VIEW DROP all 1 Vertica docs
END END all 1 Vertica docs
EXPLAIN EXPLAIN all 2 Vertica docs
EXPORT TO PARQUET EXPORT TO PARQUET all 6 Vertica docs
EXPORT TO VERTICA EXPORT TO VERTICA all 3 Vertica docs
GET DIRECTED QUERY GET DIRECTED QUERY all 1 Vertica docs
GRANT (Authentication) GRANT all 3 Vertica docs
GRANT (Database) GRANT all 1 Vertica docs
GRANT (Library) GRANT all 1 Vertica docs
GRANT (Model) GRANT all 1 Vertica docs
GRANT (Procedure) GRANT all 1 Vertica docs
GRANT (Resource Pool) GRANT all 1 Vertica docs
GRANT (Role) GRANT all 3 Vertica docs
GRANT (Schema) GRANT all 1 https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/GRANT/GRANTSchema.htm?TocPath=SQL%20Reference%20Manual|SQL%20Statements|GRANT%20Statements|_____8
GRANT (Sequence) GRANT all 1 Vertica docs
GRANT (Storage Location) GRANT all 2 Vertica docs
GRANT (Table) GRANT all 2 Vertica docs
GRANT (User Defined Extension) GRANT all 7 Vertica docs
GRANT (View) GRANT all 2 Vertica docs
INSERT INSERT all 7 Vertica docs
MERGE MERGE all 1 Vertica docs
PROFILE PROFILE all 1 Vertica docs
RELEASE SAVEPOINT RELEASE SAVEPOINT all 1 Vertica docs
REVOKE (Authentication) REVOKE all 3 Vertica docs
REVOKE (Database) REVOKE all 2 Vertica docs
REVOKE (Library) REVOKE all 1 Vertica docs
REVOKE (Model) REVOKE all 1 Vertica docs
REVOKE (Procedure) REVOKE all 1 Vertica docs
REVOKE (Resource Pool) REVOKE all 1 Vertica docs
REVOKE (Role) REVOKE all 3 Vertica docs
REVOKE (Schema) REVOKE all 1 Vertica docs
REVOKE (Sequence) REVOKE all 1 Vertica docs
REVOKE (Storage Location) REVOKE all 2 Vertica docs
REVOKE (Table) REVOKE all 1 Vertica docs
REVOKE (User Defined Extension) REVOKE all 5 Vertica docs
REVOKE (View) REVOKE all 1 Vertica docs
ROLLBACK ROLLBACK all 2 Vertica docs
ROLLBACK TO SAVEPOINT ROLLBACK all 1 Vertica docs
SAVE QUERY SAVE QUERY all 1 Vertica docs
SAVEPOINT SAVEPOINT all 1 Vertica docs
EXCEPT Clause SELECT all 6 Vertica docs
FROM Clause SELECT all 3 Vertica docs
GROUP BY Clause SELECT all 19 Vertica docs
HAVING Clause SELECT all 1 Vertica docs
INTERSECT Clause SELECT all 8 Vertica docs
INTO TABLE Clause SELECT all 3 Vertica docs
LIMIT Clause SELECT all 2 Vertica docs
MATCH Clause SELECT all 1 Vertica docs
MINUS Clause SELECT all 6 Vertica docs
OFFSET Clause SELECT all 2 Vertica docs
ORDER BY Clause SELECT all 2 Vertica docs
TIMESERIES Clause SELECT all 1 Vertica docs
UNION Clause SELECT all 8 Vertica docs
WHERE Clause SELECT all 1 Vertica docs
WITH Clause SELECT all 1 Vertica docs
SET DATESTYLE SET all 3 Vertica docs
SET ESCAPE_STRING_WARNING SET all 1 Vertica docs
SET INTERVALSTYLE SET all 1 Vertica docs
SET LOCALE SET all 3 Vertica docs
SET ROLE SET all 6 Vertica docs
SET SEARCH_PATH SET all 2 Vertica docs
SET SESSION AUTOCOMMIT SET all 2 Vertica docs
SET SESSION CHARACTERISTICS AS TRANSACTION SET all 1 Vertica docs
SET SESSION GRACEPERIOD SET all 1 Vertica docs
SET SESSION IDLESESSIONTIMEOUT SET all 1 Vertica docs
SET SESSION MEMORYCAP SET all 2 Vertica docs
SET SESSION MULTIPLEACTIVERESULTSETS SET all 2 Vertica docs
SET SESSION RESOURCE_POOL SET all 1 Vertica docs
SET SESSION RUNTIMECAP SET all 2 Vertica docs
SET SESSION TEMPSPACECAP SET all 2 Vertica docs
SET STANDARD_CONFORMING_STRINGS SET all 2 Vertica docs
SET TIME ZONE SET all 5 Vertica docs
SHOW SHOW all 1 Vertica docs
SHOW CURRENT SHOW all 1 Vertica docs
SHOW DATABASE SHOW all 2 Vertica docs
SHOW NODE SHOW all 1 Vertica docs
SHOW SESSION SHOW all 2 Vertica docs
START TRANSACTION START TRANSACTION all 1 Vertica docs
TRUNCATE TABLE TRUNCATE TABLE all 1 Vertica docs
UPDATE UPDATE all 3 Vertica docs

Key Features Supported

  • Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
  • Vertica-specific functions and data types
  • Columnar storage optimizations
  • Window functions and analytical queries
  • Machine learning functions
  • Time series analytics