blob: b59252adcbbb20c142b7bc093bb4b7ece4a27061 [file] [log] [blame]
<!DOCTYPE HTML>
<!-- NewPage -->
<html lang="en">
<head>
<!-- Generated by javadoc -->
<title>SqlKind (Apache Calcite calcite API)</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">
<link rel="stylesheet" type="text/css" href="../../../../jquery/jquery-ui.css" title="Style">
<script type="text/javascript" src="../../../../script.js"></script>
<script type="text/javascript" src="../../../../jquery/jszip/dist/jszip.min.js"></script>
<script type="text/javascript" src="../../../../jquery/jszip-utils/dist/jszip-utils.min.js"></script>
<!--[if IE]>
<script type="text/javascript" src="../../../../jquery/jszip-utils/dist/jszip-utils-ie.min.js"></script>
<![endif]-->
<script type="text/javascript" src="../../../../jquery/jquery-3.3.1.js"></script>
<script type="text/javascript" src="../../../../jquery/jquery-migrate-3.0.1.js"></script>
<script type="text/javascript" src="../../../../jquery/jquery-ui.js"></script>
</head>
<body>
<script type="text/javascript"><!--
try {
if (location.href.indexOf('is-external=true') == -1) {
parent.document.title="SqlKind (Apache Calcite calcite API)";
}
}
catch(err) {
}
//-->
var data = {"i0":10,"i1":10,"i2":10,"i3":10,"i4":9,"i5":9};
var tabs = {65535:["t0","All Methods"],1:["t1","Static Methods"],2:["t2","Instance Methods"],8:["t4","Concrete Methods"]};
var altColor = "altColor";
var rowColor = "rowColor";
var tableTab = "tableTab";
var activeTableTab = "activeTableTab";
var pathtoroot = "../../../../";
var useModuleDirectories = true;
loadScripts(document, 'script');</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<header role="banner">
<nav role="navigation">
<div class="fixedNav">
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a id="navbar.top">
<!-- -->
</a>
<div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div>
<a id="navbar.top.firstrow">
<!-- -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../index.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">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">Help</a></li>
</ul>
<div class="aboutLanguage"><b>Apache Calcite</b></div>
</div>
<div class="subNav">
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../allclasses.html">All&nbsp;Classes</a></li>
</ul>
<ul class="navListSearch">
<li><label for="search">SEARCH:</label>
<input type="text" id="search" value="search" disabled="disabled">
<input type="reset" id="reset" value="reset" disabled="disabled">
</li>
</ul>
<div>
<script type="text/javascript"><!--
allClassesLink = document.getElementById("allclasses_navbar_top");
if(window==top) {
allClassesLink.style.display = "block";
}
else {
allClassesLink.style.display = "none";
}
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li>Nested&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="subNavList">
<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>
<a id="skip.navbar.top">
<!-- -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
</div>
<div class="navPadding">&nbsp;</div>
<script type="text/javascript"><!--
$('.navPadding').css('padding-top', $('.fixedNav').css("height"));
//-->
</script>
</nav>
</header>
<!-- ======== START OF CLASS DATA ======== -->
<main role="main">
<div class="header">
<div class="subTitle"><span class="packageLabelInType">Package</span>&nbsp;<a href="package-summary.html">org.apache.calcite.sql</a></div>
<h2 title="Enum SqlKind" class="title">Enum SqlKind</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">java.lang.Object</a></li>
<li>
<ul class="inheritance">
<li><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true" title="class or interface in java.lang" class="externalLink">java.lang.Enum</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</li>
<li>
<ul class="inheritance">
<li>org.apache.calcite.sql.SqlKind</li>
</ul>
</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<dl>
<dt>All Implemented Interfaces:</dt>
<dd><code><a href="https://docs.oracle.com/javase/9/docs/api/java/io/Serializable.html?is-external=true" title="class or interface in java.io" class="externalLink">Serializable</a></code>, <code><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Comparable.html?is-external=true" title="class or interface in java.lang" class="externalLink">Comparable</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></dd>
</dl>
<hr>
<pre>public enum <span class="typeNameLabel">SqlKind</span>
extends <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true" title="class or interface in java.lang" class="externalLink">Enum</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</pre>
<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>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- =========== ENUM CONSTANT SUMMARY =========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="enum.constant.summary">
<!-- -->
</a>
<h3>Enum Constant Summary</h3>
<table class="memberSummary">
<caption><span>Enum Constants</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Enum Constant</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALL">ALL</a></span></code></th>
<td class="colLast">
<div class="block"><code>ALL</code> quantification operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_INDEX">ALTER_INDEX</a></span></code></th>
<td class="colLast">
<div class="block"><code>ALTER INDEX</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_MATERIALIZED_VIEW">ALTER_MATERIALIZED_VIEW</a></span></code></th>
<td class="colLast">
<div class="block"><code>ALTER MATERIALIZED VIEW</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_SEQUENCE">ALTER_SEQUENCE</a></span></code></th>
<td class="colLast">
<div class="block"><code>ALTER SEQUENCE</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_SESSION">ALTER_SESSION</a></span></code></th>
<td class="colLast">
<div class="block"><code>ALTER SESSION</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_TABLE">ALTER_TABLE</a></span></code></th>
<td class="colLast">
<div class="block"><code>ALTER TABLE</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_VIEW">ALTER_VIEW</a></span></code></th>
<td class="colLast">
<div class="block"><code>ALTER VIEW</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#AND">AND</a></span></code></th>
<td class="colLast">
<div class="block">Logical "AND" operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ANY_VALUE">ANY_VALUE</a></span></code></th>
<td class="colLast">
<div class="block">The <code>ANY_VALUE</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ARGUMENT_ASSIGNMENT">ARGUMENT_ASSIGNMENT</a></span></code></th>
<td class="colLast">
<div class="block">Argument assignment operator, <code>=&gt;</code>.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ARRAY_QUERY_CONSTRUCTOR">ARRAY_QUERY_CONSTRUCTOR</a></span></code></th>
<td class="colLast">
<div class="block">Array Query Constructor, e.g.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ARRAY_VALUE_CONSTRUCTOR">ARRAY_VALUE_CONSTRUCTOR</a></span></code></th>
<td class="colLast">
<div class="block">Array Value Constructor, e.g.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#AS">AS</a></span></code></th>
<td class="colLast">
<div class="block"><code>AS</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ATTRIBUTE_DEF">ATTRIBUTE_DEF</a></span></code></th>
<td class="colLast">
<div class="block">Attribute definition.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#AVG">AVG</a></span></code></th>
<td class="colLast">
<div class="block">The <code>AVG</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#BETWEEN">BETWEEN</a></span></code></th>
<td class="colLast">
<div class="block"><code>BETWEEN</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#BIT_AND">BIT_AND</a></span></code></th>
<td class="colLast">
<div class="block">The <code>BIT_AND</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#BIT_OR">BIT_OR</a></span></code></th>
<td class="colLast">
<div class="block">The <code>BIT_OR</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#BIT_XOR">BIT_XOR</a></span></code></th>
<td class="colLast">
<div class="block">The <code>BIT_XOR</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CASE">CASE</a></span></code></th>
<td class="colLast">
<div class="block"><code>CASE</code> expression.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CAST">CAST</a></span></code></th>
<td class="colLast">
<div class="block">The "CAST" operator, and also the PostgreSQL-style infix cast operator
"::".</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CEIL">CEIL</a></span></code></th>
<td class="colLast">
<div class="block"><code>CEIL</code> function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CHECK">CHECK</a></span></code></th>
<td class="colLast">
<div class="block"><code>CHECK</code> constraint.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CLASSIFIER">CLASSIFIER</a></span></code></th>
<td class="colLast">
<div class="block"><code>CLASSIFIER</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COALESCE">COALESCE</a></span></code></th>
<td class="colLast">
<div class="block"><code>COALESCE</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COLLECT">COLLECT</a></span></code></th>
<td class="colLast">
<div class="block">The <code>COLLECT</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COLLECTION_TABLE">COLLECTION_TABLE</a></span></code></th>
<td class="colLast">
<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>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COLUMN_DECL">COLUMN_DECL</a></span></code></th>
<td class="colLast">
<div class="block">Column declaration.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COLUMN_LIST">COLUMN_LIST</a></span></code></th>
<td class="colLast">
<div class="block">The non-standard constructor used to pass a
COLUMN_LIST parameter to a user-defined transform.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COMMIT">COMMIT</a></span></code></th>
<td class="colLast">
<div class="block"><code>COMMIT</code> session control statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CONTAINS">CONTAINS</a></span></code></th>
<td class="colLast">
<div class="block"><code>CONTAINS</code> operator for periods.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CORREL_VARIABLE">CORREL_VARIABLE</a></span></code></th>
<td class="colLast">
<div class="block">Reference to correlation variable.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COUNT">COUNT</a></span></code></th>
<td class="colLast">
<div class="block">The <code>COUNT</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COVAR_POP">COVAR_POP</a></span></code></th>
<td class="colLast">
<div class="block">The <code>COVAR_POP</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COVAR_SAMP">COVAR_SAMP</a></span></code></th>
<td class="colLast">
<div class="block">The <code>COVAR_SAMP</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_FOREIGN_SCHEMA">CREATE_FOREIGN_SCHEMA</a></span></code></th>
<td class="colLast">
<div class="block"><code>CREATE FOREIGN SCHEMA</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_FUNCTION">CREATE_FUNCTION</a></span></code></th>
<td class="colLast">
<div class="block"><code>CREATE FUNCTION</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_INDEX">CREATE_INDEX</a></span></code></th>
<td class="colLast">
<div class="block"><code>CREATE INDEX</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_MATERIALIZED_VIEW">CREATE_MATERIALIZED_VIEW</a></span></code></th>
<td class="colLast">
<div class="block"><code>CREATE MATERIALIZED VIEW</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_SCHEMA">CREATE_SCHEMA</a></span></code></th>
<td class="colLast">
<div class="block"><code>CREATE SCHEMA</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_SEQUENCE">CREATE_SEQUENCE</a></span></code></th>
<td class="colLast">
<div class="block"><code>CREATE SEQUENCE</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_TABLE">CREATE_TABLE</a></span></code></th>
<td class="colLast">
<div class="block"><code>CREATE TABLE</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_TYPE">CREATE_TYPE</a></span></code></th>
<td class="colLast">
<div class="block"><code>CREATE TYPE</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_VIEW">CREATE_VIEW</a></span></code></th>
<td class="colLast">
<div class="block"><code>CREATE VIEW</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CUBE">CUBE</a></span></code></th>
<td class="colLast">
<div class="block">The internal <code>CUBE</code> operator that occurs within a <code>GROUP BY</code>
clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CUME_DIST">CUME_DIST</a></span></code></th>
<td class="colLast">
<div class="block">The <code>ROW_NUMBER</code> window function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_VALUE">CURRENT_VALUE</a></span></code></th>
<td class="colLast">
<div class="block">The "CURRENT VALUE OF sequence" operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CURSOR">CURSOR</a></span></code></th>
<td class="colLast">
<div class="block"><code>CURSOR</code> constructor, for example, <code>SELECT * FROM
TABLE(udx(CURSOR(SELECT ...), x, y, z))</code>.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DECODE">DECODE</a></span></code></th>
<td class="colLast">
<div class="block"><code>DECODE</code> function (Oracle).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DEFAULT">DEFAULT</a></span></code></th>
<td class="colLast">
<div class="block"><code>DEFAULT</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DELETE">DELETE</a></span></code></th>
<td class="colLast">
<div class="block">DELETE statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DENSE_RANK">DENSE_RANK</a></span></code></th>
<td class="colLast">
<div class="block">The <code>DENSE_RANK</code> window function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DESCENDING">DESCENDING</a></span></code></th>
<td class="colLast">
<div class="block"><code>DESC</code> operator in <code>ORDER BY</code>.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DESCRIBE_SCHEMA">DESCRIBE_SCHEMA</a></span></code></th>
<td class="colLast">
<div class="block">DESCRIBE SCHEMA statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DESCRIBE_TABLE">DESCRIBE_TABLE</a></span></code></th>
<td class="colLast">
<div class="block">DESCRIBE TABLE statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DESCRIPTOR">DESCRIPTOR</a></span></code></th>
<td class="colLast">
<div class="block">The <code>DESCRIPTOR(column_name, ...)</code>.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DIVIDE">DIVIDE</a></span></code></th>
<td class="colLast">
<div class="block">Arithmetic division operator, "/".</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DOT">DOT</a></span></code></th>
<td class="colLast">
<div class="block">Dot.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_FUNCTION">DROP_FUNCTION</a></span></code></th>
<td class="colLast">
<div class="block"><code>DROP FUNCTION</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_INDEX">DROP_INDEX</a></span></code></th>
<td class="colLast">
<div class="block"><code>DROP INDEX</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_MATERIALIZED_VIEW">DROP_MATERIALIZED_VIEW</a></span></code></th>
<td class="colLast">
<div class="block"><code>DROP MATERIALIZED VIEW</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_SCHEMA">DROP_SCHEMA</a></span></code></th>
<td class="colLast">
<div class="block"><code>DROP SCHEMA</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_SEQUENCE">DROP_SEQUENCE</a></span></code></th>
<td class="colLast">
<div class="block"><code>DROP SEQUENCE</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_TABLE">DROP_TABLE</a></span></code></th>
<td class="colLast">
<div class="block"><code>DROP TABLE</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_TYPE">DROP_TYPE</a></span></code></th>
<td class="colLast">
<div class="block"><code>DROP TYPE</code> DDL statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_VIEW">DROP_VIEW</a></span></code></th>
<td class="colLast">
<div class="block"><code>DROP VIEW</code> DDL statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DYNAMIC_PARAM">DYNAMIC_PARAM</a></span></code></th>
<td class="colLast">
<div class="block">A dynamic parameter.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EQUALS">EQUALS</a></span></code></th>
<td class="colLast">
<div class="block">Equals operator, "=".</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ESCAPE">ESCAPE</a></span></code></th>
<td class="colLast">
<div class="block">Escape operator (always part of LIKE or SIMILAR TO expression).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXCEPT">EXCEPT</a></span></code></th>
<td class="colLast">
<div class="block"><code>EXCEPT</code> relational operator (known as <code>MINUS</code> in some SQL
dialects).</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXISTS">EXISTS</a></span></code></th>
<td class="colLast">
<div class="block"><code>EXISTS</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXPLAIN">EXPLAIN</a></span></code></th>
<td class="colLast">
<div class="block">EXPLAIN statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXPLICIT_TABLE">EXPLICIT_TABLE</a></span></code></th>
<td class="colLast">
<div class="block">Explicit table, e.g.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXTEND">EXTEND</a></span></code></th>
<td class="colLast">
<div class="block">The internal <code>EXTEND</code> operator that qualifies a table name in the
<code>FROM</code> clause.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXTRACT">EXTRACT</a></span></code></th>
<td class="colLast">
<div class="block"><code>EXTRACT</code> function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FIELD_ACCESS">FIELD_ACCESS</a></span></code></th>
<td class="colLast">
<div class="block">The field access operator, ".".</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FILTER">FILTER</a></span></code></th>
<td class="colLast">
<div class="block"><code>FILTER</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FINAL">FINAL</a></span></code></th>
<td class="colLast">
<div class="block"><code>FINAL</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FIRST">FIRST</a></span></code></th>
<td class="colLast">
<div class="block"><code>FIRST</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FIRST_VALUE">FIRST_VALUE</a></span></code></th>
<td class="colLast">
<div class="block">The <code>FIRST_VALUE</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FLOOR">FLOOR</a></span></code></th>
<td class="colLast">
<div class="block"><code>FLOOR</code> function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FOLLOWING">FOLLOWING</a></span></code></th>
<td class="colLast">
<div class="block"><code>FOLLOWING</code> qualifier of an interval end-point in a window
specification.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FOREIGN_KEY">FOREIGN_KEY</a></span></code></th>
<td class="colLast">
<div class="block"><code>FOREIGN KEY</code> constraint.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FUSION">FUSION</a></span></code></th>
<td class="colLast">
<div class="block">The <code>FUSION</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GREATER_THAN">GREATER_THAN</a></span></code></th>
<td class="colLast">
<div class="block">Greater-than operator, "&gt;".</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GREATER_THAN_OR_EQUAL">GREATER_THAN_OR_EQUAL</a></span></code></th>
<td class="colLast">
<div class="block">Greater-than-or-equal operator, "&gt;=".</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GREATEST">GREATEST</a></span></code></th>
<td class="colLast">
<div class="block"><code>GREATEST</code> function (Oracle).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GROUP_ID">GROUP_ID</a></span></code></th>
<td class="colLast">
<div class="block">The <code>GROUP_ID()</code> function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GROUPING">GROUPING</a></span></code></th>
<td class="colLast">
<div class="block">The <code>GROUPING(e, ...)</code> function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GROUPING_ID">GROUPING_ID</a></span></code></th>
<td class="colLast">
<div class="block"><span class="deprecatedLabel">Deprecated.</span>
<div class="deprecationComment">Use <a href="#GROUPING"><code>GROUPING</code></a>.</div>
</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GROUPING_SETS">GROUPING_SETS</a></span></code></th>
<td class="colLast">
<div class="block">The internal <code>GROUPING SETS</code> operator that occurs within a
<code>GROUP BY</code> clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#HINT">HINT</a></span></code></th>
<td class="colLast">
<div class="block">Sql Hint statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#HOP">HOP</a></span></code></th>
<td class="colLast">
<div class="block">The <code>HOP</code> group function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#HOP_END">HOP_END</a></span></code></th>
<td class="colLast">
<div class="block">The <code>HOP_END</code> auxiliary function of
the <a href="#HOP"><code>HOP</code></a> group function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#HOP_START">HOP_START</a></span></code></th>
<td class="colLast">
<div class="block">The <code>HOP_START</code> auxiliary function of
the <a href="#HOP"><code>HOP</code></a> group function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IDENTIFIER">IDENTIFIER</a></span></code></th>
<td class="colLast">
<div class="block">An identifier.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IGNORE_NULLS">IGNORE_NULLS</a></span></code></th>
<td class="colLast">
<div class="block"><code>IGNORE NULLS</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IMMEDIATELY_PRECEDES">IMMEDIATELY_PRECEDES</a></span></code></th>
<td class="colLast">
<div class="block"><code>IMMEDIATELY PRECEDES</code> operator for periods.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IMMEDIATELY_SUCCEEDS">IMMEDIATELY_SUCCEEDS</a></span></code></th>
<td class="colLast">
<div class="block"><code>IMMEDIATELY SUCCEEDS</code> operator for periods.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IN">IN</a></span></code></th>
<td class="colLast">
<div class="block"><code>IN</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#INPUT_REF">INPUT_REF</a></span></code></th>
<td class="colLast">
<div class="block">Reference to an input field.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#INSERT">INSERT</a></span></code></th>
<td class="colLast">
<div class="block">INSERT statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#INTERSECT">INTERSECT</a></span></code></th>
<td class="colLast">
<div class="block"><code>INTERSECT</code> relational operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#INTERSECTION">INTERSECTION</a></span></code></th>
<td class="colLast">
<div class="block">The <code>INTERSECTION</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#INTERVAL">INTERVAL</a></span></code></th>
<td class="colLast">
<div class="block"><code>INTERVAL</code> expression.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#INTERVAL_QUALIFIER">INTERVAL_QUALIFIER</a></span></code></th>
<td class="colLast">
<div class="block">Interval qualifier.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_DISTINCT_FROM">IS_DISTINCT_FROM</a></span></code></th>
<td class="colLast">
<div class="block"><code>IS DISTINCT FROM</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_FALSE">IS_FALSE</a></span></code></th>
<td class="colLast">
<div class="block"><code>IS FALSE</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_DISTINCT_FROM">IS_NOT_DISTINCT_FROM</a></span></code></th>
<td class="colLast">
<div class="block"><code>IS NOT DISTINCT FROM</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_FALSE">IS_NOT_FALSE</a></span></code></th>
<td class="colLast">
<div class="block"><code>IS NOT FALSE</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_NULL">IS_NOT_NULL</a></span></code></th>
<td class="colLast">
<div class="block"><code>IS NOT NULL</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_TRUE">IS_NOT_TRUE</a></span></code></th>
<td class="colLast">
<div class="block"><code>IS NOT TRUE</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_NULL">IS_NULL</a></span></code></th>
<td class="colLast">
<div class="block"><code>IS NULL</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_TRUE">IS_TRUE</a></span></code></th>
<td class="colLast">
<div class="block"><code>IS TRUE</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_UNKNOWN">IS_UNKNOWN</a></span></code></th>
<td class="colLast">
<div class="block"><code>IS UNKNOWN</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ITEM">ITEM</a></span></code></th>
<td class="colLast">
<div class="block">Item expression.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#JDBC_FN">JDBC_FN</a></span></code></th>
<td class="colLast">
<div class="block">Call to a function using JDBC function syntax.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#JOIN">JOIN</a></span></code></th>
<td class="colLast">
<div class="block">JOIN operator or compound FROM clause.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#JSON_ARRAYAGG">JSON_ARRAYAGG</a></span></code></th>
<td class="colLast">
<div class="block"><code>JSON_ARRAYAGG</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#JSON_OBJECTAGG">JSON_OBJECTAGG</a></span></code></th>
<td class="colLast">
<div class="block"><code>JSON_OBJECTAGG</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#JSON_VALUE_EXPRESSION">JSON_VALUE_EXPRESSION</a></span></code></th>
<td class="colLast">
<div class="block"><code>JSON</code> value expression.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LAG">LAG</a></span></code></th>
<td class="colLast">
<div class="block">The <code>LAG</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LAST">LAST</a></span></code></th>
<td class="colLast">
<div class="block"><code>LAST</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LAST_VALUE">LAST_VALUE</a></span></code></th>
<td class="colLast">
<div class="block">The <code>LAST_VALUE</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LATERAL">LATERAL</a></span></code></th>
<td class="colLast">
<div class="block">The "LATERAL" qualifier to relations in the FROM clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LEAD">LEAD</a></span></code></th>
<td class="colLast">
<div class="block">The <code>LEAD</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LEAST">LEAST</a></span></code></th>
<td class="colLast">
<div class="block"><code>LEAST</code> function (Oracle).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LESS_THAN">LESS_THAN</a></span></code></th>
<td class="colLast">
<div class="block">Less-than operator, "&lt;".</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LESS_THAN_OR_EQUAL">LESS_THAN_OR_EQUAL</a></span></code></th>
<td class="colLast">
<div class="block">Less-than-or-equal operator, "&lt;=".</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LIKE">LIKE</a></span></code></th>
<td class="colLast">
<div class="block"><code>LIKE</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LISTAGG">LISTAGG</a></span></code></th>
<td class="colLast">
<div class="block">The <code>LISTAGG</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LITERAL">LITERAL</a></span></code></th>
<td class="colLast">
<div class="block">A literal.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LITERAL_CHAIN">LITERAL_CHAIN</a></span></code></th>
<td class="colLast">
<div class="block">Literal chain operator (for composite string literals).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LOCAL_REF">LOCAL_REF</a></span></code></th>
<td class="colLast">
<div class="block">Reference to a sub-expression computed within the current relational
operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LTRIM">LTRIM</a></span></code></th>
<td class="colLast">
<div class="block"><code>LTRIM</code> function (Oracle).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MAP_QUERY_CONSTRUCTOR">MAP_QUERY_CONSTRUCTOR</a></span></code></th>
<td class="colLast">
<div class="block">MAP query constructor,
e.g.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MAP_VALUE_CONSTRUCTOR">MAP_VALUE_CONSTRUCTOR</a></span></code></th>
<td class="colLast">
<div class="block">MAP value constructor, e.g.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MATCH_NUMBER">MATCH_NUMBER</a></span></code></th>
<td class="colLast">
<div class="block"><code>MATCH_NUMBER</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MATCH_RECOGNIZE">MATCH_RECOGNIZE</a></span></code></th>
<td class="colLast">
<div class="block">MATCH_RECOGNIZE clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MAX">MAX</a></span></code></th>
<td class="colLast">
<div class="block">The <code>MAX</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MERGE">MERGE</a></span></code></th>
<td class="colLast">
<div class="block">MERGE statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MIN">MIN</a></span></code></th>
<td class="colLast">
<div class="block">The <code>MIN</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MINUS">MINUS</a></span></code></th>
<td class="colLast">
<div class="block">Arithmetic minus operator, "-".</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MINUS_PREFIX">MINUS_PREFIX</a></span></code></th>
<td class="colLast">
<div class="block">Unary minus operator, as in "-1".</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MOD">MOD</a></span></code></th>
<td class="colLast">
<div class="block">Arithmetic remainder operator, "MOD" (and "%" in some dialects).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_QUERY_CONSTRUCTOR">MULTISET_QUERY_CONSTRUCTOR</a></span></code></th>
<td class="colLast">
<div class="block"><code>MULTISET</code> query constructor.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_VALUE_CONSTRUCTOR">MULTISET_VALUE_CONSTRUCTOR</a></span></code></th>
<td class="colLast">
<div class="block"><code>MULTISET</code> value constructor.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NEW_SPECIFICATION">NEW_SPECIFICATION</a></span></code></th>
<td class="colLast">
<div class="block">New specification.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NEXT">NEXT</a></span></code></th>
<td class="colLast">
<div class="block"><code>NEXT</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NEXT_VALUE">NEXT_VALUE</a></span></code></th>
<td class="colLast">
<div class="block">The "NEXT VALUE OF sequence" operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NOT">NOT</a></span></code></th>
<td class="colLast">
<div class="block">Logical <code>NOT</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NOT_EQUALS">NOT_EQUALS</a></span></code></th>
<td class="colLast">
<div class="block">Not-equals operator, "&#33;=" or "&lt;&gt;".</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NOT_IN">NOT_IN</a></span></code></th>
<td class="colLast">
<div class="block"><code>NOT IN</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NTH_VALUE">NTH_VALUE</a></span></code></th>
<td class="colLast">
<div class="block">The <code>NTH_VALUE</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NTILE">NTILE</a></span></code></th>
<td class="colLast">
<div class="block">The <code>NTILE</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NULLIF">NULLIF</a></span></code></th>
<td class="colLast">
<div class="block"><code>NULLIF</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NULLS_FIRST">NULLS_FIRST</a></span></code></th>
<td class="colLast">
<div class="block"><code>NULLS FIRST</code> clause in <code>ORDER BY</code>.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NULLS_LAST">NULLS_LAST</a></span></code></th>
<td class="colLast">
<div class="block"><code>NULLS LAST</code> clause in <code>ORDER BY</code>.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NVL">NVL</a></span></code></th>
<td class="colLast">
<div class="block"><code>NVL</code> function (Oracle).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OR">OR</a></span></code></th>
<td class="colLast">
<div class="block">Logical "OR" operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ORDER_BY">ORDER_BY</a></span></code></th>
<td class="colLast">
<div class="block">ORDER BY clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OTHER">OTHER</a></span></code></th>
<td class="colLast">
<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>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OTHER_DDL">OTHER_DDL</a></span></code></th>
<td class="colLast">
<div class="block">DDL statement not handled above.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OTHER_FUNCTION">OTHER_FUNCTION</a></span></code></th>
<td class="colLast">
<div class="block">Function that is not a special function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OVER">OVER</a></span></code></th>
<td class="colLast">
<div class="block"><code>OVER</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OVERLAPS">OVERLAPS</a></span></code></th>
<td class="colLast">
<div class="block"><code>OVERLAPS</code> operator for periods.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_ALTER">PATTERN_ALTER</a></span></code></th>
<td class="colLast">
<div class="block">Alternation operator in a pattern expression within a
<code>MATCH_RECOGNIZE</code> clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_CONCAT">PATTERN_CONCAT</a></span></code></th>
<td class="colLast">
<div class="block">Concatenation operator in a pattern expression within a
<code>MATCH_RECOGNIZE</code> clause.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_EXCLUDED">PATTERN_EXCLUDED</a></span></code></th>
<td class="colLast">
<div class="block">The special patterns to exclude enclosing pattern from output in a
MATCH_RECOGNIZE clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_INPUT_REF">PATTERN_INPUT_REF</a></span></code></th>
<td class="colLast">
<div class="block">Reference to an input field, with pattern var as modifier.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_PERMUTE">PATTERN_PERMUTE</a></span></code></th>
<td class="colLast">
<div class="block">The internal "permute" function in a MATCH_RECOGNIZE clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_QUANTIFIER">PATTERN_QUANTIFIER</a></span></code></th>
<td class="colLast">
<div class="block">the repetition quantifier of a pattern factor in a match_recognize clause.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PERCENT_RANK">PERCENT_RANK</a></span></code></th>
<td class="colLast">
<div class="block">The <code>PERCENT_RANK</code> window function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PERIOD_EQUALS">PERIOD_EQUALS</a></span></code></th>
<td class="colLast">
<div class="block"><code>EQUALS</code> operator for periods.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PLUS">PLUS</a></span></code></th>
<td class="colLast">
<div class="block">Arithmetic plus operator, "+".</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PLUS_PREFIX">PLUS_PREFIX</a></span></code></th>
<td class="colLast">
<div class="block">Unary plus operator, as in "+1".</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#POSITION">POSITION</a></span></code></th>
<td class="colLast">
<div class="block">POSITION function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#POSIX_REGEX_CASE_INSENSITIVE">POSIX_REGEX_CASE_INSENSITIVE</a></span></code></th>
<td class="colLast">
<div class="block"><code>~*</code> operator (for case-insensitive POSIX-style regular
expressions).</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#POSIX_REGEX_CASE_SENSITIVE">POSIX_REGEX_CASE_SENSITIVE</a></span></code></th>
<td class="colLast">
<div class="block"><code>~</code> operator (for POSIX-style regular expressions).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PRECEDES">PRECEDES</a></span></code></th>
<td class="colLast">
<div class="block"><code>PRECEDES</code> operator for periods.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PRECEDING">PRECEDING</a></span></code></th>
<td class="colLast">
<div class="block"><code>PRECEDING</code> qualifier of an interval end-point in a window
specification.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PREV">PREV</a></span></code></th>
<td class="colLast">
<div class="block"><code>PREV</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PRIMARY_KEY">PRIMARY_KEY</a></span></code></th>
<td class="colLast">
<div class="block"><code>PRIMARY KEY</code> constraint.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PROCEDURE_CALL">PROCEDURE_CALL</a></span></code></th>
<td class="colLast">
<div class="block">Procedure call.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#RANK">RANK</a></span></code></th>
<td class="colLast">
<div class="block">The <code>RANK</code> window function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REGR_COUNT">REGR_COUNT</a></span></code></th>
<td class="colLast">
<div class="block">The <code>REGR_COUNT</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REGR_SXX">REGR_SXX</a></span></code></th>
<td class="colLast">
<div class="block">The <code>REGR_SXX</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REGR_SYY">REGR_SYY</a></span></code></th>
<td class="colLast">
<div class="block">The <code>REGR_SYY</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REINTERPRET">REINTERPRET</a></span></code></th>
<td class="colLast">
<div class="block">The internal REINTERPRET operator (meaning a reinterpret cast).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#RESPECT_NULLS">RESPECT_NULLS</a></span></code></th>
<td class="colLast">
<div class="block"><code>RESPECT NULLS</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REVERSE">REVERSE</a></span></code></th>
<td class="colLast">
<div class="block"><code>REVERSE</code> function (SQL Server, MySQL).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ROLLBACK">ROLLBACK</a></span></code></th>
<td class="colLast">
<div class="block"><code>ROLLBACK</code> session control statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ROLLUP">ROLLUP</a></span></code></th>
<td class="colLast">
<div class="block">The internal <code>ROLLUP</code> operator that occurs within a <code>GROUP BY</code>
clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ROW">ROW</a></span></code></th>
<td class="colLast">
<div class="block">The row-constructor function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ROW_NUMBER">ROW_NUMBER</a></span></code></th>
<td class="colLast">
<div class="block">The <code>ROW_NUMBER</code> window function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#RTRIM">RTRIM</a></span></code></th>
<td class="colLast">
<div class="block"><code>RTRIM</code> function (Oracle).</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#RUNNING">RUNNING</a></span></code></th>
<td class="colLast">
<div class="block"><code>FINAL</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SCALAR_QUERY">SCALAR_QUERY</a></span></code></th>
<td class="colLast">
<div class="block">Scalar query; that is, a sub-query used in an expression context, and
returning one row and one column.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SELECT">SELECT</a></span></code></th>
<td class="colLast">
<div class="block">SELECT statement or sub-query.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SESSION">SESSION</a></span></code></th>
<td class="colLast">
<div class="block">The <code>SESSION</code> group function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SESSION_END">SESSION_END</a></span></code></th>
<td class="colLast">
<div class="block">The <code>SESSION_END</code> auxiliary function of
the <a href="#SESSION"><code>SESSION</code></a> group function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SESSION_START">SESSION_START</a></span></code></th>
<td class="colLast">
<div class="block">The <code>SESSION_START</code> auxiliary function of
the <a href="#SESSION"><code>SESSION</code></a> group function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SET_OPTION">SET_OPTION</a></span></code></th>
<td class="colLast">
<div class="block">"<code>ALTER scope SET option = value</code>" statement.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SIMILAR">SIMILAR</a></span></code></th>
<td class="colLast">
<div class="block"><code>SIMILAR</code> operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SINGLE_VALUE">SINGLE_VALUE</a></span></code></th>
<td class="colLast">
<div class="block">The <code>SINGLE_VALUE</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SKIP_TO_FIRST">SKIP_TO_FIRST</a></span></code></th>
<td class="colLast">
<div class="block"><code>SKIP TO FIRST</code> qualifier of restarting point in a
<code>MATCH_RECOGNIZE</code> clause.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SKIP_TO_LAST">SKIP_TO_LAST</a></span></code></th>
<td class="colLast">
<div class="block"><code>SKIP TO LAST</code> qualifier of restarting point in a
<code>MATCH_RECOGNIZE</code> clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SNAPSHOT">SNAPSHOT</a></span></code></th>
<td class="colLast">
<div class="block">SNAPSHOT operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SOME">SOME</a></span></code></th>
<td class="colLast">
<div class="block"><code>SOME</code> quantification operator (also called <code>ANY</code>).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#STDDEV_POP">STDDEV_POP</a></span></code></th>
<td class="colLast">
<div class="block">The <code>STDDEV_POP</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#STDDEV_SAMP">STDDEV_SAMP</a></span></code></th>
<td class="colLast">
<div class="block">The <code>STDDEV_SAMP</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SUCCEEDS">SUCCEEDS</a></span></code></th>
<td class="colLast">
<div class="block"><code>SUCCEEDS</code> operator for periods.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SUM">SUM</a></span></code></th>
<td class="colLast">
<div class="block">The <code>SUM</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SUM0">SUM0</a></span></code></th>
<td class="colLast">
<div class="block">The <code>SUM0</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TABLE_INPUT_REF">TABLE_INPUT_REF</a></span></code></th>
<td class="colLast">
<div class="block">Reference to an input field, with a qualified name and an identifier.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TABLE_REF">TABLE_REF</a></span></code></th>
<td class="colLast">
<div class="block">Table reference.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TABLESAMPLE">TABLESAMPLE</a></span></code></th>
<td class="colLast">
<div class="block">TABLESAMPLE relational operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TIMES">TIMES</a></span></code></th>
<td class="colLast">
<div class="block">Arithmetic multiplication operator, "*".</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TIMESTAMP_ADD">TIMESTAMP_ADD</a></span></code></th>
<td class="colLast">
<div class="block"><code>TIMESTAMP_ADD</code> function (ODBC, SQL Server, MySQL).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TIMESTAMP_DIFF">TIMESTAMP_DIFF</a></span></code></th>
<td class="colLast">
<div class="block"><code>TIMESTAMP_DIFF</code> function (ODBC, SQL Server, MySQL).</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TRIM">TRIM</a></span></code></th>
<td class="colLast">
<div class="block"><code>TRIM</code> function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TUMBLE">TUMBLE</a></span></code></th>
<td class="colLast">
<div class="block">The <code>TUMBLE</code> group function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TUMBLE_END">TUMBLE_END</a></span></code></th>
<td class="colLast">
<div class="block">The <code>TUMBLE_END</code> auxiliary function of
the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TUMBLE_START">TUMBLE_START</a></span></code></th>
<td class="colLast">
<div class="block">The <code>TUMBLE_START</code> auxiliary function of
the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#UNION">UNION</a></span></code></th>
<td class="colLast">
<div class="block"><code>UNION</code> relational operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#UNIQUE">UNIQUE</a></span></code></th>
<td class="colLast">
<div class="block"><code>UNIQUE</code> constraint.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#UNNEST">UNNEST</a></span></code></th>
<td class="colLast">
<div class="block"><code>UNNEST</code> operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#UPDATE">UPDATE</a></span></code></th>
<td class="colLast">
<div class="block">UPDATE statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#VALUES">VALUES</a></span></code></th>
<td class="colLast">
<div class="block"><code>VALUES</code> relational operator.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#VAR_POP">VAR_POP</a></span></code></th>
<td class="colLast">
<div class="block">The <code>VAR_POP</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#VAR_SAMP">VAR_SAMP</a></span></code></th>
<td class="colLast">
<div class="block">The <code>VAR_SAMP</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#WINDOW">WINDOW</a></span></code></th>
<td class="colLast">
<div class="block">Window specification.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#WITH">WITH</a></span></code></th>
<td class="colLast">
<div class="block">WITH clause.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#WITH_ITEM">WITH_ITEM</a></span></code></th>
<td class="colLast">
<div class="block">Item in WITH clause.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#WITHIN_GROUP">WITHIN_GROUP</a></span></code></th>
<td class="colLast">
<div class="block"><code>WITHIN GROUP</code> operator.</div>
</td>
</tr>
</table>
</li>
</ul>
</section>
<!-- =========== FIELD SUMMARY =========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="field.summary">
<!-- -->
</a>
<h3>Field Summary</h3>
<table class="memberSummary">
<caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colSecond" scope="col">Field</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#AGGREGATE">AGGREGATE</a></span></code></th>
<td class="colLast">
<div class="block">Category consisting of all built-in aggregate functions.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#AVG_AGG_FUNCTIONS">AVG_AGG_FUNCTIONS</a></span></code></th>
<td class="colLast">
<div class="block">Category of SqlAvgAggFunction.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#BINARY_ARITHMETIC">BINARY_ARITHMETIC</a></span></code></th>
<td class="colLast">
<div class="block">Category of binary arithmetic.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#BINARY_COMPARISON">BINARY_COMPARISON</a></span></code></th>
<td class="colLast">
<div class="block">Category of binary comparison.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#BINARY_EQUALITY">BINARY_EQUALITY</a></span></code></th>
<td class="colLast">
<div class="block">Category of binary equality.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COMPARISON">COMPARISON</a></span></code></th>
<td class="colLast">
<div class="block">Category of comparison operators.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COVAR_AVG_AGG_FUNCTIONS">COVAR_AVG_AGG_FUNCTIONS</a></span></code></th>
<td class="colLast">
<div class="block">Category of SqlCovarAggFunction.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DDL">DDL</a></span></code></th>
<td class="colLast">
<div class="block">Category consisting of all DDL operators.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DML">DML</a></span></code></th>
<td class="colLast">
<div class="block">Category consisting of all DML operators.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#EXPRESSION">EXPRESSION</a></span></code></th>
<td class="colLast">
<div class="block">Category consisting of all expression operators.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#FUNCTION">FUNCTION</a></span></code></th>
<td class="colLast">
<div class="block">Category consisting of regular and special functions.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a></code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lowerName">lowerName</a></span></code></th>
<td class="colLast">
<div class="block">Lower-case name.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#QUERY">QUERY</a></span></code></th>
<td class="colLast">
<div class="block">Category consisting of query node types.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SET_QUERY">SET_QUERY</a></span></code></th>
<td class="colLast">
<div class="block">Category consisting of set-query node types.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SIMPLE_BINARY_OPS">SIMPLE_BINARY_OPS</a></span></code></th>
<td class="colLast">
<div class="block">Simple binary operators are those operators which expects operands from the same Domain.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a></code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#sql">sql</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SYMMETRICAL">SYMMETRICAL</a></span></code></th>
<td class="colLast">
<div class="block">Category of operators that do not depend on the argument order.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SYMMETRICAL_SAME_ARG_TYPE">SYMMETRICAL_SAME_ARG_TYPE</a></span></code></th>
<td class="colLast">
<div class="block">Category of operators that do not depend on the argument order if argument types are equal.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#TOP_LEVEL">TOP_LEVEL</a></span></code></th>
<td class="colLast">
<div class="block">Category of all SQL statement types.</div>
</td>
</tr>
</table>
</li>
</ul>
</section>
<!-- ========== METHOD SUMMARY =========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="method.summary">
<!-- -->
</a>
<h3>Method Summary</h3>
<table class="memberSummary">
<caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd">&nbsp;</span></span><span id="t1" class="tableTab"><span><a href="javascript:show(1);">Static Methods</a></span><span class="tabEnd">&nbsp;</span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd">&nbsp;</span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd">&nbsp;</span></span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colSecond" scope="col">Method</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr id="i0" class="altColor">
<td class="colFirst"><code>boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#belongsTo(java.util.Collection)">belongsTo</a></span>&#8203;(<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;&nbsp;category)</code></th>
<td class="colLast">
<div class="block">Returns whether this <code>SqlKind</code> belongs to a given category.</div>
</td>
</tr>
<tr id="i1" class="rowColor">
<td class="colFirst"><code><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#negate()">negate</a></span>()</code></th>
<td class="colLast">
<div class="block">Returns the kind that you get if you apply NOT to this kind.</div>
</td>
</tr>
<tr id="i2" class="altColor">
<td class="colFirst"><code><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#negateNullSafe()">negateNullSafe</a></span>()</code></th>
<td class="colLast">
<div class="block">Returns the kind that you get if you negate this kind.</div>
</td>
</tr>
<tr id="i3" class="rowColor">
<td class="colFirst"><code><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#reverse()">reverse</a></span>()</code></th>
<td class="colLast">
<div class="block">Returns the kind that corresponds to this operator but in the opposite
direction.</div>
</td>
</tr>
<tr id="i4" class="altColor">
<td class="colFirst"><code>static <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#valueOf(java.lang.String)">valueOf</a></span>&#8203;(<a href="https://docs.oracle.com/javase/9/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>&nbsp;name)</code></th>
<td class="colLast">
<div class="block">Returns the enum constant of this type with the specified name.</div>
</td>
</tr>
<tr id="i5" class="rowColor">
<td class="colFirst"><code>static <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>[]</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#values()">values</a></span>()</code></th>
<td class="colLast">
<div class="block">Returns an array containing the constants of this enum type, in
the order they are declared.</div>
</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a id="methods.inherited.from.class.java.lang.Enum">
<!-- -->
</a>
<h3>Methods inherited from class&nbsp;java.lang.<a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true" title="class or interface in java.lang" class="externalLink">Enum</a></h3>
<code><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true#clone()" title="class or interface in java.lang" class="externalLink">clone</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true#compareTo(E)" title="class or interface in java.lang" class="externalLink">compareTo</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true#equals(java.lang.Object)" title="class or interface in java.lang" class="externalLink">equals</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true#finalize()" title="class or interface in java.lang" class="externalLink">finalize</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true#getDeclaringClass()" title="class or interface in java.lang" class="externalLink">getDeclaringClass</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true#hashCode()" title="class or interface in java.lang" class="externalLink">hashCode</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true#name()" title="class or interface in java.lang" class="externalLink">name</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true#ordinal()" title="class or interface in java.lang" class="externalLink">ordinal</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true#toString()" title="class or interface in java.lang" class="externalLink">toString</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.html?is-external=true#valueOf(java.lang.Class,java.lang.String)" title="class or interface in java.lang" class="externalLink">valueOf</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a id="methods.inherited.from.class.java.lang.Object">
<!-- -->
</a>
<h3>Methods inherited from class&nbsp;java.lang.<a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a></h3>
<code><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Object.html?is-external=true#getClass()" title="class or interface in java.lang" class="externalLink">getClass</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Object.html?is-external=true#notify()" title="class or interface in java.lang" class="externalLink">notify</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Object.html?is-external=true#notifyAll()" title="class or interface in java.lang" class="externalLink">notifyAll</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Object.html?is-external=true#wait()" title="class or interface in java.lang" class="externalLink">wait</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Object.html?is-external=true#wait(long)" title="class or interface in java.lang" class="externalLink">wait</a>, <a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Object.html?is-external=true#wait(long,int)" title="class or interface in java.lang" class="externalLink">wait</a></code></li>
</ul>
</li>
</ul>
</section>
</li>
</ul>
</div>
<div class="details">
<ul class="blockList">
<li class="blockList">
<!-- ============ ENUM CONSTANT DETAIL =========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="enum.constant.detail">
<!-- -->
</a>
<h3>Enum Constant Detail</h3>
<a id="OTHER">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>OTHER</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OTHER</pre>
<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>
<dt><span class="seeLabel">See Also:</span></dt>
<dd><a href="#OTHER_FUNCTION"><code>OTHER_FUNCTION</code></a></dd>
</dl>
</li>
</ul>
<a id="SELECT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SELECT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SELECT</pre>
<div class="block">SELECT statement or sub-query.</div>
</li>
</ul>
<a id="HINT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>HINT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> HINT</pre>
<div class="block">Sql Hint statement.</div>
</li>
</ul>
<a id="TABLE_REF">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TABLE_REF</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TABLE_REF</pre>
<div class="block">Table reference.</div>
</li>
</ul>
<a id="JOIN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>JOIN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> JOIN</pre>
<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>
</li>
</ul>
<a id="IDENTIFIER">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IDENTIFIER</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IDENTIFIER</pre>
<div class="block">An identifier.</div>
</li>
</ul>
<a id="LITERAL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LITERAL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LITERAL</pre>
<div class="block">A literal.</div>
</li>
</ul>
<a id="INTERVAL_QUALIFIER">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>INTERVAL_QUALIFIER</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> INTERVAL_QUALIFIER</pre>
<div class="block">Interval qualifier.</div>
</li>
</ul>
<a id="OTHER_FUNCTION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>OTHER_FUNCTION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OTHER_FUNCTION</pre>
<div class="block">Function that is not a special function.</div>
<dl>
<dt><span class="seeLabel">See Also:</span></dt>
<dd><a href="#FUNCTION"><code>FUNCTION</code></a></dd>
</dl>
</li>
</ul>
<a id="POSITION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>POSITION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> POSITION</pre>
<div class="block">POSITION function.</div>
</li>
</ul>
<a id="EXPLAIN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>EXPLAIN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXPLAIN</pre>
<div class="block">EXPLAIN statement.</div>
</li>
</ul>
<a id="DESCRIBE_SCHEMA">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DESCRIBE_SCHEMA</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DESCRIBE_SCHEMA</pre>
<div class="block">DESCRIBE SCHEMA statement.</div>
</li>
</ul>
<a id="DESCRIBE_TABLE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DESCRIBE_TABLE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DESCRIBE_TABLE</pre>
<div class="block">DESCRIBE TABLE statement.</div>
</li>
</ul>
<a id="INSERT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>INSERT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> INSERT</pre>
<div class="block">INSERT statement.</div>
</li>
</ul>
<a id="DELETE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DELETE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DELETE</pre>
<div class="block">DELETE statement.</div>
</li>
</ul>
<a id="UPDATE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>UPDATE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> UPDATE</pre>
<div class="block">UPDATE statement.</div>
</li>
</ul>
<a id="SET_OPTION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SET_OPTION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SET_OPTION</pre>
<div class="block">"<code>ALTER scope SET option = value</code>" statement.</div>
</li>
</ul>
<a id="DYNAMIC_PARAM">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DYNAMIC_PARAM</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DYNAMIC_PARAM</pre>
<div class="block">A dynamic parameter.</div>
</li>
</ul>
<a id="ORDER_BY">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ORDER_BY</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ORDER_BY</pre>
<div class="block">ORDER BY clause.</div>
<dl>
<dt><span class="seeLabel">See Also:</span></dt>
<dd><a href="#DESCENDING"><code>DESCENDING</code></a>,
<a href="#NULLS_FIRST"><code>NULLS_FIRST</code></a>,
<a href="#NULLS_LAST"><code>NULLS_LAST</code></a></dd>
</dl>
</li>
</ul>
<a id="WITH">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>WITH</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> WITH</pre>
<div class="block">WITH clause.</div>
</li>
</ul>
<a id="WITH_ITEM">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>WITH_ITEM</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> WITH_ITEM</pre>
<div class="block">Item in WITH clause.</div>
</li>
</ul>
<a id="ITEM">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ITEM</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ITEM</pre>
<div class="block">Item expression.</div>
</li>
</ul>
<a id="UNION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>UNION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> UNION</pre>
<div class="block"><code>UNION</code> relational operator.</div>
</li>
</ul>
<a id="EXCEPT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>EXCEPT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXCEPT</pre>
<div class="block"><code>EXCEPT</code> relational operator (known as <code>MINUS</code> in some SQL
dialects).</div>
</li>
</ul>
<a id="INTERSECT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>INTERSECT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> INTERSECT</pre>
<div class="block"><code>INTERSECT</code> relational operator.</div>
</li>
</ul>
<a id="AS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>AS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> AS</pre>
<div class="block"><code>AS</code> operator.</div>
</li>
</ul>
<a id="ARGUMENT_ASSIGNMENT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ARGUMENT_ASSIGNMENT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ARGUMENT_ASSIGNMENT</pre>
<div class="block">Argument assignment operator, <code>=&gt;</code>.</div>
</li>
</ul>
<a id="DEFAULT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DEFAULT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DEFAULT</pre>
<div class="block"><code>DEFAULT</code> operator.</div>
</li>
</ul>
<a id="OVER">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>OVER</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OVER</pre>
<div class="block"><code>OVER</code> operator.</div>
</li>
</ul>
<a id="RESPECT_NULLS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>RESPECT_NULLS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> RESPECT_NULLS</pre>
<div class="block"><code>RESPECT NULLS</code> operator.</div>
</li>
</ul>
<a id="IGNORE_NULLS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IGNORE_NULLS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IGNORE_NULLS</pre>
<div class="block"><code>IGNORE NULLS</code> operator.</div>
</li>
</ul>
<a id="FILTER">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FILTER</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FILTER</pre>
<div class="block"><code>FILTER</code> operator.</div>
</li>
</ul>
<a id="WITHIN_GROUP">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>WITHIN_GROUP</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> WITHIN_GROUP</pre>
<div class="block"><code>WITHIN GROUP</code> operator.</div>
</li>
</ul>
<a id="WINDOW">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>WINDOW</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> WINDOW</pre>
<div class="block">Window specification.</div>
</li>
</ul>
<a id="MERGE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MERGE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MERGE</pre>
<div class="block">MERGE statement.</div>
</li>
</ul>
<a id="TABLESAMPLE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TABLESAMPLE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TABLESAMPLE</pre>
<div class="block">TABLESAMPLE relational operator.</div>
</li>
</ul>
<a id="MATCH_RECOGNIZE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MATCH_RECOGNIZE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MATCH_RECOGNIZE</pre>
<div class="block">MATCH_RECOGNIZE clause.</div>
</li>
</ul>
<a id="SNAPSHOT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SNAPSHOT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SNAPSHOT</pre>
<div class="block">SNAPSHOT operator.</div>
</li>
</ul>
<a id="TIMES">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TIMES</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TIMES</pre>
<div class="block">Arithmetic multiplication operator, "*".</div>
</li>
</ul>
<a id="DIVIDE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DIVIDE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DIVIDE</pre>
<div class="block">Arithmetic division operator, "/".</div>
</li>
</ul>
<a id="MOD">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MOD</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MOD</pre>
<div class="block">Arithmetic remainder operator, "MOD" (and "%" in some dialects).</div>
</li>
</ul>
<a id="PLUS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PLUS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PLUS</pre>
<div class="block">Arithmetic plus operator, "+".</div>
<dl>
<dt><span class="seeLabel">See Also:</span></dt>
<dd><a href="#PLUS_PREFIX"><code>PLUS_PREFIX</code></a></dd>
</dl>
</li>
</ul>
<a id="MINUS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MINUS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MINUS</pre>
<div class="block">Arithmetic minus operator, "-".</div>
<dl>
<dt><span class="seeLabel">See Also:</span></dt>
<dd><a href="#MINUS_PREFIX"><code>MINUS_PREFIX</code></a></dd>
</dl>
</li>
</ul>
<a id="PATTERN_ALTER">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PATTERN_ALTER</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_ALTER</pre>
<div class="block">Alternation operator in a pattern expression within a
<code>MATCH_RECOGNIZE</code> clause.</div>
</li>
</ul>
<a id="PATTERN_CONCAT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PATTERN_CONCAT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_CONCAT</pre>
<div class="block">Concatenation operator in a pattern expression within a
<code>MATCH_RECOGNIZE</code> clause.</div>
</li>
</ul>
<a id="IN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IN</pre>
<div class="block"><code>IN</code> operator.</div>
</li>
</ul>
<a id="NOT_IN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NOT_IN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NOT_IN</pre>
<div class="block"><code>NOT IN</code> operator.
<p>Only occurs in SqlNode trees. Is expanded to NOT(IN ...) before
entering RelNode land.</div>
</li>
</ul>
<a id="LESS_THAN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LESS_THAN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LESS_THAN</pre>
<div class="block">Less-than operator, "&lt;".</div>
</li>
</ul>
<a id="GREATER_THAN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>GREATER_THAN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GREATER_THAN</pre>
<div class="block">Greater-than operator, "&gt;".</div>
</li>
</ul>
<a id="LESS_THAN_OR_EQUAL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LESS_THAN_OR_EQUAL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LESS_THAN_OR_EQUAL</pre>
<div class="block">Less-than-or-equal operator, "&lt;=".</div>
</li>
</ul>
<a id="GREATER_THAN_OR_EQUAL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>GREATER_THAN_OR_EQUAL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GREATER_THAN_OR_EQUAL</pre>
<div class="block">Greater-than-or-equal operator, "&gt;=".</div>
</li>
</ul>
<a id="EQUALS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>EQUALS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EQUALS</pre>
<div class="block">Equals operator, "=".</div>
</li>
</ul>
<a id="NOT_EQUALS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NOT_EQUALS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NOT_EQUALS</pre>
<div class="block">Not-equals operator, "&#33;=" or "&lt;&gt;".
The latter is standard, and preferred.</div>
</li>
</ul>
<a id="IS_DISTINCT_FROM">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IS_DISTINCT_FROM</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_DISTINCT_FROM</pre>
<div class="block"><code>IS DISTINCT FROM</code> operator.</div>
</li>
</ul>
<a id="IS_NOT_DISTINCT_FROM">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IS_NOT_DISTINCT_FROM</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_NOT_DISTINCT_FROM</pre>
<div class="block"><code>IS NOT DISTINCT FROM</code> operator.</div>
</li>
</ul>
<a id="OR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>OR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OR</pre>
<div class="block">Logical "OR" operator.</div>
</li>
</ul>
<a id="AND">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>AND</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> AND</pre>
<div class="block">Logical "AND" operator.</div>
</li>
</ul>
<a id="DOT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DOT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DOT</pre>
<div class="block">Dot.</div>
</li>
</ul>
<a id="OVERLAPS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>OVERLAPS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OVERLAPS</pre>
<div class="block"><code>OVERLAPS</code> operator for periods.</div>
</li>
</ul>
<a id="CONTAINS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CONTAINS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CONTAINS</pre>
<div class="block"><code>CONTAINS</code> operator for periods.</div>
</li>
</ul>
<a id="PRECEDES">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PRECEDES</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PRECEDES</pre>
<div class="block"><code>PRECEDES</code> operator for periods.</div>
</li>
</ul>
<a id="IMMEDIATELY_PRECEDES">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IMMEDIATELY_PRECEDES</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IMMEDIATELY_PRECEDES</pre>
<div class="block"><code>IMMEDIATELY PRECEDES</code> operator for periods.</div>
</li>
</ul>
<a id="SUCCEEDS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SUCCEEDS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SUCCEEDS</pre>
<div class="block"><code>SUCCEEDS</code> operator for periods.</div>
</li>
</ul>
<a id="IMMEDIATELY_SUCCEEDS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IMMEDIATELY_SUCCEEDS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IMMEDIATELY_SUCCEEDS</pre>
<div class="block"><code>IMMEDIATELY SUCCEEDS</code> operator for periods.</div>
</li>
</ul>
<a id="PERIOD_EQUALS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PERIOD_EQUALS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PERIOD_EQUALS</pre>
<div class="block"><code>EQUALS</code> operator for periods.</div>
</li>
</ul>
<a id="LIKE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LIKE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LIKE</pre>
<div class="block"><code>LIKE</code> operator.</div>
</li>
</ul>
<a id="SIMILAR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SIMILAR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SIMILAR</pre>
<div class="block"><code>SIMILAR</code> operator.</div>
</li>
</ul>
<a id="POSIX_REGEX_CASE_SENSITIVE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>POSIX_REGEX_CASE_SENSITIVE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> POSIX_REGEX_CASE_SENSITIVE</pre>
<div class="block"><code>~</code> operator (for POSIX-style regular expressions).</div>
</li>
</ul>
<a id="POSIX_REGEX_CASE_INSENSITIVE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>POSIX_REGEX_CASE_INSENSITIVE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> POSIX_REGEX_CASE_INSENSITIVE</pre>
<div class="block"><code>~*</code> operator (for case-insensitive POSIX-style regular
expressions).</div>
</li>
</ul>
<a id="BETWEEN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BETWEEN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> BETWEEN</pre>
<div class="block"><code>BETWEEN</code> operator.</div>
</li>
</ul>
<a id="CASE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CASE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CASE</pre>
<div class="block"><code>CASE</code> expression.</div>
</li>
</ul>
<a id="INTERVAL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>INTERVAL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> INTERVAL</pre>
<div class="block"><code>INTERVAL</code> expression.</div>
</li>
</ul>
<a id="NULLIF">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NULLIF</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NULLIF</pre>
<div class="block"><code>NULLIF</code> operator.</div>
</li>
</ul>
<a id="COALESCE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COALESCE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COALESCE</pre>
<div class="block"><code>COALESCE</code> operator.</div>
</li>
</ul>
<a id="DECODE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DECODE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DECODE</pre>
<div class="block"><code>DECODE</code> function (Oracle).</div>
</li>
</ul>
<a id="NVL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NVL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NVL</pre>
<div class="block"><code>NVL</code> function (Oracle).</div>
</li>
</ul>
<a id="GREATEST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>GREATEST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GREATEST</pre>
<div class="block"><code>GREATEST</code> function (Oracle).</div>
</li>
</ul>
<a id="LEAST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LEAST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LEAST</pre>
<div class="block"><code>LEAST</code> function (Oracle).</div>
</li>
</ul>
<a id="TIMESTAMP_ADD">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TIMESTAMP_ADD</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TIMESTAMP_ADD</pre>
<div class="block"><code>TIMESTAMP_ADD</code> function (ODBC, SQL Server, MySQL).</div>
</li>
</ul>
<a id="TIMESTAMP_DIFF">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TIMESTAMP_DIFF</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TIMESTAMP_DIFF</pre>
<div class="block"><code>TIMESTAMP_DIFF</code> function (ODBC, SQL Server, MySQL).</div>
</li>
</ul>
<a id="NOT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NOT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NOT</pre>
<div class="block">Logical <code>NOT</code> operator.</div>
</li>
</ul>
<a id="PLUS_PREFIX">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PLUS_PREFIX</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PLUS_PREFIX</pre>
<div class="block">Unary plus operator, as in "+1".</div>
<dl>
<dt><span class="seeLabel">See Also:</span></dt>
<dd><a href="#PLUS"><code>PLUS</code></a></dd>
</dl>
</li>
</ul>
<a id="MINUS_PREFIX">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MINUS_PREFIX</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MINUS_PREFIX</pre>
<div class="block">Unary minus operator, as in "-1".</div>
<dl>
<dt><span class="seeLabel">See Also:</span></dt>
<dd><a href="#MINUS"><code>MINUS</code></a></dd>
</dl>
</li>
</ul>
<a id="EXISTS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>EXISTS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXISTS</pre>
<div class="block"><code>EXISTS</code> operator.</div>
</li>
</ul>
<a id="SOME">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SOME</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SOME</pre>
<div class="block"><code>SOME</code> quantification operator (also called <code>ANY</code>).</div>
</li>
</ul>
<a id="ALL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALL</pre>
<div class="block"><code>ALL</code> quantification operator.</div>
</li>
</ul>
<a id="VALUES">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>VALUES</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> VALUES</pre>
<div class="block"><code>VALUES</code> relational operator.</div>
</li>
</ul>
<a id="EXPLICIT_TABLE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>EXPLICIT_TABLE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXPLICIT_TABLE</pre>
<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>
</li>
</ul>
<a id="SCALAR_QUERY">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SCALAR_QUERY</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SCALAR_QUERY</pre>
<div class="block">Scalar query; that is, a sub-query used in an expression context, and
returning one row and one column.</div>
</li>
</ul>
<a id="PROCEDURE_CALL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PROCEDURE_CALL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PROCEDURE_CALL</pre>
<div class="block">Procedure call.</div>
</li>
</ul>
<a id="NEW_SPECIFICATION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NEW_SPECIFICATION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NEW_SPECIFICATION</pre>
<div class="block">New specification.</div>
</li>
</ul>
<a id="FINAL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FINAL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FINAL</pre>
<div class="block"><code>FINAL</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</li>
</ul>
<a id="RUNNING">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>RUNNING</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> RUNNING</pre>
<div class="block"><code>FINAL</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</li>
</ul>
<a id="PREV">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PREV</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PREV</pre>
<div class="block"><code>PREV</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</li>
</ul>
<a id="NEXT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NEXT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NEXT</pre>
<div class="block"><code>NEXT</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</li>
</ul>
<a id="FIRST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FIRST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FIRST</pre>
<div class="block"><code>FIRST</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</li>
</ul>
<a id="LAST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LAST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LAST</pre>
<div class="block"><code>LAST</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</li>
</ul>
<a id="CLASSIFIER">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CLASSIFIER</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CLASSIFIER</pre>
<div class="block"><code>CLASSIFIER</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</li>
</ul>
<a id="MATCH_NUMBER">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MATCH_NUMBER</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MATCH_NUMBER</pre>
<div class="block"><code>MATCH_NUMBER</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</li>
</ul>
<a id="SKIP_TO_FIRST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SKIP_TO_FIRST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SKIP_TO_FIRST</pre>
<div class="block"><code>SKIP TO FIRST</code> qualifier of restarting point in a
<code>MATCH_RECOGNIZE</code> clause.</div>
</li>
</ul>
<a id="SKIP_TO_LAST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SKIP_TO_LAST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SKIP_TO_LAST</pre>
<div class="block"><code>SKIP TO LAST</code> qualifier of restarting point in a
<code>MATCH_RECOGNIZE</code> clause.</div>
</li>
</ul>
<a id="DESCENDING">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DESCENDING</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DESCENDING</pre>
<div class="block"><code>DESC</code> operator in <code>ORDER BY</code>. A parse tree, not a true
expression.</div>
</li>
</ul>
<a id="NULLS_FIRST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NULLS_FIRST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NULLS_FIRST</pre>
<div class="block"><code>NULLS FIRST</code> clause in <code>ORDER BY</code>. A parse tree, not a true
expression.</div>
</li>
</ul>
<a id="NULLS_LAST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NULLS_LAST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NULLS_LAST</pre>
<div class="block"><code>NULLS LAST</code> clause in <code>ORDER BY</code>. A parse tree, not a true
expression.</div>
</li>
</ul>
<a id="IS_TRUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IS_TRUE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_TRUE</pre>
<div class="block"><code>IS TRUE</code> operator.</div>
</li>
</ul>
<a id="IS_FALSE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IS_FALSE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_FALSE</pre>
<div class="block"><code>IS FALSE</code> operator.</div>
</li>
</ul>
<a id="IS_NOT_TRUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IS_NOT_TRUE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_NOT_TRUE</pre>
<div class="block"><code>IS NOT TRUE</code> operator.</div>
</li>
</ul>
<a id="IS_NOT_FALSE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IS_NOT_FALSE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_NOT_FALSE</pre>
<div class="block"><code>IS NOT FALSE</code> operator.</div>
</li>
</ul>
<a id="IS_UNKNOWN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IS_UNKNOWN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_UNKNOWN</pre>
<div class="block"><code>IS UNKNOWN</code> operator.</div>
</li>
</ul>
<a id="IS_NULL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IS_NULL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_NULL</pre>
<div class="block"><code>IS NULL</code> operator.</div>
</li>
</ul>
<a id="IS_NOT_NULL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>IS_NOT_NULL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_NOT_NULL</pre>
<div class="block"><code>IS NOT NULL</code> operator.</div>
</li>
</ul>
<a id="PRECEDING">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PRECEDING</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PRECEDING</pre>
<div class="block"><code>PRECEDING</code> qualifier of an interval end-point in a window
specification.</div>
</li>
</ul>
<a id="FOLLOWING">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FOLLOWING</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FOLLOWING</pre>
<div class="block"><code>FOLLOWING</code> qualifier of an interval end-point in a window
specification.</div>
</li>
</ul>
<a id="FIELD_ACCESS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FIELD_ACCESS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FIELD_ACCESS</pre>
<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>
</li>
</ul>
<a id="INPUT_REF">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>INPUT_REF</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> INPUT_REF</pre>
<div class="block">Reference to an input field.
<p>(Only used at the RexNode level.)</p></div>
</li>
</ul>
<a id="TABLE_INPUT_REF">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TABLE_INPUT_REF</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TABLE_INPUT_REF</pre>
<div class="block">Reference to an input field, with a qualified name and an identifier.
<p>(Only used at the RexNode level.)</p></div>
</li>
</ul>
<a id="PATTERN_INPUT_REF">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PATTERN_INPUT_REF</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_INPUT_REF</pre>
<div class="block">Reference to an input field, with pattern var as modifier.
<p>(Only used at the RexNode level.)</p></div>
</li>
</ul>
<a id="LOCAL_REF">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LOCAL_REF</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LOCAL_REF</pre>
<div class="block">Reference to a sub-expression computed within the current relational
operator.
<p>(Only used at the RexNode level.)</p></div>
</li>
</ul>
<a id="CORREL_VARIABLE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CORREL_VARIABLE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CORREL_VARIABLE</pre>
<div class="block">Reference to correlation variable.
<p>(Only used at the RexNode level.)</p></div>
</li>
</ul>
<a id="PATTERN_QUANTIFIER">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PATTERN_QUANTIFIER</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_QUANTIFIER</pre>
<div class="block">the repetition quantifier of a pattern factor in a match_recognize clause.</div>
</li>
</ul>
<a id="ROW">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ROW</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ROW</pre>
<div class="block">The row-constructor function. May be explicit or implicit:
<code>VALUES 1, ROW (2)</code>.</div>
</li>
</ul>
<a id="COLUMN_LIST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COLUMN_LIST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COLUMN_LIST</pre>
<div class="block">The non-standard constructor used to pass a
COLUMN_LIST parameter to a user-defined transform.</div>
</li>
</ul>
<a id="CAST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CAST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CAST</pre>
<div class="block">The "CAST" operator, and also the PostgreSQL-style infix cast operator
"::".</div>
</li>
</ul>
<a id="NEXT_VALUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NEXT_VALUE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NEXT_VALUE</pre>
<div class="block">The "NEXT VALUE OF sequence" operator.</div>
</li>
</ul>
<a id="CURRENT_VALUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CURRENT_VALUE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CURRENT_VALUE</pre>
<div class="block">The "CURRENT VALUE OF sequence" operator.</div>
</li>
</ul>
<a id="FLOOR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FLOOR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FLOOR</pre>
<div class="block"><code>FLOOR</code> function.</div>
</li>
</ul>
<a id="CEIL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CEIL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CEIL</pre>
<div class="block"><code>CEIL</code> function.</div>
</li>
</ul>
<a id="TRIM">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TRIM</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TRIM</pre>
<div class="block"><code>TRIM</code> function.</div>
</li>
</ul>
<a id="LTRIM">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LTRIM</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LTRIM</pre>
<div class="block"><code>LTRIM</code> function (Oracle).</div>
</li>
</ul>
<a id="RTRIM">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>RTRIM</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> RTRIM</pre>
<div class="block"><code>RTRIM</code> function (Oracle).</div>
</li>
</ul>
<a id="EXTRACT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>EXTRACT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXTRACT</pre>
<div class="block"><code>EXTRACT</code> function.</div>
</li>
</ul>
<a id="REVERSE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>REVERSE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> REVERSE</pre>
<div class="block"><code>REVERSE</code> function (SQL Server, MySQL).</div>
</li>
</ul>
<a id="JDBC_FN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>JDBC_FN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> JDBC_FN</pre>
<div class="block">Call to a function using JDBC function syntax.</div>
</li>
</ul>
<a id="MULTISET_VALUE_CONSTRUCTOR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MULTISET_VALUE_CONSTRUCTOR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MULTISET_VALUE_CONSTRUCTOR</pre>
<div class="block"><code>MULTISET</code> value constructor.</div>
</li>
</ul>
<a id="MULTISET_QUERY_CONSTRUCTOR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MULTISET_QUERY_CONSTRUCTOR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MULTISET_QUERY_CONSTRUCTOR</pre>
<div class="block"><code>MULTISET</code> query constructor.</div>
</li>
</ul>
<a id="JSON_VALUE_EXPRESSION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>JSON_VALUE_EXPRESSION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> JSON_VALUE_EXPRESSION</pre>
<div class="block"><code>JSON</code> value expression.</div>
</li>
</ul>
<a id="JSON_ARRAYAGG">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>JSON_ARRAYAGG</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> JSON_ARRAYAGG</pre>
<div class="block"><code>JSON_ARRAYAGG</code> aggregate function.</div>
</li>
</ul>
<a id="JSON_OBJECTAGG">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>JSON_OBJECTAGG</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> JSON_OBJECTAGG</pre>
<div class="block"><code>JSON_OBJECTAGG</code> aggregate function.</div>
</li>
</ul>
<a id="UNNEST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>UNNEST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> UNNEST</pre>
<div class="block"><code>UNNEST</code> operator.</div>
</li>
</ul>
<a id="LATERAL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LATERAL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LATERAL</pre>
<div class="block">The "LATERAL" qualifier to relations in the FROM clause.</div>
</li>
</ul>
<a id="COLLECTION_TABLE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COLLECTION_TABLE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COLLECTION_TABLE</pre>
<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>
</li>
</ul>
<a id="ARRAY_VALUE_CONSTRUCTOR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ARRAY_VALUE_CONSTRUCTOR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ARRAY_VALUE_CONSTRUCTOR</pre>
<div class="block">Array Value Constructor, e.g. <code>Array[1, 2, 3]</code>.</div>
</li>
</ul>
<a id="ARRAY_QUERY_CONSTRUCTOR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ARRAY_QUERY_CONSTRUCTOR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ARRAY_QUERY_CONSTRUCTOR</pre>
<div class="block">Array Query Constructor, e.g. <code>Array(select deptno from dept)</code>.</div>
</li>
</ul>
<a id="MAP_VALUE_CONSTRUCTOR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MAP_VALUE_CONSTRUCTOR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MAP_VALUE_CONSTRUCTOR</pre>
<div class="block">MAP value constructor, e.g. <code>MAP ['washington', 1, 'obama', 44]</code>.</div>
</li>
</ul>
<a id="MAP_QUERY_CONSTRUCTOR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MAP_QUERY_CONSTRUCTOR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MAP_QUERY_CONSTRUCTOR</pre>
<div class="block">MAP query constructor,
e.g. <code>MAP (SELECT empno, deptno FROM emp)</code>.</div>
</li>
</ul>
<a id="CURSOR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CURSOR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CURSOR</pre>
<div class="block"><code>CURSOR</code> constructor, for example, <code>SELECT * FROM
TABLE(udx(CURSOR(SELECT ...), x, y, z))</code>.</div>
</li>
</ul>
<a id="LITERAL_CHAIN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LITERAL_CHAIN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LITERAL_CHAIN</pre>
<div class="block">Literal chain operator (for composite string literals).
An internal operator that does not appear in SQL syntax.</div>
</li>
</ul>
<a id="ESCAPE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ESCAPE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ESCAPE</pre>
<div class="block">Escape operator (always part of LIKE or SIMILAR TO expression).
An internal operator that does not appear in SQL syntax.</div>
</li>
</ul>
<a id="REINTERPRET">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>REINTERPRET</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> REINTERPRET</pre>
<div class="block">The internal REINTERPRET operator (meaning a reinterpret cast).
An internal operator that does not appear in SQL syntax.</div>
</li>
</ul>
<a id="EXTEND">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>EXTEND</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXTEND</pre>
<div class="block">The internal <code>EXTEND</code> operator that qualifies a table name in the
<code>FROM</code> clause.</div>
</li>
</ul>
<a id="CUBE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CUBE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CUBE</pre>
<div class="block">The internal <code>CUBE</code> operator that occurs within a <code>GROUP BY</code>
clause.</div>
</li>
</ul>
<a id="ROLLUP">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ROLLUP</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ROLLUP</pre>
<div class="block">The internal <code>ROLLUP</code> operator that occurs within a <code>GROUP BY</code>
clause.</div>
</li>
</ul>
<a id="GROUPING_SETS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>GROUPING_SETS</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GROUPING_SETS</pre>
<div class="block">The internal <code>GROUPING SETS</code> operator that occurs within a
<code>GROUP BY</code> clause.</div>
</li>
</ul>
<a id="GROUPING">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>GROUPING</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GROUPING</pre>
<div class="block">The <code>GROUPING(e, ...)</code> function.</div>
</li>
</ul>
<a id="GROUPING_ID">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>GROUPING_ID</h4>
<pre><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Deprecated.html?is-external=true" title="class or interface in java.lang" class="externalLink">@Deprecated</a>
public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GROUPING_ID</pre>
<div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span>
<div class="deprecationComment">Use <a href="#GROUPING"><code>GROUPING</code></a>.</div>
</div>
</li>
</ul>
<a id="GROUP_ID">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>GROUP_ID</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GROUP_ID</pre>
<div class="block">The <code>GROUP_ID()</code> function.</div>
</li>
</ul>
<a id="PATTERN_PERMUTE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PATTERN_PERMUTE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_PERMUTE</pre>
<div class="block">The internal "permute" function in a MATCH_RECOGNIZE clause.</div>
</li>
</ul>
<a id="PATTERN_EXCLUDED">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PATTERN_EXCLUDED</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_EXCLUDED</pre>
<div class="block">The special patterns to exclude enclosing pattern from output in a
MATCH_RECOGNIZE clause.</div>
</li>
</ul>
<a id="COUNT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COUNT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COUNT</pre>
<div class="block">The <code>COUNT</code> aggregate function.</div>
</li>
</ul>
<a id="SUM">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SUM</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SUM</pre>
<div class="block">The <code>SUM</code> aggregate function.</div>
</li>
</ul>
<a id="SUM0">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SUM0</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SUM0</pre>
<div class="block">The <code>SUM0</code> aggregate function.</div>
</li>
</ul>
<a id="MIN">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MIN</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MIN</pre>
<div class="block">The <code>MIN</code> aggregate function.</div>
</li>
</ul>
<a id="MAX">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MAX</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MAX</pre>
<div class="block">The <code>MAX</code> aggregate function.</div>
</li>
</ul>
<a id="LEAD">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LEAD</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LEAD</pre>
<div class="block">The <code>LEAD</code> aggregate function.</div>
</li>
</ul>
<a id="LAG">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LAG</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LAG</pre>
<div class="block">The <code>LAG</code> aggregate function.</div>
</li>
</ul>
<a id="FIRST_VALUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FIRST_VALUE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FIRST_VALUE</pre>
<div class="block">The <code>FIRST_VALUE</code> aggregate function.</div>
</li>
</ul>
<a id="LAST_VALUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LAST_VALUE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LAST_VALUE</pre>
<div class="block">The <code>LAST_VALUE</code> aggregate function.</div>
</li>
</ul>
<a id="ANY_VALUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ANY_VALUE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ANY_VALUE</pre>
<div class="block">The <code>ANY_VALUE</code> aggregate function.</div>
</li>
</ul>
<a id="COVAR_POP">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COVAR_POP</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COVAR_POP</pre>
<div class="block">The <code>COVAR_POP</code> aggregate function.</div>
</li>
</ul>
<a id="COVAR_SAMP">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COVAR_SAMP</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COVAR_SAMP</pre>
<div class="block">The <code>COVAR_SAMP</code> aggregate function.</div>
</li>
</ul>
<a id="REGR_COUNT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>REGR_COUNT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> REGR_COUNT</pre>
<div class="block">The <code>REGR_COUNT</code> aggregate function.</div>
</li>
</ul>
<a id="REGR_SXX">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>REGR_SXX</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> REGR_SXX</pre>
<div class="block">The <code>REGR_SXX</code> aggregate function.</div>
</li>
</ul>
<a id="REGR_SYY">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>REGR_SYY</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> REGR_SYY</pre>
<div class="block">The <code>REGR_SYY</code> aggregate function.</div>
</li>
</ul>
<a id="AVG">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>AVG</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> AVG</pre>
<div class="block">The <code>AVG</code> aggregate function.</div>
</li>
</ul>
<a id="STDDEV_POP">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>STDDEV_POP</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> STDDEV_POP</pre>
<div class="block">The <code>STDDEV_POP</code> aggregate function.</div>
</li>
</ul>
<a id="STDDEV_SAMP">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>STDDEV_SAMP</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> STDDEV_SAMP</pre>
<div class="block">The <code>STDDEV_SAMP</code> aggregate function.</div>
</li>
</ul>
<a id="VAR_POP">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>VAR_POP</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> VAR_POP</pre>
<div class="block">The <code>VAR_POP</code> aggregate function.</div>
</li>
</ul>
<a id="VAR_SAMP">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>VAR_SAMP</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> VAR_SAMP</pre>
<div class="block">The <code>VAR_SAMP</code> aggregate function.</div>
</li>
</ul>
<a id="NTILE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NTILE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NTILE</pre>
<div class="block">The <code>NTILE</code> aggregate function.</div>
</li>
</ul>
<a id="NTH_VALUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NTH_VALUE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NTH_VALUE</pre>
<div class="block">The <code>NTH_VALUE</code> aggregate function.</div>
</li>
</ul>
<a id="LISTAGG">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LISTAGG</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LISTAGG</pre>
<div class="block">The <code>LISTAGG</code> aggregate function.</div>
</li>
</ul>
<a id="COLLECT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COLLECT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COLLECT</pre>
<div class="block">The <code>COLLECT</code> aggregate function.</div>
</li>
</ul>
<a id="FUSION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FUSION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FUSION</pre>
<div class="block">The <code>FUSION</code> aggregate function.</div>
</li>
</ul>
<a id="INTERSECTION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>INTERSECTION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> INTERSECTION</pre>
<div class="block">The <code>INTERSECTION</code> aggregate function.</div>
</li>
</ul>
<a id="SINGLE_VALUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SINGLE_VALUE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SINGLE_VALUE</pre>
<div class="block">The <code>SINGLE_VALUE</code> aggregate function.</div>
</li>
</ul>
<a id="BIT_AND">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BIT_AND</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> BIT_AND</pre>
<div class="block">The <code>BIT_AND</code> aggregate function.</div>
</li>
</ul>
<a id="BIT_OR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BIT_OR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> BIT_OR</pre>
<div class="block">The <code>BIT_OR</code> aggregate function.</div>
</li>
</ul>
<a id="BIT_XOR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BIT_XOR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> BIT_XOR</pre>
<div class="block">The <code>BIT_XOR</code> aggregate function.</div>
</li>
</ul>
<a id="ROW_NUMBER">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ROW_NUMBER</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ROW_NUMBER</pre>
<div class="block">The <code>ROW_NUMBER</code> window function.</div>
</li>
</ul>
<a id="RANK">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>RANK</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> RANK</pre>
<div class="block">The <code>RANK</code> window function.</div>
</li>
</ul>
<a id="PERCENT_RANK">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PERCENT_RANK</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PERCENT_RANK</pre>
<div class="block">The <code>PERCENT_RANK</code> window function.</div>
</li>
</ul>
<a id="DENSE_RANK">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DENSE_RANK</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DENSE_RANK</pre>
<div class="block">The <code>DENSE_RANK</code> window function.</div>
</li>
</ul>
<a id="CUME_DIST">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CUME_DIST</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CUME_DIST</pre>
<div class="block">The <code>ROW_NUMBER</code> window function.</div>
</li>
</ul>
<a id="DESCRIPTOR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DESCRIPTOR</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DESCRIPTOR</pre>
<div class="block">The <code>DESCRIPTOR(column_name, ...)</code>.</div>
</li>
</ul>
<a id="TUMBLE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TUMBLE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TUMBLE</pre>
<div class="block">The <code>TUMBLE</code> group function.</div>
</li>
</ul>
<a id="TUMBLE_START">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TUMBLE_START</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TUMBLE_START</pre>
<div class="block">The <code>TUMBLE_START</code> auxiliary function of
the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div>
</li>
</ul>
<a id="TUMBLE_END">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TUMBLE_END</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TUMBLE_END</pre>
<div class="block">The <code>TUMBLE_END</code> auxiliary function of
the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div>
</li>
</ul>
<a id="HOP">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>HOP</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> HOP</pre>
<div class="block">The <code>HOP</code> group function.</div>
</li>
</ul>
<a id="HOP_START">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>HOP_START</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> HOP_START</pre>
<div class="block">The <code>HOP_START</code> auxiliary function of
the <a href="#HOP"><code>HOP</code></a> group function.</div>
</li>
</ul>
<a id="HOP_END">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>HOP_END</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> HOP_END</pre>
<div class="block">The <code>HOP_END</code> auxiliary function of
the <a href="#HOP"><code>HOP</code></a> group function.</div>
</li>
</ul>
<a id="SESSION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SESSION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SESSION</pre>
<div class="block">The <code>SESSION</code> group function.</div>
</li>
</ul>
<a id="SESSION_START">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SESSION_START</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SESSION_START</pre>
<div class="block">The <code>SESSION_START</code> auxiliary function of
the <a href="#SESSION"><code>SESSION</code></a> group function.</div>
</li>
</ul>
<a id="SESSION_END">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SESSION_END</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SESSION_END</pre>
<div class="block">The <code>SESSION_END</code> auxiliary function of
the <a href="#SESSION"><code>SESSION</code></a> group function.</div>
</li>
</ul>
<a id="COLUMN_DECL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COLUMN_DECL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COLUMN_DECL</pre>
<div class="block">Column declaration.</div>
</li>
</ul>
<a id="ATTRIBUTE_DEF">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ATTRIBUTE_DEF</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ATTRIBUTE_DEF</pre>
<div class="block">Attribute definition.</div>
</li>
</ul>
<a id="CHECK">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CHECK</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CHECK</pre>
<div class="block"><code>CHECK</code> constraint.</div>
</li>
</ul>
<a id="UNIQUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>UNIQUE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> UNIQUE</pre>
<div class="block"><code>UNIQUE</code> constraint.</div>
</li>
</ul>
<a id="PRIMARY_KEY">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PRIMARY_KEY</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PRIMARY_KEY</pre>
<div class="block"><code>PRIMARY KEY</code> constraint.</div>
</li>
</ul>
<a id="FOREIGN_KEY">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FOREIGN_KEY</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FOREIGN_KEY</pre>
<div class="block"><code>FOREIGN KEY</code> constraint.</div>
</li>
</ul>
<a id="COMMIT">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COMMIT</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COMMIT</pre>
<div class="block"><code>COMMIT</code> session control statement.</div>
</li>
</ul>
<a id="ROLLBACK">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ROLLBACK</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ROLLBACK</pre>
<div class="block"><code>ROLLBACK</code> session control statement.</div>
</li>
</ul>
<a id="ALTER_SESSION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALTER_SESSION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_SESSION</pre>
<div class="block"><code>ALTER SESSION</code> DDL statement.</div>
</li>
</ul>
<a id="CREATE_SCHEMA">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CREATE_SCHEMA</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_SCHEMA</pre>
<div class="block"><code>CREATE SCHEMA</code> DDL statement.</div>
</li>
</ul>
<a id="CREATE_FOREIGN_SCHEMA">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CREATE_FOREIGN_SCHEMA</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_FOREIGN_SCHEMA</pre>
<div class="block"><code>CREATE FOREIGN SCHEMA</code> DDL statement.</div>
</li>
</ul>
<a id="DROP_SCHEMA">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DROP_SCHEMA</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_SCHEMA</pre>
<div class="block"><code>DROP SCHEMA</code> DDL statement.</div>
</li>
</ul>
<a id="CREATE_TABLE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CREATE_TABLE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_TABLE</pre>
<div class="block"><code>CREATE TABLE</code> DDL statement.</div>
</li>
</ul>
<a id="ALTER_TABLE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALTER_TABLE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_TABLE</pre>
<div class="block"><code>ALTER TABLE</code> DDL statement.</div>
</li>
</ul>
<a id="DROP_TABLE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DROP_TABLE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_TABLE</pre>
<div class="block"><code>DROP TABLE</code> DDL statement.</div>
</li>
</ul>
<a id="CREATE_VIEW">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CREATE_VIEW</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_VIEW</pre>
<div class="block"><code>CREATE VIEW</code> DDL statement.</div>
</li>
</ul>
<a id="ALTER_VIEW">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALTER_VIEW</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_VIEW</pre>
<div class="block"><code>ALTER VIEW</code> DDL statement.</div>
</li>
</ul>
<a id="DROP_VIEW">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DROP_VIEW</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_VIEW</pre>
<div class="block"><code>DROP VIEW</code> DDL statement.</div>
</li>
</ul>
<a id="CREATE_MATERIALIZED_VIEW">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CREATE_MATERIALIZED_VIEW</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_MATERIALIZED_VIEW</pre>
<div class="block"><code>CREATE MATERIALIZED VIEW</code> DDL statement.</div>
</li>
</ul>
<a id="ALTER_MATERIALIZED_VIEW">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALTER_MATERIALIZED_VIEW</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_MATERIALIZED_VIEW</pre>
<div class="block"><code>ALTER MATERIALIZED VIEW</code> DDL statement.</div>
</li>
</ul>
<a id="DROP_MATERIALIZED_VIEW">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DROP_MATERIALIZED_VIEW</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_MATERIALIZED_VIEW</pre>
<div class="block"><code>DROP MATERIALIZED VIEW</code> DDL statement.</div>
</li>
</ul>
<a id="CREATE_SEQUENCE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CREATE_SEQUENCE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_SEQUENCE</pre>
<div class="block"><code>CREATE SEQUENCE</code> DDL statement.</div>
</li>
</ul>
<a id="ALTER_SEQUENCE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALTER_SEQUENCE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_SEQUENCE</pre>
<div class="block"><code>ALTER SEQUENCE</code> DDL statement.</div>
</li>
</ul>
<a id="DROP_SEQUENCE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DROP_SEQUENCE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_SEQUENCE</pre>
<div class="block"><code>DROP SEQUENCE</code> DDL statement.</div>
</li>
</ul>
<a id="CREATE_INDEX">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CREATE_INDEX</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_INDEX</pre>
<div class="block"><code>CREATE INDEX</code> DDL statement.</div>
</li>
</ul>
<a id="ALTER_INDEX">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALTER_INDEX</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_INDEX</pre>
<div class="block"><code>ALTER INDEX</code> DDL statement.</div>
</li>
</ul>
<a id="DROP_INDEX">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DROP_INDEX</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_INDEX</pre>
<div class="block"><code>DROP INDEX</code> DDL statement.</div>
</li>
</ul>
<a id="CREATE_TYPE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CREATE_TYPE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_TYPE</pre>
<div class="block"><code>CREATE TYPE</code> DDL statement.</div>
</li>
</ul>
<a id="DROP_TYPE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DROP_TYPE</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_TYPE</pre>
<div class="block"><code>DROP TYPE</code> DDL statement.</div>
</li>
</ul>
<a id="CREATE_FUNCTION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CREATE_FUNCTION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_FUNCTION</pre>
<div class="block"><code>CREATE FUNCTION</code> DDL statement.</div>
</li>
</ul>
<a id="DROP_FUNCTION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DROP_FUNCTION</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_FUNCTION</pre>
<div class="block"><code>DROP FUNCTION</code> DDL statement.</div>
</li>
</ul>
<a id="OTHER_DDL">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>OTHER_DDL</h4>
<pre>public static final&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OTHER_DDL</pre>
<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>
</li>
</ul>
</li>
</ul>
</section>
<!-- ============ FIELD DETAIL =========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="field.detail">
<!-- -->
</a>
<h3>Field Detail</h3>
<a id="SET_QUERY">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SET_QUERY</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; SET_QUERY</pre>
<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>
</li>
</ul>
<a id="AGGREGATE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>AGGREGATE</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; AGGREGATE</pre>
<div class="block">Category consisting of all built-in aggregate functions.</div>
</li>
</ul>
<a id="DML">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DML</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; DML</pre>
<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>
</li>
</ul>
<a id="DDL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DDL</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; DDL</pre>
<div class="block">Category consisting of all DDL operators.</div>
</li>
</ul>
<a id="QUERY">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>QUERY</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; QUERY</pre>
<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>
</li>
</ul>
<a id="EXPRESSION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>EXPRESSION</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; EXPRESSION</pre>
<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>
</li>
</ul>
<a id="TOP_LEVEL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>TOP_LEVEL</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/EnumSet.html?is-external=true" title="class or interface in java.util" class="externalLink">EnumSet</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; TOP_LEVEL</pre>
<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>
</li>
</ul>
<a id="FUNCTION">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FUNCTION</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; FUNCTION</pre>
<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>
</li>
</ul>
<a id="AVG_AGG_FUNCTIONS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>AVG_AGG_FUNCTIONS</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; AVG_AGG_FUNCTIONS</pre>
<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>
</li>
</ul>
<a id="COVAR_AVG_AGG_FUNCTIONS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COVAR_AVG_AGG_FUNCTIONS</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; COVAR_AVG_AGG_FUNCTIONS</pre>
<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>
</li>
</ul>
<a id="COMPARISON">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>COMPARISON</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; COMPARISON</pre>
<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>
</li>
</ul>
<a id="BINARY_ARITHMETIC">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BINARY_ARITHMETIC</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; BINARY_ARITHMETIC</pre>
<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>
</li>
</ul>
<a id="BINARY_EQUALITY">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BINARY_EQUALITY</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; BINARY_EQUALITY</pre>
<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>
</li>
</ul>
<a id="BINARY_COMPARISON">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BINARY_COMPARISON</h4>
<pre>public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; BINARY_COMPARISON</pre>
<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>
</li>
</ul>
<a id="SYMMETRICAL">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SYMMETRICAL</h4>
<pre>@API(since="1.22",
status=EXPERIMENTAL)
public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; SYMMETRICAL</pre>
<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>
</li>
</ul>
<a id="SYMMETRICAL_SAME_ARG_TYPE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SYMMETRICAL_SAME_ARG_TYPE</h4>
<pre>@API(since="1.22",
status=EXPERIMENTAL)
public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; SYMMETRICAL_SAME_ARG_TYPE</pre>
<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>
</li>
</ul>
<a id="SIMPLE_BINARY_OPS">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SIMPLE_BINARY_OPS</h4>
<pre>@API(since="1.24",
status=EXPERIMENTAL)
public static final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Set.html?is-external=true" title="class or interface in java.util" class="externalLink">Set</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt; SIMPLE_BINARY_OPS</pre>
<div class="block">Simple binary operators are those operators which expects operands from the same Domain.
<p>Example: simple comparisions (<code>=</code>, <code>&lt;</code>).
<p>Note: it does not contain <code>IN</code> because that is defined on D x D^n.</div>
</li>
</ul>
<a id="lowerName">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lowerName</h4>
<pre>public final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> lowerName</pre>
<div class="block">Lower-case name.</div>
</li>
</ul>
<a id="sql">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>sql</h4>
<pre>public final&nbsp;<a href="https://docs.oracle.com/javase/9/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> sql</pre>
</li>
</ul>
</li>
</ul>
</section>
<!-- ============ METHOD DETAIL ========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="method.detail">
<!-- -->
</a>
<h3>Method Detail</h3>
<a id="values()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>values</h4>
<pre class="methodSignature">public static&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>[]&nbsp;values()</pre>
<div class="block">Returns an array containing the constants of this enum type, in
the order they are declared. This method may be used to iterate
over the constants as follows:
<pre>
for (SqlKind c : SqlKind.values())
&nbsp; System.out.println(c);
</pre></div>
<dl>
<dt><span class="returnLabel">Returns:</span></dt>
<dd>an array containing the constants of this enum type, in the order they are declared</dd>
</dl>
</li>
</ul>
<a id="valueOf(java.lang.String)">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>valueOf</h4>
<pre class="methodSignature">public static&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&nbsp;valueOf&#8203;(<a href="https://docs.oracle.com/javase/9/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>&nbsp;name)</pre>
<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>
<dt><span class="paramLabel">Parameters:</span></dt>
<dd><code>name</code> - the name of the enum constant to be returned.</dd>
<dt><span class="returnLabel">Returns:</span></dt>
<dd>the enum constant with the specified name</dd>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/IllegalArgumentException.html?is-external=true" title="class or interface in java.lang" class="externalLink">IllegalArgumentException</a></code> - if this enum type has no constant with the specified name</dd>
<dd><code><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/NullPointerException.html?is-external=true" title="class or interface in java.lang" class="externalLink">NullPointerException</a></code> - if the argument is null</dd>
</dl>
</li>
</ul>
<a id="reverse()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>reverse</h4>
<pre class="methodSignature">public&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&nbsp;reverse()</pre>
<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>
</li>
</ul>
<a id="negate()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>negate</h4>
<pre class="methodSignature">public&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&nbsp;negate()</pre>
<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>
</li>
</ul>
<a id="negateNullSafe()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>negateNullSafe</h4>
<pre class="methodSignature">public&nbsp;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&nbsp;negateNullSafe()</pre>
<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>
</li>
</ul>
<a id="belongsTo(java.util.Collection)">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>belongsTo</h4>
<pre class="methodSignature">public final&nbsp;boolean&nbsp;belongsTo&#8203;(<a href="https://docs.oracle.com/javase/9/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a>&lt;<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&gt;&nbsp;category)</pre>
<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>
<dt><span class="paramLabel">Parameters:</span></dt>
<dd><code>category</code> - Category</dd>
<dt><span class="returnLabel">Returns:</span></dt>
<dd>Whether this kind belongs to the given category</dd>
</dl>
</li>
</ul>
</li>
</ul>
</section>
</li>
</ul>
</div>
</div>
</main>
<!-- ========= END OF CLASS DATA ========= -->
<footer role="contentinfo">
<nav role="navigation">
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a id="navbar.bottom">
<!-- -->
</a>
<div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div>
<a id="navbar.bottom.firstrow">
<!-- -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../index.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">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">Help</a></li>
</ul>
<div class="aboutLanguage"><b>Apache Calcite</b></div>
</div>
<div class="subNav">
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../allclasses.html">All&nbsp;Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
allClassesLink = document.getElementById("allclasses_navbar_bottom");
if(window==top) {
allClassesLink.style.display = "block";
}
else {
allClassesLink.style.display = "none";
}
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li>Nested&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="subNavList">
<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>
<a id="skip.navbar.bottom">
<!-- -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
</nav>
<p class="legalCopy"><small>Copyright &copy; 2012-2020 Apache Software Foundation. All Rights Reserved.</small></p>
</footer>
</body>
</html>