Class SynapseDialect


  • public class SynapseDialect
    extends org.apache.calcite.sql.dialect.MssqlSqlDialect
    Azure Synapse-specific SQL dialect with catalog casing filter support. Synapse uses the Microsoft SQL Server (T-SQL) engine and JDBC driver, so it renders Substrait-derived query plans with the Calcite MSSQL dialect and uses square brackets ([]) for identifier quoting.
    • Nested Class Summary

      • Nested classes/interfaces inherited from class org.apache.calcite.sql.SqlDialect

        org.apache.calcite.sql.SqlDialect.CalendarPolicy, org.apache.calcite.sql.SqlDialect.Context, org.apache.calcite.sql.SqlDialect.DatabaseProduct, org.apache.calcite.sql.SqlDialect.FakeUtil
    • Field Summary

      Fields 
      Modifier and Type Field Description
      static org.apache.calcite.sql.SqlDialect DEFAULT  
      • Fields inherited from class org.apache.calcite.sql.dialect.MssqlSqlDialect

        DEFAULT_CONTEXT, MSSQL_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
      SynapseDialect​(boolean catalogCasingFilter)  
    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      StringBuilder quoteIdentifier​(StringBuilder buf, String identifier)  
      • Methods inherited from class org.apache.calcite.sql.dialect.MssqlSqlDialect

        emulateNullDirection, supportsApproxCountDistinct, supportsCharSet, supportsGroupByWithCube, supportsGroupByWithRollup, unparseBoolLiteral, unparseCall, unparseDateTimeLiteral, unparseOffsetFetch, unparseSqlDatetimeArithmetic, unparseSqlIntervalLiteral, unparseSqlIntervalQualifier, unparseTopN
      • Methods inherited from class org.apache.calcite.sql.SqlDialect

        allowsAs, configureParser, configureParser, containsNonAscii, create, defaultNullDirection, emulateJoinTypeForCrossJoin, emulateNullDirectionWithIsNull, getCalendarPolicy, getCastSpec, getConformance, getDatabaseProduct, getFormatModel, getNullCollation, getProduct, getQuotedCasing, getQuoting, getSingleRowTableName, getTypeSystem, getUnquotedCasing, hasImplicitTableAlias, identifierNeedsQuote, isCaseSensitive, prepareUnparse, quoteIdentifier, quoteIdentifier, quoteStringLiteral, quoteStringLiteral, quoteStringLiteralUnicode, quoteTimestampLiteral, requiresAliasForFromItems, rewriteMaxMin, rewriteMaxMinExpr, rewriteSingleValueExpr, supportBooleanCaseWhen, supportsAggregateFunction, supportsAggregateFunctionFilter, supportsAliasedValues, supportsDataType, supportsFunction, supportsGroupByLiteral, supportsImplicitTypeCoercion, supportsJoinType, supportsNestedAggregations, supportsOffsetFetch, supportsTimestampPrecision, supportsWindowFunctions, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseLimit, unparseNumericLiteral, unparseOffset, unparseSqlSetOption, unparseTableScanHints, unquoteStringLiteral
    • Field Detail

      • DEFAULT

        public static final org.apache.calcite.sql.SqlDialect DEFAULT
    • Constructor Detail

      • SynapseDialect

        public SynapseDialect​(boolean catalogCasingFilter)
    • Method Detail

      • quoteIdentifier

        public StringBuilder quoteIdentifier​(StringBuilder buf,
                                             String identifier)
        Overrides:
        quoteIdentifier in class org.apache.calcite.sql.SqlDialect