Package gudusoft.gsqlparser.parser

Class GreenplumSqlParser

Object

gudusoft.gsqlparser.parser.AbstractSqlParser

gudusoft.gsqlparser.parser.GreenplumSqlParser

All Implemented Interfaces:

SqlParser

public class GreenplumSqlParser
extends AbstractSqlParser

Greenplum database SQL parser implementation.

This parser handles Greenplum-specific SQL syntax including:

• PL/pgSQL blocks (procedures, functions, triggers)
• Dollar-quoted strings ($$ ... $$)
• Backslash meta commands (\d, \dt, etc.)
• PostgreSQL-compatible syntax extensions
• Special token handling (INNER, NOT DEFERRABLE, etc.)

Design Notes:

• Extends AbstractSqlParser using the template method pattern
• Uses TLexerGreenplum for tokenization
• Uses TParserGreenplum for parsing
• Delimiter character: '/' for PL/pgSQL blocks

Usage Example:

 // Get Greenplum parser from factory
 SqlParser parser = SqlParserFactory.get(EDbVendor.dbvgreenplum);

 // Build context
 ParserContext context = new ParserContext.Builder(EDbVendor.dbvgreenplum)
     .sqlText("SELECT * FROM employees WHERE dept_id = 10")
     .build();

 // Parse
 SqlParseResult result = parser.parse(context);

 // Access statements
 TStatementList statements = result.getSqlStatements();
 

Since:

3.3.1.0

See Also:

• SqlParser
• AbstractSqlParser
• TLexerGreenplum
• TParserGreenplum

Nested Class Summary

Nested classes/interfaces inherited from class gudusoft.gsqlparser.parser.AbstractSqlParser

AbstractSqlParser.PreparedSqlReader

Field Summary

Fields

Modifier and Type	Field	Description
TLexerGreenplum	flexer	The Greenplum lexer used for tokenization

Fields inherited from class gudusoft.gsqlparser.parser.AbstractSqlParser

defaultDelimiterStr, delimiterChar, frameStack, globalContext, globalFrame, lexer, parserContext, sourcetokenlist, sqlcmds, sqlEnv, sqlstatements, syntaxErrors, vendor

Constructor Summary

Constructors

Constructor	Description
GreenplumSqlParser()	Construct Greenplum SQL parser.

Method Summary

Modifier and Type	Method	Description
protected void	afterStatementParsed(TCustomSqlStatement stmt)	Hook method called after each statement is parsed.
protected void	extractVendorRawStatements(SqlParseResult.Builder builder)	Call Greenplum-specific raw statement extraction.
protected TCustomLexer	getLexer(ParserContext context)	Return the Greenplum lexer instance.
protected TCustomParser	getParser(ParserContext context, TSourceTokenList tokens)	Return the Greenplum SQL parser instance with updated token list.
protected TCustomParser	getSecondaryParser(ParserContext context, TSourceTokenList tokens)	Greenplum doesn't use secondary parser (unlike Oracle with PL/SQL parser).
protected TStatementList	performParsing(ParserContext context, TCustomParser mainParser, TCustomParser secondaryParser, TSourceTokenList tokens, TStatementList rawStatements)	Parse all statements in the statement list.
protected void	performSemanticAnalysis(ParserContext context, TStatementList statements)	Perform semantic analysis on parsed statements.
protected void	setupVendorParsersForExtraction()	Setup vendor parsers before raw statement extraction.
protected void	tokenizeVendorSql()	Call Greenplum-specific tokenization logic.

Methods inherited from class gudusoft.gsqlparser.parser.AbstractSqlParser

attemptErrorRecovery, copyErrorsFromStatement, doAfterTokenize, doExtractRawStatements, extractRawStatements, getanewsourcetoken, getDefaultDelimiterStr, getDelimiterChar, getErrorCount, getrawsqlstatements, getSyntaxErrors, getVendor, handleStatementParsingException, initializeGlobalContext, isDollarFunctionDelimiter, onRawStatementComplete, onRawStatementCompleteVendorSpecific, parse, performInterpreter, performTokenization, prepareSqlReader, processTokensBeforeParse, processTokensInTokenTable, setTokenHandle, tokenize, toString, towinlinebreak

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Details

