Package org.apache.calcite.sql.dialect

Class StarRocksSqlDialect

java.lang.Object

org.apache.calcite.sql.SqlDialect

org.apache.calcite.sql.dialect.MysqlSqlDialect

org.apache.calcite.sql.dialect.StarRocksSqlDialect

Direct Known Subclasses:

DorisSqlDialect

public class StarRocksSqlDialect
extends MysqlSqlDialect

A SqlDialect implementation for the StarRocks 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
static final RelDataTypeSystem	STARROCKS_TYPE_SYSTEM	StarRocks type system.

Fields inherited from class org.apache.calcite.sql.dialect.MysqlSqlDialect

ISNULL_FUNCTION, MYSQL_TYPE_SYSTEM

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
StarRocksSqlDialect(SqlDialect.Context context)	Creates a StarRocksSqlDialect.

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.
RexNode	prepareUnparse(RexNode arg)	Converts RexNode expression to RexNode expression before unparse.
boolean	supportsApproxCountDistinct()	Returns whether this dialect supports APPROX_COUNT_DISTINCT functions.
boolean	supportsGroupByWithRollup()	Returns whether this dialect supports "WITH ROLLUP" in the "GROUP BY" clause.
boolean	supportsJoinType(JoinRelType joinType)	Returns whether this dialect support the specified type of join.
boolean	supportsTimestampPrecision()	Returns whether this dialect supports TIMESTAMP with precision.
void	unparseCall(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec)
void	unparseDateTimeLiteral(SqlWriter writer, SqlAbstractDateTimeLiteral literal, int leftPrec, int rightPrec)

Methods inherited from class org.apache.calcite.sql.dialect.MysqlSqlDialect

emulateNullDirection, getCalendarPolicy, requiresAliasForFromItems, rewriteSingleValueExpr, supportsAggregateFunction, supportsAggregateFunctionFilter, supportsAliasedValues, supportsCharSet, supportsNestedAggregations, unparseOffsetFetch, unparseSqlIntervalQualifier

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

allowsAs, configureParser, configureParser, containsNonAscii, create, defaultNullDirection, emulateJoinTypeForCrossJoin, emulateNullDirectionWithIsNull, getConformance, getDatabaseProduct, getFormatModel, getNullCollation, getProduct, getQuotedCasing, getQuoting, getSingleRowTableName, getTypeSystem, getUnquotedCasing, hasImplicitTableAlias, identifierNeedsQuote, isCaseSensitive, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteStringLiteral, quoteStringLiteral, quoteStringLiteralUnicode, quoteTimestampLiteral, rewriteMaxMin, rewriteMaxMinExpr, supportBooleanCaseWhen, supportsDataType, supportsFunction, supportsGroupByLiteral, supportsGroupByWithCube, supportsImplicitTypeCoercion, supportsOffsetFetch, supportsWindowFunctions, unparseBoolLiteral, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseLimit, unparseNumericLiteral, unparseOffset, unparseSqlDatetimeArithmetic, unparseSqlIntervalLiteral, unparseSqlSetOption, unparseTableScanHints, unparseTopN, unquoteStringLiteral

Methods inherited from class java.lang.Object

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

Field Details

STARROCKS_TYPE_SYSTEM

public static final RelDataTypeSystem STARROCKS_TYPE_SYSTEM

StarRocks type system.

DEFAULT_CONTEXT

public static final SqlDialect.Context DEFAULT_CONTEXT

DEFAULT

public static final SqlDialect DEFAULT

Constructor Details

StarRocksSqlDialect

public StarRocksSqlDialect(SqlDialect.Context context)

Creates a StarRocksSqlDialect.

Method Details

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 MysqlSqlDialect

supportsTimestampPrecision

public boolean supportsTimestampPrecision()

Description copied from class: SqlDialect

Returns whether this dialect supports TIMESTAMP with precision.

Overrides:

supportsTimestampPrecision 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

supportsJoinType

public boolean supportsJoinType(JoinRelType joinType)

Description copied from class: SqlDialect

Returns whether this dialect support the specified type of join.

Overrides:

supportsJoinType in class MysqlSqlDialect

prepareUnparse

public RexNode prepareUnparse(RexNode arg)

Description copied from class: SqlDialect

Converts RexNode expression to RexNode expression before unparse.

Overrides:

prepareUnparse in class SqlDialect

unparseCall

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

Overrides:

unparseCall in class MysqlSqlDialect

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 MysqlSqlDialect

unparseDateTimeLiteral

public void unparseDateTimeLiteral(SqlWriter writer,
 SqlAbstractDateTimeLiteral literal,
 int leftPrec,
 int rightPrec)

Overrides:

unparseDateTimeLiteral in class SqlDialect