gudusoft.gsqlparser.sqlcmds

Class TSqlCmdsDatabricks

Object

gudusoft.gsqlparser.sqlcmds.AbstractSqlCmds

gudusoft.gsqlparser.sqlcmds.TSqlCmdsDatabricks

All Implemented Interfaces:

ISqlCmds

public class TSqlCmdsDatabricks
extends AbstractSqlCmds

Databricks SQL command resolver. Contains all Databricks-specific SQL command recognition logic.

Since:

3.1.0.9

Field Summary

Fields inherited from class gudusoft.gsqlparser.sqlcmds.AbstractSqlCmds

initialized, initLock, sqlCmdList, vendor

Constructor Summary

Constructors

Constructor and Description
TSqlCmdsDatabricks()

Method Summary

Modifier and Type	Method and Description
protected TCustomSqlStatement	findcte(TSourceToken ptoken) Databricks/Spark allow the AS keyword to be omitted in a CTE:
protected String	getToken1Str(int token1) Get the string representation for vendor-specific token codes.
protected void	initializeCommands() Initialize vendor-specific commands.
TCustomSqlStatement	issql(TSourceToken token, EFindSqlStateType state, TCustomSqlStatement currentStatement) Identifies the SQL statement type from a token stream.

Methods inherited from class gudusoft.gsqlparser.sqlcmds.AbstractSqlCmds

addCmd, addCmd, addCmd, addCmd, addCmd, addCmd, addCmd, addCmd, ensureInitialized, findCteByStructure, finddbcmd, getSqlCmdList, getStatementTypeForToken, getVendor, overrideCmd

Methods inherited from class Object

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

Constructor Detail

TSqlCmdsDatabricks

public TSqlCmdsDatabricks()

Method Detail

findcte

protected TCustomSqlStatement findcte(TSourceToken ptoken)

Databricks/Spark allow the AS keyword to be omitted in a CTE:

WITH cte_name [ ( col_list ) ] ( query ) ...

The shared AbstractSqlCmds.findcte(TSourceToken) only recognizes the AS form; this override adds the no-AS form.

The no-AS detection runs FIRST: the shared logic keys off the first AS token, which for a no-AS CTE could be an unrelated later AS (e.g. an INSERT INTO t AS a target alias) and lead to the wrong statement class. findCteWithoutAs(gudusoft.gsqlparser.TSourceToken) returns null for a genuine AS CTE, so those still fall through to the shared logic.

Overrides:

findcte in class AbstractSqlCmds

Parameters:

ptoken - The WITH token

Returns:

Statement object for the CTE query, or null if not a valid CTE

getToken1Str

protected String getToken1Str(int token1)

Description copied from class: AbstractSqlCmds

Get the string representation for vendor-specific token codes. Subclasses should override this method to provide mappings for vendor-specific reserved words (tokens > TBaseType.rrw_abort).

Overrides:

getToken1Str in class AbstractSqlCmds

Parameters:

token1 - Token code

Returns:

String representation of the token, or null if not applicable

initializeCommands

protected void initializeCommands()

Description copied from class: AbstractSqlCmds

Initialize vendor-specific commands. Subclasses must implement this to populate sqlCmdList.

Specified by:

initializeCommands in class AbstractSqlCmds

issql

public TCustomSqlStatement issql(TSourceToken token,
                                 EFindSqlStateType state,
                                 TCustomSqlStatement currentStatement)

Description copied from interface: ISqlCmds

Identifies the SQL statement type from a token stream. This method is called repeatedly during parsing to identify statement boundaries and types in complex SQL scripts.

Parameters:

token - Current token being analyzed

state - Current parsing state (start, in body, or in exception)

currentStatement - Current statement being built (may be modified)

Returns:

The identified or modified SQL statement