Package org.apache.calcite.sql.dialect

Class SparkSqlDialect

java.lang.Object

org.apache.calcite.sql.SqlDialect

org.apache.calcite.sql.dialect.SparkSqlDialect

public class SparkSqlDialect
extends SqlDialect

A SqlDialect implementation for the APACHE SPARK database.

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.calcite.sql.SqlDialect

SqlDialect.CalendarPolicy, SqlDialect.Context, SqlDialect.DatabaseProduct, SqlDialect.FakeUtil

Field Summary

Fields

Modifier and Type	Field	Description
static final SqlDialect	DEFAULT
static final SqlDialect.Context	DEFAULT_CONTEXT

Fields inherited from class org.apache.calcite.sql.SqlDialect

BUILT_IN_OPERATORS_LIST, EMPTY_CONTEXT, identifierEndQuoteString, identifierEscapedQuote, identifierQuoteString, literalEndQuoteString, literalEscapedQuote, literalQuoteString, LOGGER, nullCollation

Constructor Summary

Constructors

Constructor	Description
SparkSqlDialect(SqlDialect.Context context)	Creates a SparkSqlDialect.

Method Summary

Modifier and Type	Method	Description
protected boolean	allowsAs()
JoinType	emulateJoinTypeForCrossJoin()
boolean	supportsAggregateFunction(SqlKind kind)
boolean	supportsApproxCountDistinct()	Returns whether this dialect supports APPROX_COUNT_DISTINCT functions.
boolean	supportsCharSet()	Returns whether the dialect supports character set names as part of a data type, for instance VARCHAR(30) CHARACTER SET `ISO-8859-1`.
boolean	supportsGroupByWithCube()	Returns whether this dialect supports "WITH CUBE" in "GROUP BY" clause.
boolean	supportsGroupByWithRollup()	Returns whether this dialect supports "WITH ROLLUP" in the "GROUP BY" clause.
boolean	supportsNestedAggregations()	Returns whether the dialect supports nested aggregations, for instance SELECT SUM(SUM(1)) .
void	unparseCall(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec)
void	unparseOffsetFetch(SqlWriter writer, @Nullable SqlNode offset, @Nullable SqlNode fetch)	Converts an offset and fetch into SQL.

Methods inherited from class org.apache.calcite.sql.SqlDialect

configureParser, configureParser, containsNonAscii, create, defaultNullDirection, emulateNullDirection, emulateNullDirectionWithIsNull, getCalendarPolicy, getCastSpec, getConformance, getDatabaseProduct, getFormatModel, getNullCollation, getProduct, getQuotedCasing, getQuoting, getSingleRowTableName, getTypeSystem, getUnquotedCasing, hasImplicitTableAlias, identifierNeedsQuote, isCaseSensitive, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteStringLiteral, quoteStringLiteral, quoteStringLiteralUnicode, quoteTimestampLiteral, requiresAliasForFromItems, rewriteSingleValueExpr, supportsAggregateFunctionFilter, supportsAliasedValues, supportsDataType, supportsFunction, supportsGroupByLiteral, supportsImplicitTypeCoercion, supportsJoinType, supportsOffsetFetch, supportsWindowFunctions, unparseDateTimeLiteral, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseLimit, unparseOffset, unparseSqlDatetimeArithmetic, unparseSqlIntervalLiteral, unparseSqlIntervalQualifier, unparseTableScanHints, unparseTopN, unquoteStringLiteral

Methods inherited from class java.lang.Object

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

Field Details

DEFAULT_CONTEXT

public static final SqlDialect.Context DEFAULT_CONTEXT

DEFAULT

public static final SqlDialect DEFAULT

Constructor Details

SparkSqlDialect

public SparkSqlDialect(SqlDialect.Context context)

Creates a SparkSqlDialect.

Method Details

allowsAs

protected boolean allowsAs()

Overrides:

allowsAs in class SqlDialect

supportsCharSet

public boolean supportsCharSet()

Description copied from class: SqlDialect

Returns whether the dialect supports character set names as part of a data type, for instance VARCHAR(30) CHARACTER SET `ISO-8859-1`.

Overrides:

supportsCharSet in class SqlDialect

emulateJoinTypeForCrossJoin

public JoinType emulateJoinTypeForCrossJoin()

Overrides:

emulateJoinTypeForCrossJoin in class SqlDialect

supportsGroupByWithRollup

public boolean supportsGroupByWithRollup()

Description copied from class: SqlDialect

Returns whether this dialect supports "WITH ROLLUP" in the "GROUP BY" clause.

For instance, in MySQL version 5,

SELECT deptno, job, COUNT(*) AS c FROM emp GROUP BY deptno, job WITH ROLLUP

is equivalent to standard SQL

SELECT deptno, job, COUNT(*) AS c FROM emp GROUP BY ROLLUP(deptno, job) ORDER BY deptno, job

The "WITH ROLLUP" clause was introduced in MySQL and is not standard SQL.

See also SqlDialect.supportsAggregateFunction(SqlKind) applied to SqlKind.ROLLUP, which returns true in MySQL 8 and higher.

Overrides:

supportsGroupByWithRollup in class SqlDialect

supportsNestedAggregations

public boolean supportsNestedAggregations()

Description copied from class: SqlDialect

Returns whether the dialect supports nested aggregations, for instance SELECT SUM(SUM(1)) .

Overrides:

supportsNestedAggregations in class SqlDialect

supportsAggregateFunction

public boolean supportsAggregateFunction(SqlKind kind)

Overrides:

supportsAggregateFunction in class SqlDialect

supportsApproxCountDistinct

public boolean supportsApproxCountDistinct()

Description copied from class: SqlDialect

Returns whether this dialect supports APPROX_COUNT_DISTINCT functions.

Overrides:

supportsApproxCountDistinct in class SqlDialect

supportsGroupByWithCube

public boolean supportsGroupByWithCube()

Description copied from class: SqlDialect

Returns whether this dialect supports "WITH CUBE" in "GROUP BY" clause.

Overrides:

supportsGroupByWithCube in class SqlDialect

unparseOffsetFetch

public void unparseOffsetFetch(SqlWriter writer,
 @Nullable SqlNode offset,
 @Nullable SqlNode fetch)

Description copied from class: SqlDialect

Converts an offset and fetch into SQL.

At least one of offset and fetch must be provided.

Common options:

• OFFSET offset ROWS FETCH NEXT fetch ROWS ONLY (ANSI standard SQL, Oracle, PostgreSQL, and the default)
• LIMIT fetch OFFSET offset (Apache Hive, MySQL, Redshift)

Overrides:

unparseOffsetFetch in class SqlDialect

Parameters:

writer - Writer

offset - Number of rows to skip before emitting, or null

fetch - Number of rows to fetch, or null

See Also:

• SqlDialect.unparseFetchUsingAnsi(SqlWriter, SqlNode, SqlNode)
• SqlDialect.unparseFetchUsingLimit(SqlWriter, SqlNode, SqlNode)

unparseCall

public void unparseCall(SqlWriter writer,
 SqlCall call,
 int leftPrec,
 int rightPrec)

Overrides:

unparseCall in class SqlDialect