| <!DOCTYPE HTML> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc (17) --> |
| <title>RedshiftSqlDialect (Apache Calcite API)</title> |
| <meta name="viewport" content="width=device-width, initial-scale=1"> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <meta name="description" content="declaration: package: org.apache.calcite.sql.dialect, class: RedshiftSqlDialect"> |
| <meta name="generator" content="javadoc/ClassWriterImpl"> |
| <link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style"> |
| <link rel="stylesheet" type="text/css" href="../../../../../script-dir/jquery-ui.min.css" title="Style"> |
| <link rel="stylesheet" type="text/css" href="../../../../../jquery-ui.overrides.css" title="Style"> |
| <script type="text/javascript" src="../../../../../script.js"></script> |
| <script type="text/javascript" src="../../../../../script-dir/jquery-3.5.1.min.js"></script> |
| <script type="text/javascript" src="../../../../../script-dir/jquery-ui.min.js"></script> |
| </head> |
| <body class="class-declaration-page"> |
| <script type="text/javascript">var evenRowColor = "even-row-color"; |
| var oddRowColor = "odd-row-color"; |
| var tableTab = "table-tab"; |
| var activeTableTab = "active-table-tab"; |
| var pathtoroot = "../../../../../"; |
| loadScripts(document, 'script');</script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| <div class="flex-box"> |
| <header role="banner" class="flex-header"> |
| <nav role="navigation"> |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <div class="top-nav" id="navbar-top"> |
| <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div> |
| <div class="about-language"><b>Apache Calcite</b></div> |
| <ul id="navbar-top-firstrow" class="nav-list" title="Navigation"> |
| <li><a href="../../../../../index.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="nav-bar-cell1-rev">Class</li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../../help-doc.html#class">Help</a></li> |
| </ul> |
| </div> |
| <div class="sub-nav"> |
| <div> |
| <ul class="sub-nav-list"> |
| <li>Summary: </li> |
| <li><a href="#nested-class-summary">Nested</a> | </li> |
| <li><a href="#field-summary">Field</a> | </li> |
| <li><a href="#constructor-summary">Constr</a> | </li> |
| <li><a href="#method-summary">Method</a></li> |
| </ul> |
| <ul class="sub-nav-list"> |
| <li>Detail: </li> |
| <li><a href="#field-detail">Field</a> | </li> |
| <li><a href="#constructor-detail">Constr</a> | </li> |
| <li><a href="#method-detail">Method</a></li> |
| </ul> |
| </div> |
| <div class="nav-list-search"><label for="search-input">SEARCH:</label> |
| <input type="text" id="search-input" value="search" disabled="disabled"> |
| <input type="reset" id="reset-button" value="reset" disabled="disabled"> |
| </div> |
| </div> |
| <!-- ========= END OF TOP NAVBAR ========= --> |
| <span class="skip-nav" id="skip-navbar-top"></span></nav> |
| </header> |
| <div class="flex-content"> |
| <main role="main"> |
| <!-- ======== START OF CLASS DATA ======== --> |
| <div class="header"> |
| <div class="sub-title"><span class="package-label-in-type">Package</span> <a href="package-summary.html">org.apache.calcite.sql.dialect</a></div> |
| <h1 title="Class RedshiftSqlDialect" class="title">Class RedshiftSqlDialect</h1> |
| </div> |
| <div class="inheritance" title="Inheritance Tree"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">java.lang.Object</a> |
| <div class="inheritance"><a href="../SqlDialect.html" title="class in org.apache.calcite.sql">org.apache.calcite.sql.SqlDialect</a> |
| <div class="inheritance">org.apache.calcite.sql.dialect.RedshiftSqlDialect</div> |
| </div> |
| </div> |
| <section class="class-description" id="class-description"> |
| <hr> |
| <div class="type-signature"><span class="modifiers">public class </span><span class="element-name type-name-label">RedshiftSqlDialect</span> |
| <span class="extends-implements">extends <a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></span></div> |
| <div class="block">A <code>SqlDialect</code> implementation for the Redshift database.</div> |
| </section> |
| <section class="summary"> |
| <ul class="summary-list"> |
| <!-- ======== NESTED CLASS SUMMARY ======== --> |
| <li> |
| <section class="nested-class-summary" id="nested-class-summary"> |
| <h2>Nested Class Summary</h2> |
| <div class="inherited-list"> |
| <h2 id="nested-classes-inherited-from-class-org.apache.calcite.sql.SqlDialect">Nested classes/interfaces inherited from class org.apache.calcite.sql.<a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></h2> |
| <code><a href="../SqlDialect.CalendarPolicy.html" title="enum in org.apache.calcite.sql">SqlDialect.CalendarPolicy</a>, <a href="../SqlDialect.Context.html" title="interface in org.apache.calcite.sql">SqlDialect.Context</a>, <a href="../SqlDialect.DatabaseProduct.html" title="enum in org.apache.calcite.sql">SqlDialect.DatabaseProduct</a>, <a href="../SqlDialect.FakeUtil.html" title="class in org.apache.calcite.sql">SqlDialect.FakeUtil</a></code></div> |
| </section> |
| </li> |
| <!-- =========== FIELD SUMMARY =========== --> |
| <li> |
| <section class="field-summary" id="field-summary"> |
| <h2>Field Summary</h2> |
| <div class="caption"><span>Fields</span></div> |
| <div class="summary-table three-column-summary"> |
| <div class="table-header col-first">Modifier and Type</div> |
| <div class="table-header col-second">Field</div> |
| <div class="table-header col-last">Description</div> |
| <div class="col-first even-row-color"><code>static final <a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></div> |
| <div class="col-second even-row-color"><code><a href="#DEFAULT" class="member-name-link">DEFAULT</a></code></div> |
| <div class="col-last even-row-color"> </div> |
| <div class="col-first odd-row-color"><code>static final <a href="../SqlDialect.Context.html" title="interface in org.apache.calcite.sql">SqlDialect.Context</a></code></div> |
| <div class="col-second odd-row-color"><code><a href="#DEFAULT_CONTEXT" class="member-name-link">DEFAULT_CONTEXT</a></code></div> |
| <div class="col-last odd-row-color"> </div> |
| <div class="col-first even-row-color"><code>static final <a href="../../rel/type/RelDataTypeSystem.html" title="interface in org.apache.calcite.rel.type">RelDataTypeSystem</a></code></div> |
| <div class="col-second even-row-color"><code><a href="#TYPE_SYSTEM" class="member-name-link">TYPE_SYSTEM</a></code></div> |
| <div class="col-last even-row-color"> </div> |
| </div> |
| <div class="inherited-list"> |
| <h3 id="fields-inherited-from-class-org.apache.calcite.sql.SqlDialect">Fields inherited from class org.apache.calcite.sql.<a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></h3> |
| <code><a href="../SqlDialect.html#BUILT_IN_OPERATORS_LIST">BUILT_IN_OPERATORS_LIST</a>, <a href="../SqlDialect.html#EMPTY_CONTEXT">EMPTY_CONTEXT</a>, <a href="../SqlDialect.html#identifierEndQuoteString">identifierEndQuoteString</a>, <a href="../SqlDialect.html#identifierEscapedQuote">identifierEscapedQuote</a>, <a href="../SqlDialect.html#identifierQuoteString">identifierQuoteString</a>, <a href="../SqlDialect.html#literalEndQuoteString">literalEndQuoteString</a>, <a href="../SqlDialect.html#literalEscapedQuote">literalEscapedQuote</a>, <a href="../SqlDialect.html#literalQuoteString">literalQuoteString</a>, <a href="../SqlDialect.html#LOGGER">LOGGER</a>, <a href="../SqlDialect.html#nullCollation">nullCollation</a></code></div> |
| </section> |
| </li> |
| <!-- ======== CONSTRUCTOR SUMMARY ======== --> |
| <li> |
| <section class="constructor-summary" id="constructor-summary"> |
| <h2>Constructor Summary</h2> |
| <div class="caption"><span>Constructors</span></div> |
| <div class="summary-table two-column-summary"> |
| <div class="table-header col-first">Constructor</div> |
| <div class="table-header col-last">Description</div> |
| <div class="col-constructor-name even-row-color"><code><a href="#%3Cinit%3E(org.apache.calcite.sql.SqlDialect.Context)" class="member-name-link">RedshiftSqlDialect</a><wbr>(<a href="../SqlDialect.Context.html" title="interface in org.apache.calcite.sql">SqlDialect.Context</a> context)</code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Creates a RedshiftSqlDialect.</div> |
| </div> |
| </div> |
| </section> |
| </li> |
| <!-- ========== METHOD SUMMARY =========== --> |
| <li> |
| <section class="method-summary" id="method-summary"> |
| <h2>Method Summary</h2> |
| <div id="method-summary-table"> |
| <div class="table-tabs" role="tablist" aria-orientation="horizontal"><button id="method-summary-table-tab0" role="tab" aria-selected="true" aria-controls="method-summary-table.tabpanel" tabindex="0" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table', 3)" class="active-table-tab">All Methods</button><button id="method-summary-table-tab2" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab2', 3)" class="table-tab">Instance Methods</button><button id="method-summary-table-tab4" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab4', 3)" class="table-tab">Concrete Methods</button></div> |
| <div id="method-summary-table.tabpanel" role="tabpanel"> |
| <div class="summary-table three-column-summary" aria-labelledby="method-summary-table-tab0"> |
| <div class="table-header col-first">Modifier and Type</div> |
| <div class="table-header col-second">Method</div> |
| <div class="table-header col-last">Description</div> |
| <div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>@Nullable <a href="../SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a></code></div> |
| <div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getCastSpec(org.apache.calcite.rel.type.RelDataType)" class="member-name-link">getCastSpec</a><wbr>(<a href="../../rel/type/RelDataType.html" title="interface in org.apache.calcite.rel.type">RelDataType</a> type)</code></div> |
| <div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> |
| <div class="block">Returns SqlNode for type in "cast(column as type)", which might be |
| different between databases by type name, precision etc.</div> |
| </div> |
| <div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>boolean</code></div> |
| <div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#supportsAliasedValues()" class="member-name-link">supportsAliasedValues</a>()</code></div> |
| <div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> |
| <div class="block">Returns whether the dialect supports VALUES in a sub-query with |
| and an "AS t(column, ...)" values to define column names.</div> |
| </div> |
| <div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>boolean</code></div> |
| <div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#supportsCharSet()" class="member-name-link">supportsCharSet</a>()</code></div> |
| <div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> |
| <div class="block">Returns whether the dialect supports character set names as part of a |
| data type, for instance <code>VARCHAR(30) CHARACTER SET `ISO-8859-1`</code>.</div> |
| </div> |
| <div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>boolean</code></div> |
| <div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#supportsGroupByLiteral()" class="member-name-link">supportsGroupByLiteral</a>()</code></div> |
| <div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> |
| <div class="block">Returns whether the dialect supports GROUP BY literals.</div> |
| </div> |
| <div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>void</code></div> |
| <div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#unparseOffsetFetch(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode,org.apache.calcite.sql.SqlNode)" class="member-name-link">unparseOffsetFetch</a><wbr>(<a href="../SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| @Nullable <a href="../SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> offset, |
| @Nullable <a href="../SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> fetch)</code></div> |
| <div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> |
| <div class="block">Converts an offset and fetch into SQL.</div> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="inherited-list"> |
| <h3 id="methods-inherited-from-class-org.apache.calcite.sql.SqlDialect">Methods inherited from class org.apache.calcite.sql.<a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></h3> |
| <code><a href="../SqlDialect.html#allowsAs()">allowsAs</a>, <a href="../SqlDialect.html#configureParser(org.apache.calcite.sql.parser.SqlParser.Config)">configureParser</a>, <a href="../SqlDialect.html#configureParser(org.apache.calcite.sql.parser.SqlParser.ConfigBuilder)">configureParser</a>, <a href="../SqlDialect.html#containsNonAscii(java.lang.String)">containsNonAscii</a>, <a href="../SqlDialect.html#create(java.sql.DatabaseMetaData)">create</a>, <a href="../SqlDialect.html#defaultNullDirection(org.apache.calcite.rel.RelFieldCollation.Direction)">defaultNullDirection</a>, <a href="../SqlDialect.html#emulateJoinTypeForCrossJoin()">emulateJoinTypeForCrossJoin</a>, <a href="../SqlDialect.html#emulateNullDirection(org.apache.calcite.sql.SqlNode,boolean,boolean)">emulateNullDirection</a>, <a href="../SqlDialect.html#emulateNullDirectionWithIsNull(org.apache.calcite.sql.SqlNode,boolean,boolean)">emulateNullDirectionWithIsNull</a>, <a href="../SqlDialect.html#getCalendarPolicy()">getCalendarPolicy</a>, <a href="../SqlDialect.html#getConformance()">getConformance</a>, <a href="../SqlDialect.html#getDatabaseProduct()">getDatabaseProduct</a>, <a href="../SqlDialect.html#getNullCollation()">getNullCollation</a>, <a href="../SqlDialect.html#getProduct(java.lang.String,java.lang.String)">getProduct</a>, <a href="../SqlDialect.html#getQuotedCasing()">getQuotedCasing</a>, <a href="../SqlDialect.html#getQuoting()">getQuoting</a>, <a href="../SqlDialect.html#getSingleRowTableName()">getSingleRowTableName</a>, <a href="../SqlDialect.html#getTypeSystem()">getTypeSystem</a>, <a href="../SqlDialect.html#getUnquotedCasing()">getUnquotedCasing</a>, <a href="../SqlDialect.html#hasImplicitTableAlias()">hasImplicitTableAlias</a>, <a href="../SqlDialect.html#identifierNeedsQuote(java.lang.String)">identifierNeedsQuote</a>, <a href="../SqlDialect.html#isCaseSensitive()">isCaseSensitive</a>, <a href="../SqlDialect.html#quoteIdentifier(java.lang.String)">quoteIdentifier</a>, <a href="../SqlDialect.html#quoteIdentifier(java.lang.StringBuilder,java.lang.String)">quoteIdentifier</a>, <a href="../SqlDialect.html#quoteIdentifier(java.lang.StringBuilder,java.util.List)">quoteIdentifier</a>, <a href="../SqlDialect.html#quoteStringLiteral(java.lang.String)">quoteStringLiteral</a>, <a href="../SqlDialect.html#quoteStringLiteral(java.lang.StringBuilder,java.lang.String,java.lang.String)">quoteStringLiteral</a>, <a href="../SqlDialect.html#quoteStringLiteralUnicode(java.lang.StringBuilder,java.lang.String)">quoteStringLiteralUnicode</a>, <a href="../SqlDialect.html#quoteTimestampLiteral(java.sql.Timestamp)">quoteTimestampLiteral</a>, <a href="../SqlDialect.html#requiresAliasForFromItems()">requiresAliasForFromItems</a>, <a href="../SqlDialect.html#rewriteSingleValueExpr(org.apache.calcite.sql.SqlNode)">rewriteSingleValueExpr</a>, <a href="../SqlDialect.html#supportsAggregateFunction(org.apache.calcite.sql.SqlKind)">supportsAggregateFunction</a>, <a href="../SqlDialect.html#supportsAggregateFunctionFilter()">supportsAggregateFunctionFilter</a>, <a href="../SqlDialect.html#supportsApproxCountDistinct()">supportsApproxCountDistinct</a>, <a href="../SqlDialect.html#supportsDataType(org.apache.calcite.rel.type.RelDataType)">supportsDataType</a>, <a href="../SqlDialect.html#supportsFunction(org.apache.calcite.sql.SqlOperator,org.apache.calcite.rel.type.RelDataType,java.util.List)">supportsFunction</a>, <a href="../SqlDialect.html#supportsGroupByWithCube()">supportsGroupByWithCube</a>, <a href="../SqlDialect.html#supportsGroupByWithRollup()">supportsGroupByWithRollup</a>, <a href="../SqlDialect.html#supportsImplicitTypeCoercion(org.apache.calcite.rex.RexCall)">supportsImplicitTypeCoercion</a>, <a href="../SqlDialect.html#supportsJoinType(org.apache.calcite.rel.core.JoinRelType)">supportsJoinType</a>, <a href="../SqlDialect.html#supportsNestedAggregations()">supportsNestedAggregations</a>, <a href="../SqlDialect.html#supportsOffsetFetch()">supportsOffsetFetch</a>, <a href="../SqlDialect.html#supportsWindowFunctions()">supportsWindowFunctions</a>, <a href="../SqlDialect.html#unparseCall(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlCall,int,int)">unparseCall</a>, <a href="../SqlDialect.html#unparseDateTimeLiteral(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlAbstractDateTimeLiteral,int,int)">unparseDateTimeLiteral</a>, <a href="../SqlDialect.html#unparseFetchUsingAnsi(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode,org.apache.calcite.sql.SqlNode)">unparseFetchUsingAnsi</a>, <a href="../SqlDialect.html#unparseFetchUsingLimit(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode,org.apache.calcite.sql.SqlNode)">unparseFetchUsingLimit</a>, <a href="../SqlDialect.html#unparseLimit(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode)">unparseLimit</a>, <a href="../SqlDialect.html#unparseOffset(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode)">unparseOffset</a>, <a href="../SqlDialect.html#unparseSqlDatetimeArithmetic(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlCall,org.apache.calcite.sql.SqlKind,int,int)">unparseSqlDatetimeArithmetic</a>, <a href="../SqlDialect.html#unparseSqlIntervalLiteral(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlIntervalLiteral,int,int)">unparseSqlIntervalLiteral</a>, <a href="../SqlDialect.html#unparseSqlIntervalQualifier(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlIntervalQualifier,org.apache.calcite.rel.type.RelDataTypeSystem)">unparseSqlIntervalQualifier</a>, <a href="../SqlDialect.html#unparseTableScanHints(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNodeList,int,int)">unparseTableScanHints</a>, <a href="../SqlDialect.html#unparseTopN(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode,org.apache.calcite.sql.SqlNode)">unparseTopN</a>, <a href="../SqlDialect.html#unquoteStringLiteral(java.lang.String)">unquoteStringLiteral</a></code></div> |
| <div class="inherited-list"> |
| <h3 id="methods-inherited-from-class-java.lang.Object">Methods inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a></h3> |
| <code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#clone()" title="class or interface in java.lang" class="external-link">clone</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang" class="external-link">equals</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#finalize()" title="class or interface in java.lang" class="external-link">finalize</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#getClass()" title="class or interface in java.lang" class="external-link">getClass</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#hashCode()" title="class or interface in java.lang" class="external-link">hashCode</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#notify()" title="class or interface in java.lang" class="external-link">notify</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#notifyAll()" title="class or interface in java.lang" class="external-link">notifyAll</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#toString()" title="class or interface in java.lang" class="external-link">toString</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#wait()" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#wait(long)" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#wait(long,int)" title="class or interface in java.lang" class="external-link">wait</a></code></div> |
| </section> |
| </li> |
| </ul> |
| </section> |
| <section class="details"> |
| <ul class="details-list"> |
| <!-- ============ FIELD DETAIL =========== --> |
| <li> |
| <section class="field-details" id="field-detail"> |
| <h2>Field Details</h2> |
| <ul class="member-list"> |
| <li> |
| <section class="detail" id="TYPE_SYSTEM"> |
| <h3>TYPE_SYSTEM</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="../../rel/type/RelDataTypeSystem.html" title="interface in org.apache.calcite.rel.type">RelDataTypeSystem</a></span> <span class="element-name">TYPE_SYSTEM</span></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DEFAULT_CONTEXT"> |
| <h3>DEFAULT_CONTEXT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="../SqlDialect.Context.html" title="interface in org.apache.calcite.sql">SqlDialect.Context</a></span> <span class="element-name">DEFAULT_CONTEXT</span></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DEFAULT"> |
| <h3>DEFAULT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></span> <span class="element-name">DEFAULT</span></div> |
| </section> |
| </li> |
| </ul> |
| </section> |
| </li> |
| <!-- ========= CONSTRUCTOR DETAIL ======== --> |
| <li> |
| <section class="constructor-details" id="constructor-detail"> |
| <h2>Constructor Details</h2> |
| <ul class="member-list"> |
| <li> |
| <section class="detail" id="<init>(org.apache.calcite.sql.SqlDialect.Context)"> |
| <h3>RedshiftSqlDialect</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="element-name">RedshiftSqlDialect</span><wbr><span class="parameters">(<a href="../SqlDialect.Context.html" title="interface in org.apache.calcite.sql">SqlDialect.Context</a> context)</span></div> |
| <div class="block">Creates a RedshiftSqlDialect.</div> |
| </section> |
| </li> |
| </ul> |
| </section> |
| </li> |
| <!-- ============ METHOD DETAIL ========== --> |
| <li> |
| <section class="method-details" id="method-detail"> |
| <h2>Method Details</h2> |
| <ul class="member-list"> |
| <li> |
| <section class="detail" id="unparseOffsetFetch(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode,org.apache.calcite.sql.SqlNode)"> |
| <h3>unparseOffsetFetch</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">void</span> <span class="element-name">unparseOffsetFetch</span><wbr><span class="parameters">(<a href="../SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| @Nullable <a href="../SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> offset, |
| @Nullable <a href="../SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> fetch)</span></div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#unparseOffsetFetch(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode,org.apache.calcite.sql.SqlNode)">SqlDialect</a></code></span></div> |
| <div class="block">Converts an offset and fetch into SQL. |
| |
| <p>At least one of <code>offset</code> and <code>fetch</code> must be provided. |
| |
| <p>Common options: |
| <ul> |
| <li><code>OFFSET offset ROWS FETCH NEXT fetch ROWS ONLY</code> |
| (ANSI standard SQL, Oracle, PostgreSQL, and the default) |
| <li><code>LIMIT fetch OFFSET offset</code> (Apache Hive, MySQL, Redshift) |
| </ul></div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#unparseOffsetFetch(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode,org.apache.calcite.sql.SqlNode)">unparseOffsetFetch</a></code> in class <code><a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| <dt>Parameters:</dt> |
| <dd><code>writer</code> - Writer</dd> |
| <dd><code>offset</code> - Number of rows to skip before emitting, or null</dd> |
| <dd><code>fetch</code> - Number of rows to fetch, or null</dd> |
| <dt>See Also:</dt> |
| <dd> |
| <ul class="see-list-long"> |
| <li><a href="../SqlDialect.html#unparseFetchUsingAnsi(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode,org.apache.calcite.sql.SqlNode)"><code>SqlDialect.unparseFetchUsingAnsi(SqlWriter, SqlNode, SqlNode)</code></a></li> |
| <li><a href="../SqlDialect.html#unparseFetchUsingLimit(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlNode,org.apache.calcite.sql.SqlNode)"><code>SqlDialect.unparseFetchUsingLimit(SqlWriter, SqlNode, SqlNode)</code></a></li> |
| </ul> |
| </dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="supportsCharSet()"> |
| <h3>supportsCharSet</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">boolean</span> <span class="element-name">supportsCharSet</span>()</div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#supportsCharSet()">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether the dialect supports character set names as part of a |
| data type, for instance <code>VARCHAR(30) CHARACTER SET `ISO-8859-1`</code>.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#supportsCharSet()">supportsCharSet</a></code> in class <code><a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="getCastSpec(org.apache.calcite.rel.type.RelDataType)"> |
| <h3>getCastSpec</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">@Nullable <a href="../SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a></span> <span class="element-name">getCastSpec</span><wbr><span class="parameters">(<a href="../../rel/type/RelDataType.html" title="interface in org.apache.calcite.rel.type">RelDataType</a> type)</span></div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#getCastSpec(org.apache.calcite.rel.type.RelDataType)">SqlDialect</a></code></span></div> |
| <div class="block">Returns SqlNode for type in "cast(column as type)", which might be |
| different between databases by type name, precision etc. |
| |
| <p>If this method returns null, the cast will be omitted. In the default |
| implementation, this is the case for the NULL type, and therefore |
| <code>CAST(NULL AS <nulltype>)</code> is rendered as <code>NULL</code>.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#getCastSpec(org.apache.calcite.rel.type.RelDataType)">getCastSpec</a></code> in class <code><a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="supportsGroupByLiteral()"> |
| <h3>supportsGroupByLiteral</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">boolean</span> <span class="element-name">supportsGroupByLiteral</span>()</div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#supportsGroupByLiteral()">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether the dialect supports GROUP BY literals. |
| |
| <p>For instance, in <a href="../SqlDialect.DatabaseProduct.html#REDSHIFT"><code>SqlDialect.DatabaseProduct.REDSHIFT</code></a>, the following queries are illegal.</p> |
| <pre><code> |
| select avg(salary) |
| from emp |
| group by true |
| </code></pre> |
| |
| <pre><code> |
| select avg(salary) |
| from emp |
| group by 'a', DATE '2022-01-01' |
| </code></pre></div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#supportsGroupByLiteral()">supportsGroupByLiteral</a></code> in class <code><a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="supportsAliasedValues()"> |
| <h3>supportsAliasedValues</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">boolean</span> <span class="element-name">supportsAliasedValues</span>()</div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#supportsAliasedValues()">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether the dialect supports VALUES in a sub-query with |
| and an "AS t(column, ...)" values to define column names. |
| |
| <p>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.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#supportsAliasedValues()">supportsAliasedValues</a></code> in class <code><a href="../SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </section> |
| </li> |
| </ul> |
| </section> |
| </li> |
| </ul> |
| </section> |
| <!-- ========= END OF CLASS DATA ========= --> |
| </main> |
| <footer role="contentinfo"> |
| <hr> |
| <p class="legal-copy"><small>Copyright © 2012-2023 Apache Software Foundation. All Rights Reserved.</small></p> |
| </footer> |
| </div> |
| </div> |
| </body> |
| </html> |
