| <!DOCTYPE HTML> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc (17) --> |
| <title>BigQuerySqlDialect (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: BigQuerySqlDialect"> |
| <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 BigQuerySqlDialect" class="title">Class BigQuerySqlDialect</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.BigQuerySqlDialect</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">BigQuerySqlDialect</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 Google BigQuery's "Standard SQL" |
| dialect.</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> |
| <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">BigQuerySqlDialect</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 BigQuerySqlDialect.</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><a href="../parser/SqlParser.Config.html" title="interface in org.apache.calcite.sql.parser">SqlParser.Config</a></code></div> |
| <div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#configureParser(org.apache.calcite.sql.parser.SqlParser.Config)" class="member-name-link">configureParser</a><wbr>(<a href="../parser/SqlParser.Config.html" title="interface in org.apache.calcite.sql.parser">SqlParser.Config</a> configBuilder)</code></div> |
| <div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> |
| <div class="block">Copies settings from this dialect into a parser configuration.</div> |
| </div> |
| <div class="col-first odd-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 odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#emulateNullDirection(org.apache.calcite.sql.SqlNode,boolean,boolean)" class="member-name-link">emulateNullDirection</a><wbr>(<a href="../SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> node, |
| boolean nullsFirst, |
| boolean desc)</code></div> |
| <div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> |
| <div class="block">Returns the SqlNode for emulating the null direction for the given field |
| or <code>null</code> if no emulation needs to be done.</div> |
| </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>protected boolean</code></div> |
| <div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#identifierNeedsQuote(java.lang.String)" class="member-name-link">identifierNeedsQuote</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> val)</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 to quote an identifier.</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="#supportsAggregateFunctionFilter()" class="member-name-link">supportsAggregateFunctionFilter</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 this dialect supports the use of FILTER clauses for |
| aggregate functions.</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="#supportsApproxCountDistinct()" class="member-name-link">supportsApproxCountDistinct</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 this dialect supports APPROX_COUNT_DISTINCT functions.</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="#supportsImplicitTypeCoercion(org.apache.calcite.rex.RexCall)" class="member-name-link">supportsImplicitTypeCoercion</a><wbr>(<a href="../../rex/RexCall.html" title="class in org.apache.calcite.rex">RexCall</a> call)</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 implicit type coercion.</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="#supportsNestedAggregations()" class="member-name-link">supportsNestedAggregations</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 nested aggregations, for instance |
| <code>SELECT SUM(SUM(1)) </code>.</div> |
| </div> |
| <div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>void</code></div> |
| <div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#unparseCall(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlCall,int,int)" class="member-name-link">unparseCall</a><wbr>(<a href="../SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a> call, |
| int leftPrec, |
| int rightPrec)</code></div> |
| <div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> </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 class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>void</code></div> |
| <div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#unparseSqlIntervalLiteral(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlIntervalLiteral,int,int)" class="member-name-link">unparseSqlIntervalLiteral</a><wbr>(<a href="../SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../SqlIntervalLiteral.html" title="class in org.apache.calcite.sql">SqlIntervalLiteral</a> literal, |
| int leftPrec, |
| int rightPrec)</code></div> |
| <div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> |
| <div class="block">BigQuery interval syntax: INTERVAL int64 time_unit.</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="#unparseSqlIntervalQualifier(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlIntervalQualifier,org.apache.calcite.rel.type.RelDataTypeSystem)" class="member-name-link">unparseSqlIntervalQualifier</a><wbr>(<a href="../SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../SqlIntervalQualifier.html" title="class in org.apache.calcite.sql">SqlIntervalQualifier</a> qualifier, |
| <a href="../../rel/type/RelDataTypeSystem.html" title="interface in org.apache.calcite.rel.type">RelDataTypeSystem</a> typeSystem)</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 interval qualifier to a SQL string.</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.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#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#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#supportsCharSet()">supportsCharSet</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#supportsGroupByLiteral()">supportsGroupByLiteral</a>, <a href="../SqlDialect.html#supportsGroupByWithCube()">supportsGroupByWithCube</a>, <a href="../SqlDialect.html#supportsGroupByWithRollup()">supportsGroupByWithRollup</a>, <a href="../SqlDialect.html#supportsJoinType(org.apache.calcite.rel.core.JoinRelType)">supportsJoinType</a>, <a href="../SqlDialect.html#supportsOffsetFetch()">supportsOffsetFetch</a>, <a href="../SqlDialect.html#supportsWindowFunctions()">supportsWindowFunctions</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#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="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>BigQuerySqlDialect</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="element-name">BigQuerySqlDialect</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 BigQuerySqlDialect.</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="identifierNeedsQuote(java.lang.String)"> |
| <h3>identifierNeedsQuote</h3> |
| <div class="member-signature"><span class="modifiers">protected</span> <span class="return-type">boolean</span> <span class="element-name">identifierNeedsQuote</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> val)</span></div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#identifierNeedsQuote(java.lang.String)">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether to quote an identifier. |
| By default, all identifiers are quoted.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#identifierNeedsQuote(java.lang.String)">identifierNeedsQuote</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="emulateNullDirection(org.apache.calcite.sql.SqlNode,boolean,boolean)"> |
| <h3>emulateNullDirection</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">emulateNullDirection</span><wbr><span class="parameters">(<a href="../SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> node, |
| boolean nullsFirst, |
| boolean desc)</span></div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#emulateNullDirection(org.apache.calcite.sql.SqlNode,boolean,boolean)">SqlDialect</a></code></span></div> |
| <div class="block">Returns the SqlNode for emulating the null direction for the given field |
| or <code>null</code> if no emulation needs to be done.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#emulateNullDirection(org.apache.calcite.sql.SqlNode,boolean,boolean)">emulateNullDirection</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>node</code> - The SqlNode representing the expression</dd> |
| <dd><code>nullsFirst</code> - Whether nulls should come first</dd> |
| <dd><code>desc</code> - Whether the sort direction is |
| <a href="../../rel/RelFieldCollation.Direction.html#DESCENDING"><code>RelFieldCollation.Direction.DESCENDING</code></a> or |
| <a href="../../rel/RelFieldCollation.Direction.html#STRICTLY_DESCENDING"><code>RelFieldCollation.Direction.STRICTLY_DESCENDING</code></a></dd> |
| <dt>Returns:</dt> |
| <dd>A SqlNode for null direction emulation or <code>null</code> if not required</dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="supportsImplicitTypeCoercion(org.apache.calcite.rex.RexCall)"> |
| <h3>supportsImplicitTypeCoercion</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">boolean</span> <span class="element-name">supportsImplicitTypeCoercion</span><wbr><span class="parameters">(<a href="../../rex/RexCall.html" title="class in org.apache.calcite.rex">RexCall</a> call)</span></div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#supportsImplicitTypeCoercion(org.apache.calcite.rex.RexCall)">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether the dialect supports implicit type coercion. |
| |
| <p>Most of the sql dialects support implicit type coercion, so we make this method |
| default return true. For instance, "cast('10' as integer) > 5" |
| can be simplified to "'10' > 5" if the dialect supports implicit type coercion |
| for VARCHAR and INTEGER comparison. |
| |
| <p>For sql dialect that does not support implicit type coercion, such as the BigQuery, |
| we can not convert '10' into INT64 implicitly. |
| |
| <p>Now this method is used for some auxiliary decision when translating some <a href="../../rex/RexCall.html" title="class in org.apache.calcite.rex"><code>RexCall</code></a>s, |
| see SqlImplementor#stripCastFromString for details.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#supportsImplicitTypeCoercion(org.apache.calcite.rex.RexCall)">supportsImplicitTypeCoercion</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>call</code> - the call to make decision</dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="supportsApproxCountDistinct()"> |
| <h3>supportsApproxCountDistinct</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">boolean</span> <span class="element-name">supportsApproxCountDistinct</span>()</div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#supportsApproxCountDistinct()">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether this dialect supports APPROX_COUNT_DISTINCT functions.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#supportsApproxCountDistinct()">supportsApproxCountDistinct</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="supportsNestedAggregations()"> |
| <h3>supportsNestedAggregations</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">boolean</span> <span class="element-name">supportsNestedAggregations</span>()</div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#supportsNestedAggregations()">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether the dialect supports nested aggregations, for instance |
| <code>SELECT SUM(SUM(1)) </code>.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#supportsNestedAggregations()">supportsNestedAggregations</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="supportsAggregateFunctionFilter()"> |
| <h3>supportsAggregateFunctionFilter</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">boolean</span> <span class="element-name">supportsAggregateFunctionFilter</span>()</div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#supportsAggregateFunctionFilter()">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether this dialect supports the use of FILTER clauses for |
| aggregate functions. e.g. <code>COUNT(*) FILTER (WHERE a = 2)</code>.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#supportsAggregateFunctionFilter()">supportsAggregateFunctionFilter</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="configureParser(org.apache.calcite.sql.parser.SqlParser.Config)"> |
| <h3>configureParser</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type"><a href="../parser/SqlParser.Config.html" title="interface in org.apache.calcite.sql.parser">SqlParser.Config</a></span> <span class="element-name">configureParser</span><wbr><span class="parameters">(<a href="../parser/SqlParser.Config.html" title="interface in org.apache.calcite.sql.parser">SqlParser.Config</a> configBuilder)</span></div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#configureParser(org.apache.calcite.sql.parser.SqlParser.Config)">SqlDialect</a></code></span></div> |
| <div class="block">Copies settings from this dialect into a parser configuration. |
| |
| <p><code>SqlDialect</code>, <a href="../parser/SqlParser.Config.html" title="interface in org.apache.calcite.sql.parser"><code>SqlParser.Config</code></a> and <a href="../validate/SqlConformance.html" title="interface in org.apache.calcite.sql.validate"><code>SqlConformance</code></a> |
| cover different aspects of the same thing - the dialect of SQL spoken by a |
| database - and this method helps to bridge between them. (The aspects are, |
| respectively, generating SQL to send to a source database, parsing SQL |
| sent to Calcite, and validating queries sent to Calcite. It makes sense to |
| keep them as separate interfaces because they are used by different |
| modules.) |
| |
| <p>The settings copied may differ among dialects, and may change over time, |
| but currently include the following: |
| |
| <ul> |
| <li><a href="../SqlDialect.html#getQuoting()"><code>SqlDialect.getQuoting()</code></a> |
| <li><a href="../SqlDialect.html#getQuotedCasing()"><code>SqlDialect.getQuotedCasing()</code></a> |
| <li><a href="../SqlDialect.html#getUnquotedCasing()"><code>SqlDialect.getUnquotedCasing()</code></a> |
| <li><a href="../SqlDialect.html#isCaseSensitive()"><code>SqlDialect.isCaseSensitive()</code></a> |
| <li><a href="../SqlDialect.html#getConformance()"><code>SqlDialect.getConformance()</code></a> |
| </ul></div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#configureParser(org.apache.calcite.sql.parser.SqlParser.Config)">configureParser</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>configBuilder</code> - Parser configuration builder</dd> |
| <dt>Returns:</dt> |
| <dd>The configuration builder</dd> |
| </dl> |
| </section> |
| </li> |
| <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="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> |
| <li> |
| <section class="detail" id="unparseCall(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlCall,int,int)"> |
| <h3>unparseCall</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">void</span> <span class="element-name">unparseCall</span><wbr><span class="parameters">(<a href="../SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a> call, |
| int leftPrec, |
| int rightPrec)</span></div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#unparseCall(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlCall,int,int)">unparseCall</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="unparseSqlIntervalLiteral(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlIntervalLiteral,int,int)"> |
| <h3>unparseSqlIntervalLiteral</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">void</span> <span class="element-name">unparseSqlIntervalLiteral</span><wbr><span class="parameters">(<a href="../SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../SqlIntervalLiteral.html" title="class in org.apache.calcite.sql">SqlIntervalLiteral</a> literal, |
| int leftPrec, |
| int rightPrec)</span></div> |
| <div class="block">BigQuery interval syntax: INTERVAL int64 time_unit.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#unparseSqlIntervalLiteral(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlIntervalLiteral,int,int)">unparseSqlIntervalLiteral</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="unparseSqlIntervalQualifier(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlIntervalQualifier,org.apache.calcite.rel.type.RelDataTypeSystem)"> |
| <h3>unparseSqlIntervalQualifier</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type">void</span> <span class="element-name">unparseSqlIntervalQualifier</span><wbr><span class="parameters">(<a href="../SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../SqlIntervalQualifier.html" title="class in org.apache.calcite.sql">SqlIntervalQualifier</a> qualifier, |
| <a href="../../rel/type/RelDataTypeSystem.html" title="interface in org.apache.calcite.rel.type">RelDataTypeSystem</a> typeSystem)</span></div> |
| <div class="block"><span class="descfrm-type-label">Description copied from class: <code><a href="../SqlDialect.html#unparseSqlIntervalQualifier(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlIntervalQualifier,org.apache.calcite.rel.type.RelDataTypeSystem)">SqlDialect</a></code></span></div> |
| <div class="block">Converts an interval qualifier to a SQL string. The default implementation |
| returns strings such as |
| <code>INTERVAL '1 2:3:4' DAY(4) TO SECOND(4)</code>.</div> |
| <dl class="notes"> |
| <dt>Overrides:</dt> |
| <dd><code><a href="../SqlDialect.html#unparseSqlIntervalQualifier(org.apache.calcite.sql.SqlWriter,org.apache.calcite.sql.SqlIntervalQualifier,org.apache.calcite.rel.type.RelDataTypeSystem)">unparseSqlIntervalQualifier</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">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>. |
| |
| <p>BigQuery data type reference: |
| <a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types"> |
| BigQuery Standard SQL Data Types</a>.</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> |
| </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> |