flexer

public TLexerGreenplum flexer

The Greenplum lexer used for tokenization

Constructor Details

GreenplumSqlParser

public GreenplumSqlParser()

Construct Greenplum SQL parser.

Configures the parser for Greenplum database with default delimiter (/).

Following the original TGSqlParser pattern, the lexer and parser are created once in the constructor and reused for all parsing operations.

Method Details

getLexer

protected TCustomLexer getLexer(ParserContext context)

Return the Greenplum lexer instance.

Specified by:

getLexer in class AbstractSqlParser

Parameters:

context - the parser context

Returns:

configured lexer instance (never null)

getParser

protected TCustomParser getParser(ParserContext context,
 TSourceTokenList tokens)

Return the Greenplum SQL parser instance with updated token list.

Specified by:

getParser in class AbstractSqlParser

Parameters:

context - the parser context

tokens - the source token list

Returns:

configured parser instance (never null)

getSecondaryParser

protected TCustomParser getSecondaryParser(ParserContext context,
 TSourceTokenList tokens)

Greenplum doesn't use secondary parser (unlike Oracle with PL/SQL parser).

Overrides:

getSecondaryParser in class AbstractSqlParser

Parameters:

context - the parser context

tokens - the source token list

Returns:

secondary parser instance, or null if not needed

tokenizeVendorSql

protected void tokenizeVendorSql()

Call Greenplum-specific tokenization logic.

Delegates to dogreenplumtexttotokenlist which handles Greenplum's tokenization including backslash commands, dollar-quoted strings, and PostgreSQL-compatible syntax.

Specified by:

tokenizeVendorSql in class AbstractSqlParser

setupVendorParsersForExtraction

protected void setupVendorParsersForExtraction()

Setup vendor parsers before raw statement extraction.

Injects sqlcmds and sourcetokenlist into the Greenplum parser.

Specified by:

setupVendorParsersForExtraction in class AbstractSqlParser

extractVendorRawStatements

protected void extractVendorRawStatements(SqlParseResult.Builder builder)

Call Greenplum-specific raw statement extraction.

Delegates to dogreenplumgetrawsqlstatements which handles: - PL/pgSQL block boundaries (dollar-quoted strings) - Backslash meta commands - Semicolon-separated statements

Specified by:

extractVendorRawStatements in class AbstractSqlParser

Parameters:

builder - the result builder to populate with raw statements

performParsing

protected TStatementList performParsing(ParserContext context,
 TCustomParser mainParser,
 TCustomParser secondaryParser,
 TSourceTokenList tokens,
 TStatementList rawStatements)

Parse all statements in the statement list.

This is the main parsing loop that processes each raw statement and converts it into a fully parsed AST.

Specified by:

performParsing in class AbstractSqlParser

Parameters:

context - the parser context

mainParser - the main parser instance

secondaryParser - secondary parser (may be null)

tokens - the source token list

rawStatements - raw statements already extracted (never null)

Returns:

statement list with parsed AST (never null)

performSemanticAnalysis

protected void performSemanticAnalysis(ParserContext context,
 TStatementList statements)

Perform semantic analysis on parsed statements.

This runs the TSQLResolver to resolve column-to-table relationships, data flow analysis, and other semantic checks.

Overrides:

performSemanticAnalysis in class AbstractSqlParser

Parameters:

context - the parser context

statements - the parsed statements (mutable)

afterStatementParsed

protected void afterStatementParsed(TCustomSqlStatement stmt)

Hook method called after each statement is parsed.

Greenplum doesn't need special post-processing, so this is a no-op.

Overrides:

afterStatementParsed in class AbstractSqlParser

Parameters:

stmt - the statement that was just parsed