Package org.apache.calcite.sql.dialect

Class DuckDBSqlDialect

java.lang.Object

org.apache.calcite.sql.SqlDialect

org.apache.calcite.sql.dialect.DuckDBSqlDialect

public class DuckDBSqlDialect
extends SqlDialect

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

Method Summary

Modifier and Type	Method	Description
boolean	supportsAliasedValues()	Returns whether the dialect supports VALUES in a sub-query with and an "AS t(column, ...)" values to define column names.
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, prepareUnparse, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteStringLiteral, quoteStringLiteral, quoteStringLiteralUnicode, quoteTimestampLiteral, requiresAliasForFromItems, rewriteMaxMin, rewriteMaxMinExpr, rewriteSingleValueExpr, supportBooleanCaseWhen, supportsAggregateFunction, supportsAggregateFunctionFilter, supportsCharSet, supportsDataType, supportsFunction, supportsGroupByLiteral, supportsGroupByWithCube, supportsGroupByWithRollup, supportsImplicitTypeCoercion, supportsJoinType, supportsNestedAggregations, supportsOffsetFetch, supportsTimestampPrecision, supportsWindowFunctions, unparseBoolLiteral, unparseDateTimeLiteral, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseLimit, unparseNumericLiteral, unparseOffset, unparseOffsetFetch, unparseSqlDatetimeArithmetic, unparseSqlIntervalLiteral, unparseSqlIntervalQualifier, unparseSqlSetOption, unparseTableScanHints, unparseTopN, unquoteStringLiteral

Methods inherited from class java.lang.Object

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

Field Details

TYPE_SYSTEM

public static final RelDataTypeSystem TYPE_SYSTEM

DEFAULT_CONTEXT

public static final SqlDialect.Context DEFAULT_CONTEXT

DEFAULT

public static final SqlDialect DEFAULT

Constructor Details

DuckDBSqlDialect

public DuckDBSqlDialect(SqlDialect.Context context)

Creates a DuckDBSqlDialect.

Method Details

supportsApproxCountDistinct

public boolean supportsApproxCountDistinct()

Description copied from class: SqlDialect

Returns whether this dialect supports APPROX_COUNT_DISTINCT functions.

Overrides:

supportsApproxCountDistinct in class SqlDialect

supportsAliasedValues

public boolean supportsAliasedValues()

Description copied from class: SqlDialect

Returns whether the dialect supports VALUES in a sub-query with and an "AS t(column, ...)" values to define column names.

Currently, only Oracle does not. For this, we generate "SELECT v0 AS c0, v1 AS c1 ... UNION ALL ...". We may need to refactor this method when we support VALUES for other dialects.

Overrides:

supportsAliasedValues in class SqlDialect

unparseCall

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

Overrides:

unparseCall in class SqlDialect