blob: 337432132857ef3305e4fa80c4f4bd00d6ef8612 [file] [log] [blame]
<!DOCTYPE HTML>
<!-- NewPage -->
<html lang="en">
<head>
<!-- Generated by javadoc -->
<title>SqlKind (Apache 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 API)";
}
}
catch(err) {
}
//-->
var data = {"i0":10,"i1":9,"i2":10,"i3":10,"i4":10,"i5":9,"i6":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="class-use/SqlKind.html">Use</a></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>
<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>java.lang.Object</li>
<li>
<ul class="inheritance">
<li>java.lang.Enum&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>java.io.Serializable</code>, <code>java.lang.Comparable&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 java.lang.Enum&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">The "ALL" 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">The 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">AS 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">The "BETWEEN" 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="#CASE">CASE</a></span></code></th>
<td class="colLast">
<div class="block">A "CASE" expression.</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CEIL">CEIL</a></span></code></th>
<td class="colLast">
<div class="block">The "CEIL" function</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CLASSIFIER">CLASSIFIER</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COALESCE">COALESCE</a></span></code></th>
<td class="colLast">
<div class="block">The "COALESCE" operator.</div>
</td>
</tr>
<tr class="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CONTAINS">CONTAINS</a></span></code></th>
<td class="colLast">
<div class="block">The "CONTAINS" operator for periods.</div>
</td>
</tr>
<tr class="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CURSOR">CURSOR</a></span></code></th>
<td class="colLast">
<div class="block">CURSOR constructor, for example, <code>select * from
TABLE(udx(CURSOR(select ...), x, y, z))</code></div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DECODE">DECODE</a></span></code></th>
<td class="colLast">
<div class="block">The "DECODE" function (Oracle).</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DEFAULT">DEFAULT</a></span></code></th>
<td class="colLast">
<div class="block">DEFAULT operator</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DESCENDING">DESCENDING</a></span></code></th>
<td class="colLast">
<div class="block">DESC in ORDER BY.</div>
</td>
</tr>
<tr class="altColor">
<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="rowColor">
<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="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DIVIDE">DIVIDE</a></span></code></th>
<td class="colLast">
<div class="block">The 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">The 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">Except</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">The "EXISTS" 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">The "EXTRACT" 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">FILTER 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">Special functions in MATCH_RECOGNIZE.</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">&nbsp;</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">The "FLOOR" 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">The "FOLLOWING" 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">The 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">The 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">The "GREATEST" 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="#HOP">HOP</a></span></code></th>
<td class="colLast">
<div class="block">The <code>HOP</code> group function.</div>
</td>
</tr>
<tr class="altColor">
<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="rowColor">
<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="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IDENTIFIER">IDENTIFIER</a></span></code></th>
<td class="colLast">
<div class="block">Identifier</div>
</td>
</tr>
<tr class="rowColor">
<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">IGNORE NULLS operator</div>
</td>
</tr>
<tr class="altColor">
<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">The "IMMEDIATELY PRECEDES" operator for periods.</div>
</td>
</tr>
<tr class="rowColor">
<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">The "IMMEDIATELY SUCCEEDS" operator for periods.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IN">IN</a></span></code></th>
<td class="colLast">
<div class="block">The "IN" operator.</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#INTERSECT">INTERSECT</a></span></code></th>
<td class="colLast">
<div class="block">Intersect</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">The is-distinct-from 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">The "IS FALSE" 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">The is-not-distinct-from 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">The "IS NOT FALSE" 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">The "IS NOT NULL" 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">The "IS NOT TRUE" 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">The "IS NULL" 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">The "IS TRUE" 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">The "IS UNKNOWN" operator.</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<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">The <code>JSON_ARRAYAGG</code> aggregate function.</div>
</td>
</tr>
<tr class="altColor">
<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">The <code>JSON_OBJECTAGG</code> aggregate function.</div>
</td>
</tr>
<tr class="rowColor">
<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">The JSON value expression.</div>
</td>
</tr>
<tr class="altColor">
<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="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LAST">LAST</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LEAST">LEAST</a></span></code></th>
<td class="colLast">
<div class="block">The "LEAST" function (Oracle).</div>
</td>
</tr>
<tr class="altColor">
<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">The less-than operator, "&lt;".</div>
</td>
</tr>
<tr class="rowColor">
<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">The less-than-or-equal operator, "&lt;=".</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LIKE">LIKE</a></span></code></th>
<td class="colLast">
<div class="block">The "LIKE" operator.</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LTRIM">LTRIM</a></span></code></th>
<td class="colLast">
<div class="block">The "LTRIM" function (Oracle).</div>
</td>
</tr>
<tr class="altColor">
<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="rowColor">
<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="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MATCH_NUMBER">MATCH_NUMBER</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MINUS">MINUS</a></span></code></th>
<td class="colLast">
<div class="block">The arithmetic minus operator, "-".</div>
</td>
</tr>
<tr class="altColor">
<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">The unary minus operator, as in "-1".</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MOD">MOD</a></span></code></th>
<td class="colLast">
<div class="block">The arithmetic remainder operator, "MOD" (and "%" in some dialects).</div>
</td>
</tr>
<tr class="altColor">
<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">The MULTISET query constructor.</div>
</td>
</tr>
<tr class="rowColor">
<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">The MULTISET value constructor.</div>
</td>
</tr>
<tr class="altColor">
<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">NewSpecification</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NEXT">NEXT</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="altColor">
<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="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NOT">NOT</a></span></code></th>
<td class="colLast">
<div class="block">The logical "NOT" operator.</div>
</td>
</tr>
<tr class="altColor">
<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">The not-equals operator, "&#33;=" or "&lt;&gt;".</div>
</td>
</tr>
<tr class="rowColor">
<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">The "NOT IN" operator.</div>
</td>
</tr>
<tr class="altColor">
<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="rowColor">
<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="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NULLIF">NULLIF</a></span></code></th>
<td class="colLast">
<div class="block">The "NULLIF" operator.</div>
</td>
</tr>
<tr class="rowColor">
<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">NULLS FIRST clause in ORDER BY.</div>
</td>
</tr>
<tr class="altColor">
<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">NULLS LAST clause in ORDER BY.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NVL">NVL</a></span></code></th>
<td class="colLast">
<div class="block">The "NVL" function (Oracle).</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OR">OR</a></span></code></th>
<td class="colLast">
<div class="block">The logical "OR" operator.</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OVER">OVER</a></span></code></th>
<td class="colLast">
<div class="block">OVER operator</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OVERLAPS">OVERLAPS</a></span></code></th>
<td class="colLast">
<div class="block">The "OVERLAPS" operator for periods.</div>
</td>
</tr>
<tr class="rowColor">
<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">the alternation operator in a pattern expression within a match_recognize clause</div>
</td>
</tr>
<tr class="altColor">
<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">the concatenation operator in a pattern expression within a match_recognize clause</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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">The "EQUALS" operator for periods.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PLUS">PLUS</a></span></code></th>
<td class="colLast">
<div class="block">The arithmetic plus operator, "+".</div>
</td>
</tr>
<tr class="altColor">
<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">The unary plus operator, as in "+1".</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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">The "~*" operator.</div>
</td>
</tr>
<tr class="rowColor">
<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">The "~" operator.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PRECEDES">PRECEDES</a></span></code></th>
<td class="colLast">
<div class="block">The "PRECEDES" operator for periods.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PRECEDING">PRECEDING</a></span></code></th>
<td class="colLast">
<div class="block">The "PRECEDING" 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="#PREV">PREV</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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">ProcedureCall</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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">RESPECT NULLS operator</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REVERSE">REVERSE</a></span></code></th>
<td class="colLast">
<div class="block">The "REVERSE" function (SQL Server, MySQL).</div>
</td>
</tr>
<tr class="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#RTRIM">RTRIM</a></span></code></th>
<td class="colLast">
<div class="block">The "RTRIM" function (Oracle).</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#RUNNING">RUNNING</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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">"ALTER scope SET option = value" statement.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SIMILAR">SIMILAR</a></span></code></th>
<td class="colLast">
<div class="block">The "SIMILAR" operator.</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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">The "SKIP TO FIRST" qualifier of restarting point in a MATCH_RECOGNIZE
clause.</div>
</td>
</tr>
<tr class="rowColor">
<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">The "SKIP TO LAST" qualifier of restarting point in a MATCH_RECOGNIZE
clause.</div>
</td>
</tr>
<tr class="altColor">
<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="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SOME">SOME</a></span></code></th>
<td class="colLast">
<div class="block">The "SOME" quantification operator (also called "ANY").</div>
</td>
</tr>
<tr class="altColor">
<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="rowColor">
<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="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SUCCEEDS">SUCCEEDS</a></span></code></th>
<td class="colLast">
<div class="block">The "SUCCEEDS" operator for periods.</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<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="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 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">The 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">The "TIMESTAMP_ADD" 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">The "TIMESTAMP_DIFF" 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">The "TRIM" 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">Union</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">The "UNNEST" 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">The "VALUES" 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">WITHIN_GROUP 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 java.util.EnumSet&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 java.util.Set&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 java.util.Set&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 java.util.Set&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 java.util.Set&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 java.util.Set&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 java.util.Set&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 java.util.EnumSet&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 java.util.EnumSet&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 java.util.Set&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 java.util.Set&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>java.lang.String</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 java.util.EnumSet&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 java.util.EnumSet&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>java.lang.String</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="rowColor">
<td class="colFirst"><code>static java.util.EnumSet&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>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="constructor.summary">
<!-- -->
</a>
<h3>Constructor Summary</h3>
<table class="memberSummary">
<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier</th>
<th class="colSecond" scope="col">Constructor</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>private </code></td>
<th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E()">SqlKind</a></span>()</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>private </code></td>
<th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(java.lang.String)">SqlKind</a></span>&#8203;(java.lang.String&nbsp;sql)</code></th>
<td class="colLast">&nbsp;</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;(java.util.Collection&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>private static &lt;E extends java.lang.Enum&lt;E&gt;&gt;<br>java.util.EnumSet&lt;E&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#concat(java.util.EnumSet,java.util.EnumSet...)">concat</a></span>&#8203;(java.util.EnumSet&lt;E&gt;&nbsp;set0,
java.util.EnumSet&lt;E&gt;...&nbsp;sets)</code></th>
<td class="colLast">&nbsp;</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="#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="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="#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="i4" 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="#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="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="#valueOf(java.lang.String)">valueOf</a></span>&#8203;(java.lang.String&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="i6" 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="#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.Enum</h3>
<code>clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf</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.Object</h3>
<code>getClass, notify, notifyAll, wait, wait, wait</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="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">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="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">"ALTER scope SET option = value" 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="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">Union</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">Except</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">Intersect</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">AS 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">DEFAULT 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">OVER 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">RESPECT NULLS 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">IGNORE NULLS 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">FILTER 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">WITHIN_GROUP 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 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">The 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">The 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">The 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">The 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">The 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">the alternation operator in a pattern expression within a match_recognize clause</div>
</li>
</ul>
<a id="PATTERN_CONCAT">
<!-- -->
</a>
<ul class="blockList">
<li