Package org.apache.calcite.sql.dialect

Class VerticaSqlDialect

java.lang.Object

org.apache.calcite.sql.SqlDialect

org.apache.calcite.sql.dialect.VerticaSqlDialect

public class VerticaSqlDialect
extends SqlDialect

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

Method Summary

Modifier and Type	Method	Description
boolean	supportsFunction(SqlOperator operator, RelDataType type, List<RelDataType> paramTypes)	Returns whether this dialect supports a given function or operator.
boolean	supportsNestedAggregations()	Returns whether the dialect supports nested aggregations, for instance SELECT SUM(SUM(1)) .
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

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, rewriteMaxMin, rewriteMaxMinExpr, rewriteSingleValueExpr, supportBooleanCaseWhen, supportsAggregateFunction, supportsAggregateFunctionFilter, supportsAliasedValues, supportsApproxCountDistinct, supportsCharSet, supportsDataType, supportsGroupByLiteral, supportsGroupByWithCube, supportsGroupByWithRollup, supportsImplicitTypeCoercion, supportsJoinType, supportsOffsetFetch, supportsTimestampPrecision, supportsWindowFunctions, unparseBoolLiteral, unparseCall, unparseDateTimeLiteral, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseLimit, unparseNumericLiteral, unparseOffset, 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

DEFAULT_CONTEXT

public static final SqlDialect.Context DEFAULT_CONTEXT

DEFAULT

public static final SqlDialect DEFAULT

Constructor Details

VerticaSqlDialect

public VerticaSqlDialect(SqlDialect.Context context)

Creates a VerticaSqlDialect.

Method Details

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

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

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)