| <!DOCTYPE HTML> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc (17) --> |
| <title>SqlKind (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, enum: SqlKind"> |
| <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="#enum-constant-summary">Enum Constants</a> | </li> |
| <li><a href="#field-summary">Field</a> | </li> |
| <li><a href="#method-summary">Method</a></li> |
| </ul> |
| <ul class="sub-nav-list"> |
| <li>Detail: </li> |
| <li><a href="#enum-constant-detail">Enum Constants</a> | </li> |
| <li><a href="#field-detail">Field</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</a></div> |
| <h1 title="Enum SqlKind" class="title">Enum SqlKind</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="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.html" title="class or interface in java.lang" class="external-link">java.lang.Enum</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> |
| <div class="inheritance">org.apache.calcite.sql.SqlKind</div> |
| </div> |
| </div> |
| <section class="class-description" id="class-description"> |
| <dl class="notes"> |
| <dt>All Implemented Interfaces:</dt> |
| <dd><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/io/Serializable.html" title="class or interface in java.io" class="external-link">Serializable</a></code>, <code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Comparable.html" title="class or interface in java.lang" class="external-link">Comparable</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code>, <code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/constant/Constable.html" title="class or interface in java.lang.constant" class="external-link">Constable</a></code></dd> |
| </dl> |
| <hr> |
| <div class="type-signature"><span class="modifiers">public enum </span><span class="element-name type-name-label">SqlKind</span> |
| <span class="extends-implements">extends <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.html" title="class or interface in java.lang" class="external-link">Enum</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span></div> |
| <div class="block">Enumerates the possible types of <a href="SqlNode.html" title="class in org.apache.calcite.sql"><code>SqlNode</code></a>. |
| |
| <p>The values are immutable, canonical constants, so you can use Kinds to |
| find particular types of expressions quickly. To identity a call to a common |
| operator such as '=', use <a href="SqlNode.html#isA(java.util.Set)"><code>SqlNode.isA(java.util.Set<org.apache.calcite.sql.SqlKind>)</code></a>:</p> |
| |
| <blockquote> |
| exp.<a href="SqlNode.html#isA(java.util.Set)"><code>isA</code></a>(<a href="#EQUALS"><code>EQUALS</code></a>) |
| </blockquote> |
| |
| <p>Only commonly-used nodes have their own type; other nodes are of type |
| <a href="#OTHER"><code>OTHER</code></a>. Some of the values, such as <a href="#SET_QUERY"><code>SET_QUERY</code></a>, represent |
| aggregates.</p> |
| |
| <p>To quickly choose between a number of options, use a switch statement:</p> |
| |
| <blockquote> |
| <pre>switch (exp.getKind()) { |
| case <a href="#EQUALS"><code>EQUALS</code></a>: |
| ...; |
| case <a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a>: |
| ...; |
| default: |
| throw new AssertionError("unexpected"); |
| }</pre> |
| </blockquote> |
| |
| <p>Note that we do not even have to check that a <code>SqlNode</code> is a |
| <a href="SqlCall.html" title="class in org.apache.calcite.sql"><code>SqlCall</code></a>.</p> |
| |
| <p>To identify a category of expressions, use <code>SqlNode.isA</code> with |
| an aggregate SqlKind. The following expression will return <code>true</code> |
| for calls to '=' and '>=', but <code>false</code> for the constant '5', or |
| a call to '+':</p> |
| |
| <blockquote> |
| <pre>exp.isA(<a href="#COMPARISON"><code>SqlKind.COMPARISON</code></a>)</pre> |
| </blockquote> |
| |
| <p>RexNode also has a <code>getKind</code> method; <code>SqlKind</code> values are |
| preserved during translation from <code>SqlNode</code> to <code>RexNode</code>, where |
| applicable.</p> |
| |
| <p>There is no water-tight definition of "common", but that's OK. There will |
| always be operators that don't have their own kind, and for these we use the |
| <code>SqlOperator</code>. But for really the common ones, e.g. the many places |
| where we are looking for <code>AND</code>, <code>OR</code> and <code>EQUALS</code>, the enum |
| helps.</p> |
| |
| <p>(If we were using Scala, <a href="SqlOperator.html" title="class in org.apache.calcite.sql"><code>SqlOperator</code></a> would be a case |
| class, and we wouldn't need <code>SqlKind</code>. But we're not.)</p></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-java.lang.Enum">Nested classes/interfaces inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.html" title="class or interface in java.lang" class="external-link">Enum</a></h2> |
| <code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.EnumDesc.html" title="class or interface in java.lang" class="external-link">Enum.EnumDesc</a><<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.EnumDesc.html" title="class or interface in java.lang" class="external-link">E</a> extends <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.html" title="class or interface in java.lang" class="external-link">Enum</a><<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.EnumDesc.html" title="class or interface in java.lang" class="external-link">E</a>>></code></div> |
| </section> |
| </li> |
| <!-- =========== ENUM CONSTANT SUMMARY =========== --> |
| <li> |
| <section class="constants-summary" id="enum-constant-summary"> |
| <h2>Enum Constant Summary</h2> |
| <div class="caption"><span>Enum Constants</span></div> |
| <div class="summary-table two-column-summary"> |
| <div class="table-header col-first">Enum Constant</div> |
| <div class="table-header col-last">Description</div> |
| <div class="col-first even-row-color"><code><a href="#AGGREGATE_FN" class="member-name-link">AGGREGATE_FN</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>AGGREGATE</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ALL" class="member-name-link">ALL</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>ALL</code> quantification operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ALTER_INDEX" class="member-name-link">ALTER_INDEX</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>ALTER INDEX</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ALTER_MATERIALIZED_VIEW" class="member-name-link">ALTER_MATERIALIZED_VIEW</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>ALTER MATERIALIZED VIEW</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ALTER_SEQUENCE" class="member-name-link">ALTER_SEQUENCE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>ALTER SEQUENCE</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ALTER_SESSION" class="member-name-link">ALTER_SESSION</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>ALTER SESSION</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ALTER_TABLE" class="member-name-link">ALTER_TABLE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>ALTER TABLE</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ALTER_VIEW" class="member-name-link">ALTER_VIEW</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>ALTER VIEW</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#AND" class="member-name-link">AND</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Logical "AND" operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ANY_VALUE" class="member-name-link">ANY_VALUE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>ANY_VALUE</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ARG_MAX" class="member-name-link">ARG_MAX</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>ARG_MAX</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ARG_MIN" class="member-name-link">ARG_MIN</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>ARG_MIN</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ARGUMENT_ASSIGNMENT" class="member-name-link">ARGUMENT_ASSIGNMENT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Argument assignment operator, <code>=></code>.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ARRAY_AGG" class="member-name-link">ARRAY_AGG</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>ARRAY_AGG</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ARRAY_CONCAT" class="member-name-link">ARRAY_CONCAT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>ARRAY_CONCAT</code> function (BigQuery semantics).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ARRAY_CONCAT_AGG" class="member-name-link">ARRAY_CONCAT_AGG</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>ARRAY_CONCAT_AGG</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ARRAY_QUERY_CONSTRUCTOR" class="member-name-link">ARRAY_QUERY_CONSTRUCTOR</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Array Query Constructor, e.g.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ARRAY_REVERSE" class="member-name-link">ARRAY_REVERSE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>ARRAY_REVERSE</code> function (BigQuery semantics).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ARRAY_VALUE_CONSTRUCTOR" class="member-name-link">ARRAY_VALUE_CONSTRUCTOR</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Array Value Constructor, e.g.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#AS" class="member-name-link">AS</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>AS</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ATTRIBUTE_DEF" class="member-name-link">ATTRIBUTE_DEF</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Attribute definition.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#AVG" class="member-name-link">AVG</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>AVG</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#BETWEEN" class="member-name-link">BETWEEN</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>BETWEEN</code> operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#BIT_AND" class="member-name-link">BIT_AND</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>BIT_AND</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#BIT_OR" class="member-name-link">BIT_OR</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>BIT_OR</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#BIT_XOR" class="member-name-link">BIT_XOR</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>BIT_XOR</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CASE" class="member-name-link">CASE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>CASE</code> expression.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#CAST" class="member-name-link">CAST</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The "CAST" operator, and also the PostgreSQL-style infix cast operator |
| "::".</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CEIL" class="member-name-link">CEIL</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>CEIL</code> function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#CHECK" class="member-name-link">CHECK</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>CHECK</code> constraint.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CLASSIFIER" class="member-name-link">CLASSIFIER</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>CLASSIFIER</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#COALESCE" class="member-name-link">COALESCE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>COALESCE</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#COLLECT" class="member-name-link">COLLECT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>COLLECT</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#COLLECTION_TABLE" class="member-name-link">COLLECTION_TABLE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Table operator which converts user-defined transform into a relation, for |
| example, <code>select * from TABLE(udx(x, y, z))</code>.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#COLUMN_DECL" class="member-name-link">COLUMN_DECL</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Column declaration.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#COLUMN_LIST" class="member-name-link">COLUMN_LIST</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The non-standard constructor used to pass a |
| COLUMN_LIST parameter to a user-defined transform.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#COMMIT" class="member-name-link">COMMIT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>COMMIT</code> session control statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#CONCAT2" class="member-name-link">CONCAT2</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The two-argument <code>CONCAT</code> function (Oracle).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CONTAINS" class="member-name-link">CONTAINS</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>CONTAINS</code> operator for periods.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#CORREL_VARIABLE" class="member-name-link">CORREL_VARIABLE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Reference to correlation variable.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#COUNT" class="member-name-link">COUNT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>COUNT</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#COUNTIF" class="member-name-link">COUNTIF</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>COUNTIF</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#COVAR_POP" class="member-name-link">COVAR_POP</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>COVAR_POP</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#COVAR_SAMP" class="member-name-link">COVAR_SAMP</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>COVAR_SAMP</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CREATE_FOREIGN_SCHEMA" class="member-name-link">CREATE_FOREIGN_SCHEMA</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>CREATE FOREIGN SCHEMA</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#CREATE_FUNCTION" class="member-name-link">CREATE_FUNCTION</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>CREATE FUNCTION</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CREATE_INDEX" class="member-name-link">CREATE_INDEX</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>CREATE INDEX</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#CREATE_MATERIALIZED_VIEW" class="member-name-link">CREATE_MATERIALIZED_VIEW</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>CREATE MATERIALIZED VIEW</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CREATE_SCHEMA" class="member-name-link">CREATE_SCHEMA</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>CREATE SCHEMA</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#CREATE_SEQUENCE" class="member-name-link">CREATE_SEQUENCE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>CREATE SEQUENCE</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CREATE_TABLE" class="member-name-link">CREATE_TABLE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>CREATE TABLE</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#CREATE_TYPE" class="member-name-link">CREATE_TYPE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>CREATE TYPE</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CREATE_VIEW" class="member-name-link">CREATE_VIEW</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>CREATE VIEW</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#CUBE" class="member-name-link">CUBE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The internal <code>CUBE</code> operator that occurs within a <code>GROUP BY</code> |
| clause.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CUME_DIST" class="member-name-link">CUME_DIST</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>ROW_NUMBER</code> window function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#CURRENT_VALUE" class="member-name-link">CURRENT_VALUE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The "CURRENT VALUE OF sequence" operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#CURSOR" class="member-name-link">CURSOR</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>CURSOR</code> constructor, for example, <code>SELECT * FROM |
| TABLE(udx(CURSOR(SELECT ...), x, y, z))</code>.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DATE_SUB" class="member-name-link">DATE_SUB</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>DATE_SUB</code> function (BigQuery).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DECODE" class="member-name-link">DECODE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>DECODE</code> function (Oracle).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DEFAULT" class="member-name-link">DEFAULT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>DEFAULT</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DELETE" class="member-name-link">DELETE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">DELETE statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DENSE_RANK" class="member-name-link">DENSE_RANK</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>DENSE_RANK</code> window function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DESCENDING" class="member-name-link">DESCENDING</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>DESC</code> operator in <code>ORDER BY</code>.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DESCRIBE_SCHEMA" class="member-name-link">DESCRIBE_SCHEMA</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">DESCRIBE SCHEMA statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DESCRIBE_TABLE" class="member-name-link">DESCRIBE_TABLE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">DESCRIBE TABLE statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DESCRIPTOR" class="member-name-link">DESCRIPTOR</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>DESCRIPTOR(column_name, ...)</code>.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DIVIDE" class="member-name-link">DIVIDE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Arithmetic division operator, "/".</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DOT" class="member-name-link">DOT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Dot.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DROP_FUNCTION" class="member-name-link">DROP_FUNCTION</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>DROP FUNCTION</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DROP_INDEX" class="member-name-link">DROP_INDEX</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>DROP INDEX</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DROP_MATERIALIZED_VIEW" class="member-name-link">DROP_MATERIALIZED_VIEW</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>DROP MATERIALIZED VIEW</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DROP_SCHEMA" class="member-name-link">DROP_SCHEMA</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>DROP SCHEMA</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DROP_SEQUENCE" class="member-name-link">DROP_SEQUENCE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>DROP SEQUENCE</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DROP_TABLE" class="member-name-link">DROP_TABLE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>DROP TABLE</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DROP_TYPE" class="member-name-link">DROP_TYPE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>DROP TYPE</code> DDL statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DROP_VIEW" class="member-name-link">DROP_VIEW</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>DROP VIEW</code> DDL statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DRUID_BETWEEN" class="member-name-link">DRUID_BETWEEN</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Variant of <code>BETWEEN</code> for the Druid adapter.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DRUID_IN" class="member-name-link">DRUID_IN</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Variant of <code>IN</code> for the Druid adapter.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#DRUID_NOT_IN" class="member-name-link">DRUID_NOT_IN</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Variant of <code>NOT_IN</code> for the Druid adapter.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#DYNAMIC_PARAM" class="member-name-link">DYNAMIC_PARAM</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">A dynamic parameter.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#EQUALS" class="member-name-link">EQUALS</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Equals operator, "=".</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ESCAPE" class="member-name-link">ESCAPE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Escape operator (always part of LIKE or SIMILAR TO expression).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#EXCEPT" class="member-name-link">EXCEPT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>EXCEPT</code> relational operator (known as <code>MINUS</code> in some SQL |
| dialects).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#EXISTS" class="member-name-link">EXISTS</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>EXISTS</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#EXPLAIN" class="member-name-link">EXPLAIN</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">EXPLAIN statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#EXPLICIT_TABLE" class="member-name-link">EXPLICIT_TABLE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Explicit table, e.g.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#EXTEND" class="member-name-link">EXTEND</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The internal <code>EXTEND</code> operator that qualifies a table name in the |
| <code>FROM</code> clause.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#EXTRACT" class="member-name-link">EXTRACT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>EXTRACT</code> function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#FIELD_ACCESS" class="member-name-link">FIELD_ACCESS</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The field access operator, ".".</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#FILTER" class="member-name-link">FILTER</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>FILTER</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#FINAL" class="member-name-link">FINAL</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>FINAL</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#FIRST" class="member-name-link">FIRST</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>FIRST</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#FIRST_VALUE" class="member-name-link">FIRST_VALUE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>FIRST_VALUE</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#FLOOR" class="member-name-link">FLOOR</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>FLOOR</code> function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#FOLLOWING" class="member-name-link">FOLLOWING</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>FOLLOWING</code> qualifier of an interval end-point in a window |
| specification.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#FOREIGN_KEY" class="member-name-link">FOREIGN_KEY</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>FOREIGN KEY</code> constraint.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#FUSION" class="member-name-link">FUSION</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>FUSION</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#GREATER_THAN" class="member-name-link">GREATER_THAN</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Greater-than operator, ">".</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#GREATER_THAN_OR_EQUAL" class="member-name-link">GREATER_THAN_OR_EQUAL</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Greater-than-or-equal operator, ">=".</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#GREATEST" class="member-name-link">GREATEST</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>GREATEST</code> function (Oracle).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#GROUP_BY_DISTINCT" class="member-name-link">GROUP_BY_DISTINCT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The DISTINCT keyword of the GROUP BY clause.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#GROUP_CONCAT" class="member-name-link">GROUP_CONCAT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>GROUP_CONCAT</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#GROUP_ID" class="member-name-link">GROUP_ID</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>GROUP_ID()</code> function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#GROUPING" class="member-name-link">GROUPING</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>GROUPING(e, ...)</code> function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#GROUPING_ID" class="member-name-link">GROUPING_ID</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><span class="deprecated-label">Deprecated.</span> |
| <div class="deprecation-comment">Use <a href="#GROUPING"><code>GROUPING</code></a>.</div> |
| </div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#GROUPING_SETS" class="member-name-link">GROUPING_SETS</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The internal <code>GROUPING SETS</code> operator that occurs within a |
| <code>GROUP BY</code> clause.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#HILBERT" class="member-name-link">HILBERT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>Hilbert</code> function that converts (x, y) to a position on a |
| Hilbert space-filling curve.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#HINT" class="member-name-link">HINT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Sql Hint statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#HOP" class="member-name-link">HOP</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>HOP</code> group function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#HOP_END" class="member-name-link">HOP_END</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>HOP_END</code> auxiliary function of |
| the <a href="#HOP"><code>HOP</code></a> group function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#HOP_START" class="member-name-link">HOP_START</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>HOP_START</code> auxiliary function of |
| the <a href="#HOP"><code>HOP</code></a> group function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#IDENTIFIER" class="member-name-link">IDENTIFIER</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">An identifier.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#IF" class="member-name-link">IF</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The "IF" function (BigQuery, Hive, Spark).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#IGNORE_NULLS" class="member-name-link">IGNORE_NULLS</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>IGNORE NULLS</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#IMMEDIATELY_PRECEDES" class="member-name-link">IMMEDIATELY_PRECEDES</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>IMMEDIATELY PRECEDES</code> operator for periods.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#IMMEDIATELY_SUCCEEDS" class="member-name-link">IMMEDIATELY_SUCCEEDS</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>IMMEDIATELY SUCCEEDS</code> operator for periods.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#IN" class="member-name-link">IN</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>IN</code> operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#INPUT_REF" class="member-name-link">INPUT_REF</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Reference to an input field.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#INSERT" class="member-name-link">INSERT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">INSERT statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#INTERSECT" class="member-name-link">INTERSECT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>INTERSECT</code> relational operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#INTERSECTION" class="member-name-link">INTERSECTION</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>INTERSECTION</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#INTERVAL" class="member-name-link">INTERVAL</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>INTERVAL</code> expression.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#INTERVAL_QUALIFIER" class="member-name-link">INTERVAL_QUALIFIER</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Interval qualifier.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#IS_DISTINCT_FROM" class="member-name-link">IS_DISTINCT_FROM</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>IS DISTINCT FROM</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#IS_FALSE" class="member-name-link">IS_FALSE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>IS FALSE</code> operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#IS_NOT_DISTINCT_FROM" class="member-name-link">IS_NOT_DISTINCT_FROM</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>IS NOT DISTINCT FROM</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#IS_NOT_FALSE" class="member-name-link">IS_NOT_FALSE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>IS NOT FALSE</code> operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#IS_NOT_NULL" class="member-name-link">IS_NOT_NULL</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>IS NOT NULL</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#IS_NOT_TRUE" class="member-name-link">IS_NOT_TRUE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>IS NOT TRUE</code> operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#IS_NULL" class="member-name-link">IS_NULL</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>IS NULL</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#IS_TRUE" class="member-name-link">IS_TRUE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>IS TRUE</code> operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#IS_UNKNOWN" class="member-name-link">IS_UNKNOWN</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>IS UNKNOWN</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ITEM" class="member-name-link">ITEM</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Item expression.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#JDBC_FN" class="member-name-link">JDBC_FN</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Call to a function using JDBC function syntax.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#JOIN" class="member-name-link">JOIN</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">JOIN operator or compound FROM clause.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#JSON_ARRAYAGG" class="member-name-link">JSON_ARRAYAGG</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>JSON_ARRAYAGG</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#JSON_OBJECTAGG" class="member-name-link">JSON_OBJECTAGG</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>JSON_OBJECTAGG</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#JSON_TYPE" class="member-name-link">JSON_TYPE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>JSON</code> type function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#JSON_VALUE_EXPRESSION" class="member-name-link">JSON_VALUE_EXPRESSION</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>JSON</code> value expression.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#LAG" class="member-name-link">LAG</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>LAG</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#LAST" class="member-name-link">LAST</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>LAST</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#LAST_VALUE" class="member-name-link">LAST_VALUE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>LAST_VALUE</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#LATERAL" class="member-name-link">LATERAL</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The "LATERAL" qualifier to relations in the FROM clause.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#LEAD" class="member-name-link">LEAD</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>LEAD</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#LEAST" class="member-name-link">LEAST</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>LEAST</code> function (Oracle).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#LESS_THAN" class="member-name-link">LESS_THAN</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Less-than operator, "<".</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#LESS_THAN_OR_EQUAL" class="member-name-link">LESS_THAN_OR_EQUAL</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Less-than-or-equal operator, "<=".</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#LIKE" class="member-name-link">LIKE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>LIKE</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#LISTAGG" class="member-name-link">LISTAGG</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>LISTAGG</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#LITERAL" class="member-name-link">LITERAL</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">A literal.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#LITERAL_CHAIN" class="member-name-link">LITERAL_CHAIN</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Literal chain operator (for composite string literals).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#LOCAL_REF" class="member-name-link">LOCAL_REF</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Reference to a sub-expression computed within the current relational |
| operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#LTRIM" class="member-name-link">LTRIM</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>LTRIM</code> function (Oracle).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#MAP_QUERY_CONSTRUCTOR" class="member-name-link">MAP_QUERY_CONSTRUCTOR</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">MAP query constructor, |
| e.g.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#MAP_VALUE_CONSTRUCTOR" class="member-name-link">MAP_VALUE_CONSTRUCTOR</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">MAP value constructor, e.g.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#MATCH_NUMBER" class="member-name-link">MATCH_NUMBER</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>MATCH_NUMBER</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#MATCH_RECOGNIZE" class="member-name-link">MATCH_RECOGNIZE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">MATCH_RECOGNIZE clause.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#MAX" class="member-name-link">MAX</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>MAX</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#MERGE" class="member-name-link">MERGE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">MERGE statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#MIN" class="member-name-link">MIN</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>MIN</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#MINUS" class="member-name-link">MINUS</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Arithmetic minus operator, "-".</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#MINUS_PREFIX" class="member-name-link">MINUS_PREFIX</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Unary minus operator, as in "-1".</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#MOD" class="member-name-link">MOD</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Arithmetic remainder operator, "MOD" (and "%" in some dialects).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#MODE" class="member-name-link">MODE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>MODE</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#MULTISET_QUERY_CONSTRUCTOR" class="member-name-link">MULTISET_QUERY_CONSTRUCTOR</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>MULTISET</code> query constructor.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#MULTISET_VALUE_CONSTRUCTOR" class="member-name-link">MULTISET_VALUE_CONSTRUCTOR</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>MULTISET</code> value constructor.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#NEW_SPECIFICATION" class="member-name-link">NEW_SPECIFICATION</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">New specification.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#NEXT" class="member-name-link">NEXT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>NEXT</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#NEXT_VALUE" class="member-name-link">NEXT_VALUE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The "NEXT VALUE OF sequence" operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#NOT" class="member-name-link">NOT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Logical <code>NOT</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#NOT_EQUALS" class="member-name-link">NOT_EQUALS</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Not-equals operator, "!=" or "<>".</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#NOT_IN" class="member-name-link">NOT_IN</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>NOT IN</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#NTH_VALUE" class="member-name-link">NTH_VALUE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>NTH_VALUE</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#NTILE" class="member-name-link">NTILE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>NTILE</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#NULLIF" class="member-name-link">NULLIF</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>NULLIF</code> operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#NULLS_FIRST" class="member-name-link">NULLS_FIRST</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>NULLS FIRST</code> clause in <code>ORDER BY</code>.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#NULLS_LAST" class="member-name-link">NULLS_LAST</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>NULLS LAST</code> clause in <code>ORDER BY</code>.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#NVL" class="member-name-link">NVL</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>NVL</code> function (Oracle).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#OR" class="member-name-link">OR</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Logical "OR" operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ORDER_BY" class="member-name-link">ORDER_BY</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">ORDER BY clause.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#OTHER" class="member-name-link">OTHER</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Expression not covered by any other <a href="SqlKind.html" title="enum in org.apache.calcite.sql"><code>SqlKind</code></a> value.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#OTHER_DDL" class="member-name-link">OTHER_DDL</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">DDL statement not handled above.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#OTHER_FUNCTION" class="member-name-link">OTHER_FUNCTION</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Function that is not a special function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#OVER" class="member-name-link">OVER</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>OVER</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#OVERLAPS" class="member-name-link">OVERLAPS</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>OVERLAPS</code> operator for periods.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#PATTERN_ALTER" class="member-name-link">PATTERN_ALTER</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Alternation operator in a pattern expression within a |
| <code>MATCH_RECOGNIZE</code> clause.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#PATTERN_CONCAT" class="member-name-link">PATTERN_CONCAT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Concatenation operator in a pattern expression within a |
| <code>MATCH_RECOGNIZE</code> clause.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#PATTERN_EXCLUDED" class="member-name-link">PATTERN_EXCLUDED</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The special patterns to exclude enclosing pattern from output in a |
| MATCH_RECOGNIZE clause.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#PATTERN_INPUT_REF" class="member-name-link">PATTERN_INPUT_REF</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Reference to an input field, with pattern var as modifier.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#PATTERN_PERMUTE" class="member-name-link">PATTERN_PERMUTE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The internal "permute" function in a MATCH_RECOGNIZE clause.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#PATTERN_QUANTIFIER" class="member-name-link">PATTERN_QUANTIFIER</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">the repetition quantifier of a pattern factor in a match_recognize clause.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#PERCENT_RANK" class="member-name-link">PERCENT_RANK</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>PERCENT_RANK</code> window function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#PERCENTILE_CONT" class="member-name-link">PERCENTILE_CONT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>PERCENTILE_CONT</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#PERCENTILE_DISC" class="member-name-link">PERCENTILE_DISC</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>PERCENTILE_DISC</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#PERIOD_EQUALS" class="member-name-link">PERIOD_EQUALS</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>EQUALS</code> operator for periods.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#PIVOT" class="member-name-link">PIVOT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">PIVOT clause.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#PLUS" class="member-name-link">PLUS</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Arithmetic plus operator, "+".</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#PLUS_PREFIX" class="member-name-link">PLUS_PREFIX</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Unary plus operator, as in "+1".</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#POSITION" class="member-name-link">POSITION</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">POSITION function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#POSIX_REGEX_CASE_INSENSITIVE" class="member-name-link">POSIX_REGEX_CASE_INSENSITIVE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>~*</code> operator (for case-insensitive POSIX-style regular |
| expressions).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#POSIX_REGEX_CASE_SENSITIVE" class="member-name-link">POSIX_REGEX_CASE_SENSITIVE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>~</code> operator (for POSIX-style regular expressions).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#PRECEDES" class="member-name-link">PRECEDES</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>PRECEDES</code> operator for periods.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#PRECEDING" class="member-name-link">PRECEDING</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>PRECEDING</code> qualifier of an interval end-point in a window |
| specification.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#PREV" class="member-name-link">PREV</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>PREV</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#PRIMARY_KEY" class="member-name-link">PRIMARY_KEY</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>PRIMARY KEY</code> constraint.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#PROCEDURE_CALL" class="member-name-link">PROCEDURE_CALL</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Procedure call.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#RANK" class="member-name-link">RANK</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>RANK</code> window function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#REGR_COUNT" class="member-name-link">REGR_COUNT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>REGR_COUNT</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#REGR_SXX" class="member-name-link">REGR_SXX</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>REGR_SXX</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#REGR_SYY" class="member-name-link">REGR_SYY</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>REGR_SYY</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#REINTERPRET" class="member-name-link">REINTERPRET</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The internal REINTERPRET operator (meaning a reinterpret cast).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#RESPECT_NULLS" class="member-name-link">RESPECT_NULLS</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>RESPECT NULLS</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#REVERSE" class="member-name-link">REVERSE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>REVERSE</code> function (SQL Server, MySQL).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#RLIKE" class="member-name-link">RLIKE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>RLIKE</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ROLLBACK" class="member-name-link">ROLLBACK</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>ROLLBACK</code> session control statement.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ROLLUP" class="member-name-link">ROLLUP</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The internal <code>ROLLUP</code> operator that occurs within a <code>GROUP BY</code> |
| clause.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ROW" class="member-name-link">ROW</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The row-constructor function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ROW_NUMBER" class="member-name-link">ROW_NUMBER</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>ROW_NUMBER</code> window function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#RTRIM" class="member-name-link">RTRIM</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>RTRIM</code> function (Oracle).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#RUNNING" class="member-name-link">RUNNING</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>FINAL</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SCALAR_QUERY" class="member-name-link">SCALAR_QUERY</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Scalar query; that is, a sub-query used in an expression context, and |
| returning one row and one column.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SEARCH" class="member-name-link">SEARCH</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>SEARCH</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SELECT" class="member-name-link">SELECT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">SELECT statement or sub-query.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SEPARATOR" class="member-name-link">SEPARATOR</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>SEPARATOR</code> expression.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SESSION" class="member-name-link">SESSION</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>SESSION</code> group function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SESSION_END" class="member-name-link">SESSION_END</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>SESSION_END</code> auxiliary function of |
| the <a href="#SESSION"><code>SESSION</code></a> group function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SESSION_START" class="member-name-link">SESSION_START</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>SESSION_START</code> auxiliary function of |
| the <a href="#SESSION"><code>SESSION</code></a> group function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SET_OPTION" class="member-name-link">SET_OPTION</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">"<code>ALTER scope SET option = value</code>" statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SET_SEMANTICS_TABLE" class="member-name-link">SET_SEMANTICS_TABLE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Input tables have either row semantics or set semantics.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SIMILAR" class="member-name-link">SIMILAR</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>SIMILAR</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SINGLE_VALUE" class="member-name-link">SINGLE_VALUE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>SINGLE_VALUE</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SKIP_TO_FIRST" class="member-name-link">SKIP_TO_FIRST</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>SKIP TO FIRST</code> qualifier of restarting point in a |
| <code>MATCH_RECOGNIZE</code> clause.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SKIP_TO_LAST" class="member-name-link">SKIP_TO_LAST</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>SKIP TO LAST</code> qualifier of restarting point in a |
| <code>MATCH_RECOGNIZE</code> clause.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SNAPSHOT" class="member-name-link">SNAPSHOT</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">SNAPSHOT operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SOME" class="member-name-link">SOME</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>SOME</code> quantification operator (also called <code>ANY</code>).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ST_CONTAINS" class="member-name-link">ST_CONTAINS</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>ST_Contains</code> function that tests whether one geometry contains |
| another.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ST_DWITHIN" class="member-name-link">ST_DWITHIN</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>ST_DWithin</code> geo-spatial function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ST_MAKE_LINE" class="member-name-link">ST_MAKE_LINE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>ST_MakeLine</code> function that makes a line.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#ST_POINT" class="member-name-link">ST_POINT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>ST_Point</code> function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#ST_POINT3" class="member-name-link">ST_POINT3</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>ST_Point</code> function that makes a 3D point.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#STDDEV_POP" class="member-name-link">STDDEV_POP</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>STDDEV_POP</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#STDDEV_SAMP" class="member-name-link">STDDEV_SAMP</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>STDDEV_SAMP</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#STRING_AGG" class="member-name-link">STRING_AGG</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>STRING_AGG</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SUBSTR_BIG_QUERY" class="member-name-link">SUBSTR_BIG_QUERY</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>SUBSTR</code> function (BigQuery semantics).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SUBSTR_MYSQL" class="member-name-link">SUBSTR_MYSQL</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>SUBSTR</code> function (MySQL semantics).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SUBSTR_ORACLE" class="member-name-link">SUBSTR_ORACLE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>SUBSTR</code> function (Oracle semantics).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SUBSTR_POSTGRESQL" class="member-name-link">SUBSTR_POSTGRESQL</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>SUBSTR</code> function (PostgreSQL semantics).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SUCCEEDS" class="member-name-link">SUCCEEDS</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>SUCCEEDS</code> operator for periods.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#SUM" class="member-name-link">SUM</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>SUM</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#SUM0" class="member-name-link">SUM0</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>SUM0</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#TABLE_INPUT_REF" class="member-name-link">TABLE_INPUT_REF</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Reference to an input field, with a qualified name and an identifier.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#TABLE_REF" class="member-name-link">TABLE_REF</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Table reference.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#TABLESAMPLE" class="member-name-link">TABLESAMPLE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">TABLESAMPLE relational operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#TIME_ADD" class="member-name-link">TIME_ADD</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>TIME_ADD</code> function (BigQuery).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#TIME_SUB" class="member-name-link">TIME_SUB</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>TIME_SUB</code> function (BigQuery).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#TIMES" class="member-name-link">TIMES</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Arithmetic multiplication operator, "*".</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#TIMESTAMP_ADD" class="member-name-link">TIMESTAMP_ADD</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>TIMESTAMP_ADD</code> function (ODBC, SQL Server, MySQL).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#TIMESTAMP_DIFF" class="member-name-link">TIMESTAMP_DIFF</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>TIMESTAMP_DIFF</code> function (ODBC, SQL Server, MySQL).</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#TIMESTAMP_SUB" class="member-name-link">TIMESTAMP_SUB</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>TIMESTAMP_SUB</code> function (BigQuery).</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#TRIM" class="member-name-link">TRIM</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>TRIM</code> function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#TUMBLE" class="member-name-link">TUMBLE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>TUMBLE</code> group function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#TUMBLE_END" class="member-name-link">TUMBLE_END</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>TUMBLE_END</code> auxiliary function of |
| the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#TUMBLE_START" class="member-name-link">TUMBLE_START</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>TUMBLE_START</code> auxiliary function of |
| the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#UNION" class="member-name-link">UNION</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>UNION</code> relational operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#UNIQUE" class="member-name-link">UNIQUE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>UNIQUE</code> constraint.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#UNNEST" class="member-name-link">UNNEST</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>UNNEST</code> operator.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#UNPIVOT" class="member-name-link">UNPIVOT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">UNPIVOT clause.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#UPDATE" class="member-name-link">UPDATE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">UPDATE statement.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#VALUES" class="member-name-link">VALUES</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>VALUES</code> relational operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#VAR_POP" class="member-name-link">VAR_POP</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">The <code>VAR_POP</code> aggregate function.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#VAR_SAMP" class="member-name-link">VAR_SAMP</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">The <code>VAR_SAMP</code> aggregate function.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#WINDOW" class="member-name-link">WINDOW</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Window specification.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#WITH" class="member-name-link">WITH</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">WITH clause.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#WITH_ITEM" class="member-name-link">WITH_ITEM</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Item in WITH clause.</div> |
| </div> |
| <div class="col-first even-row-color"><code><a href="#WITHIN_DISTINCT" class="member-name-link">WITHIN_DISTINCT</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block"><code>WITHIN DISTINCT</code> operator.</div> |
| </div> |
| <div class="col-first odd-row-color"><code><a href="#WITHIN_GROUP" class="member-name-link">WITHIN_GROUP</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block"><code>WITHIN GROUP</code> operator.</div> |
| </div> |
| </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="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second even-row-color"><code><a href="#AGGREGATE" class="member-name-link">AGGREGATE</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Category consisting of all built-in aggregate functions.</div> |
| </div> |
| <div class="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second odd-row-color"><code><a href="#AVG_AGG_FUNCTIONS" class="member-name-link">AVG_AGG_FUNCTIONS</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Category of SqlAvgAggFunction.</div> |
| </div> |
| <div class="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second even-row-color"><code><a href="#BINARY_ARITHMETIC" class="member-name-link">BINARY_ARITHMETIC</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Category of binary arithmetic.</div> |
| </div> |
| <div class="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second odd-row-color"><code><a href="#BINARY_COMPARISON" class="member-name-link">BINARY_COMPARISON</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Category of binary comparison.</div> |
| </div> |
| <div class="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second even-row-color"><code><a href="#BINARY_EQUALITY" class="member-name-link">BINARY_EQUALITY</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Category of binary equality.</div> |
| </div> |
| <div class="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second odd-row-color"><code><a href="#COMPARISON" class="member-name-link">COMPARISON</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Category of comparison operators.</div> |
| </div> |
| <div class="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second even-row-color"><code><a href="#COVAR_AVG_AGG_FUNCTIONS" class="member-name-link">COVAR_AVG_AGG_FUNCTIONS</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Category of SqlCovarAggFunction.</div> |
| </div> |
| <div class="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second odd-row-color"><code><a href="#DDL" class="member-name-link">DDL</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Category consisting of all DDL operators.</div> |
| </div> |
| <div class="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second even-row-color"><code><a href="#DML" class="member-name-link">DML</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Category consisting of all DML operators.</div> |
| </div> |
| <div class="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second odd-row-color"><code><a href="#EXPRESSION" class="member-name-link">EXPRESSION</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Category consisting of all expression operators.</div> |
| </div> |
| <div class="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second even-row-color"><code><a href="#FUNCTION" class="member-name-link">FUNCTION</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Category consisting of regular and special functions.</div> |
| </div> |
| <div class="col-first odd-row-color"><code>final <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></code></div> |
| <div class="col-second odd-row-color"><code><a href="#lowerName" class="member-name-link">lowerName</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Lower-case name.</div> |
| </div> |
| <div class="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second even-row-color"><code><a href="#QUERY" class="member-name-link">QUERY</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Category consisting of query node types.</div> |
| </div> |
| <div class="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second odd-row-color"><code><a href="#SET_QUERY" class="member-name-link">SET_QUERY</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Category consisting of set-query node types.</div> |
| </div> |
| <div class="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second even-row-color"><code><a href="#SIMPLE_BINARY_OPS" class="member-name-link">SIMPLE_BINARY_OPS</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Simple binary operators are those operators which expects operands from the same Domain.</div> |
| </div> |
| <div class="col-first odd-row-color"><code>final <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></code></div> |
| <div class="col-second odd-row-color"><code><a href="#sql" class="member-name-link">sql</a></code></div> |
| <div class="col-last odd-row-color"> </div> |
| <div class="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second even-row-color"><code><a href="#SYMMETRICAL" class="member-name-link">SYMMETRICAL</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Category of operators that do not depend on the argument order.</div> |
| </div> |
| <div class="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second odd-row-color"><code><a href="#SYMMETRICAL_SAME_ARG_TYPE" class="member-name-link">SYMMETRICAL_SAME_ARG_TYPE</a></code></div> |
| <div class="col-last odd-row-color"> |
| <div class="block">Category of operators that do not depend on the argument order if argument types are equal.</div> |
| </div> |
| <div class="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></div> |
| <div class="col-second even-row-color"><code><a href="#TOP_LEVEL" class="member-name-link">TOP_LEVEL</a></code></div> |
| <div class="col-last even-row-color"> |
| <div class="block">Category of all SQL statement types.</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-tab1" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab1', 3)" class="table-tab">Static 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>final boolean</code></div> |
| <div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#belongsTo(java.util.Collection)" class="member-name-link">belongsTo</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Collection.html" title="class or interface in java.util" class="external-link">Collection</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> category)</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 <code>SqlKind</code> belongs to a given category.</div> |
| </div> |
| <div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></div> |
| <div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#negate()" class="member-name-link">negate</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 the kind that you get if you apply NOT to this kind.</div> |
| </div> |
| <div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></div> |
| <div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#negateNullSafe()" class="member-name-link">negateNullSafe</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 the kind that you get if you negate this kind.</div> |
| </div> |
| <div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></div> |
| <div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#reverse()" class="member-name-link">reverse</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 the kind that corresponds to this operator but in the opposite |
| direction.</div> |
| </div> |
| <div class="col-first even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code>static <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></div> |
| <div class="col-second even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code><a href="#valueOf(java.lang.String)" class="member-name-link">valueOf</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> name)</code></div> |
| <div class="col-last even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"> |
| <div class="block">Returns the enum constant of this type with the specified name.</div> |
| </div> |
| <div class="col-first odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code>static <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>[]</code></div> |
| <div class="col-second odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code><a href="#values()" class="member-name-link">values</a>()</code></div> |
| <div class="col-last odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"> |
| <div class="block">Returns an array containing the constants of this enum type, in |
| the order they are declared.</div> |
| </div> |
| </div> |
| </div> |
| </div> |
| <div class="inherited-list"> |
| <h3 id="methods-inherited-from-class-java.lang.Enum">Methods inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.html" title="class or interface in java.lang" class="external-link">Enum</a></h3> |
| <code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.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/Enum.html#compareTo(E)" title="class or interface in java.lang" class="external-link">compareTo</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.html#describeConstable()" title="class or interface in java.lang" class="external-link">describeConstable</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.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/Enum.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/Enum.html#getDeclaringClass()" title="class or interface in java.lang" class="external-link">getDeclaringClass</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.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/Enum.html#name()" title="class or interface in java.lang" class="external-link">name</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.html#ordinal()" title="class or interface in java.lang" class="external-link">ordinal</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Enum.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/Enum.html#valueOf(java.lang.Class,java.lang.String)" title="class or interface in java.lang" class="external-link">valueOf</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#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#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#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"> |
| <!-- ============ ENUM CONSTANT DETAIL =========== --> |
| <li> |
| <section class="constant-details" id="enum-constant-detail"> |
| <h2>Enum Constant Details</h2> |
| <ul class="member-list"> |
| <li> |
| <section class="detail" id="OTHER"> |
| <h3>OTHER</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">OTHER</span></div> |
| <div class="block">Expression not covered by any other <a href="SqlKind.html" title="enum in org.apache.calcite.sql"><code>SqlKind</code></a> value.</div> |
| <dl class="notes"> |
| <dt>See Also:</dt> |
| <dd> |
| <ul class="see-list"> |
| <li><a href="#OTHER_FUNCTION"><code>OTHER_FUNCTION</code></a></li> |
| </ul> |
| </dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SELECT"> |
| <h3>SELECT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SELECT</span></div> |
| <div class="block">SELECT statement or sub-query.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="HINT"> |
| <h3>HINT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">HINT</span></div> |
| <div class="block">Sql Hint statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TABLE_REF"> |
| <h3>TABLE_REF</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TABLE_REF</span></div> |
| <div class="block">Table reference.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="JOIN"> |
| <h3>JOIN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">JOIN</span></div> |
| <div class="block">JOIN operator or compound FROM clause. |
| |
| <p>A FROM clause with more than one table is represented as if it were a |
| join. For example, "FROM x, y, z" is represented as |
| "JOIN(x, JOIN(x, y))".</p></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IDENTIFIER"> |
| <h3>IDENTIFIER</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IDENTIFIER</span></div> |
| <div class="block">An identifier.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LITERAL"> |
| <h3>LITERAL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LITERAL</span></div> |
| <div class="block">A literal.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="INTERVAL_QUALIFIER"> |
| <h3>INTERVAL_QUALIFIER</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">INTERVAL_QUALIFIER</span></div> |
| <div class="block">Interval qualifier.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="OTHER_FUNCTION"> |
| <h3>OTHER_FUNCTION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">OTHER_FUNCTION</span></div> |
| <div class="block">Function that is not a special function.</div> |
| <dl class="notes"> |
| <dt>See Also:</dt> |
| <dd> |
| <ul class="see-list"> |
| <li><a href="#FUNCTION"><code>FUNCTION</code></a></li> |
| </ul> |
| </dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SET_SEMANTICS_TABLE"> |
| <h3>SET_SEMANTICS_TABLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SET_SEMANTICS_TABLE</span></div> |
| <div class="block">Input tables have either row semantics or set semantics. |
| <ul> |
| <li>Row semantics means that the result of the table function is |
| decided on a row-by-row basis. |
| <li>Set semantics means that the outcome of the function depends on how |
| the data is partitioned. |
| When the table function is called from a query, the table parameter can |
| optionally be extended with either a PARTITION BY clause or |
| an ORDER BY clause or both. |
| </ul></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="POSITION"> |
| <h3>POSITION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">POSITION</span></div> |
| <div class="block">POSITION function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="EXPLAIN"> |
| <h3>EXPLAIN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">EXPLAIN</span></div> |
| <div class="block">EXPLAIN statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DESCRIBE_SCHEMA"> |
| <h3>DESCRIBE_SCHEMA</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DESCRIBE_SCHEMA</span></div> |
| <div class="block">DESCRIBE SCHEMA statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DESCRIBE_TABLE"> |
| <h3>DESCRIBE_TABLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DESCRIBE_TABLE</span></div> |
| <div class="block">DESCRIBE TABLE statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="INSERT"> |
| <h3>INSERT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">INSERT</span></div> |
| <div class="block">INSERT statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DELETE"> |
| <h3>DELETE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DELETE</span></div> |
| <div class="block">DELETE statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="UPDATE"> |
| <h3>UPDATE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">UPDATE</span></div> |
| <div class="block">UPDATE statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SET_OPTION"> |
| <h3>SET_OPTION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SET_OPTION</span></div> |
| <div class="block">"<code>ALTER scope SET option = value</code>" statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DYNAMIC_PARAM"> |
| <h3>DYNAMIC_PARAM</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DYNAMIC_PARAM</span></div> |
| <div class="block">A dynamic parameter.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="GROUP_BY_DISTINCT"> |
| <h3>GROUP_BY_DISTINCT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">GROUP_BY_DISTINCT</span></div> |
| <div class="block">The DISTINCT keyword of the GROUP BY clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ORDER_BY"> |
| <h3>ORDER_BY</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ORDER_BY</span></div> |
| <div class="block">ORDER BY clause.</div> |
| <dl class="notes"> |
| <dt>See Also:</dt> |
| <dd> |
| <ul class="see-list"> |
| <li><a href="#DESCENDING"><code>DESCENDING</code></a></li> |
| <li><a href="#NULLS_FIRST"><code>NULLS_FIRST</code></a></li> |
| <li><a href="#NULLS_LAST"><code>NULLS_LAST</code></a></li> |
| </ul> |
| </dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="WITH"> |
| <h3>WITH</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">WITH</span></div> |
| <div class="block">WITH clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="WITH_ITEM"> |
| <h3>WITH_ITEM</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">WITH_ITEM</span></div> |
| <div class="block">Item in WITH clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ITEM"> |
| <h3>ITEM</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ITEM</span></div> |
| <div class="block">Item expression.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="UNION"> |
| <h3>UNION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">UNION</span></div> |
| <div class="block"><code>UNION</code> relational operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="EXCEPT"> |
| <h3>EXCEPT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">EXCEPT</span></div> |
| <div class="block"><code>EXCEPT</code> relational operator (known as <code>MINUS</code> in some SQL |
| dialects).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="INTERSECT"> |
| <h3>INTERSECT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">INTERSECT</span></div> |
| <div class="block"><code>INTERSECT</code> relational operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="AS"> |
| <h3>AS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">AS</span></div> |
| <div class="block"><code>AS</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ARGUMENT_ASSIGNMENT"> |
| <h3>ARGUMENT_ASSIGNMENT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ARGUMENT_ASSIGNMENT</span></div> |
| <div class="block">Argument assignment operator, <code>=></code>.</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="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DEFAULT</span></div> |
| <div class="block"><code>DEFAULT</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="OVER"> |
| <h3>OVER</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">OVER</span></div> |
| <div class="block"><code>OVER</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="RESPECT_NULLS"> |
| <h3>RESPECT_NULLS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">RESPECT_NULLS</span></div> |
| <div class="block"><code>RESPECT NULLS</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IGNORE_NULLS"> |
| <h3>IGNORE_NULLS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IGNORE_NULLS</span></div> |
| <div class="block"><code>IGNORE NULLS</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="FILTER"> |
| <h3>FILTER</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">FILTER</span></div> |
| <div class="block"><code>FILTER</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="WITHIN_GROUP"> |
| <h3>WITHIN_GROUP</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">WITHIN_GROUP</span></div> |
| <div class="block"><code>WITHIN GROUP</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="WITHIN_DISTINCT"> |
| <h3>WITHIN_DISTINCT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">WITHIN_DISTINCT</span></div> |
| <div class="block"><code>WITHIN DISTINCT</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="WINDOW"> |
| <h3>WINDOW</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">WINDOW</span></div> |
| <div class="block">Window specification.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MERGE"> |
| <h3>MERGE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MERGE</span></div> |
| <div class="block">MERGE statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TABLESAMPLE"> |
| <h3>TABLESAMPLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TABLESAMPLE</span></div> |
| <div class="block">TABLESAMPLE relational operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PIVOT"> |
| <h3>PIVOT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PIVOT</span></div> |
| <div class="block">PIVOT clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="UNPIVOT"> |
| <h3>UNPIVOT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">UNPIVOT</span></div> |
| <div class="block">UNPIVOT clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MATCH_RECOGNIZE"> |
| <h3>MATCH_RECOGNIZE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MATCH_RECOGNIZE</span></div> |
| <div class="block">MATCH_RECOGNIZE clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SNAPSHOT"> |
| <h3>SNAPSHOT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SNAPSHOT</span></div> |
| <div class="block">SNAPSHOT operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TIMES"> |
| <h3>TIMES</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TIMES</span></div> |
| <div class="block">Arithmetic multiplication operator, "*".</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DIVIDE"> |
| <h3>DIVIDE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DIVIDE</span></div> |
| <div class="block">Arithmetic division operator, "/".</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MOD"> |
| <h3>MOD</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MOD</span></div> |
| <div class="block">Arithmetic remainder operator, "MOD" (and "%" in some dialects).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PLUS"> |
| <h3>PLUS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PLUS</span></div> |
| <div class="block">Arithmetic plus operator, "+".</div> |
| <dl class="notes"> |
| <dt>See Also:</dt> |
| <dd> |
| <ul class="see-list"> |
| <li><a href="#PLUS_PREFIX"><code>PLUS_PREFIX</code></a></li> |
| </ul> |
| </dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MINUS"> |
| <h3>MINUS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MINUS</span></div> |
| <div class="block">Arithmetic minus operator, "-".</div> |
| <dl class="notes"> |
| <dt>See Also:</dt> |
| <dd> |
| <ul class="see-list"> |
| <li><a href="#MINUS_PREFIX"><code>MINUS_PREFIX</code></a></li> |
| </ul> |
| </dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PATTERN_ALTER"> |
| <h3>PATTERN_ALTER</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PATTERN_ALTER</span></div> |
| <div class="block">Alternation operator in a pattern expression within a |
| <code>MATCH_RECOGNIZE</code> clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PATTERN_CONCAT"> |
| <h3>PATTERN_CONCAT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PATTERN_CONCAT</span></div> |
| <div class="block">Concatenation operator in a pattern expression within a |
| <code>MATCH_RECOGNIZE</code> clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IN"> |
| <h3>IN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IN</span></div> |
| <div class="block"><code>IN</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NOT_IN"> |
| <h3>NOT_IN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NOT_IN</span></div> |
| <div class="block"><code>NOT IN</code> operator. |
| |
| <p>Only occurs in SqlNode trees. Is expanded to NOT(IN ...) before |
| entering RelNode land.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DRUID_IN"> |
| <h3>DRUID_IN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DRUID_IN</span></div> |
| <div class="block">Variant of <code>IN</code> for the Druid adapter.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DRUID_NOT_IN"> |
| <h3>DRUID_NOT_IN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DRUID_NOT_IN</span></div> |
| <div class="block">Variant of <code>NOT_IN</code> for the Druid adapter.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LESS_THAN"> |
| <h3>LESS_THAN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LESS_THAN</span></div> |
| <div class="block">Less-than operator, "<".</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="GREATER_THAN"> |
| <h3>GREATER_THAN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">GREATER_THAN</span></div> |
| <div class="block">Greater-than operator, ">".</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LESS_THAN_OR_EQUAL"> |
| <h3>LESS_THAN_OR_EQUAL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LESS_THAN_OR_EQUAL</span></div> |
| <div class="block">Less-than-or-equal operator, "<=".</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="GREATER_THAN_OR_EQUAL"> |
| <h3>GREATER_THAN_OR_EQUAL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">GREATER_THAN_OR_EQUAL</span></div> |
| <div class="block">Greater-than-or-equal operator, ">=".</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="EQUALS"> |
| <h3>EQUALS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">EQUALS</span></div> |
| <div class="block">Equals operator, "=".</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NOT_EQUALS"> |
| <h3>NOT_EQUALS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NOT_EQUALS</span></div> |
| <div class="block">Not-equals operator, "!=" or "<>". |
| The latter is standard, and preferred.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IS_DISTINCT_FROM"> |
| <h3>IS_DISTINCT_FROM</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IS_DISTINCT_FROM</span></div> |
| <div class="block"><code>IS DISTINCT FROM</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IS_NOT_DISTINCT_FROM"> |
| <h3>IS_NOT_DISTINCT_FROM</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IS_NOT_DISTINCT_FROM</span></div> |
| <div class="block"><code>IS NOT DISTINCT FROM</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SEARCH"> |
| <h3>SEARCH</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SEARCH</span></div> |
| <div class="block"><code>SEARCH</code> operator. (Analogous to scalar <code>IN</code>, used only in |
| RexNode, not SqlNode.)</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="OR"> |
| <h3>OR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">OR</span></div> |
| <div class="block">Logical "OR" operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="AND"> |
| <h3>AND</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">AND</span></div> |
| <div class="block">Logical "AND" operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DOT"> |
| <h3>DOT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DOT</span></div> |
| <div class="block">Dot.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="OVERLAPS"> |
| <h3>OVERLAPS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">OVERLAPS</span></div> |
| <div class="block"><code>OVERLAPS</code> operator for periods.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CONTAINS"> |
| <h3>CONTAINS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CONTAINS</span></div> |
| <div class="block"><code>CONTAINS</code> operator for periods.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PRECEDES"> |
| <h3>PRECEDES</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PRECEDES</span></div> |
| <div class="block"><code>PRECEDES</code> operator for periods.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IMMEDIATELY_PRECEDES"> |
| <h3>IMMEDIATELY_PRECEDES</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IMMEDIATELY_PRECEDES</span></div> |
| <div class="block"><code>IMMEDIATELY PRECEDES</code> operator for periods.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SUCCEEDS"> |
| <h3>SUCCEEDS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SUCCEEDS</span></div> |
| <div class="block"><code>SUCCEEDS</code> operator for periods.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IMMEDIATELY_SUCCEEDS"> |
| <h3>IMMEDIATELY_SUCCEEDS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IMMEDIATELY_SUCCEEDS</span></div> |
| <div class="block"><code>IMMEDIATELY SUCCEEDS</code> operator for periods.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PERIOD_EQUALS"> |
| <h3>PERIOD_EQUALS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PERIOD_EQUALS</span></div> |
| <div class="block"><code>EQUALS</code> operator for periods.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LIKE"> |
| <h3>LIKE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LIKE</span></div> |
| <div class="block"><code>LIKE</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="RLIKE"> |
| <h3>RLIKE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">RLIKE</span></div> |
| <div class="block"><code>RLIKE</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SIMILAR"> |
| <h3>SIMILAR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SIMILAR</span></div> |
| <div class="block"><code>SIMILAR</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="POSIX_REGEX_CASE_SENSITIVE"> |
| <h3>POSIX_REGEX_CASE_SENSITIVE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">POSIX_REGEX_CASE_SENSITIVE</span></div> |
| <div class="block"><code>~</code> operator (for POSIX-style regular expressions).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="POSIX_REGEX_CASE_INSENSITIVE"> |
| <h3>POSIX_REGEX_CASE_INSENSITIVE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">POSIX_REGEX_CASE_INSENSITIVE</span></div> |
| <div class="block"><code>~*</code> operator (for case-insensitive POSIX-style regular |
| expressions).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="BETWEEN"> |
| <h3>BETWEEN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">BETWEEN</span></div> |
| <div class="block"><code>BETWEEN</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DRUID_BETWEEN"> |
| <h3>DRUID_BETWEEN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DRUID_BETWEEN</span></div> |
| <div class="block">Variant of <code>BETWEEN</code> for the Druid adapter.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CASE"> |
| <h3>CASE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CASE</span></div> |
| <div class="block"><code>CASE</code> expression.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="INTERVAL"> |
| <h3>INTERVAL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">INTERVAL</span></div> |
| <div class="block"><code>INTERVAL</code> expression.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SEPARATOR"> |
| <h3>SEPARATOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SEPARATOR</span></div> |
| <div class="block"><code>SEPARATOR</code> expression.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NULLIF"> |
| <h3>NULLIF</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NULLIF</span></div> |
| <div class="block"><code>NULLIF</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COALESCE"> |
| <h3>COALESCE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">COALESCE</span></div> |
| <div class="block"><code>COALESCE</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DECODE"> |
| <h3>DECODE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DECODE</span></div> |
| <div class="block"><code>DECODE</code> function (Oracle).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NVL"> |
| <h3>NVL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NVL</span></div> |
| <div class="block"><code>NVL</code> function (Oracle).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="GREATEST"> |
| <h3>GREATEST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">GREATEST</span></div> |
| <div class="block"><code>GREATEST</code> function (Oracle).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CONCAT2"> |
| <h3>CONCAT2</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CONCAT2</span></div> |
| <div class="block">The two-argument <code>CONCAT</code> function (Oracle).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IF"> |
| <h3>IF</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IF</span></div> |
| <div class="block">The "IF" function (BigQuery, Hive, Spark).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LEAST"> |
| <h3>LEAST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LEAST</span></div> |
| <div class="block"><code>LEAST</code> function (Oracle).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DATE_SUB"> |
| <h3>DATE_SUB</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DATE_SUB</span></div> |
| <div class="block"><code>DATE_SUB</code> function (BigQuery).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TIME_ADD"> |
| <h3>TIME_ADD</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TIME_ADD</span></div> |
| <div class="block"><code>TIME_ADD</code> function (BigQuery).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TIME_SUB"> |
| <h3>TIME_SUB</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TIME_SUB</span></div> |
| <div class="block"><code>TIME_SUB</code> function (BigQuery).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TIMESTAMP_ADD"> |
| <h3>TIMESTAMP_ADD</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TIMESTAMP_ADD</span></div> |
| <div class="block"><code>TIMESTAMP_ADD</code> function (ODBC, SQL Server, MySQL).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TIMESTAMP_DIFF"> |
| <h3>TIMESTAMP_DIFF</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TIMESTAMP_DIFF</span></div> |
| <div class="block"><code>TIMESTAMP_DIFF</code> function (ODBC, SQL Server, MySQL).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TIMESTAMP_SUB"> |
| <h3>TIMESTAMP_SUB</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TIMESTAMP_SUB</span></div> |
| <div class="block"><code>TIMESTAMP_SUB</code> function (BigQuery).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NOT"> |
| <h3>NOT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NOT</span></div> |
| <div class="block">Logical <code>NOT</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PLUS_PREFIX"> |
| <h3>PLUS_PREFIX</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PLUS_PREFIX</span></div> |
| <div class="block">Unary plus operator, as in "+1".</div> |
| <dl class="notes"> |
| <dt>See Also:</dt> |
| <dd> |
| <ul class="see-list"> |
| <li><a href="#PLUS"><code>PLUS</code></a></li> |
| </ul> |
| </dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MINUS_PREFIX"> |
| <h3>MINUS_PREFIX</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MINUS_PREFIX</span></div> |
| <div class="block">Unary minus operator, as in "-1".</div> |
| <dl class="notes"> |
| <dt>See Also:</dt> |
| <dd> |
| <ul class="see-list"> |
| <li><a href="#MINUS"><code>MINUS</code></a></li> |
| </ul> |
| </dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="EXISTS"> |
| <h3>EXISTS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">EXISTS</span></div> |
| <div class="block"><code>EXISTS</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SOME"> |
| <h3>SOME</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SOME</span></div> |
| <div class="block"><code>SOME</code> quantification operator (also called <code>ANY</code>).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ALL"> |
| <h3>ALL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ALL</span></div> |
| <div class="block"><code>ALL</code> quantification operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="VALUES"> |
| <h3>VALUES</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">VALUES</span></div> |
| <div class="block"><code>VALUES</code> relational operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="EXPLICIT_TABLE"> |
| <h3>EXPLICIT_TABLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">EXPLICIT_TABLE</span></div> |
| <div class="block">Explicit table, e.g. <code>select * from (TABLE t)</code> or <code>TABLE |
| t</code>. See also <a href="#COLLECTION_TABLE"><code>COLLECTION_TABLE</code></a>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SCALAR_QUERY"> |
| <h3>SCALAR_QUERY</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SCALAR_QUERY</span></div> |
| <div class="block">Scalar query; that is, a sub-query used in an expression context, and |
| returning one row and one column.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PROCEDURE_CALL"> |
| <h3>PROCEDURE_CALL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PROCEDURE_CALL</span></div> |
| <div class="block">Procedure call.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NEW_SPECIFICATION"> |
| <h3>NEW_SPECIFICATION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NEW_SPECIFICATION</span></div> |
| <div class="block">New specification.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="FINAL"> |
| <h3>FINAL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">FINAL</span></div> |
| <div class="block"><code>FINAL</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="RUNNING"> |
| <h3>RUNNING</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">RUNNING</span></div> |
| <div class="block"><code>FINAL</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PREV"> |
| <h3>PREV</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PREV</span></div> |
| <div class="block"><code>PREV</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NEXT"> |
| <h3>NEXT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NEXT</span></div> |
| <div class="block"><code>NEXT</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="FIRST"> |
| <h3>FIRST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">FIRST</span></div> |
| <div class="block"><code>FIRST</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LAST"> |
| <h3>LAST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LAST</span></div> |
| <div class="block"><code>LAST</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CLASSIFIER"> |
| <h3>CLASSIFIER</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CLASSIFIER</span></div> |
| <div class="block"><code>CLASSIFIER</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MATCH_NUMBER"> |
| <h3>MATCH_NUMBER</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MATCH_NUMBER</span></div> |
| <div class="block"><code>MATCH_NUMBER</code> operator in <code>MATCH_RECOGNIZE</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SKIP_TO_FIRST"> |
| <h3>SKIP_TO_FIRST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SKIP_TO_FIRST</span></div> |
| <div class="block"><code>SKIP TO FIRST</code> qualifier of restarting point in a |
| <code>MATCH_RECOGNIZE</code> clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SKIP_TO_LAST"> |
| <h3>SKIP_TO_LAST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SKIP_TO_LAST</span></div> |
| <div class="block"><code>SKIP TO LAST</code> qualifier of restarting point in a |
| <code>MATCH_RECOGNIZE</code> clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DESCENDING"> |
| <h3>DESCENDING</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DESCENDING</span></div> |
| <div class="block"><code>DESC</code> operator in <code>ORDER BY</code>. A parse tree, not a true |
| expression.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NULLS_FIRST"> |
| <h3>NULLS_FIRST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NULLS_FIRST</span></div> |
| <div class="block"><code>NULLS FIRST</code> clause in <code>ORDER BY</code>. A parse tree, not a true |
| expression.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NULLS_LAST"> |
| <h3>NULLS_LAST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NULLS_LAST</span></div> |
| <div class="block"><code>NULLS LAST</code> clause in <code>ORDER BY</code>. A parse tree, not a true |
| expression.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IS_TRUE"> |
| <h3>IS_TRUE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IS_TRUE</span></div> |
| <div class="block"><code>IS TRUE</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IS_FALSE"> |
| <h3>IS_FALSE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IS_FALSE</span></div> |
| <div class="block"><code>IS FALSE</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IS_NOT_TRUE"> |
| <h3>IS_NOT_TRUE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IS_NOT_TRUE</span></div> |
| <div class="block"><code>IS NOT TRUE</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IS_NOT_FALSE"> |
| <h3>IS_NOT_FALSE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IS_NOT_FALSE</span></div> |
| <div class="block"><code>IS NOT FALSE</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IS_UNKNOWN"> |
| <h3>IS_UNKNOWN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IS_UNKNOWN</span></div> |
| <div class="block"><code>IS UNKNOWN</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IS_NULL"> |
| <h3>IS_NULL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IS_NULL</span></div> |
| <div class="block"><code>IS NULL</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="IS_NOT_NULL"> |
| <h3>IS_NOT_NULL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">IS_NOT_NULL</span></div> |
| <div class="block"><code>IS NOT NULL</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PRECEDING"> |
| <h3>PRECEDING</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PRECEDING</span></div> |
| <div class="block"><code>PRECEDING</code> qualifier of an interval end-point in a window |
| specification.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="FOLLOWING"> |
| <h3>FOLLOWING</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">FOLLOWING</span></div> |
| <div class="block"><code>FOLLOWING</code> qualifier of an interval end-point in a window |
| specification.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="FIELD_ACCESS"> |
| <h3>FIELD_ACCESS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">FIELD_ACCESS</span></div> |
| <div class="block">The field access operator, ".". |
| |
| <p>(Only used at the RexNode level; at |
| SqlNode level, a field-access is part of an identifier.)</p></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="INPUT_REF"> |
| <h3>INPUT_REF</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">INPUT_REF</span></div> |
| <div class="block">Reference to an input field. |
| |
| <p>(Only used at the RexNode level.)</p></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TABLE_INPUT_REF"> |
| <h3>TABLE_INPUT_REF</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TABLE_INPUT_REF</span></div> |
| <div class="block">Reference to an input field, with a qualified name and an identifier. |
| |
| <p>(Only used at the RexNode level.)</p></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PATTERN_INPUT_REF"> |
| <h3>PATTERN_INPUT_REF</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PATTERN_INPUT_REF</span></div> |
| <div class="block">Reference to an input field, with pattern var as modifier. |
| |
| <p>(Only used at the RexNode level.)</p></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LOCAL_REF"> |
| <h3>LOCAL_REF</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LOCAL_REF</span></div> |
| <div class="block">Reference to a sub-expression computed within the current relational |
| operator. |
| |
| <p>(Only used at the RexNode level.)</p></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CORREL_VARIABLE"> |
| <h3>CORREL_VARIABLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CORREL_VARIABLE</span></div> |
| <div class="block">Reference to correlation variable. |
| |
| <p>(Only used at the RexNode level.)</p></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PATTERN_QUANTIFIER"> |
| <h3>PATTERN_QUANTIFIER</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PATTERN_QUANTIFIER</span></div> |
| <div class="block">the repetition quantifier of a pattern factor in a match_recognize clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ROW"> |
| <h3>ROW</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ROW</span></div> |
| <div class="block">The row-constructor function. May be explicit or implicit: |
| <code>VALUES 1, ROW (2)</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COLUMN_LIST"> |
| <h3>COLUMN_LIST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">COLUMN_LIST</span></div> |
| <div class="block">The non-standard constructor used to pass a |
| COLUMN_LIST parameter to a user-defined transform.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CAST"> |
| <h3>CAST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CAST</span></div> |
| <div class="block">The "CAST" operator, and also the PostgreSQL-style infix cast operator |
| "::".</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NEXT_VALUE"> |
| <h3>NEXT_VALUE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NEXT_VALUE</span></div> |
| <div class="block">The "NEXT VALUE OF sequence" operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CURRENT_VALUE"> |
| <h3>CURRENT_VALUE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CURRENT_VALUE</span></div> |
| <div class="block">The "CURRENT VALUE OF sequence" operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="FLOOR"> |
| <h3>FLOOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">FLOOR</span></div> |
| <div class="block"><code>FLOOR</code> function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CEIL"> |
| <h3>CEIL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CEIL</span></div> |
| <div class="block"><code>CEIL</code> function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TRIM"> |
| <h3>TRIM</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TRIM</span></div> |
| <div class="block"><code>TRIM</code> function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LTRIM"> |
| <h3>LTRIM</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LTRIM</span></div> |
| <div class="block"><code>LTRIM</code> function (Oracle).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="RTRIM"> |
| <h3>RTRIM</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">RTRIM</span></div> |
| <div class="block"><code>RTRIM</code> function (Oracle).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="EXTRACT"> |
| <h3>EXTRACT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">EXTRACT</span></div> |
| <div class="block"><code>EXTRACT</code> function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ARRAY_CONCAT"> |
| <h3>ARRAY_CONCAT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ARRAY_CONCAT</span></div> |
| <div class="block"><code>ARRAY_CONCAT</code> function (BigQuery semantics).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ARRAY_REVERSE"> |
| <h3>ARRAY_REVERSE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ARRAY_REVERSE</span></div> |
| <div class="block"><code>ARRAY_REVERSE</code> function (BigQuery semantics).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="REVERSE"> |
| <h3>REVERSE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">REVERSE</span></div> |
| <div class="block"><code>REVERSE</code> function (SQL Server, MySQL).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SUBSTR_BIG_QUERY"> |
| <h3>SUBSTR_BIG_QUERY</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SUBSTR_BIG_QUERY</span></div> |
| <div class="block"><code>SUBSTR</code> function (BigQuery semantics).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SUBSTR_MYSQL"> |
| <h3>SUBSTR_MYSQL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SUBSTR_MYSQL</span></div> |
| <div class="block"><code>SUBSTR</code> function (MySQL semantics).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SUBSTR_ORACLE"> |
| <h3>SUBSTR_ORACLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SUBSTR_ORACLE</span></div> |
| <div class="block"><code>SUBSTR</code> function (Oracle semantics).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SUBSTR_POSTGRESQL"> |
| <h3>SUBSTR_POSTGRESQL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SUBSTR_POSTGRESQL</span></div> |
| <div class="block"><code>SUBSTR</code> function (PostgreSQL semantics).</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="JDBC_FN"> |
| <h3>JDBC_FN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">JDBC_FN</span></div> |
| <div class="block">Call to a function using JDBC function syntax.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MULTISET_VALUE_CONSTRUCTOR"> |
| <h3>MULTISET_VALUE_CONSTRUCTOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MULTISET_VALUE_CONSTRUCTOR</span></div> |
| <div class="block"><code>MULTISET</code> value constructor.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MULTISET_QUERY_CONSTRUCTOR"> |
| <h3>MULTISET_QUERY_CONSTRUCTOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MULTISET_QUERY_CONSTRUCTOR</span></div> |
| <div class="block"><code>MULTISET</code> query constructor.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="JSON_VALUE_EXPRESSION"> |
| <h3>JSON_VALUE_EXPRESSION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">JSON_VALUE_EXPRESSION</span></div> |
| <div class="block"><code>JSON</code> value expression.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="JSON_ARRAYAGG"> |
| <h3>JSON_ARRAYAGG</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">JSON_ARRAYAGG</span></div> |
| <div class="block"><code>JSON_ARRAYAGG</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="JSON_OBJECTAGG"> |
| <h3>JSON_OBJECTAGG</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">JSON_OBJECTAGG</span></div> |
| <div class="block"><code>JSON_OBJECTAGG</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="JSON_TYPE"> |
| <h3>JSON_TYPE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">JSON_TYPE</span></div> |
| <div class="block"><code>JSON</code> type function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="UNNEST"> |
| <h3>UNNEST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">UNNEST</span></div> |
| <div class="block"><code>UNNEST</code> operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LATERAL"> |
| <h3>LATERAL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LATERAL</span></div> |
| <div class="block">The "LATERAL" qualifier to relations in the FROM clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COLLECTION_TABLE"> |
| <h3>COLLECTION_TABLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">COLLECTION_TABLE</span></div> |
| <div class="block">Table operator which converts user-defined transform into a relation, for |
| example, <code>select * from TABLE(udx(x, y, z))</code>. See also the |
| <a href="#EXPLICIT_TABLE"><code>EXPLICIT_TABLE</code></a> prefix operator.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ARRAY_VALUE_CONSTRUCTOR"> |
| <h3>ARRAY_VALUE_CONSTRUCTOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ARRAY_VALUE_CONSTRUCTOR</span></div> |
| <div class="block">Array Value Constructor, e.g. <code>Array[1, 2, 3]</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ARRAY_QUERY_CONSTRUCTOR"> |
| <h3>ARRAY_QUERY_CONSTRUCTOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ARRAY_QUERY_CONSTRUCTOR</span></div> |
| <div class="block">Array Query Constructor, e.g. <code>Array(select deptno from dept)</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MAP_VALUE_CONSTRUCTOR"> |
| <h3>MAP_VALUE_CONSTRUCTOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MAP_VALUE_CONSTRUCTOR</span></div> |
| <div class="block">MAP value constructor, e.g. <code>MAP ['washington', 1, 'obama', 44]</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MAP_QUERY_CONSTRUCTOR"> |
| <h3>MAP_QUERY_CONSTRUCTOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MAP_QUERY_CONSTRUCTOR</span></div> |
| <div class="block">MAP query constructor, |
| e.g. <code>MAP (SELECT empno, deptno FROM emp)</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CURSOR"> |
| <h3>CURSOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CURSOR</span></div> |
| <div class="block"><code>CURSOR</code> constructor, for example, <code>SELECT * FROM |
| TABLE(udx(CURSOR(SELECT ...), x, y, z))</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LITERAL_CHAIN"> |
| <h3>LITERAL_CHAIN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LITERAL_CHAIN</span></div> |
| <div class="block">Literal chain operator (for composite string literals). |
| An internal operator that does not appear in SQL syntax.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ESCAPE"> |
| <h3>ESCAPE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ESCAPE</span></div> |
| <div class="block">Escape operator (always part of LIKE or SIMILAR TO expression). |
| An internal operator that does not appear in SQL syntax.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="REINTERPRET"> |
| <h3>REINTERPRET</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">REINTERPRET</span></div> |
| <div class="block">The internal REINTERPRET operator (meaning a reinterpret cast). |
| An internal operator that does not appear in SQL syntax.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="EXTEND"> |
| <h3>EXTEND</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">EXTEND</span></div> |
| <div class="block">The internal <code>EXTEND</code> operator that qualifies a table name in the |
| <code>FROM</code> clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CUBE"> |
| <h3>CUBE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CUBE</span></div> |
| <div class="block">The internal <code>CUBE</code> operator that occurs within a <code>GROUP BY</code> |
| clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ROLLUP"> |
| <h3>ROLLUP</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ROLLUP</span></div> |
| <div class="block">The internal <code>ROLLUP</code> operator that occurs within a <code>GROUP BY</code> |
| clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="GROUPING_SETS"> |
| <h3>GROUPING_SETS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">GROUPING_SETS</span></div> |
| <div class="block">The internal <code>GROUPING SETS</code> operator that occurs within a |
| <code>GROUP BY</code> clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="GROUPING"> |
| <h3>GROUPING</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">GROUPING</span></div> |
| <div class="block">The <code>GROUPING(e, ...)</code> function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="GROUPING_ID"> |
| <h3>GROUPING_ID</h3> |
| <div class="member-signature"><span class="annotations"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Deprecated.html" title="class or interface in java.lang" class="external-link">@Deprecated</a> |
| </span><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">GROUPING_ID</span></div> |
| <div class="deprecation-block"><span class="deprecated-label">Deprecated.</span> |
| <div class="deprecation-comment">Use <a href="#GROUPING"><code>GROUPING</code></a>.</div> |
| </div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="GROUP_ID"> |
| <h3>GROUP_ID</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">GROUP_ID</span></div> |
| <div class="block">The <code>GROUP_ID()</code> function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PATTERN_PERMUTE"> |
| <h3>PATTERN_PERMUTE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PATTERN_PERMUTE</span></div> |
| <div class="block">The internal "permute" function in a MATCH_RECOGNIZE clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PATTERN_EXCLUDED"> |
| <h3>PATTERN_EXCLUDED</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PATTERN_EXCLUDED</span></div> |
| <div class="block">The special patterns to exclude enclosing pattern from output in a |
| MATCH_RECOGNIZE clause.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COUNT"> |
| <h3>COUNT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">COUNT</span></div> |
| <div class="block">The <code>COUNT</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SUM"> |
| <h3>SUM</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SUM</span></div> |
| <div class="block">The <code>SUM</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SUM0"> |
| <h3>SUM0</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SUM0</span></div> |
| <div class="block">The <code>SUM0</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MIN"> |
| <h3>MIN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MIN</span></div> |
| <div class="block">The <code>MIN</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MAX"> |
| <h3>MAX</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MAX</span></div> |
| <div class="block">The <code>MAX</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LEAD"> |
| <h3>LEAD</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LEAD</span></div> |
| <div class="block">The <code>LEAD</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LAG"> |
| <h3>LAG</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LAG</span></div> |
| <div class="block">The <code>LAG</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="FIRST_VALUE"> |
| <h3>FIRST_VALUE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">FIRST_VALUE</span></div> |
| <div class="block">The <code>FIRST_VALUE</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LAST_VALUE"> |
| <h3>LAST_VALUE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LAST_VALUE</span></div> |
| <div class="block">The <code>LAST_VALUE</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ANY_VALUE"> |
| <h3>ANY_VALUE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ANY_VALUE</span></div> |
| <div class="block">The <code>ANY_VALUE</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COVAR_POP"> |
| <h3>COVAR_POP</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">COVAR_POP</span></div> |
| <div class="block">The <code>COVAR_POP</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COVAR_SAMP"> |
| <h3>COVAR_SAMP</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">COVAR_SAMP</span></div> |
| <div class="block">The <code>COVAR_SAMP</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="REGR_COUNT"> |
| <h3>REGR_COUNT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">REGR_COUNT</span></div> |
| <div class="block">The <code>REGR_COUNT</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="REGR_SXX"> |
| <h3>REGR_SXX</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">REGR_SXX</span></div> |
| <div class="block">The <code>REGR_SXX</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="REGR_SYY"> |
| <h3>REGR_SYY</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">REGR_SYY</span></div> |
| <div class="block">The <code>REGR_SYY</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="AVG"> |
| <h3>AVG</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">AVG</span></div> |
| <div class="block">The <code>AVG</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="STDDEV_POP"> |
| <h3>STDDEV_POP</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">STDDEV_POP</span></div> |
| <div class="block">The <code>STDDEV_POP</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="STDDEV_SAMP"> |
| <h3>STDDEV_SAMP</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">STDDEV_SAMP</span></div> |
| <div class="block">The <code>STDDEV_SAMP</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="VAR_POP"> |
| <h3>VAR_POP</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">VAR_POP</span></div> |
| <div class="block">The <code>VAR_POP</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="VAR_SAMP"> |
| <h3>VAR_SAMP</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">VAR_SAMP</span></div> |
| <div class="block">The <code>VAR_SAMP</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NTILE"> |
| <h3>NTILE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NTILE</span></div> |
| <div class="block">The <code>NTILE</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="NTH_VALUE"> |
| <h3>NTH_VALUE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">NTH_VALUE</span></div> |
| <div class="block">The <code>NTH_VALUE</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="LISTAGG"> |
| <h3>LISTAGG</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">LISTAGG</span></div> |
| <div class="block">The <code>LISTAGG</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="STRING_AGG"> |
| <h3>STRING_AGG</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">STRING_AGG</span></div> |
| <div class="block">The <code>STRING_AGG</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COUNTIF"> |
| <h3>COUNTIF</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">COUNTIF</span></div> |
| <div class="block">The <code>COUNTIF</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ARRAY_AGG"> |
| <h3>ARRAY_AGG</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ARRAY_AGG</span></div> |
| <div class="block">The <code>ARRAY_AGG</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ARRAY_CONCAT_AGG"> |
| <h3>ARRAY_CONCAT_AGG</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ARRAY_CONCAT_AGG</span></div> |
| <div class="block">The <code>ARRAY_CONCAT_AGG</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="GROUP_CONCAT"> |
| <h3>GROUP_CONCAT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">GROUP_CONCAT</span></div> |
| <div class="block">The <code>GROUP_CONCAT</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COLLECT"> |
| <h3>COLLECT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">COLLECT</span></div> |
| <div class="block">The <code>COLLECT</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="MODE"> |
| <h3>MODE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">MODE</span></div> |
| <div class="block">The <code>MODE</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ARG_MAX"> |
| <h3>ARG_MAX</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ARG_MAX</span></div> |
| <div class="block">The <code>ARG_MAX</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ARG_MIN"> |
| <h3>ARG_MIN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ARG_MIN</span></div> |
| <div class="block">The <code>ARG_MIN</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PERCENTILE_CONT"> |
| <h3>PERCENTILE_CONT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PERCENTILE_CONT</span></div> |
| <div class="block">The <code>PERCENTILE_CONT</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PERCENTILE_DISC"> |
| <h3>PERCENTILE_DISC</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PERCENTILE_DISC</span></div> |
| <div class="block">The <code>PERCENTILE_DISC</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="FUSION"> |
| <h3>FUSION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">FUSION</span></div> |
| <div class="block">The <code>FUSION</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="INTERSECTION"> |
| <h3>INTERSECTION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">INTERSECTION</span></div> |
| <div class="block">The <code>INTERSECTION</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SINGLE_VALUE"> |
| <h3>SINGLE_VALUE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SINGLE_VALUE</span></div> |
| <div class="block">The <code>SINGLE_VALUE</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="AGGREGATE_FN"> |
| <h3>AGGREGATE_FN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">AGGREGATE_FN</span></div> |
| <div class="block">The <code>AGGREGATE</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="BIT_AND"> |
| <h3>BIT_AND</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">BIT_AND</span></div> |
| <div class="block">The <code>BIT_AND</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="BIT_OR"> |
| <h3>BIT_OR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">BIT_OR</span></div> |
| <div class="block">The <code>BIT_OR</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="BIT_XOR"> |
| <h3>BIT_XOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">BIT_XOR</span></div> |
| <div class="block">The <code>BIT_XOR</code> aggregate function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ROW_NUMBER"> |
| <h3>ROW_NUMBER</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ROW_NUMBER</span></div> |
| <div class="block">The <code>ROW_NUMBER</code> window function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="RANK"> |
| <h3>RANK</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">RANK</span></div> |
| <div class="block">The <code>RANK</code> window function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PERCENT_RANK"> |
| <h3>PERCENT_RANK</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PERCENT_RANK</span></div> |
| <div class="block">The <code>PERCENT_RANK</code> window function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DENSE_RANK"> |
| <h3>DENSE_RANK</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DENSE_RANK</span></div> |
| <div class="block">The <code>DENSE_RANK</code> window function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CUME_DIST"> |
| <h3>CUME_DIST</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CUME_DIST</span></div> |
| <div class="block">The <code>ROW_NUMBER</code> window function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DESCRIPTOR"> |
| <h3>DESCRIPTOR</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DESCRIPTOR</span></div> |
| <div class="block">The <code>DESCRIPTOR(column_name, ...)</code>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TUMBLE"> |
| <h3>TUMBLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TUMBLE</span></div> |
| <div class="block">The <code>TUMBLE</code> group function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TUMBLE_START"> |
| <h3>TUMBLE_START</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TUMBLE_START</span></div> |
| <div class="block">The <code>TUMBLE_START</code> auxiliary function of |
| the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TUMBLE_END"> |
| <h3>TUMBLE_END</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">TUMBLE_END</span></div> |
| <div class="block">The <code>TUMBLE_END</code> auxiliary function of |
| the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="HOP"> |
| <h3>HOP</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">HOP</span></div> |
| <div class="block">The <code>HOP</code> group function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="HOP_START"> |
| <h3>HOP_START</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">HOP_START</span></div> |
| <div class="block">The <code>HOP_START</code> auxiliary function of |
| the <a href="#HOP"><code>HOP</code></a> group function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="HOP_END"> |
| <h3>HOP_END</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">HOP_END</span></div> |
| <div class="block">The <code>HOP_END</code> auxiliary function of |
| the <a href="#HOP"><code>HOP</code></a> group function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SESSION"> |
| <h3>SESSION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SESSION</span></div> |
| <div class="block">The <code>SESSION</code> group function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SESSION_START"> |
| <h3>SESSION_START</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SESSION_START</span></div> |
| <div class="block">The <code>SESSION_START</code> auxiliary function of |
| the <a href="#SESSION"><code>SESSION</code></a> group function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SESSION_END"> |
| <h3>SESSION_END</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">SESSION_END</span></div> |
| <div class="block">The <code>SESSION_END</code> auxiliary function of |
| the <a href="#SESSION"><code>SESSION</code></a> group function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COLUMN_DECL"> |
| <h3>COLUMN_DECL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">COLUMN_DECL</span></div> |
| <div class="block">Column declaration.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ATTRIBUTE_DEF"> |
| <h3>ATTRIBUTE_DEF</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ATTRIBUTE_DEF</span></div> |
| <div class="block">Attribute definition.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CHECK"> |
| <h3>CHECK</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CHECK</span></div> |
| <div class="block"><code>CHECK</code> constraint.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="UNIQUE"> |
| <h3>UNIQUE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">UNIQUE</span></div> |
| <div class="block"><code>UNIQUE</code> constraint.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="PRIMARY_KEY"> |
| <h3>PRIMARY_KEY</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">PRIMARY_KEY</span></div> |
| <div class="block"><code>PRIMARY KEY</code> constraint.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="FOREIGN_KEY"> |
| <h3>FOREIGN_KEY</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">FOREIGN_KEY</span></div> |
| <div class="block"><code>FOREIGN KEY</code> constraint.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ST_DWITHIN"> |
| <h3>ST_DWITHIN</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ST_DWITHIN</span></div> |
| <div class="block">The <code>ST_DWithin</code> geo-spatial function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ST_POINT"> |
| <h3>ST_POINT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ST_POINT</span></div> |
| <div class="block">The <code>ST_Point</code> function.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ST_POINT3"> |
| <h3>ST_POINT3</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ST_POINT3</span></div> |
| <div class="block">The <code>ST_Point</code> function that makes a 3D point.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ST_MAKE_LINE"> |
| <h3>ST_MAKE_LINE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ST_MAKE_LINE</span></div> |
| <div class="block">The <code>ST_MakeLine</code> function that makes a line.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ST_CONTAINS"> |
| <h3>ST_CONTAINS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ST_CONTAINS</span></div> |
| <div class="block">The <code>ST_Contains</code> function that tests whether one geometry contains |
| another.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="HILBERT"> |
| <h3>HILBERT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">HILBERT</span></div> |
| <div class="block">The <code>Hilbert</code> function that converts (x, y) to a position on a |
| Hilbert space-filling curve.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COMMIT"> |
| <h3>COMMIT</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">COMMIT</span></div> |
| <div class="block"><code>COMMIT</code> session control statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ROLLBACK"> |
| <h3>ROLLBACK</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ROLLBACK</span></div> |
| <div class="block"><code>ROLLBACK</code> session control statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ALTER_SESSION"> |
| <h3>ALTER_SESSION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ALTER_SESSION</span></div> |
| <div class="block"><code>ALTER SESSION</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CREATE_SCHEMA"> |
| <h3>CREATE_SCHEMA</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CREATE_SCHEMA</span></div> |
| <div class="block"><code>CREATE SCHEMA</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CREATE_FOREIGN_SCHEMA"> |
| <h3>CREATE_FOREIGN_SCHEMA</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CREATE_FOREIGN_SCHEMA</span></div> |
| <div class="block"><code>CREATE FOREIGN SCHEMA</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DROP_SCHEMA"> |
| <h3>DROP_SCHEMA</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DROP_SCHEMA</span></div> |
| <div class="block"><code>DROP SCHEMA</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CREATE_TABLE"> |
| <h3>CREATE_TABLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CREATE_TABLE</span></div> |
| <div class="block"><code>CREATE TABLE</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ALTER_TABLE"> |
| <h3>ALTER_TABLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ALTER_TABLE</span></div> |
| <div class="block"><code>ALTER TABLE</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DROP_TABLE"> |
| <h3>DROP_TABLE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DROP_TABLE</span></div> |
| <div class="block"><code>DROP TABLE</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CREATE_VIEW"> |
| <h3>CREATE_VIEW</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CREATE_VIEW</span></div> |
| <div class="block"><code>CREATE VIEW</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ALTER_VIEW"> |
| <h3>ALTER_VIEW</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ALTER_VIEW</span></div> |
| <div class="block"><code>ALTER VIEW</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DROP_VIEW"> |
| <h3>DROP_VIEW</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DROP_VIEW</span></div> |
| <div class="block"><code>DROP VIEW</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CREATE_MATERIALIZED_VIEW"> |
| <h3>CREATE_MATERIALIZED_VIEW</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CREATE_MATERIALIZED_VIEW</span></div> |
| <div class="block"><code>CREATE MATERIALIZED VIEW</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ALTER_MATERIALIZED_VIEW"> |
| <h3>ALTER_MATERIALIZED_VIEW</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ALTER_MATERIALIZED_VIEW</span></div> |
| <div class="block"><code>ALTER MATERIALIZED VIEW</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DROP_MATERIALIZED_VIEW"> |
| <h3>DROP_MATERIALIZED_VIEW</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DROP_MATERIALIZED_VIEW</span></div> |
| <div class="block"><code>DROP MATERIALIZED VIEW</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CREATE_SEQUENCE"> |
| <h3>CREATE_SEQUENCE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CREATE_SEQUENCE</span></div> |
| <div class="block"><code>CREATE SEQUENCE</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ALTER_SEQUENCE"> |
| <h3>ALTER_SEQUENCE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ALTER_SEQUENCE</span></div> |
| <div class="block"><code>ALTER SEQUENCE</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DROP_SEQUENCE"> |
| <h3>DROP_SEQUENCE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DROP_SEQUENCE</span></div> |
| <div class="block"><code>DROP SEQUENCE</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CREATE_INDEX"> |
| <h3>CREATE_INDEX</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CREATE_INDEX</span></div> |
| <div class="block"><code>CREATE INDEX</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="ALTER_INDEX"> |
| <h3>ALTER_INDEX</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">ALTER_INDEX</span></div> |
| <div class="block"><code>ALTER INDEX</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DROP_INDEX"> |
| <h3>DROP_INDEX</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DROP_INDEX</span></div> |
| <div class="block"><code>DROP INDEX</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CREATE_TYPE"> |
| <h3>CREATE_TYPE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CREATE_TYPE</span></div> |
| <div class="block"><code>CREATE TYPE</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DROP_TYPE"> |
| <h3>DROP_TYPE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DROP_TYPE</span></div> |
| <div class="block"><code>DROP TYPE</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="CREATE_FUNCTION"> |
| <h3>CREATE_FUNCTION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">CREATE_FUNCTION</span></div> |
| <div class="block"><code>CREATE FUNCTION</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DROP_FUNCTION"> |
| <h3>DROP_FUNCTION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">DROP_FUNCTION</span></div> |
| <div class="block"><code>DROP FUNCTION</code> DDL statement.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="OTHER_DDL"> |
| <h3>OTHER_DDL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">OTHER_DDL</span></div> |
| <div class="block">DDL statement not handled above. |
| |
| <p><b>Note to other projects</b>: If you are extending Calcite's SQL parser |
| and have your own object types you no doubt want to define CREATE and DROP |
| commands for them. Use OTHER_DDL in the short term, but we are happy to add |
| new enum values for your object types. Just ask!</div> |
| </section> |
| </li> |
| </ul> |
| </section> |
| </li> |
| <!-- ============ FIELD DETAIL =========== --> |
| <li> |
| <section class="field-details" id="field-detail"> |
| <h2>Field Details</h2> |
| <ul class="member-list"> |
| <li> |
| <section class="detail" id="SET_QUERY"> |
| <h3>SET_QUERY</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">SET_QUERY</span></div> |
| <div class="block">Category consisting of set-query node types. |
| |
| <p>Consists of: |
| <a href="#EXCEPT"><code>EXCEPT</code></a>, |
| <a href="#INTERSECT"><code>INTERSECT</code></a>, |
| <a href="#UNION"><code>UNION</code></a>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="AGGREGATE"> |
| <h3>AGGREGATE</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">AGGREGATE</span></div> |
| <div class="block">Category consisting of all built-in aggregate functions.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DML"> |
| <h3>DML</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">DML</span></div> |
| <div class="block">Category consisting of all DML operators. |
| |
| <p>Consists of: |
| <a href="#INSERT"><code>INSERT</code></a>, |
| <a href="#UPDATE"><code>UPDATE</code></a>, |
| <a href="#DELETE"><code>DELETE</code></a>, |
| <a href="#MERGE"><code>MERGE</code></a>, |
| <a href="#PROCEDURE_CALL"><code>PROCEDURE_CALL</code></a>. |
| |
| <p>NOTE jvs 1-June-2006: For now we treat procedure calls as DML; |
| this makes it easy for JDBC clients to call execute or |
| executeUpdate and not have to process dummy cursor results. If |
| in the future we support procedures which return results sets, |
| we'll need to refine this.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="DDL"> |
| <h3>DDL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">DDL</span></div> |
| <div class="block">Category consisting of all DDL operators.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="QUERY"> |
| <h3>QUERY</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">QUERY</span></div> |
| <div class="block">Category consisting of query node types. |
| |
| <p>Consists of: |
| <a href="#SELECT"><code>SELECT</code></a>, |
| <a href="#EXCEPT"><code>EXCEPT</code></a>, |
| <a href="#INTERSECT"><code>INTERSECT</code></a>, |
| <a href="#UNION"><code>UNION</code></a>, |
| <a href="#VALUES"><code>VALUES</code></a>, |
| <a href="#ORDER_BY"><code>ORDER_BY</code></a>, |
| <a href="#EXPLICIT_TABLE"><code>EXPLICIT_TABLE</code></a>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="EXPRESSION"> |
| <h3>EXPRESSION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">EXPRESSION</span></div> |
| <div class="block">Category consisting of all expression operators. |
| |
| <p>A node is an expression if it is NOT one of the following: |
| <a href="#AS"><code>AS</code></a>, |
| <a href="#ARGUMENT_ASSIGNMENT"><code>ARGUMENT_ASSIGNMENT</code></a>, |
| <a href="#DEFAULT"><code>DEFAULT</code></a>, |
| <a href="#DESCENDING"><code>DESCENDING</code></a>, |
| <a href="#SELECT"><code>SELECT</code></a>, |
| <a href="#JOIN"><code>JOIN</code></a>, |
| <a href="#OTHER_FUNCTION"><code>OTHER_FUNCTION</code></a>, |
| <a href="#CAST"><code>CAST</code></a>, |
| <a href="#TRIM"><code>TRIM</code></a>, |
| <a href="#LITERAL_CHAIN"><code>LITERAL_CHAIN</code></a>, |
| <a href="#JDBC_FN"><code>JDBC_FN</code></a>, |
| <a href="#PRECEDING"><code>PRECEDING</code></a>, |
| <a href="#FOLLOWING"><code>FOLLOWING</code></a>, |
| <a href="#ORDER_BY"><code>ORDER_BY</code></a>, |
| <a href="#COLLECTION_TABLE"><code>COLLECTION_TABLE</code></a>, |
| <a href="#TABLESAMPLE"><code>TABLESAMPLE</code></a>, |
| <a href="#UNNEST"><code>UNNEST</code></a> |
| or an aggregate function, DML or DDL.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="TOP_LEVEL"> |
| <h3>TOP_LEVEL</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">TOP_LEVEL</span></div> |
| <div class="block">Category of all SQL statement types. |
| |
| <p>Consists of all types in <a href="#QUERY"><code>QUERY</code></a>, <a href="#DML"><code>DML</code></a> and <a href="#DDL"><code>DDL</code></a>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="FUNCTION"> |
| <h3>FUNCTION</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">FUNCTION</span></div> |
| <div class="block">Category consisting of regular and special functions. |
| |
| <p>Consists of regular functions <a href="#OTHER_FUNCTION"><code>OTHER_FUNCTION</code></a> and special |
| functions <a href="#ROW"><code>ROW</code></a>, <a href="#TRIM"><code>TRIM</code></a>, <a href="#CAST"><code>CAST</code></a>, <a href="#REVERSE"><code>REVERSE</code></a>, <a href="#JDBC_FN"><code>JDBC_FN</code></a>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="AVG_AGG_FUNCTIONS"> |
| <h3>AVG_AGG_FUNCTIONS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">AVG_AGG_FUNCTIONS</span></div> |
| <div class="block">Category of SqlAvgAggFunction. |
| |
| <p>Consists of <a href="#AVG"><code>AVG</code></a>, <a href="#STDDEV_POP"><code>STDDEV_POP</code></a>, <a href="#STDDEV_SAMP"><code>STDDEV_SAMP</code></a>, |
| <a href="#VAR_POP"><code>VAR_POP</code></a>, <a href="#VAR_SAMP"><code>VAR_SAMP</code></a>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COVAR_AVG_AGG_FUNCTIONS"> |
| <h3>COVAR_AVG_AGG_FUNCTIONS</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">COVAR_AVG_AGG_FUNCTIONS</span></div> |
| <div class="block">Category of SqlCovarAggFunction. |
| |
| <p>Consists of <a href="#COVAR_POP"><code>COVAR_POP</code></a>, <a href="#COVAR_SAMP"><code>COVAR_SAMP</code></a>, <a href="#REGR_SXX"><code>REGR_SXX</code></a>, |
| <a href="#REGR_SYY"><code>REGR_SYY</code></a>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="COMPARISON"> |
| <h3>COMPARISON</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">COMPARISON</span></div> |
| <div class="block">Category of comparison operators. |
| |
| <p>Consists of: |
| <a href="#IN"><code>IN</code></a>, |
| <a href="#EQUALS"><code>EQUALS</code></a>, |
| <a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a>, |
| <a href="#LESS_THAN"><code>LESS_THAN</code></a>, |
| <a href="#GREATER_THAN"><code>GREATER_THAN</code></a>, |
| <a href="#LESS_THAN_OR_EQUAL"><code>LESS_THAN_OR_EQUAL</code></a>, |
| <a href="#GREATER_THAN_OR_EQUAL"><code>GREATER_THAN_OR_EQUAL</code></a>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="BINARY_ARITHMETIC"> |
| <h3>BINARY_ARITHMETIC</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">BINARY_ARITHMETIC</span></div> |
| <div class="block">Category of binary arithmetic. |
| |
| <p>Consists of: |
| <a href="#PLUS"><code>PLUS</code></a> |
| <a href="#MINUS"><code>MINUS</code></a> |
| <a href="#TIMES"><code>TIMES</code></a> |
| <a href="#DIVIDE"><code>DIVIDE</code></a> |
| <a href="#MOD"><code>MOD</code></a>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="BINARY_EQUALITY"> |
| <h3>BINARY_EQUALITY</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">BINARY_EQUALITY</span></div> |
| <div class="block">Category of binary equality. |
| |
| <p>Consists of: |
| <a href="#EQUALS"><code>EQUALS</code></a> |
| <a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="BINARY_COMPARISON"> |
| <h3>BINARY_COMPARISON</h3> |
| <div class="member-signature"><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">BINARY_COMPARISON</span></div> |
| <div class="block">Category of binary comparison. |
| |
| <p>Consists of: |
| <a href="#EQUALS"><code>EQUALS</code></a> |
| <a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a> |
| <a href="#GREATER_THAN"><code>GREATER_THAN</code></a> |
| <a href="#GREATER_THAN_OR_EQUAL"><code>GREATER_THAN_OR_EQUAL</code></a> |
| <a href="#LESS_THAN"><code>LESS_THAN</code></a> |
| <a href="#LESS_THAN_OR_EQUAL"><code>LESS_THAN_OR_EQUAL</code></a> |
| <a href="#IS_DISTINCT_FROM"><code>IS_DISTINCT_FROM</code></a> |
| <a href="#IS_NOT_DISTINCT_FROM"><code>IS_NOT_DISTINCT_FROM</code></a></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SYMMETRICAL"> |
| <h3>SYMMETRICAL</h3> |
| <div class="member-signature"><span class="annotations">@API(since="1.22", |
| status=EXPERIMENTAL) |
| </span><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">SYMMETRICAL</span></div> |
| <div class="block">Category of operators that do not depend on the argument order. |
| |
| <p>For instance: <a href="#AND"><code>AND</code></a>, <a href="#OR"><code>OR</code></a>, <a href="#EQUALS"><code>EQUALS</code></a>, <a href="#LEAST"><code>LEAST</code></a></p> |
| <p>Note: <a href="#PLUS"><code>PLUS</code></a> does depend on the argument oder if argument types are different</p></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SYMMETRICAL_SAME_ARG_TYPE"> |
| <h3>SYMMETRICAL_SAME_ARG_TYPE</h3> |
| <div class="member-signature"><span class="annotations">@API(since="1.22", |
| status=EXPERIMENTAL) |
| </span><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">SYMMETRICAL_SAME_ARG_TYPE</span></div> |
| <div class="block">Category of operators that do not depend on the argument order if argument types are equal. |
| |
| <p>For instance: <a href="#PLUS"><code>PLUS</code></a>, <a href="#TIMES"><code>TIMES</code></a></p></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="SIMPLE_BINARY_OPS"> |
| <h3>SIMPLE_BINARY_OPS</h3> |
| <div class="member-signature"><span class="annotations">@API(since="1.24", |
| status=EXPERIMENTAL) |
| </span><span class="modifiers">public static final</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Set.html" title="class or interface in java.util" class="external-link">Set</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></span> <span class="element-name">SIMPLE_BINARY_OPS</span></div> |
| <div class="block">Simple binary operators are those operators which expects operands from the same Domain. |
| |
| <p>Example: simple comparisons (<code>=</code>, <code><</code>). |
| |
| <p>Note: it does not contain <code>IN</code> because that is defined on D x D^n.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="lowerName"> |
| <h3>lowerName</h3> |
| <div class="member-signature"><span class="modifiers">public final</span> <span class="return-type"><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></span> <span class="element-name">lowerName</span></div> |
| <div class="block">Lower-case name.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="sql"> |
| <h3>sql</h3> |
| <div class="member-signature"><span class="modifiers">public final</span> <span class="return-type"><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></span> <span class="element-name">sql</span></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="values()"> |
| <h3>values</h3> |
| <div class="member-signature"><span class="modifiers">public static</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>[]</span> <span class="element-name">values</span>()</div> |
| <div class="block">Returns an array containing the constants of this enum type, in |
| the order they are declared.</div> |
| <dl class="notes"> |
| <dt>Returns:</dt> |
| <dd>an array containing the constants of this enum type, in the order they are declared</dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="valueOf(java.lang.String)"> |
| <h3>valueOf</h3> |
| <div class="member-signature"><span class="modifiers">public static</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">valueOf</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> name)</span></div> |
| <div class="block">Returns the enum constant of this type with the specified name. |
| The string must match <i>exactly</i> an identifier used to declare an |
| enum constant in this type. (Extraneous whitespace characters are |
| not permitted.)</div> |
| <dl class="notes"> |
| <dt>Parameters:</dt> |
| <dd><code>name</code> - the name of the enum constant to be returned.</dd> |
| <dt>Returns:</dt> |
| <dd>the enum constant with the specified name</dd> |
| <dt>Throws:</dt> |
| <dd><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/IllegalArgumentException.html" title="class or interface in java.lang" class="external-link">IllegalArgumentException</a></code> - if this enum type has no constant with the specified name</dd> |
| <dd><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/NullPointerException.html" title="class or interface in java.lang" class="external-link">NullPointerException</a></code> - if the argument is null</dd> |
| </dl> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="reverse()"> |
| <h3>reverse</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">reverse</span>()</div> |
| <div class="block">Returns the kind that corresponds to this operator but in the opposite |
| direction. Or returns this, if this kind is not reversible. |
| |
| <p>For example, <code>GREATER_THAN.reverse()</code> returns <a href="#LESS_THAN"><code>LESS_THAN</code></a>.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="negate()"> |
| <h3>negate</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">negate</span>()</div> |
| <div class="block">Returns the kind that you get if you apply NOT to this kind. |
| |
| <p>For example, <code>IS_NOT_NULL.negate()</code> returns <a href="#IS_NULL"><code>IS_NULL</code></a>. |
| |
| <p>For <a href="#IS_TRUE"><code>IS_TRUE</code></a>, <a href="#IS_FALSE"><code>IS_FALSE</code></a>, <a href="#IS_NOT_TRUE"><code>IS_NOT_TRUE</code></a>, |
| <a href="#IS_NOT_FALSE"><code>IS_NOT_FALSE</code></a>, nullable inputs need to be treated carefully. |
| |
| <p><code>NOT(IS_TRUE(null))</code> = <code>NOT(false)</code> = <code>true</code>, |
| while <code>IS_FALSE(null)</code> = <code>false</code>, |
| so <code>NOT(IS_TRUE(X))</code> should be <code>IS_NOT_TRUE(X)</code>. |
| On the other hand, |
| <code>IS_TRUE(NOT(null))</code> = <code>IS_TRUE(null)</code> = <code>false</code>. |
| |
| <p>This is why negate() != negateNullSafe() for these operators.</div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="negateNullSafe()"> |
| <h3>negateNullSafe</h3> |
| <div class="member-signature"><span class="modifiers">public</span> <span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span> <span class="element-name">negateNullSafe</span>()</div> |
| <div class="block">Returns the kind that you get if you negate this kind. |
| To conform to null semantics, null value should not be compared. |
| |
| <p>For <a href="#IS_TRUE"><code>IS_TRUE</code></a>, <a href="#IS_FALSE"><code>IS_FALSE</code></a>, <a href="#IS_NOT_TRUE"><code>IS_NOT_TRUE</code></a> and |
| <a href="#IS_NOT_FALSE"><code>IS_NOT_FALSE</code></a>, nullable inputs need to be treated carefully: |
| |
| <ul> |
| <li>NOT(IS_TRUE(null)) = NOT(false) = true |
| <li>IS_TRUE(NOT(null)) = IS_TRUE(null) = false |
| <li>IS_FALSE(null) = false |
| <li>IS_NOT_TRUE(null) = true |
| </ul></div> |
| </section> |
| </li> |
| <li> |
| <section class="detail" id="belongsTo(java.util.Collection)"> |
| <h3>belongsTo</h3> |
| <div class="member-signature"><span class="modifiers">public final</span> <span class="return-type">boolean</span> <span class="element-name">belongsTo</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/Collection.html" title="class or interface in java.util" class="external-link">Collection</a><<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> category)</span></div> |
| <div class="block">Returns whether this <code>SqlKind</code> belongs to a given category. |
| |
| <p>A category is a collection of kinds, not necessarily disjoint. For |
| example, QUERY is { SELECT, UNION, INTERSECT, EXCEPT, VALUES, ORDER_BY, |
| EXPLICIT_TABLE }.</div> |
| <dl class="notes"> |
| <dt>Parameters:</dt> |
| <dd><code>category</code> - Category</dd> |
| <dt>Returns:</dt> |
| <dd>Whether this kind belongs to the given category</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> |