blob: 1d888a2f541c59cd46fc1206d50810cedd0d5db9 [file] [log] [blame]
<!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:&nbsp;</li>
<li><a href="#nested-class-summary">Nested</a>&nbsp;|&nbsp;</li>
<li><a href="#enum-constant-summary">Enum Constants</a>&nbsp;|&nbsp;</li>
<li><a href="#field-summary">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#method-summary">Method</a></li>
</ul>
<ul class="sub-nav-list">
<li>Detail:&nbsp;</li>
<li><a href="#enum-constant-detail">Enum Constants</a>&nbsp;|&nbsp;</li>
<li><a href="#field-detail">Field</a>&nbsp;|&nbsp;</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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;
<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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&lt;org.apache.calcite.sql.SqlKind&gt;)</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 '&gt;=', 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&nbsp;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>&lt;<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>&lt;<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>&gt;&gt;</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>=&gt;</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, "&gt;".</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, "&gt;=".</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, "&lt;".</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, "&lt;=".</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, "&#33;=" or "&lt;&gt;".</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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">&nbsp;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;&nbsp;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>&nbsp;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&nbsp;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&nbsp;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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="element-name">ARGUMENT_ASSIGNMENT</span></div>
<div class="block">Argument assignment operator, <code>=&gt;</code>.</div>
</section>
</li>
<li>
<section class="detail" id="DEFAULT">
<h3>DEFAULT</h3>
<div class="member-signature"><span class="modifiers">public static final</span>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="element-name">LESS_THAN</span></div>
<div class="block">Less-than operator, "&lt;".</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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="element-name">GREATER_THAN</span></div>
<div class="block">Greater-than operator, "&gt;".</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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="element-name">LESS_THAN_OR_EQUAL</span></div>
<div class="block">Less-than-or-equal operator, "&lt;=".</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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="element-name">GREATER_THAN_OR_EQUAL</span></div>
<div class="block">Greater-than-or-equal operator, "&gt;=".</div>
</section>
</li>
<li>
<section class="detail" id="EQUALS">
<h3>EQUALS</h3>
<div class="member-signature"><span class="modifiers">public static final</span>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="element-name">NOT_EQUALS</span></div>
<div class="block">Not-equals operator, "&#33;=" or "&lt;&gt;".
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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</span>&nbsp;<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>&lt;</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>&nbsp;<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>&nbsp;<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>&nbsp;<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>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>[]</span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<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>&nbsp;<span class="return-type">boolean</span>&nbsp;<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>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;&nbsp;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 &copy; 2012-2023 Apache Software Foundation. All Rights Reserved.</small></p>
</footer>
</div>
</div>
</body>
</html>