Package org.apache.calcite.sql.dialect

Class FireboltSqlDialect

java.lang.Object

org.apache.calcite.sql.SqlDialect

org.apache.calcite.sql.dialect.FireboltSqlDialect

public class FireboltSqlDialect
extends SqlDialect

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

Method Summary

Modifier and Type	Method	Description
@Nullable SqlNode	getCastSpec(RelDataType type)	Returns SqlNode for type in "cast(column as type)", which might be different between databases by type name, precision etc.
protected boolean	identifierNeedsQuote(String val)	Returns whether to quote an identifier.
boolean	supportsAggregateFunction(SqlKind kind)
boolean	supportsAggregateFunctionFilter()	Returns whether this dialect supports the use of FILTER clauses for aggregate 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	supportsFunction(SqlOperator operator, RelDataType type, List<RelDataType> paramTypes)	Returns whether this dialect supports a given function or operator.
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.
void	unparseSqlIntervalLiteral(SqlWriter writer, SqlIntervalLiteral literal, int leftPrec, int rightPrec)	Firebolt interval syntax: sign INTERVAL int64 time_unit.
void	unparseSqlIntervalQualifier(SqlWriter writer, SqlIntervalQualifier qualifier, RelDataTypeSystem typeSystem)	Converts an interval qualifier to a SQL string.

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

allowsAs, configureParser, configureParser, containsNonAscii, create, defaultNullDirection, emulateJoinTypeForCrossJoin, emulateNullDirection, emulateNullDirectionWithIsNull, getCalendarPolicy, getConformance, getDatabaseProduct, getFormatModel, getNullCollation, getProduct, getQuotedCasing, getQuoting, getSingleRowTableName, getTypeSystem, getUnquotedCasing, hasImplicitTableAlias, isCaseSensitive, prepareUnparse, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteStringLiteral, quoteStringLiteral, quoteStringLiteralUnicode, quoteTimestampLiteral, requiresAliasForFromItems, rewriteMaxMin, rewriteMaxMinExpr, rewriteSingleValueExpr, supportBooleanCaseWhen, supportsAliasedValues, supportsApproxCountDistinct, supportsDataType, supportsGroupByLiteral, supportsGroupByWithCube, supportsGroupByWithRollup, supportsImplicitTypeCoercion, supportsJoinType, supportsNestedAggregations, supportsOffsetFetch, supportsTimestampPrecision, supportsWindowFunctions, unparseBoolLiteral, unparseDateTimeLiteral, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseLimit, unparseNumericLiteral, unparseOffset, unparseSqlDatetimeArithmetic, unparseSqlSetOption, 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

FireboltSqlDialect

public FireboltSqlDialect(SqlDialect.Context context)

Creates a FireboltSqlDialect.

Method Details

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

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)

supportsAggregateFunction

public boolean supportsAggregateFunction(SqlKind kind)

Overrides:

supportsAggregateFunction in class SqlDialect

identifierNeedsQuote

protected boolean identifierNeedsQuote(String val)

Description copied from class: SqlDialect

Returns whether to quote an identifier. By default, all identifiers are quoted.

Overrides:

identifierNeedsQuote in class SqlDialect

getCastSpec

public @Nullable SqlNode getCastSpec(RelDataType type)

Description copied from class: SqlDialect

Returns SqlNode for type in "cast(column as type)", which might be different between databases by type name, precision etc.

If this method returns null, the cast will be omitted. In the default implementation, this is the case for the NULL type, and therefore CAST(NULL AS <nulltype>) is rendered as NULL.

Overrides:

getCastSpec in class SqlDialect

supportsAggregateFunctionFilter

public boolean supportsAggregateFunctionFilter()

Description copied from class: SqlDialect

Returns whether this dialect supports the use of FILTER clauses for aggregate functions. e.g. COUNT(*) FILTER (WHERE a = 2).

Overrides:

supportsAggregateFunctionFilter in class SqlDialect

supportsFunction

public boolean supportsFunction(SqlOperator operator,
 RelDataType type,
 List<RelDataType> paramTypes)

Description copied from class: SqlDialect

Returns whether this dialect supports a given function or operator. It only applies to built-in scalar functions and operators, since user-defined functions and procedures should be read by JdbcSchema.

Overrides:

supportsFunction in class SqlDialect

unparseCall

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

Overrides:

unparseCall in class SqlDialect

unparseSqlIntervalLiteral

public void unparseSqlIntervalLiteral(SqlWriter writer,
 SqlIntervalLiteral literal,
 int leftPrec,
 int rightPrec)

Firebolt interval syntax: sign INTERVAL int64 time_unit.

Overrides:

unparseSqlIntervalLiteral in class SqlDialect

unparseSqlIntervalQualifier

public void unparseSqlIntervalQualifier(SqlWriter writer,
 SqlIntervalQualifier qualifier,
 RelDataTypeSystem typeSystem)

Description copied from class: SqlDialect

Converts an interval qualifier to a SQL string. The default implementation returns strings such as INTERVAL '1 2:3:4' DAY(4) TO SECOND(4).

Overrides:

unparseSqlIntervalQualifier in class SqlDialect