Package org.apache.calcite.sql.dialect

Class SnowflakeSqlDialect

java.lang.Object

org.apache.calcite.sql.SqlDialect

org.apache.calcite.sql.dialect.SnowflakeSqlDialect

public class SnowflakeSqlDialect
extends SqlDialect

A SqlDialect implementation for the Snowflake 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
SnowflakeSqlDialect(SqlDialect.Context context)	Creates a SnowflakeSqlDialect.

Method Summary

Modifier and Type	Method	Description
static SqlNode	rewriteMaxMin(SqlNode aggCall, RelDataType relDataType)	Helper for rewrites of MAX/MIN.
SqlNode	rewriteMaxMinExpr(SqlNode aggCall, RelDataType relDataType)	Rewrites MAX(x)/MIN(x) as BOOL_OR(x)/BOOL_AND(x) for certain database variants (Postgres and Redshift, currently).
boolean	supportsApproxCountDistinct()	Returns whether this dialect supports APPROX_COUNT_DISTINCT functions.
void	unparseCall(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec)

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

allowsAs, configureParser, configureParser, containsNonAscii, create, defaultNullDirection, emulateJoinTypeForCrossJoin, 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, supportBooleanCaseWhen, supportsAggregateFunction, supportsAggregateFunctionFilter, supportsAliasedValues, supportsCharSet, supportsDataType, supportsFunction, supportsGroupByLiteral, supportsGroupByWithCube, supportsGroupByWithRollup, supportsImplicitTypeCoercion, supportsJoinType, supportsNestedAggregations, supportsOffsetFetch, supportsTimestampPrecision, supportsWindowFunctions, unparseBoolLiteral, unparseDateTimeLiteral, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseLimit, unparseOffset, unparseOffsetFetch, 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

SnowflakeSqlDialect

public SnowflakeSqlDialect(SqlDialect.Context context)

Creates a SnowflakeSqlDialect.

Method Details

unparseCall

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

Overrides:

unparseCall in class SqlDialect

rewriteMaxMinExpr

public SqlNode rewriteMaxMinExpr(SqlNode aggCall,
 RelDataType relDataType)

Description copied from class: SqlDialect

Rewrites MAX(x)/MIN(x) as BOOL_OR(x)/BOOL_AND(x) for certain database variants (Postgres and Redshift, currently).

Overrides:

rewriteMaxMinExpr in class SqlDialect

See Also:

• SqlDialect.rewriteMaxMin(SqlNode, RelDataType)

rewriteMaxMin

public static SqlNode rewriteMaxMin(SqlNode aggCall,
 RelDataType relDataType)

Helper for rewrites of MAX/MIN. Snowflake, rewrite as BOOLOR_AGG/BOOLAND_AGG if the return type is BOOLEAN.

supportsApproxCountDistinct

public boolean supportsApproxCountDistinct()

Description copied from class: SqlDialect

Returns whether this dialect supports APPROX_COUNT_DISTINCT functions.

Overrides:

supportsApproxCountDistinct in class SqlDialect