blob: 30c22caf0132395f4f31d013989b382721f24862 [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">
<meta name="description" content="declaration: package: org.apache.calcite.sql, enum: SqlKind">
<meta name="generator" content="javadoc/ClassWriterImpl">
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">
<link rel="stylesheet" type="text/css" href="../../../../script-dir/jquery-ui.css" title="Style">
<script type="text/javascript" src="../../../../script.js"></script>
<script type="text/javascript" src="../../../../script-dir/jszip/dist/jszip.min.js"></script>
<script type="text/javascript" src="../../../../script-dir/jszip-utils/dist/jszip-utils.min.js"></script>
<!--[if IE]>
<script type="text/javascript" src="../../../../script-dir/jszip-utils/dist/jszip-utils-ie.min.js"></script>
<![endif]-->
<script type="text/javascript" src="../../../../script-dir/jquery-3.4.1.js"></script>
<script type="text/javascript" src="../../../../script-dir/jquery-ui.js"></script>
</head>
<body class="class-declaration">
<script type="text/javascript">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 = "../../../../";
loadScripts(document, 'script');</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<div class="flexBox">
<header role="banner" class="flexHeader">
<nav role="navigation">
<!-- ========= 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">
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li><a href="#nested.class.summary">Nested</a>&nbsp;|&nbsp;</li>
<li><a href="#enum.constant.summary">Enum Constants</a>&nbsp;|&nbsp;</li>
<li><a href="#field.summary">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#method.summary">Method</a></li>
</ul>
<ul class="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>
<div class="navListSearch"><label for="search">SEARCH:</label>
<input type="text" id="search" value="search" disabled="disabled">
<input type="reset" id="reset" value="reset" disabled="disabled">
</div>
</div>
<!-- ========= END OF TOP NAVBAR ========= -->
<div class="skipNav"><a id="skip.navbar.top">
<!-- -->
</a></div>
</nav>
</header>
<div class="flexContent">
<main role="main">
<!-- ======== START OF CLASS DATA ======== -->
<div class="header">
<div class="subTitle"><span class="packageLabelInType">Package</span>&nbsp;<a href="package-summary.html">org.apache.calcite.sql</a></div>
<h1 title="Enum SqlKind" class="title">Enum SqlKind</h1>
</div>
<div class="contentContainer">
<div class="inheritance" title="Inheritance Tree"><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>
<div class="inheritance"><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;
<div class="inheritance">org.apache.calcite.sql.SqlKind</div>
</div>
</div>
<section class="description">
<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>, <code>java.lang.constant.Constable</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>
</section>
<section class="summary">
<ul class="blockList">
<!-- ======== NESTED CLASS SUMMARY ======== -->
<li class="blockList">
<section class="nestedClassSummary"><a id="nested.class.summary">
<!-- -->
</a>
<h2>Nested Class Summary</h2>
<div class="inheritedList">
<h2>Nested classes/interfaces 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></h2>
<a id="nested.classes.inherited.from.class.java.lang.Enum">
<!-- -->
</a><code><a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.EnumDesc.html?is-external=true" title="class or interface in java.lang" class="externalLink">Enum.EnumDesc</a>&lt;<a href="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.EnumDesc.html?is-external=true" title="class or interface in java.lang" class="externalLink">E</a> 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="https://docs.oracle.com/javase/9/docs/api/java/lang/Enum.EnumDesc.html?is-external=true" title="class or interface in java.lang" class="externalLink">E</a>&gt;&gt;</code></div>
</section>
</li>
<!-- =========== ENUM CONSTANT SUMMARY =========== -->
<li class="blockList">
<section class="constantsSummary"><a id="enum.constant.summary">
<!-- -->
</a>
<h2>Enum Constant Summary</h2>
<div class="memberSummary">
<table>
<caption><span>Enum Constants</span><span class="tabEnd">&nbsp;</span></caption>
<thead>
<tr>
<th class="colFirst" scope="col">Enum Constant</th>
<th class="colLast" scope="col">Description</th>
</tr>
</thead>
<tbody>
<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="#DRUID_BETWEEN">DRUID_BETWEEN</a></span></code></th>
<td class="colLast">
<div class="block">Variant of <code>BETWEEN</code> for the Druid adapter.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DRUID_IN">DRUID_IN</a></span></code></th>
<td class="colLast">
<div class="block">Variant of <code>IN</code> for the Druid adapter.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DRUID_NOT_IN">DRUID_NOT_IN</a></span></code></th>
<td class="colLast">
<div class="block">Variant of <code>NOT_IN</code> for the Druid adapter.</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#HILBERT">HILBERT</a></span></code></th>
<td class="colLast">
<div class="block">The <code>Hilbert</code> function that converts (x, y) to a position on a
Hilbert space-filling curve.</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="#PIVOT">PIVOT</a></span></code></th>
<td class="colLast">
<div class="block">PIVOT clause.</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">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">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"><code>~*</code> operator (for case-insensitive POSIX-style regular
expressions).</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"><code>~</code> operator (for POSIX-style regular expressions).</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"><code>PRECEDES</code> 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"><code>PRECEDING</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="#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="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">Procedure call.</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"><code>RESPECT NULLS</code> 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"><code>REVERSE</code> 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"><code>RTRIM</code> 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">
<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="#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="#SEARCH">SEARCH</a></span></code></th>
<td class="colLast">
<div class="block"><code>SEARCH</code> operator.</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="#ST_CONTAINS">ST_CONTAINS</a></span></code></th>
<td class="colLast">
<div class="block">The <code>ST_Contains</code> function that tests whether one geometry contains
another.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ST_DWITHIN">ST_DWITHIN</a></span></code></th>
<td class="colLast">
<div class="block">The <code>ST_DWithin</code> geo-spatial function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ST_MAKE_LINE">ST_MAKE_LINE</a></span></code></th>
<td class="colLast">
<div class="block">The <code>ST_MakeLine</code> function that makes a line.</div>
</td>
</tr>
<tr class="altColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ST_POINT">ST_POINT</a></span></code></th>
<td class="colLast">
<div class="block">The <code>ST_Point</code> function.</div>
</td>
</tr>
<tr class="rowColor">
<th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ST_POINT3">ST_POINT3</a></span></code></th>
<td class="colLast">
<div class="block">The <code>ST_Point</code> function that makes a 3D point.</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"><code>SUCCEEDS</code> 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="#TABLE_REF">TABLE_REF</a></span></code></th>
<td class="colLast">
<div class="block">Table reference.</div>
</td>
</tr>
<tr class="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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="altColor">
<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="rowColor">
<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>
</tbody>
</table>
</div>
</section>
</li>
<!-- =========== FIELD SUMMARY =========== -->
<li class="blockList">
<section class="fieldSummary"><a id="field.summary">
<!-- -->
</a>
<h2>Field Summary</h2>
<div class="memberSummary">
<table>
<caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
<thead>
<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>
</thead>
<tbody>
<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>
</tbody>
</table>
</div>
</section>
</li>
<!-- ========== METHOD SUMMARY =========== -->
<li class="blockList">
<section class="methodSummary"><a id="method.summary">
<!-- -->
</a>
<h2>Method Summary</h2>
<div class="memberSummary">
<div role="tablist" aria-orientation="horizontal"><button role="tab" aria-selected="true" aria-controls="memberSummary_tabpanel" tabindex="0" onkeydown="switchTab(event)" id="t0" class="activeTableTab">All Methods</button><button role="tab" aria-selected="false" aria-controls="memberSummary_tabpanel" tabindex="-1" onkeydown="switchTab(event)" id="t1" class="tableTab" onclick="show(1);">Static Methods</button><button role="tab" aria-selected="false" aria-controls="memberSummary_tabpanel" tabindex="-1" onkeydown="switchTab(event)" id="t2" class="tableTab" onclick="show(2);">Instance Methods</button><button role="tab" aria-selected="false" aria-controls="memberSummary_tabpanel" tabindex="-1" onkeydown="switchTab(event)" id="t4" class="tableTab" onclick="show(8);">Concrete Methods</button></div>
<div id="memberSummary_tabpanel" role="tabpanel">
<table aria-labelledby="t0">
<thead>
<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>
</thead>
<tbody>
<tr class="altColor" id="i0">
<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 class="rowColor" id="i1">
<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 class="altColor" id="i2">
<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 class="rowColor" id="i3">
<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 class="altColor" id="i4">
<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 class="rowColor" id="i5">
<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>
</tbody>
</table>
</div>
</div>
<div class="inheritedList">
<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>
<a id="methods.inherited.from.class.java.lang.Enum">
<!-- -->
</a><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#describeConstable()" title="class or interface in java.lang" class="externalLink">describeConstable</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></div>
<div class="inheritedList">
<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>
<a id="methods.inherited.from.class.java.lang.Object">
<!-- -->
</a><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></div>
</section>
</li>
</ul>
</section>
<section class="details">
<ul class="blockList">
<!-- ============ ENUM CONSTANT DETAIL =========== -->
<li class="blockList">
<section class="constantDetails"><a id="enum.constant.detail">
<!-- -->
</a>
<h2>Enum Constant Details</h2>
<ul class="blockList">
<li class="blockList">
<section class="detail">
<h3><a id="OTHER">OTHER</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">OTHER</span></div>
<div class="block">Expression not covered by any other <a href="SqlKind.html" title="enum in org.apache.calcite.sql"><code>SqlKind</code></a> value.</div>
<dl>
<dt><span class="seeLabel">See Also:</span></dt>
<dd><a href="#OTHER_FUNCTION"><code>OTHER_FUNCTION</code></a></dd>
</dl>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SELECT">SELECT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SELECT</span></div>
<div class="block">SELECT statement or sub-query.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="HINT">HINT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">HINT</span></div>
<div class="block">Sql Hint statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TABLE_REF">TABLE_REF</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">TABLE_REF</span></div>
<div class="block">Table reference.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="JOIN">JOIN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">JOIN</span></div>
<div class="block">JOIN operator or compound FROM clause.
<p>A FROM clause with more than one table is represented as if it were a
join. For example, "FROM x, y, z" is represented as
"JOIN(x, JOIN(x, y))".</p></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IDENTIFIER">IDENTIFIER</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IDENTIFIER</span></div>
<div class="block">An identifier.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LITERAL">LITERAL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LITERAL</span></div>
<div class="block">A literal.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="INTERVAL_QUALIFIER">INTERVAL_QUALIFIER</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">INTERVAL_QUALIFIER</span></div>
<div class="block">Interval qualifier.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="OTHER_FUNCTION">OTHER_FUNCTION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">OTHER_FUNCTION</span></div>
<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>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="POSITION">POSITION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">POSITION</span></div>
<div class="block">POSITION function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="EXPLAIN">EXPLAIN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">EXPLAIN</span></div>
<div class="block">EXPLAIN statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DESCRIBE_SCHEMA">DESCRIBE_SCHEMA</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DESCRIBE_SCHEMA</span></div>
<div class="block">DESCRIBE SCHEMA statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DESCRIBE_TABLE">DESCRIBE_TABLE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DESCRIBE_TABLE</span></div>
<div class="block">DESCRIBE TABLE statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="INSERT">INSERT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">INSERT</span></div>
<div class="block">INSERT statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DELETE">DELETE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DELETE</span></div>
<div class="block">DELETE statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="UPDATE">UPDATE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">UPDATE</span></div>
<div class="block">UPDATE statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SET_OPTION">SET_OPTION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SET_OPTION</span></div>
<div class="block">"<code>ALTER scope SET option = value</code>" statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DYNAMIC_PARAM">DYNAMIC_PARAM</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DYNAMIC_PARAM</span></div>
<div class="block">A dynamic parameter.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ORDER_BY">ORDER_BY</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ORDER_BY</span></div>
<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>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="WITH">WITH</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">WITH</span></div>
<div class="block">WITH clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="WITH_ITEM">WITH_ITEM</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">WITH_ITEM</span></div>
<div class="block">Item in WITH clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ITEM">ITEM</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ITEM</span></div>
<div class="block">Item expression.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="UNION">UNION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">UNION</span></div>
<div class="block"><code>UNION</code> relational operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="EXCEPT">EXCEPT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">EXCEPT</span></div>
<div class="block"><code>EXCEPT</code> relational operator (known as <code>MINUS</code> in some SQL
dialects).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="INTERSECT">INTERSECT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">INTERSECT</span></div>
<div class="block"><code>INTERSECT</code> relational operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="AS">AS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">AS</span></div>
<div class="block"><code>AS</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ARGUMENT_ASSIGNMENT">ARGUMENT_ASSIGNMENT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ARGUMENT_ASSIGNMENT</span></div>
<div class="block">Argument assignment operator, <code>=&gt;</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DEFAULT">DEFAULT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DEFAULT</span></div>
<div class="block"><code>DEFAULT</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="OVER">OVER</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">OVER</span></div>
<div class="block"><code>OVER</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="RESPECT_NULLS">RESPECT_NULLS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">RESPECT_NULLS</span></div>
<div class="block"><code>RESPECT NULLS</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IGNORE_NULLS">IGNORE_NULLS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IGNORE_NULLS</span></div>
<div class="block"><code>IGNORE NULLS</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="FILTER">FILTER</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">FILTER</span></div>
<div class="block"><code>FILTER</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="WITHIN_GROUP">WITHIN_GROUP</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">WITHIN_GROUP</span></div>
<div class="block"><code>WITHIN GROUP</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="WINDOW">WINDOW</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">WINDOW</span></div>
<div class="block">Window specification.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MERGE">MERGE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MERGE</span></div>
<div class="block">MERGE statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TABLESAMPLE">TABLESAMPLE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">TABLESAMPLE</span></div>
<div class="block">TABLESAMPLE relational operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PIVOT">PIVOT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PIVOT</span></div>
<div class="block">PIVOT clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MATCH_RECOGNIZE">MATCH_RECOGNIZE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MATCH_RECOGNIZE</span></div>
<div class="block">MATCH_RECOGNIZE clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SNAPSHOT">SNAPSHOT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SNAPSHOT</span></div>
<div class="block">SNAPSHOT operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TIMES">TIMES</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">TIMES</span></div>
<div class="block">Arithmetic multiplication operator, "*".</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DIVIDE">DIVIDE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DIVIDE</span></div>
<div class="block">Arithmetic division operator, "/".</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MOD">MOD</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MOD</span></div>
<div class="block">Arithmetic remainder operator, "MOD" (and "%" in some dialects).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PLUS">PLUS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PLUS</span></div>
<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>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MINUS">MINUS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MINUS</span></div>
<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>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PATTERN_ALTER">PATTERN_ALTER</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PATTERN_ALTER</span></div>
<div class="block">Alternation operator in a pattern expression within a
<code>MATCH_RECOGNIZE</code> clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PATTERN_CONCAT">PATTERN_CONCAT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PATTERN_CONCAT</span></div>
<div class="block">Concatenation operator in a pattern expression within a
<code>MATCH_RECOGNIZE</code> clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IN">IN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IN</span></div>
<div class="block"><code>IN</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NOT_IN">NOT_IN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NOT_IN</span></div>
<div class="block"><code>NOT IN</code> operator.
<p>Only occurs in SqlNode trees. Is expanded to NOT(IN ...) before
entering RelNode land.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DRUID_IN">DRUID_IN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DRUID_IN</span></div>
<div class="block">Variant of <code>IN</code> for the Druid adapter.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DRUID_NOT_IN">DRUID_NOT_IN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DRUID_NOT_IN</span></div>
<div class="block">Variant of <code>NOT_IN</code> for the Druid adapter.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LESS_THAN">LESS_THAN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LESS_THAN</span></div>
<div class="block">Less-than operator, "&lt;".</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="GREATER_THAN">GREATER_THAN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">GREATER_THAN</span></div>
<div class="block">Greater-than operator, "&gt;".</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LESS_THAN_OR_EQUAL">LESS_THAN_OR_EQUAL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LESS_THAN_OR_EQUAL</span></div>
<div class="block">Less-than-or-equal operator, "&lt;=".</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="GREATER_THAN_OR_EQUAL">GREATER_THAN_OR_EQUAL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">GREATER_THAN_OR_EQUAL</span></div>
<div class="block">Greater-than-or-equal operator, "&gt;=".</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="EQUALS">EQUALS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">EQUALS</span></div>
<div class="block">Equals operator, "=".</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NOT_EQUALS">NOT_EQUALS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NOT_EQUALS</span></div>
<div class="block">Not-equals operator, "&#33;=" or "&lt;&gt;".
The latter is standard, and preferred.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IS_DISTINCT_FROM">IS_DISTINCT_FROM</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IS_DISTINCT_FROM</span></div>
<div class="block"><code>IS DISTINCT FROM</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IS_NOT_DISTINCT_FROM">IS_NOT_DISTINCT_FROM</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IS_NOT_DISTINCT_FROM</span></div>
<div class="block"><code>IS NOT DISTINCT FROM</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SEARCH">SEARCH</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SEARCH</span></div>
<div class="block"><code>SEARCH</code> operator. (Analogous to scalar <code>IN</code>, used only in
RexNode, not SqlNode.)</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="OR">OR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">OR</span></div>
<div class="block">Logical "OR" operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="AND">AND</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">AND</span></div>
<div class="block">Logical "AND" operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DOT">DOT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DOT</span></div>
<div class="block">Dot.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="OVERLAPS">OVERLAPS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">OVERLAPS</span></div>
<div class="block"><code>OVERLAPS</code> operator for periods.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CONTAINS">CONTAINS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CONTAINS</span></div>
<div class="block"><code>CONTAINS</code> operator for periods.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PRECEDES">PRECEDES</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PRECEDES</span></div>
<div class="block"><code>PRECEDES</code> operator for periods.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IMMEDIATELY_PRECEDES">IMMEDIATELY_PRECEDES</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IMMEDIATELY_PRECEDES</span></div>
<div class="block"><code>IMMEDIATELY PRECEDES</code> operator for periods.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SUCCEEDS">SUCCEEDS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SUCCEEDS</span></div>
<div class="block"><code>SUCCEEDS</code> operator for periods.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IMMEDIATELY_SUCCEEDS">IMMEDIATELY_SUCCEEDS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IMMEDIATELY_SUCCEEDS</span></div>
<div class="block"><code>IMMEDIATELY SUCCEEDS</code> operator for periods.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PERIOD_EQUALS">PERIOD_EQUALS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PERIOD_EQUALS</span></div>
<div class="block"><code>EQUALS</code> operator for periods.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LIKE">LIKE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LIKE</span></div>
<div class="block"><code>LIKE</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SIMILAR">SIMILAR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SIMILAR</span></div>
<div class="block"><code>SIMILAR</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="POSIX_REGEX_CASE_SENSITIVE">POSIX_REGEX_CASE_SENSITIVE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">POSIX_REGEX_CASE_SENSITIVE</span></div>
<div class="block"><code>~</code> operator (for POSIX-style regular expressions).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="POSIX_REGEX_CASE_INSENSITIVE">POSIX_REGEX_CASE_INSENSITIVE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">POSIX_REGEX_CASE_INSENSITIVE</span></div>
<div class="block"><code>~*</code> operator (for case-insensitive POSIX-style regular
expressions).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="BETWEEN">BETWEEN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">BETWEEN</span></div>
<div class="block"><code>BETWEEN</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DRUID_BETWEEN">DRUID_BETWEEN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DRUID_BETWEEN</span></div>
<div class="block">Variant of <code>BETWEEN</code> for the Druid adapter.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CASE">CASE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CASE</span></div>
<div class="block"><code>CASE</code> expression.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="INTERVAL">INTERVAL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">INTERVAL</span></div>
<div class="block"><code>INTERVAL</code> expression.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NULLIF">NULLIF</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NULLIF</span></div>
<div class="block"><code>NULLIF</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COALESCE">COALESCE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">COALESCE</span></div>
<div class="block"><code>COALESCE</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DECODE">DECODE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DECODE</span></div>
<div class="block"><code>DECODE</code> function (Oracle).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NVL">NVL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NVL</span></div>
<div class="block"><code>NVL</code> function (Oracle).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="GREATEST">GREATEST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">GREATEST</span></div>
<div class="block"><code>GREATEST</code> function (Oracle).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LEAST">LEAST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LEAST</span></div>
<div class="block"><code>LEAST</code> function (Oracle).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TIMESTAMP_ADD">TIMESTAMP_ADD</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">TIMESTAMP_ADD</span></div>
<div class="block"><code>TIMESTAMP_ADD</code> function (ODBC, SQL Server, MySQL).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TIMESTAMP_DIFF">TIMESTAMP_DIFF</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">TIMESTAMP_DIFF</span></div>
<div class="block"><code>TIMESTAMP_DIFF</code> function (ODBC, SQL Server, MySQL).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NOT">NOT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NOT</span></div>
<div class="block">Logical <code>NOT</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PLUS_PREFIX">PLUS_PREFIX</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PLUS_PREFIX</span></div>
<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>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MINUS_PREFIX">MINUS_PREFIX</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MINUS_PREFIX</span></div>
<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>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="EXISTS">EXISTS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">EXISTS</span></div>
<div class="block"><code>EXISTS</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SOME">SOME</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SOME</span></div>
<div class="block"><code>SOME</code> quantification operator (also called <code>ANY</code>).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ALL">ALL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ALL</span></div>
<div class="block"><code>ALL</code> quantification operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="VALUES">VALUES</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">VALUES</span></div>
<div class="block"><code>VALUES</code> relational operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="EXPLICIT_TABLE">EXPLICIT_TABLE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">EXPLICIT_TABLE</span></div>
<div class="block">Explicit table, e.g. <code>select * from (TABLE t)</code> or <code>TABLE
t</code>. See also <a href="#COLLECTION_TABLE"><code>COLLECTION_TABLE</code></a>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SCALAR_QUERY">SCALAR_QUERY</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SCALAR_QUERY</span></div>
<div class="block">Scalar query; that is, a sub-query used in an expression context, and
returning one row and one column.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PROCEDURE_CALL">PROCEDURE_CALL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PROCEDURE_CALL</span></div>
<div class="block">Procedure call.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NEW_SPECIFICATION">NEW_SPECIFICATION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NEW_SPECIFICATION</span></div>
<div class="block">New specification.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="FINAL">FINAL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">FINAL</span></div>
<div class="block"><code>FINAL</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="RUNNING">RUNNING</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">RUNNING</span></div>
<div class="block"><code>FINAL</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PREV">PREV</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PREV</span></div>
<div class="block"><code>PREV</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NEXT">NEXT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NEXT</span></div>
<div class="block"><code>NEXT</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="FIRST">FIRST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">FIRST</span></div>
<div class="block"><code>FIRST</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LAST">LAST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LAST</span></div>
<div class="block"><code>LAST</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CLASSIFIER">CLASSIFIER</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CLASSIFIER</span></div>
<div class="block"><code>CLASSIFIER</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MATCH_NUMBER">MATCH_NUMBER</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MATCH_NUMBER</span></div>
<div class="block"><code>MATCH_NUMBER</code> operator in <code>MATCH_RECOGNIZE</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SKIP_TO_FIRST">SKIP_TO_FIRST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SKIP_TO_FIRST</span></div>
<div class="block"><code>SKIP TO FIRST</code> qualifier of restarting point in a
<code>MATCH_RECOGNIZE</code> clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SKIP_TO_LAST">SKIP_TO_LAST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SKIP_TO_LAST</span></div>
<div class="block"><code>SKIP TO LAST</code> qualifier of restarting point in a
<code>MATCH_RECOGNIZE</code> clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DESCENDING">DESCENDING</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DESCENDING</span></div>
<div class="block"><code>DESC</code> operator in <code>ORDER BY</code>. A parse tree, not a true
expression.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NULLS_FIRST">NULLS_FIRST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NULLS_FIRST</span></div>
<div class="block"><code>NULLS FIRST</code> clause in <code>ORDER BY</code>. A parse tree, not a true
expression.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NULLS_LAST">NULLS_LAST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NULLS_LAST</span></div>
<div class="block"><code>NULLS LAST</code> clause in <code>ORDER BY</code>. A parse tree, not a true
expression.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IS_TRUE">IS_TRUE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IS_TRUE</span></div>
<div class="block"><code>IS TRUE</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IS_FALSE">IS_FALSE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IS_FALSE</span></div>
<div class="block"><code>IS FALSE</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IS_NOT_TRUE">IS_NOT_TRUE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IS_NOT_TRUE</span></div>
<div class="block"><code>IS NOT TRUE</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IS_NOT_FALSE">IS_NOT_FALSE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IS_NOT_FALSE</span></div>
<div class="block"><code>IS NOT FALSE</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IS_UNKNOWN">IS_UNKNOWN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IS_UNKNOWN</span></div>
<div class="block"><code>IS UNKNOWN</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IS_NULL">IS_NULL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IS_NULL</span></div>
<div class="block"><code>IS NULL</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="IS_NOT_NULL">IS_NOT_NULL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">IS_NOT_NULL</span></div>
<div class="block"><code>IS NOT NULL</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PRECEDING">PRECEDING</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PRECEDING</span></div>
<div class="block"><code>PRECEDING</code> qualifier of an interval end-point in a window
specification.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="FOLLOWING">FOLLOWING</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">FOLLOWING</span></div>
<div class="block"><code>FOLLOWING</code> qualifier of an interval end-point in a window
specification.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="FIELD_ACCESS">FIELD_ACCESS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">FIELD_ACCESS</span></div>
<div class="block">The field access operator, ".".
<p>(Only used at the RexNode level; at
SqlNode level, a field-access is part of an identifier.)</p></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="INPUT_REF">INPUT_REF</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">INPUT_REF</span></div>
<div class="block">Reference to an input field.
<p>(Only used at the RexNode level.)</p></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TABLE_INPUT_REF">TABLE_INPUT_REF</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">TABLE_INPUT_REF</span></div>
<div class="block">Reference to an input field, with a qualified name and an identifier.
<p>(Only used at the RexNode level.)</p></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PATTERN_INPUT_REF">PATTERN_INPUT_REF</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PATTERN_INPUT_REF</span></div>
<div class="block">Reference to an input field, with pattern var as modifier.
<p>(Only used at the RexNode level.)</p></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LOCAL_REF">LOCAL_REF</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LOCAL_REF</span></div>
<div class="block">Reference to a sub-expression computed within the current relational
operator.
<p>(Only used at the RexNode level.)</p></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CORREL_VARIABLE">CORREL_VARIABLE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CORREL_VARIABLE</span></div>
<div class="block">Reference to correlation variable.
<p>(Only used at the RexNode level.)</p></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PATTERN_QUANTIFIER">PATTERN_QUANTIFIER</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PATTERN_QUANTIFIER</span></div>
<div class="block">the repetition quantifier of a pattern factor in a match_recognize clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ROW">ROW</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ROW</span></div>
<div class="block">The row-constructor function. May be explicit or implicit:
<code>VALUES 1, ROW (2)</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COLUMN_LIST">COLUMN_LIST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">COLUMN_LIST</span></div>
<div class="block">The non-standard constructor used to pass a
COLUMN_LIST parameter to a user-defined transform.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CAST">CAST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CAST</span></div>
<div class="block">The "CAST" operator, and also the PostgreSQL-style infix cast operator
"::".</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NEXT_VALUE">NEXT_VALUE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NEXT_VALUE</span></div>
<div class="block">The "NEXT VALUE OF sequence" operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CURRENT_VALUE">CURRENT_VALUE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CURRENT_VALUE</span></div>
<div class="block">The "CURRENT VALUE OF sequence" operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="FLOOR">FLOOR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">FLOOR</span></div>
<div class="block"><code>FLOOR</code> function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CEIL">CEIL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CEIL</span></div>
<div class="block"><code>CEIL</code> function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TRIM">TRIM</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">TRIM</span></div>
<div class="block"><code>TRIM</code> function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LTRIM">LTRIM</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LTRIM</span></div>
<div class="block"><code>LTRIM</code> function (Oracle).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="RTRIM">RTRIM</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">RTRIM</span></div>
<div class="block"><code>RTRIM</code> function (Oracle).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="EXTRACT">EXTRACT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">EXTRACT</span></div>
<div class="block"><code>EXTRACT</code> function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="REVERSE">REVERSE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">REVERSE</span></div>
<div class="block"><code>REVERSE</code> function (SQL Server, MySQL).</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="JDBC_FN">JDBC_FN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">JDBC_FN</span></div>
<div class="block">Call to a function using JDBC function syntax.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MULTISET_VALUE_CONSTRUCTOR">MULTISET_VALUE_CONSTRUCTOR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MULTISET_VALUE_CONSTRUCTOR</span></div>
<div class="block"><code>MULTISET</code> value constructor.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MULTISET_QUERY_CONSTRUCTOR">MULTISET_QUERY_CONSTRUCTOR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MULTISET_QUERY_CONSTRUCTOR</span></div>
<div class="block"><code>MULTISET</code> query constructor.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="JSON_VALUE_EXPRESSION">JSON_VALUE_EXPRESSION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">JSON_VALUE_EXPRESSION</span></div>
<div class="block"><code>JSON</code> value expression.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="JSON_ARRAYAGG">JSON_ARRAYAGG</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">JSON_ARRAYAGG</span></div>
<div class="block"><code>JSON_ARRAYAGG</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="JSON_OBJECTAGG">JSON_OBJECTAGG</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">JSON_OBJECTAGG</span></div>
<div class="block"><code>JSON_OBJECTAGG</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="UNNEST">UNNEST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">UNNEST</span></div>
<div class="block"><code>UNNEST</code> operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LATERAL">LATERAL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LATERAL</span></div>
<div class="block">The "LATERAL" qualifier to relations in the FROM clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COLLECTION_TABLE">COLLECTION_TABLE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">COLLECTION_TABLE</span></div>
<div class="block">Table operator which converts user-defined transform into a relation, for
example, <code>select * from TABLE(udx(x, y, z))</code>. See also the
<a href="#EXPLICIT_TABLE"><code>EXPLICIT_TABLE</code></a> prefix operator.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ARRAY_VALUE_CONSTRUCTOR">ARRAY_VALUE_CONSTRUCTOR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ARRAY_VALUE_CONSTRUCTOR</span></div>
<div class="block">Array Value Constructor, e.g. <code>Array[1, 2, 3]</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ARRAY_QUERY_CONSTRUCTOR">ARRAY_QUERY_CONSTRUCTOR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ARRAY_QUERY_CONSTRUCTOR</span></div>
<div class="block">Array Query Constructor, e.g. <code>Array(select deptno from dept)</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MAP_VALUE_CONSTRUCTOR">MAP_VALUE_CONSTRUCTOR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MAP_VALUE_CONSTRUCTOR</span></div>
<div class="block">MAP value constructor, e.g. <code>MAP ['washington', 1, 'obama', 44]</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MAP_QUERY_CONSTRUCTOR">MAP_QUERY_CONSTRUCTOR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MAP_QUERY_CONSTRUCTOR</span></div>
<div class="block">MAP query constructor,
e.g. <code>MAP (SELECT empno, deptno FROM emp)</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CURSOR">CURSOR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CURSOR</span></div>
<div class="block"><code>CURSOR</code> constructor, for example, <code>SELECT * FROM
TABLE(udx(CURSOR(SELECT ...), x, y, z))</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LITERAL_CHAIN">LITERAL_CHAIN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LITERAL_CHAIN</span></div>
<div class="block">Literal chain operator (for composite string literals).
An internal operator that does not appear in SQL syntax.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ESCAPE">ESCAPE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ESCAPE</span></div>
<div class="block">Escape operator (always part of LIKE or SIMILAR TO expression).
An internal operator that does not appear in SQL syntax.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="REINTERPRET">REINTERPRET</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">REINTERPRET</span></div>
<div class="block">The internal REINTERPRET operator (meaning a reinterpret cast).
An internal operator that does not appear in SQL syntax.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="EXTEND">EXTEND</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">EXTEND</span></div>
<div class="block">The internal <code>EXTEND</code> operator that qualifies a table name in the
<code>FROM</code> clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CUBE">CUBE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CUBE</span></div>
<div class="block">The internal <code>CUBE</code> operator that occurs within a <code>GROUP BY</code>
clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ROLLUP">ROLLUP</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ROLLUP</span></div>
<div class="block">The internal <code>ROLLUP</code> operator that occurs within a <code>GROUP BY</code>
clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="GROUPING_SETS">GROUPING_SETS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">GROUPING_SETS</span></div>
<div class="block">The internal <code>GROUPING SETS</code> operator that occurs within a
<code>GROUP BY</code> clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="GROUPING">GROUPING</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">GROUPING</span></div>
<div class="block">The <code>GROUPING(e, ...)</code> function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="GROUPING_ID">GROUPING_ID</a></h3>
<div class="memberSignature"><span class="annotations"><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>
</span><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">GROUPING_ID</span></div>
<div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span>
<div class="deprecationComment">Use <a href="#GROUPING"><code>GROUPING</code></a>.</div>
</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="GROUP_ID">GROUP_ID</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">GROUP_ID</span></div>
<div class="block">The <code>GROUP_ID()</code> function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PATTERN_PERMUTE">PATTERN_PERMUTE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PATTERN_PERMUTE</span></div>
<div class="block">The internal "permute" function in a MATCH_RECOGNIZE clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PATTERN_EXCLUDED">PATTERN_EXCLUDED</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PATTERN_EXCLUDED</span></div>
<div class="block">The special patterns to exclude enclosing pattern from output in a
MATCH_RECOGNIZE clause.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COUNT">COUNT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">COUNT</span></div>
<div class="block">The <code>COUNT</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SUM">SUM</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SUM</span></div>
<div class="block">The <code>SUM</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SUM0">SUM0</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SUM0</span></div>
<div class="block">The <code>SUM0</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MIN">MIN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MIN</span></div>
<div class="block">The <code>MIN</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="MAX">MAX</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">MAX</span></div>
<div class="block">The <code>MAX</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LEAD">LEAD</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LEAD</span></div>
<div class="block">The <code>LEAD</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LAG">LAG</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LAG</span></div>
<div class="block">The <code>LAG</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="FIRST_VALUE">FIRST_VALUE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">FIRST_VALUE</span></div>
<div class="block">The <code>FIRST_VALUE</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LAST_VALUE">LAST_VALUE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LAST_VALUE</span></div>
<div class="block">The <code>LAST_VALUE</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ANY_VALUE">ANY_VALUE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ANY_VALUE</span></div>
<div class="block">The <code>ANY_VALUE</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COVAR_POP">COVAR_POP</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">COVAR_POP</span></div>
<div class="block">The <code>COVAR_POP</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COVAR_SAMP">COVAR_SAMP</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">COVAR_SAMP</span></div>
<div class="block">The <code>COVAR_SAMP</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="REGR_COUNT">REGR_COUNT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">REGR_COUNT</span></div>
<div class="block">The <code>REGR_COUNT</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="REGR_SXX">REGR_SXX</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">REGR_SXX</span></div>
<div class="block">The <code>REGR_SXX</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="REGR_SYY">REGR_SYY</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">REGR_SYY</span></div>
<div class="block">The <code>REGR_SYY</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="AVG">AVG</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">AVG</span></div>
<div class="block">The <code>AVG</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="STDDEV_POP">STDDEV_POP</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">STDDEV_POP</span></div>
<div class="block">The <code>STDDEV_POP</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="STDDEV_SAMP">STDDEV_SAMP</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">STDDEV_SAMP</span></div>
<div class="block">The <code>STDDEV_SAMP</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="VAR_POP">VAR_POP</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">VAR_POP</span></div>
<div class="block">The <code>VAR_POP</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="VAR_SAMP">VAR_SAMP</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">VAR_SAMP</span></div>
<div class="block">The <code>VAR_SAMP</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NTILE">NTILE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NTILE</span></div>
<div class="block">The <code>NTILE</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="NTH_VALUE">NTH_VALUE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">NTH_VALUE</span></div>
<div class="block">The <code>NTH_VALUE</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="LISTAGG">LISTAGG</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">LISTAGG</span></div>
<div class="block">The <code>LISTAGG</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COLLECT">COLLECT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">COLLECT</span></div>
<div class="block">The <code>COLLECT</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="FUSION">FUSION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">FUSION</span></div>
<div class="block">The <code>FUSION</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="INTERSECTION">INTERSECTION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">INTERSECTION</span></div>
<div class="block">The <code>INTERSECTION</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SINGLE_VALUE">SINGLE_VALUE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SINGLE_VALUE</span></div>
<div class="block">The <code>SINGLE_VALUE</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="BIT_AND">BIT_AND</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">BIT_AND</span></div>
<div class="block">The <code>BIT_AND</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="BIT_OR">BIT_OR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">BIT_OR</span></div>
<div class="block">The <code>BIT_OR</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="BIT_XOR">BIT_XOR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">BIT_XOR</span></div>
<div class="block">The <code>BIT_XOR</code> aggregate function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ROW_NUMBER">ROW_NUMBER</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ROW_NUMBER</span></div>
<div class="block">The <code>ROW_NUMBER</code> window function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="RANK">RANK</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">RANK</span></div>
<div class="block">The <code>RANK</code> window function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PERCENT_RANK">PERCENT_RANK</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PERCENT_RANK</span></div>
<div class="block">The <code>PERCENT_RANK</code> window function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DENSE_RANK">DENSE_RANK</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DENSE_RANK</span></div>
<div class="block">The <code>DENSE_RANK</code> window function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CUME_DIST">CUME_DIST</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CUME_DIST</span></div>
<div class="block">The <code>ROW_NUMBER</code> window function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DESCRIPTOR">DESCRIPTOR</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DESCRIPTOR</span></div>
<div class="block">The <code>DESCRIPTOR(column_name, ...)</code>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TUMBLE">TUMBLE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">TUMBLE</span></div>
<div class="block">The <code>TUMBLE</code> group function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TUMBLE_START">TUMBLE_START</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">TUMBLE_START</span></div>
<div class="block">The <code>TUMBLE_START</code> auxiliary function of
the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TUMBLE_END">TUMBLE_END</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">TUMBLE_END</span></div>
<div class="block">The <code>TUMBLE_END</code> auxiliary function of
the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="HOP">HOP</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">HOP</span></div>
<div class="block">The <code>HOP</code> group function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="HOP_START">HOP_START</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">HOP_START</span></div>
<div class="block">The <code>HOP_START</code> auxiliary function of
the <a href="#HOP"><code>HOP</code></a> group function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="HOP_END">HOP_END</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">HOP_END</span></div>
<div class="block">The <code>HOP_END</code> auxiliary function of
the <a href="#HOP"><code>HOP</code></a> group function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SESSION">SESSION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SESSION</span></div>
<div class="block">The <code>SESSION</code> group function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SESSION_START">SESSION_START</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SESSION_START</span></div>
<div class="block">The <code>SESSION_START</code> auxiliary function of
the <a href="#SESSION"><code>SESSION</code></a> group function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SESSION_END">SESSION_END</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">SESSION_END</span></div>
<div class="block">The <code>SESSION_END</code> auxiliary function of
the <a href="#SESSION"><code>SESSION</code></a> group function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COLUMN_DECL">COLUMN_DECL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">COLUMN_DECL</span></div>
<div class="block">Column declaration.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ATTRIBUTE_DEF">ATTRIBUTE_DEF</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ATTRIBUTE_DEF</span></div>
<div class="block">Attribute definition.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CHECK">CHECK</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CHECK</span></div>
<div class="block"><code>CHECK</code> constraint.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="UNIQUE">UNIQUE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">UNIQUE</span></div>
<div class="block"><code>UNIQUE</code> constraint.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="PRIMARY_KEY">PRIMARY_KEY</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">PRIMARY_KEY</span></div>
<div class="block"><code>PRIMARY KEY</code> constraint.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="FOREIGN_KEY">FOREIGN_KEY</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">FOREIGN_KEY</span></div>
<div class="block"><code>FOREIGN KEY</code> constraint.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ST_DWITHIN">ST_DWITHIN</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ST_DWITHIN</span></div>
<div class="block">The <code>ST_DWithin</code> geo-spatial function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ST_POINT">ST_POINT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ST_POINT</span></div>
<div class="block">The <code>ST_Point</code> function.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ST_POINT3">ST_POINT3</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ST_POINT3</span></div>
<div class="block">The <code>ST_Point</code> function that makes a 3D point.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ST_MAKE_LINE">ST_MAKE_LINE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ST_MAKE_LINE</span></div>
<div class="block">The <code>ST_MakeLine</code> function that makes a line.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ST_CONTAINS">ST_CONTAINS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ST_CONTAINS</span></div>
<div class="block">The <code>ST_Contains</code> function that tests whether one geometry contains
another.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="HILBERT">HILBERT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">HILBERT</span></div>
<div class="block">The <code>Hilbert</code> function that converts (x, y) to a position on a
Hilbert space-filling curve.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COMMIT">COMMIT</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">COMMIT</span></div>
<div class="block"><code>COMMIT</code> session control statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ROLLBACK">ROLLBACK</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ROLLBACK</span></div>
<div class="block"><code>ROLLBACK</code> session control statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ALTER_SESSION">ALTER_SESSION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ALTER_SESSION</span></div>
<div class="block"><code>ALTER SESSION</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CREATE_SCHEMA">CREATE_SCHEMA</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CREATE_SCHEMA</span></div>
<div class="block"><code>CREATE SCHEMA</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CREATE_FOREIGN_SCHEMA">CREATE_FOREIGN_SCHEMA</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CREATE_FOREIGN_SCHEMA</span></div>
<div class="block"><code>CREATE FOREIGN SCHEMA</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DROP_SCHEMA">DROP_SCHEMA</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DROP_SCHEMA</span></div>
<div class="block"><code>DROP SCHEMA</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CREATE_TABLE">CREATE_TABLE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CREATE_TABLE</span></div>
<div class="block"><code>CREATE TABLE</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ALTER_TABLE">ALTER_TABLE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ALTER_TABLE</span></div>
<div class="block"><code>ALTER TABLE</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DROP_TABLE">DROP_TABLE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DROP_TABLE</span></div>
<div class="block"><code>DROP TABLE</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CREATE_VIEW">CREATE_VIEW</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CREATE_VIEW</span></div>
<div class="block"><code>CREATE VIEW</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ALTER_VIEW">ALTER_VIEW</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ALTER_VIEW</span></div>
<div class="block"><code>ALTER VIEW</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DROP_VIEW">DROP_VIEW</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DROP_VIEW</span></div>
<div class="block"><code>DROP VIEW</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CREATE_MATERIALIZED_VIEW">CREATE_MATERIALIZED_VIEW</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CREATE_MATERIALIZED_VIEW</span></div>
<div class="block"><code>CREATE MATERIALIZED VIEW</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ALTER_MATERIALIZED_VIEW">ALTER_MATERIALIZED_VIEW</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ALTER_MATERIALIZED_VIEW</span></div>
<div class="block"><code>ALTER MATERIALIZED VIEW</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DROP_MATERIALIZED_VIEW">DROP_MATERIALIZED_VIEW</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DROP_MATERIALIZED_VIEW</span></div>
<div class="block"><code>DROP MATERIALIZED VIEW</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CREATE_SEQUENCE">CREATE_SEQUENCE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CREATE_SEQUENCE</span></div>
<div class="block"><code>CREATE SEQUENCE</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ALTER_SEQUENCE">ALTER_SEQUENCE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ALTER_SEQUENCE</span></div>
<div class="block"><code>ALTER SEQUENCE</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DROP_SEQUENCE">DROP_SEQUENCE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DROP_SEQUENCE</span></div>
<div class="block"><code>DROP SEQUENCE</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CREATE_INDEX">CREATE_INDEX</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CREATE_INDEX</span></div>
<div class="block"><code>CREATE INDEX</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="ALTER_INDEX">ALTER_INDEX</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">ALTER_INDEX</span></div>
<div class="block"><code>ALTER INDEX</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DROP_INDEX">DROP_INDEX</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DROP_INDEX</span></div>
<div class="block"><code>DROP INDEX</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CREATE_TYPE">CREATE_TYPE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CREATE_TYPE</span></div>
<div class="block"><code>CREATE TYPE</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DROP_TYPE">DROP_TYPE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DROP_TYPE</span></div>
<div class="block"><code>DROP TYPE</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="CREATE_FUNCTION">CREATE_FUNCTION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">CREATE_FUNCTION</span></div>
<div class="block"><code>CREATE FUNCTION</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DROP_FUNCTION">DROP_FUNCTION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">DROP_FUNCTION</span></div>
<div class="block"><code>DROP FUNCTION</code> DDL statement.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="OTHER_DDL">OTHER_DDL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">OTHER_DDL</span></div>
<div class="block">DDL statement not handled above.
<p><b>Note to other projects</b>: If you are extending Calcite's SQL parser
and have your own object types you no doubt want to define CREATE and DROP
commands for them. Use OTHER_DDL in the short term, but we are happy to add
new enum values for your object types. Just ask!</div>
</section>
</li>
</ul>
</section>
</li>
<!-- ============ FIELD DETAIL =========== -->
<li class="blockList">
<section class="fieldDetails"><a id="field.detail">
<!-- -->
</a>
<h2>Field Details</h2>
<ul class="blockList">
<li class="blockList">
<section class="detail">
<h3><a id="SET_QUERY">SET_QUERY</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">SET_QUERY</span></div>
<div class="block">Category consisting of set-query node types.
<p>Consists of:
<a href="#EXCEPT"><code>EXCEPT</code></a>,
<a href="#INTERSECT"><code>INTERSECT</code></a>,
<a href="#UNION"><code>UNION</code></a>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="AGGREGATE">AGGREGATE</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">AGGREGATE</span></div>
<div class="block">Category consisting of all built-in aggregate functions.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DML">DML</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">DML</span></div>
<div class="block">Category consisting of all DML operators.
<p>Consists of:
<a href="#INSERT"><code>INSERT</code></a>,
<a href="#UPDATE"><code>UPDATE</code></a>,
<a href="#DELETE"><code>DELETE</code></a>,
<a href="#MERGE"><code>MERGE</code></a>,
<a href="#PROCEDURE_CALL"><code>PROCEDURE_CALL</code></a>.
<p>NOTE jvs 1-June-2006: For now we treat procedure calls as DML;
this makes it easy for JDBC clients to call execute or
executeUpdate and not have to process dummy cursor results. If
in the future we support procedures which return results sets,
we'll need to refine this.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="DDL">DDL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">DDL</span></div>
<div class="block">Category consisting of all DDL operators.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="QUERY">QUERY</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">QUERY</span></div>
<div class="block">Category consisting of query node types.
<p>Consists of:
<a href="#SELECT"><code>SELECT</code></a>,
<a href="#EXCEPT"><code>EXCEPT</code></a>,
<a href="#INTERSECT"><code>INTERSECT</code></a>,
<a href="#UNION"><code>UNION</code></a>,
<a href="#VALUES"><code>VALUES</code></a>,
<a href="#ORDER_BY"><code>ORDER_BY</code></a>,
<a href="#EXPLICIT_TABLE"><code>EXPLICIT_TABLE</code></a>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="EXPRESSION">EXPRESSION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">EXPRESSION</span></div>
<div class="block">Category consisting of all expression operators.
<p>A node is an expression if it is NOT one of the following:
<a href="#AS"><code>AS</code></a>,
<a href="#ARGUMENT_ASSIGNMENT"><code>ARGUMENT_ASSIGNMENT</code></a>,
<a href="#DEFAULT"><code>DEFAULT</code></a>,
<a href="#DESCENDING"><code>DESCENDING</code></a>,
<a href="#SELECT"><code>SELECT</code></a>,
<a href="#JOIN"><code>JOIN</code></a>,
<a href="#OTHER_FUNCTION"><code>OTHER_FUNCTION</code></a>,
<a href="#CAST"><code>CAST</code></a>,
<a href="#TRIM"><code>TRIM</code></a>,
<a href="#LITERAL_CHAIN"><code>LITERAL_CHAIN</code></a>,
<a href="#JDBC_FN"><code>JDBC_FN</code></a>,
<a href="#PRECEDING"><code>PRECEDING</code></a>,
<a href="#FOLLOWING"><code>FOLLOWING</code></a>,
<a href="#ORDER_BY"><code>ORDER_BY</code></a>,
<a href="#COLLECTION_TABLE"><code>COLLECTION_TABLE</code></a>,
<a href="#TABLESAMPLE"><code>TABLESAMPLE</code></a>,
<a href="#UNNEST"><code>UNNEST</code></a>
or an aggregate function, DML or DDL.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="TOP_LEVEL">TOP_LEVEL</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">TOP_LEVEL</span></div>
<div class="block">Category of all SQL statement types.
<p>Consists of all types in <a href="#QUERY"><code>QUERY</code></a>, <a href="#DML"><code>DML</code></a> and <a href="#DDL"><code>DDL</code></a>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="FUNCTION">FUNCTION</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">FUNCTION</span></div>
<div class="block">Category consisting of regular and special functions.
<p>Consists of regular functions <a href="#OTHER_FUNCTION"><code>OTHER_FUNCTION</code></a> and special
functions <a href="#ROW"><code>ROW</code></a>, <a href="#TRIM"><code>TRIM</code></a>, <a href="#CAST"><code>CAST</code></a>, <a href="#REVERSE"><code>REVERSE</code></a>, <a href="#JDBC_FN"><code>JDBC_FN</code></a>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="AVG_AGG_FUNCTIONS">AVG_AGG_FUNCTIONS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">AVG_AGG_FUNCTIONS</span></div>
<div class="block">Category of SqlAvgAggFunction.
<p>Consists of <a href="#AVG"><code>AVG</code></a>, <a href="#STDDEV_POP"><code>STDDEV_POP</code></a>, <a href="#STDDEV_SAMP"><code>STDDEV_SAMP</code></a>,
<a href="#VAR_POP"><code>VAR_POP</code></a>, <a href="#VAR_SAMP"><code>VAR_SAMP</code></a>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COVAR_AVG_AGG_FUNCTIONS">COVAR_AVG_AGG_FUNCTIONS</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">COVAR_AVG_AGG_FUNCTIONS</span></div>
<div class="block">Category of SqlCovarAggFunction.
<p>Consists of <a href="#COVAR_POP"><code>COVAR_POP</code></a>, <a href="#COVAR_SAMP"><code>COVAR_SAMP</code></a>, <a href="#REGR_SXX"><code>REGR_SXX</code></a>,
<a href="#REGR_SYY"><code>REGR_SYY</code></a>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="COMPARISON">COMPARISON</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">COMPARISON</span></div>
<div class="block">Category of comparison operators.
<p>Consists of:
<a href="#IN"><code>IN</code></a>,
<a href="#EQUALS"><code>EQUALS</code></a>,
<a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a>,
<a href="#LESS_THAN"><code>LESS_THAN</code></a>,
<a href="#GREATER_THAN"><code>GREATER_THAN</code></a>,
<a href="#LESS_THAN_OR_EQUAL"><code>LESS_THAN_OR_EQUAL</code></a>,
<a href="#GREATER_THAN_OR_EQUAL"><code>GREATER_THAN_OR_EQUAL</code></a>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="BINARY_ARITHMETIC">BINARY_ARITHMETIC</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">BINARY_ARITHMETIC</span></div>
<div class="block">Category of binary arithmetic.
<p>Consists of:
<a href="#PLUS"><code>PLUS</code></a>
<a href="#MINUS"><code>MINUS</code></a>
<a href="#TIMES"><code>TIMES</code></a>
<a href="#DIVIDE"><code>DIVIDE</code></a>
<a href="#MOD"><code>MOD</code></a>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="BINARY_EQUALITY">BINARY_EQUALITY</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">BINARY_EQUALITY</span></div>
<div class="block">Category of binary equality.
<p>Consists of:
<a href="#EQUALS"><code>EQUALS</code></a>
<a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="BINARY_COMPARISON">BINARY_COMPARISON</a></h3>
<div class="memberSignature"><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">BINARY_COMPARISON</span></div>
<div class="block">Category of binary comparison.
<p>Consists of:
<a href="#EQUALS"><code>EQUALS</code></a>
<a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a>
<a href="#GREATER_THAN"><code>GREATER_THAN</code></a>
<a href="#GREATER_THAN_OR_EQUAL"><code>GREATER_THAN_OR_EQUAL</code></a>
<a href="#LESS_THAN"><code>LESS_THAN</code></a>
<a href="#LESS_THAN_OR_EQUAL"><code>LESS_THAN_OR_EQUAL</code></a>
<a href="#IS_DISTINCT_FROM"><code>IS_DISTINCT_FROM</code></a>
<a href="#IS_NOT_DISTINCT_FROM"><code>IS_NOT_DISTINCT_FROM</code></a></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SYMMETRICAL">SYMMETRICAL</a></h3>
<div class="memberSignature"><span class="annotations">@API(since="1.22",
status=EXPERIMENTAL)
</span><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">SYMMETRICAL</span></div>
<div class="block">Category of operators that do not depend on the argument order.
<p>For instance: <a href="#AND"><code>AND</code></a>, <a href="#OR"><code>OR</code></a>, <a href="#EQUALS"><code>EQUALS</code></a>, <a href="#LEAST"><code>LEAST</code></a></p>
<p>Note: <a href="#PLUS"><code>PLUS</code></a> does depend on the argument oder if argument types are different</p></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SYMMETRICAL_SAME_ARG_TYPE">SYMMETRICAL_SAME_ARG_TYPE</a></h3>
<div class="memberSignature"><span class="annotations">@API(since="1.22",
status=EXPERIMENTAL)
</span><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">SYMMETRICAL_SAME_ARG_TYPE</span></div>
<div class="block">Category of operators that do not depend on the argument order if argument types are equal.
<p>For instance: <a href="#PLUS"><code>PLUS</code></a>, <a href="#TIMES"><code>TIMES</code></a></p></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="SIMPLE_BINARY_OPS">SIMPLE_BINARY_OPS</a></h3>
<div class="memberSignature"><span class="annotations">@API(since="1.24",
status=EXPERIMENTAL)
</span><span class="modifiers">public static final</span>&nbsp;<span class="returnType"><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;</span>&nbsp;<span class="memberName">SIMPLE_BINARY_OPS</span></div>
<div class="block">Simple binary operators are those operators which expects operands from the same Domain.
<p>Example: simple comparisons (<code>=</code>, <code>&lt;</code>).
<p>Note: it does not contain <code>IN</code> because that is defined on D x D^n.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="lowerName">lowerName</a></h3>
<div class="memberSignature"><span class="modifiers">public final</span>&nbsp;<span class="returnType"><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></span>&nbsp;<span class="memberName">lowerName</span></div>
<div class="block">Lower-case name.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="sql">sql</a></h3>
<div class="memberSignature"><span class="modifiers">public final</span>&nbsp;<span class="returnType"><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></span>&nbsp;<span class="memberName">sql</span></div>
</section>
</li>
</ul>
</section>
</li>
<!-- ============ METHOD DETAIL ========== -->
<li class="blockList">
<section class="methodDetails"><a id="method.detail">
<!-- -->
</a>
<h2>Method Details</h2>
<ul class="blockList">
<li class="blockList">
<section class="detail">
<h3><a id="values()">values</a></h3>
<div class="memberSignature"><span class="modifiers">public static</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>[]</span>&nbsp;<span class="memberName">values</span>()</div>
<div class="block">Returns an array containing the constants of this enum type, in
the order they are declared.</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>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="valueOf(java.lang.String)">valueOf</a></h3>
<div class="memberSignature"><span class="modifiers">public static</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">valueOf</span>&#8203;(<span class="arguments"><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)</span></div>
<div class="block">Returns the enum constant of this type with the specified name.
The string must match <i>exactly</i> an identifier used to declare an
enum constant in this type. (Extraneous whitespace characters are
not permitted.)</div>
<dl>
<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>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="reverse()">reverse</a></h3>
<div class="memberSignature"><span class="modifiers">public</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">reverse</span>()</div>
<div class="block">Returns the kind that corresponds to this operator but in the opposite
direction. Or returns this, if this kind is not reversible.
<p>For example, <code>GREATER_THAN.reverse()</code> returns <a href="#LESS_THAN"><code>LESS_THAN</code></a>.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="negate()">negate</a></h3>
<div class="memberSignature"><span class="modifiers">public</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">negate</span>()</div>
<div class="block">Returns the kind that you get if you apply NOT to this kind.
<p>For example, <code>IS_NOT_NULL.negate()</code> returns <a href="#IS_NULL"><code>IS_NULL</code></a>.
<p>For <a href="#IS_TRUE"><code>IS_TRUE</code></a>, <a href="#IS_FALSE"><code>IS_FALSE</code></a>, <a href="#IS_NOT_TRUE"><code>IS_NOT_TRUE</code></a>,
<a href="#IS_NOT_FALSE"><code>IS_NOT_FALSE</code></a>, nullable inputs need to be treated carefully.
<p><code>NOT(IS_TRUE(null))</code> = <code>NOT(false)</code> = <code>true</code>,
while <code>IS_FALSE(null)</code> = <code>false</code>,
so <code>NOT(IS_TRUE(X))</code> should be <code>IS_NOT_TRUE(X)</code>.
On the other hand,
<code>IS_TRUE(NOT(null))</code> = <code>IS_TRUE(null)</code> = <code>false</code>.
<p>This is why negate() != negateNullSafe() for these operators.</div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="negateNullSafe()">negateNullSafe</a></h3>
<div class="memberSignature"><span class="modifiers">public</span>&nbsp;<span class="returnType"><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></span>&nbsp;<span class="memberName">negateNullSafe</span>()</div>
<div class="block">Returns the kind that you get if you negate this kind.
To conform to null semantics, null value should not be compared.
<p>For <a href="#IS_TRUE"><code>IS_TRUE</code></a>, <a href="#IS_FALSE"><code>IS_FALSE</code></a>, <a href="#IS_NOT_TRUE"><code>IS_NOT_TRUE</code></a> and
<a href="#IS_NOT_FALSE"><code>IS_NOT_FALSE</code></a>, nullable inputs need to be treated carefully:
<ul>
<li>NOT(IS_TRUE(null)) = NOT(false) = true
<li>IS_TRUE(NOT(null)) = IS_TRUE(null) = false
<li>IS_FALSE(null) = false
<li>IS_NOT_TRUE(null) = true
</ul></div>
</section>
</li>
<li class="blockList">
<section class="detail">
<h3><a id="belongsTo(java.util.Collection)">belongsTo</a></h3>
<div class="memberSignature"><span class="modifiers">public final</span>&nbsp;<span class="returnType">boolean</span>&nbsp;<span class="memberName">belongsTo</span>&#8203;(<span class="arguments"><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)</span></div>
<div class="block">Returns whether this <code>SqlKind</code> belongs to a given category.
<p>A category is a collection of kinds, not necessarily disjoint. For
example, QUERY is { SELECT, UNION, INTERSECT, EXCEPT, VALUES, ORDER_BY,
EXPLICIT_TABLE }.</div>
<dl>
<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>
</section>
</li>
</ul>
</section>
</li>
</ul>
</section>
</div>
<!-- ========= END OF CLASS DATA ========= -->
</main>
<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">
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li><a href="#nested.class.summary">Nested</a>&nbsp;|&nbsp;</li>
<li><a href="#enum.constant.summary">Enum Constants</a>&nbsp;|&nbsp;</li>
<li><a href="#field.summary">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#method.summary">Method</a></li>
</ul>
<ul class="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>
</div>
<a id="skip.navbar.bottom">
<!-- -->
</a>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
</nav>
<p class="legalCopy"><small>Copyright &copy; 2012-2020 Apache Software Foundation. All Rights Reserved.</small></p>
</footer>
</div>
</div>
</body>
</html>