apidocs/org/apache/calcite/sql/fun/SqlStdOperatorTable.html - calcite-site - Git at Google

 <!DOCTYPE HTML>
 <!-- NewPage -->
 <html lang="en">
 <head>
 <!-- Generated by javadoc -->
 <title>SqlStdOperatorTable (Apache Calcite API)</title>
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
 <link rel="stylesheet" type="text/css" href="../../../../../jquery/jquery-ui.css" title="Style">
 <script type="text/javascript" src="../../../../../script.js"></script>
 <script type="text/javascript" src="../../../../../jquery/jszip/dist/jszip.min.js"></script>
 <script type="text/javascript" src="../../../../../jquery/jszip-utils/dist/jszip-utils.min.js"></script>
 <!--[if IE]>
 <script type="text/javascript" src="../../../../../jquery/jszip-utils/dist/jszip-utils-ie.min.js"></script>
 <![endif]-->
 <script type="text/javascript" src="../../../../../jquery/jquery-3.3.1.js"></script>
 <script type="text/javascript" src="../../../../../jquery/jquery-migrate-3.0.1.js"></script>
 <script type="text/javascript" src="../../../../../jquery/jquery-ui.js"></script>
 </head>
 <body>
 <script type="text/javascript"><!--
     try {
         if (location.href.indexOf('is-external=true') == -1) {
             parent.document.title="SqlStdOperatorTable (Apache Calcite API)";
         }
     }
     catch(err) {
     }
 //-->
 var data = {"i0":9,"i1":9,"i2":9,"i3":9,"i4":9,"i5":9,"i6":9};
 var tabs = {65535:["t0","All Methods"],1:["t1","Static Methods"],8:["t4","Concrete Methods"]};
 var altColor = "altColor";
 var rowColor = "rowColor";
 var tableTab = "tableTab";
 var activeTableTab = "activeTableTab";
 var pathtoroot = "../../../../../";
 var useModuleDirectories = true;
 loadScripts(document, 'script');</script>
 <noscript>
 <div>JavaScript is disabled on your browser.</div>
 </noscript>
 <header role="banner">
 <nav role="navigation">
 <div class="fixedNav">
 <!-- ========= START OF TOP NAVBAR ======= -->
 <div class="topNav"><a id="navbar.top">
 <!--   -->
 </a>
 <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div>
 <a id="navbar.top.firstrow">
 <!--   -->
 </a>
 <ul class="navList" title="Navigation">
 <li><a href="../../../../../index.html">Overview</a></li>
 <li><a href="package-summary.html">Package</a></li>
 <li class="navBarCell1Rev">Class</li>
 <li><a href="class-use/SqlStdOperatorTable.html">Use</a></li>
 <li><a href="package-tree.html">Tree</a></li>
 <li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
 <li><a href="../../../../../index-all.html">Index</a></li>
 <li><a href="../../../../../help-doc.html">Help</a></li>
 </ul>
 </div>
 <div class="subNav">
 <ul class="navList" id="allclasses_navbar_top">
 <li><a href="../../../../../allclasses.html">All&nbsp;Classes</a></li>
 </ul>
 <ul class="navListSearch">
 <li><label for="search">SEARCH:</label>
 <input type="text" id="search" value="search" disabled="disabled">
 <input type="reset" id="reset" value="reset" disabled="disabled">
 </li>
 </ul>
 <div>
 <script type="text/javascript"><!--
   allClassesLink = document.getElementById("allclasses_navbar_top");
   if(window==top) {
     allClassesLink.style.display = "block";
   }
   else {
     allClassesLink.style.display = "none";
   }
   //-->
 </script>
 <noscript>
 <div>JavaScript is disabled on your browser.</div>
 </noscript>
 </div>
 <div>
 <ul class="subNavList">
 <li>Summary:&nbsp;</li>
 <li>Nested&nbsp;|&nbsp;</li>
 <li><a href="#field.summary">Field</a>&nbsp;|&nbsp;</li>
 <li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
 <li><a href="#method.summary">Method</a></li>
 </ul>
 <ul class="subNavList">
 <li>Detail:&nbsp;</li>
 <li><a href="#field.detail">Field</a>&nbsp;|&nbsp;</li>
 <li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
 <li><a href="#method.detail">Method</a></li>
 </ul>
 </div>
 <a id="skip.navbar.top">
 <!--   -->
 </a></div>
 <!-- ========= END OF TOP NAVBAR ========= -->
 </div>
 <div class="navPadding">&nbsp;</div>
 <script type="text/javascript"><!--
 $('.navPadding').css('padding-top', $('.fixedNav').css("height"));
 //-->
 </script>
 </nav>
 </header>
 <!-- ======== START OF CLASS DATA ======== -->
 <main role="main">
 <div class="header">
 <div class="subTitle"><span class="packageLabelInType">Package</span>&nbsp;<a href="package-summary.html">org.apache.calcite.sql.fun</a></div>
 <h2 title="Class SqlStdOperatorTable" class="title">Class SqlStdOperatorTable</h2>
 </div>
 <div class="contentContainer">
 <ul class="inheritance">
 <li>java.lang.Object</li>
 <li>
 <ul class="inheritance">
 <li><a href="../util/ReflectiveSqlOperatorTable.html" title="class in org.apache.calcite.sql.util">org.apache.calcite.sql.util.ReflectiveSqlOperatorTable</a></li>
 <li>
 <ul class="inheritance">
 <li>org.apache.calcite.sql.fun.SqlStdOperatorTable</li>
 </ul>
 </li>
 </ul>
 </li>
 </ul>
 <div class="description">
 <ul class="blockList">
 <li class="blockList">
 <dl>
 <dt>All Implemented Interfaces:</dt>
 <dd><code><a href="../SqlOperatorTable.html" title="interface in org.apache.calcite.sql">SqlOperatorTable</a></code></dd>
 </dl>
 <hr>
 <pre>public class <span class="typeNameLabel">SqlStdOperatorTable</span>
 extends <a href="../util/ReflectiveSqlOperatorTable.html" title="class in org.apache.calcite.sql.util">ReflectiveSqlOperatorTable</a></pre>
 <div class="block">Implementation of <a href="../SqlOperatorTable.html" title="interface in org.apache.calcite.sql"><code>SqlOperatorTable</code></a> containing
  the standard operators and functions.</div>
 </li>
 </ul>
 </div>
 <div class="summary">
 <ul class="blockList">
 <li class="blockList">
 <!-- =========== FIELD SUMMARY =========== -->
 <section role="region">
 <ul class="blockList">
 <li class="blockList"><a id="field.summary">
 <!--   -->
 </a>
 <h3>Field Summary</h3>
 <table class="memberSummary">
 <caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
 <tr>
 <th class="colFirst" scope="col">Modifier and Type</th>
 <th class="colSecond" scope="col">Field</th>
 <th class="colLast" scope="col">Description</th>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ABS">ABS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ACOS">ACOS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ALL_EQ">ALL_EQ</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ALL_GE">ALL_GE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ALL_GT">ALL_GT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ALL_LE">ALL_LE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ALL_LT">ALL_LT</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>&lt; ALL</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ALL_NE">ALL_NE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#AND">AND</a></span></code></th>
 <td class="colLast">
 <div class="block">Logical <code>AND</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ANY_VALUE">ANY_VALUE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>ANY_VALUE</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#APPROX_COUNT_DISTINCT">APPROX_COUNT_DISTINCT</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>APPROX_COUNT_DISTINCT</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ARGUMENT_ASSIGNMENT">ARGUMENT_ASSIGNMENT</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>ARGUMENT_ASSIGNMENT</code> operator (<code>=&lt;</code>)
  assigns an argument to a function call to a particular named parameter.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlMultisetQueryConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMultisetQueryConstructor</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ARRAY_QUERY">ARRAY_QUERY</a></span></code></th>
 <td class="colLast">
 <div class="block">The ARRAY Query Constructor.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlArrayValueConstructor.html" title="class in org.apache.calcite.sql.fun">SqlArrayValueConstructor</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ARRAY_VALUE_CONSTRUCTOR">ARRAY_VALUE_CONSTRUCTOR</a></span></code></th>
 <td class="colLast">
 <div class="block">The ARRAY Value Constructor.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAsOperator.html" title="class in org.apache.calcite.sql">SqlAsOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#AS">AS</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>AS</code> operator associates an expression in the SELECT clause
  with an alias.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ASCII">ASCII</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ASIN">ASIN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ATAN">ATAN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ATAN2">ATAN2</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#AVG">AVG</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>AVG</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlBetweenOperator.html" title="class in org.apache.calcite.sql.fun">SqlBetweenOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#BETWEEN">BETWEEN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#BIT_AND">BIT_AND</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>BIT_AND</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#BIT_OR">BIT_OR</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>BIT_OR</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CARDINALITY">CARDINALITY</a></span></code></th>
 <td class="colLast">
 <div class="block">The CARDINALITY operator, used to retrieve the number of elements in a
  MULTISET, ARRAY or MAP.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlCaseOperator.html" title="class in org.apache.calcite.sql.fun">SqlCaseOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CASE">CASE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CAST">CAST</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>CAST</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CEIL">CEIL</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>CEIL</code> function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CHAR_LENGTH">CHAR_LENGTH</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CHARACTER_LENGTH">CHARACTER_LENGTH</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CLASSIFIER">CLASSIFIER</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>CLASSIFIER</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COALESCE">COALESCE</a></span></code></th>
 <td class="colLast">
 <div class="block">The COALESCE builtin function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COLLECT">COLLECT</a></span></code></th>
 <td class="colLast">
 <div class="block">The COLLECT operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COLLECTION_TABLE">COLLECTION_TABLE</a></span></code></th>
 <td class="colLast">
 <div class="block">The "table function derived table" operator, which a table-valued
  function into a relation, e.g.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlColumnListConstructor.html" title="class in org.apache.calcite.sql.fun">SqlColumnListConstructor</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COLUMN_LIST">COLUMN_LIST</a></span></code></th>
 <td class="colLast">
 <div class="block">The COLUMN_LIST constructor.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CONCAT">CONCAT</a></span></code></th>
 <td class="colLast">
 <div class="block">String concatenation operator, '<code>||</code>'.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CONTAINS">CONTAINS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CONVERT">CONVERT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COS">COS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COT">COT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COUNT">COUNT</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>COUNT</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COVAR_POP">COVAR_POP</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>COVAR_POP</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COVAR_SAMP">COVAR_SAMP</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>COVAR_SAMP</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CUBE">CUBE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>CUBE</code> operator, occurs within <code>GROUP BY</code> clause
  or nested within a <code>GROUPING SETS</code>.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlRankFunction.html" title="class in org.apache.calcite.sql">SqlRankFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CUME_DIST">CUME_DIST</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>CUME_DIST</code> window function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_CATALOG">CURRENT_CATALOG</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>CURRENT_CATALOG</code> function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_DATE">CURRENT_DATE</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>CURRENT_DATE</code> function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_PATH">CURRENT_PATH</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>CURRENT_PATH</code> function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_ROLE">CURRENT_ROLE</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>CURRENT_ROLE</code> function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_SCHEMA">CURRENT_SCHEMA</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>CURRENT_SCHEMA</code> function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_TIME">CURRENT_TIME</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>CURRENT_TIME [(<i>precision</i>)]</code> function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_TIMESTAMP">CURRENT_TIMESTAMP</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>CURRENT_TIMESTAMP [(<i>precision</i>)]</code> function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_USER">CURRENT_USER</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>CURRENT_USER</code> function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_VALUE">CURRENT_VALUE</a></span></code></th>
 <td class="colLast">
 <div class="block">The sequence current value function: <code>CURRENT VALUE FOR
  sequence</code></div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlCursorConstructor.html" title="class in org.apache.calcite.sql.fun">SqlCursorConstructor</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#CURSOR">CURSOR</a></span></code></th>
 <td class="colLast">
 <div class="block">The CURSOR constructor.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DATETIME_PLUS">DATETIME_PLUS</a></span></code></th>
 <td class="colLast">
 <div class="block">Infix datetime plus operator, '<code>DATETIME + INTERVAL</code>'.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DAYOFMONTH">DAYOFMONTH</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>DAYOFMONTH</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DAYOFWEEK">DAYOFWEEK</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>DAYOFWEEK</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DAYOFYEAR">DAYOFYEAR</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>DAYOFYEAR</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DEFAULT">DEFAULT</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>DEFAULT</code> operator indicates that an argument to a function call
  is to take its default value..</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DEGREES">DEGREES</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlRankFunction.html" title="class in org.apache.calcite.sql">SqlRankFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DENSE_RANK">DENSE_RANK</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>DENSE_RANK</code> window function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DESC">DESC</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DIVIDE">DIVIDE</a></span></code></th>
 <td class="colLast">
 <div class="block">Arithmetic division operator, '<code>/</code>'.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DIVIDE_INTEGER">DIVIDE_INTEGER</a></span></code></th>
 <td class="colLast">
 <div class="block">Internal integer arithmetic division operator, '<code>/INT</code>'.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DOT">DOT</a></span></code></th>
 <td class="colLast">
 <div class="block">Dot operator, '<code>.</code>', used for referencing fields of records.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ELEMENT">ELEMENT</a></span></code></th>
 <td class="colLast">
 <div class="block">The ELEMENT operator, used to convert a multiset with only one item to a
  "regular" type.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ELEMENT_SLICE">ELEMENT_SLICE</a></span></code></th>
 <td class="colLast">
 <div class="block">The internal "$ELEMENT_SLICE" operator returns the first field of the
  only element of a multiset.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#EQUALS">EQUALS</a></span></code></th>
 <td class="colLast">
 <div class="block">Logical equals operator, '<code>=</code>'.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ESCAPE">ESCAPE</a></span></code></th>
 <td class="colLast">
 <div class="block">Internal operator used to represent the ESCAPE clause of a LIKE or
  SIMILAR TO expression.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#EXCEPT">EXCEPT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#EXCEPT_ALL">EXCEPT_ALL</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#EXISTS">EXISTS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#EXP">EXP</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#EXPLICIT_TABLE">EXPLICIT_TABLE</a></span></code></th>
 <td class="colLast">
 <div class="block">Keyword which allows an identifier to be explicitly flagged as a table.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#EXTEND">EXTEND</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>EXTEND</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#EXTRACT">EXTRACT</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>EXTRACT</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFilterOperator.html" title="class in org.apache.calcite.sql">SqlFilterOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#FILTER">FILTER</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>FILTER</code> operator filters which rows are included in an
   aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#FINAL">FINAL</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>FINAL</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#FIRST">FIRST</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>FIRST</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#FIRST_VALUE">FIRST_VALUE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>FIRST_VALUE</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#FLOOR">FLOOR</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>FLOOR</code> function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#FUSION">FUSION</a></span></code></th>
 <td class="colLast">
 <div class="block">The FUSION operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#GREATER_THAN">GREATER_THAN</a></span></code></th>
 <td class="colLast">
 <div class="block">Logical greater-than operator, '<code>&gt;</code>'.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" 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">Logical greater-than-or-equal operator, '<code>&gt;=</code>'.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#GROUP_ID">GROUP_ID</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>GROUP_ID()</code> function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#GROUPING">GROUPING</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>GROUPING(c1 [, c2, ...])</code> function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#GROUPING_ID">GROUPING_ID</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>GROUPING_ID</code> function is a synonym for <code>GROUPING</code>.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#GROUPING_SETS">GROUPING_SETS</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>GROUPING SETS</code> operator, occurs within <code>GROUP BY</code> clause
  or nested within a <code>GROUPING SETS</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#HISTOGRAM_AGG">HISTOGRAM_AGG</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>HISTOGRAM</code> aggregate function support.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#HISTOGRAM_FIRST_VALUE">HISTOGRAM_FIRST_VALUE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>HISTOGRAM_FIRST_VALUE</code> window aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#HISTOGRAM_LAST_VALUE">HISTOGRAM_LAST_VALUE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>HISTOGRAM_LAST_VALUE</code> window aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#HISTOGRAM_MAX">HISTOGRAM_MAX</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>HISTOGRAM_MAX</code> window aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#HISTOGRAM_MIN">HISTOGRAM_MIN</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>HISTOGRAM_MIN</code> window aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#HOP">HOP</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>HOP</code> group function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a></code></td>
 <th class="colSecond" 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 <code>HOP</code> group function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a></code></td>
 <th class="colSecond" 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 <code>HOP</code> group function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#HOUR">HOUR</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>HOUR</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlNullTreatmentOperator.html" title="class in org.apache.calcite.sql">SqlNullTreatmentOperator</a></code></td>
 <th class="colSecond" 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="altColor">
 <td class="colFirst"><code>static <a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IMMEDIATELY_PRECEDES">IMMEDIATELY_PRECEDES</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IMMEDIATELY_SUCCEEDS">IMMEDIATELY_SUCCEEDS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IN">IN</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>IN</code> operator tests for a value's membership in a sub-query or
  a list of values.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IN_FENNEL">IN_FENNEL</a></span></code></th>
 <td class="colLast">
 <div class="block">Use of the <code>IN_FENNEL</code> operator forces the argument to be
  evaluated in Fennel.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#INITCAP">INITCAP</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>private static <a href="SqlStdOperatorTable.html" title="class in org.apache.calcite.sql.fun">SqlStdOperatorTable</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#instance">instance</a></span></code></th>
 <td class="colLast">
 <div class="block">The standard operator table.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#INTERSECT">INTERSECT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#INTERSECT_ALL">INTERSECT_ALL</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_A_SET">IS_A_SET</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_DIFFERENT_FROM">IS_DIFFERENT_FROM</a></span></code></th>
 <td class="colLast">
 <div class="block">The internal <code>$IS_DIFFERENT_FROM</code> operator is the same as the
  user-level <a href="#IS_DISTINCT_FROM"><code>IS_DISTINCT_FROM</code></a> in all respects except that
  the test for equality on character datatypes treats trailing spaces as
  significant.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" 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">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_EMPTY">IS_EMPTY</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_FALSE">IS_FALSE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_JSON_ARRAY">IS_JSON_ARRAY</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_JSON_OBJECT">IS_JSON_OBJECT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_JSON_SCALAR">IS_JSON_SCALAR</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_JSON_VALUE">IS_JSON_VALUE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_A_SET">IS_NOT_A_SET</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" 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">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_EMPTY">IS_NOT_EMPTY</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_FALSE">IS_NOT_FALSE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_JSON_ARRAY">IS_NOT_JSON_ARRAY</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_JSON_OBJECT">IS_NOT_JSON_OBJECT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_JSON_SCALAR">IS_NOT_JSON_SCALAR</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_JSON_VALUE">IS_NOT_JSON_VALUE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_NULL">IS_NOT_NULL</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_TRUE">IS_NOT_TRUE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_UNKNOWN">IS_NOT_UNKNOWN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_NULL">IS_NULL</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_TRUE">IS_TRUE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#IS_UNKNOWN">IS_UNKNOWN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ITEM">ITEM</a></span></code></th>
 <td class="colLast">
 <div class="block">The item operator <code>[ ... ]</code>, used to access a given element of an
  array or map.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_ARRAY">JSON_ARRAY</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlJsonArrayAggAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonArrayAggAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_ARRAYAGG">JSON_ARRAYAGG</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_DEPTH">JSON_DEPTH</a></span></code></th>
 <td class="colLast">
 <div class="block"><span class="deprecatedLabel">Deprecated.</span></div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_EXISTS">JSON_EXISTS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_KEYS">JSON_KEYS</a></span></code></th>
 <td class="colLast">
 <div class="block"><span class="deprecatedLabel">Deprecated.</span></div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_LENGTH">JSON_LENGTH</a></span></code></th>
 <td class="colLast">
 <div class="block"><span class="deprecatedLabel">Deprecated.</span></div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_OBJECT">JSON_OBJECT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlJsonObjectAggAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonObjectAggAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_OBJECTAGG">JSON_OBJECTAGG</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_PRETTY">JSON_PRETTY</a></span></code></th>
 <td class="colLast">
 <div class="block"><span class="deprecatedLabel">Deprecated.</span></div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_QUERY">JSON_QUERY</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_REMOVE">JSON_REMOVE</a></span></code></th>
 <td class="colLast">
 <div class="block"><span class="deprecatedLabel">Deprecated.</span></div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_STORAGE_SIZE">JSON_STORAGE_SIZE</a></span></code></th>
 <td class="colLast">
 <div class="block"><span class="deprecatedLabel">Deprecated.</span></div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_TYPE">JSON_TYPE</a></span></code></th>
 <td class="colLast">
 <div class="block"><span class="deprecatedLabel">Deprecated.</span></div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_VALUE">JSON_VALUE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_VALUE_ANY">JSON_VALUE_ANY</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#JSON_VALUE_EXPRESSION">JSON_VALUE_EXPRESSION</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LAG">LAG</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>LAG</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LAST">LAST</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>LAST</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LAST_DAY">LAST_DAY</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LAST_VALUE">LAST_VALUE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>LAST_VALUE</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LATERAL">LATERAL</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>LATERAL</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LEAD">LEAD</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>LEAD</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LESS_THAN">LESS_THAN</a></span></code></th>
 <td class="colLast">
 <div class="block">Logical less-than operator, '<code>&lt;</code>'.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" 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">Logical less-than-or-equal operator, '<code>&lt;=</code>'.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LIKE">LIKE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LISTAGG">LISTAGG</a></span></code></th>
 <td class="colLast">
 <div class="block">The LISTAGG operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlLiteralChainOperator.html" title="class in org.apache.calcite.sql.fun">SqlLiteralChainOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LITERAL_CHAIN">LITERAL_CHAIN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LN">LN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LOCALTIME">LOCALTIME</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>LOCALTIME [(<i>precision</i>)]</code> function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LOCALTIMESTAMP">LOCALTIMESTAMP</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>LOCALTIMESTAMP [(<i>precision</i>)]</code> function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LOG10">LOG10</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LOWER">LOWER</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlMultisetQueryConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMultisetQueryConstructor</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MAP_QUERY">MAP_QUERY</a></span></code></th>
 <td class="colLast">
 <div class="block">The MAP Query Constructor.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlMapValueConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMapValueConstructor</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MAP_VALUE_CONSTRUCTOR">MAP_VALUE_CONSTRUCTOR</a></span></code></th>
 <td class="colLast">
 <div class="block">The MAP Value Constructor,
  e.g.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" 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> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MAX">MAX</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>MAX</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MEMBER_OF">MEMBER_OF</a></span></code></th>
 <td class="colLast">
 <div class="block">Multiset <code>MEMBER OF</code>, which returns whether a element belongs to a
  multiset.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MIN">MIN</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>MIN</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MINUS">MINUS</a></span></code></th>
 <td class="colLast">
 <div class="block">Infix arithmetic minus operator, '<code>-</code>'.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlDatetimeSubtractionOperator.html" title="class in org.apache.calcite.sql.fun">SqlDatetimeSubtractionOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MINUS_DATE">MINUS_DATE</a></span></code></th>
 <td class="colLast">
 <div class="block">A special operator for the subtraction of two DATETIMEs.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MINUTE">MINUTE</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>MINUTE</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MOD">MOD</a></span></code></th>
 <td class="colLast">
 <div class="block">Arithmetic remainder function <code>MOD</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MONTH">MONTH</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>MONTH</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MULTIPLY">MULTIPLY</a></span></code></th>
 <td class="colLast">
 <div class="block">Arithmetic multiplication operator, '<code>*</code>'.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_EXCEPT">MULTISET_EXCEPT</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>MULTISET EXCEPT [ALL]</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_EXCEPT_DISTINCT">MULTISET_EXCEPT_DISTINCT</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>MULTISET EXCEPT DISTINCT</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_INTERSECT">MULTISET_INTERSECT</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>MULTISET INTERSECT [ALL]</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_INTERSECT_DISTINCT">MULTISET_INTERSECT_DISTINCT</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>MULTISET INTERSECT DISTINCT</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlMultisetQueryConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMultisetQueryConstructor</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_QUERY">MULTISET_QUERY</a></span></code></th>
 <td class="colLast">
 <div class="block">The MULTISET Query Constructor.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_UNION">MULTISET_UNION</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>MULTISET UNION [ALL]</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_UNION_DISTINCT">MULTISET_UNION_DISTINCT</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>MULTISET UNION DISTINCT</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlMultisetValueConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMultisetValueConstructor</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_VALUE">MULTISET_VALUE</a></span></code></th>
 <td class="colLast">
 <div class="block">The MULTISET Value Constructor.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NEGATED_POSIX_REGEX_CASE_INSENSITIVE">NEGATED_POSIX_REGEX_CASE_INSENSITIVE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NEGATED_POSIX_REGEX_CASE_SENSITIVE">NEGATED_POSIX_REGEX_CASE_SENSITIVE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NEW">NEW</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NEXT">NEXT</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>NEXT</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NEXT_VALUE">NEXT_VALUE</a></span></code></th>
 <td class="colLast">
 <div class="block">The sequence next value function: <code>NEXT VALUE FOR sequence</code></div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NOT">NOT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlBetweenOperator.html" title="class in org.apache.calcite.sql.fun">SqlBetweenOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NOT_BETWEEN">NOT_BETWEEN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NOT_EQUALS">NOT_EQUALS</a></span></code></th>
 <td class="colLast">
 <div class="block">Logical not-equals operator, '<code>&lt;&gt;</code>'.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" 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 tests for a value's membership in a sub-query
  or a list of values.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NOT_LIKE">NOT_LIKE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NOT_SIMILAR_TO">NOT_SIMILAR_TO</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NOT_SUBMULTISET_OF">NOT_SUBMULTISET_OF</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NTH_VALUE">NTH_VALUE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>NTH_VALUE</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NTILE">NTILE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>NTILE</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NULLIF">NULLIF</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NULLS_FIRST">NULLS_FIRST</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NULLS_LAST">NULLS_LAST</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#OR">OR</a></span></code></th>
 <td class="colLast">
 <div class="block">Logical <code>OR</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#OVER">OVER</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>OVER</code> operator, which applies an aggregate functions to a
  <a href="../SqlWindow.html" title="class in org.apache.calcite.sql"><code>window</code></a>.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#OVERLAPS">OVERLAPS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#OVERLAY">OVERLAY</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_ALTER">PATTERN_ALTER</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>|</code> operator to create alternate patterns
  within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_CONCAT">PATTERN_CONCAT</a></span></code></th>
 <td class="colLast">
 <div class="block">Operator to concatenate patterns within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_EXCLUDE">PATTERN_EXCLUDE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>EXCLUDE</code> operator within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_PERMUTE">PATTERN_PERMUTE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>PERMUTE</code> operator to combine patterns within
  <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_QUANTIFIER">PATTERN_QUANTIFIER</a></span></code></th>
 <td class="colLast">
 <div class="block">Operator to quantify patterns within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlRankFunction.html" title="class in org.apache.calcite.sql">SqlRankFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PERCENT_RANK">PERCENT_RANK</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>PERCENT_RANK</code> window function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PERCENT_REMAINDER">PERCENT_REMAINDER</a></span></code></th>
 <td class="colLast">
 <div class="block">Arithmetic remainder operator, '<code>%</code>',
  an alternative to <a href="#MOD"><code>MOD</code></a> allowed if under certain conformance levels.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PERIOD_EQUALS">PERIOD_EQUALS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PI">PI</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PLUS">PLUS</a></span></code></th>
 <td class="colLast">
 <div class="block">Infix arithmetic plus operator, '<code>+</code>'.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#POSITION">POSITION</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#POSIX_REGEX_CASE_INSENSITIVE">POSIX_REGEX_CASE_INSENSITIVE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#POSIX_REGEX_CASE_SENSITIVE">POSIX_REGEX_CASE_SENSITIVE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#POWER">POWER</a></span></code></th>
 <td class="colLast">
 <div class="block">Uses SqlOperatorTable.useDouble for its return type since we don't know
  what the result type will be by just looking at the operand types.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PRECEDES">PRECEDES</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PREV">PREV</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>PREV</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#PROCEDURE_CALL">PROCEDURE_CALL</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#QUARTER">QUARTER</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>QUARTER</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#RADIANS">RADIANS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlRandFunction.html" title="class in org.apache.calcite.sql.fun">SqlRandFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#RAND">RAND</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>RAND([seed])</code> function, which yields a random double,
  optionally with seed.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlRandIntegerFunction.html" title="class in org.apache.calcite.sql.fun">SqlRandIntegerFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#RAND_INTEGER">RAND_INTEGER</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>RAND_INTEGER([seed, ] bound)</code> function, which yields a random
  integer, optionally with seed.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlRankFunction.html" title="class in org.apache.calcite.sql">SqlRankFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#RANK">RANK</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>RANK</code> window function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#REGR_COUNT">REGR_COUNT</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>REGR_COUNT</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#REGR_SXX">REGR_SXX</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>REGR_SXX</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#REGR_SYY">REGR_SYY</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>REGR_SYY</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#REINTERPRET">REINTERPRET</a></span></code></th>
 <td class="colLast">
 <div class="block">An <code>REINTERPRET</code> operator is internal to the planner.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#REPLACE">REPLACE</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>REPLACE(string, search, replace)</code> function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlNullTreatmentOperator.html" title="class in org.apache.calcite.sql">SqlNullTreatmentOperator</a></code></td>
 <th class="colSecond" 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">
 <td class="colFirst"><code>static <a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ROLLUP">ROLLUP</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>ROLLUP</code> operator, occurs within <code>GROUP BY</code> clause
  or nested within a <code>GROUPING SETS</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ROUND">ROUND</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlRowOperator.html" title="class in org.apache.calcite.sql.fun">SqlRowOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ROW">ROW</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlRankFunction.html" title="class in org.apache.calcite.sql">SqlRankFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ROW_NUMBER">ROW_NUMBER</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>ROW_NUMBER</code> window function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#RUNNING">RUNNING</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>RUNNING</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SCALAR_QUERY">SCALAR_QUERY</a></span></code></th>
 <td class="colLast">
 <div class="block">The internal "$SCALAR_QUERY" operator returns a scalar value from a
  record type.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SECOND">SECOND</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>SECOND</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SESSION">SESSION</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>SESSION</code> group function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a></code></td>
 <th class="colSecond" 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 <code>SESSION</code> group function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a></code></td>
 <th class="colSecond" 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 <code>SESSION</code> group function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SESSION_USER">SESSION_USER</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>SESSION_USER</code> function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SIGN">SIGN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SIMILAR_TO">SIMILAR_TO</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SIN">SIN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SINGLE_VALUE">SINGLE_VALUE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>SINGLE_VALUE</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SLICE">SLICE</a></span></code></th>
 <td class="colLast">
 <div class="block">The internal "$SLICE" operator takes a multiset of records and returns a
  multiset of the first column of those records.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SOME_EQ">SOME_EQ</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SOME_GE">SOME_GE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SOME_GT">SOME_GT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SOME_LE">SOME_LE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SOME_LT">SOME_LT</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>&lt; SOME</code> operator (synonymous with
  <code>&lt; ANY</code>).</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SOME_NE">SOME_NE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SQRT">SQRT</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#STDDEV">STDDEV</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>STDDEV</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#STDDEV_POP">STDDEV_POP</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>STDDEV_POP</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#STDDEV_SAMP">STDDEV_SAMP</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>STDDEV_SAMP</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#STRUCT_ACCESS">STRUCT_ACCESS</a></span></code></th>
 <td class="colLast">
 <div class="block">The internal <code>$STRUCT_ACCESS</code> operator is used to access a
  field of a record.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SUBMULTISET_OF">SUBMULTISET_OF</a></span></code></th>
 <td class="colLast">
 <div class="block">Submultiset.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SUBSTRING">SUBSTRING</a></span></code></th>
 <td class="colLast">
 <div class="block">The character substring function: <code>SUBSTRING(string FROM start [FOR
  length])</code>.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SUCCEEDS">SUCCEEDS</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SUM">SUM</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>SUM</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SUM0">SUM0</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>SUM0</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlBetweenOperator.html" title="class in org.apache.calcite.sql.fun">SqlBetweenOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SYMMETRIC_BETWEEN">SYMMETRIC_BETWEEN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlBetweenOperator.html" title="class in org.apache.calcite.sql.fun">SqlBetweenOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SYMMETRIC_NOT_BETWEEN">SYMMETRIC_NOT_BETWEEN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SYSTEM_USER">SYSTEM_USER</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>SYSTEM_USER</code> function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#TABLESAMPLE">TABLESAMPLE</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>TABLESAMPLE</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#TAN">TAN</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="SqlThrowOperator.html" title="class in org.apache.calcite.sql.fun">SqlThrowOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#THROW">THROW</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#TIMESTAMP_ADD">TIMESTAMP_ADD</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>TIMESTAMPADD</code> function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#TIMESTAMP_DIFF">TIMESTAMP_DIFF</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>TIMESTAMPDIFF</code> function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#TRANSLATE">TRANSLATE</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>TRANSLATE(<i>char_value</i> USING <i>translation_name</i>)</code> function
  alters the character set of a string value from one base character set to another.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#TRIM">TRIM</a></span></code></th>
 <td class="colLast">
 <div class="block">The "TRIM" function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#TRUNCATE">TRUNCATE</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a></code></td>
 <th class="colSecond" 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">
 <td class="colFirst"><code>static <a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a></code></td>
 <th class="colSecond" 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 <code>TUMBLE</code> group function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a></code></td>
 <th class="colSecond" 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 <code>TUMBLE</code> group function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#UNARY_MINUS">UNARY_MINUS</a></span></code></th>
 <td class="colLast">
 <div class="block">Prefix arithmetic minus operator, '<code>-</code>'.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#UNARY_PLUS">UNARY_PLUS</a></span></code></th>
 <td class="colLast">
 <div class="block">Prefix arithmetic plus operator, '<code>+</code>'.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#UNION">UNION</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#UNION_ALL">UNION_ALL</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlUnnestOperator.html" title="class in org.apache.calcite.sql">SqlUnnestOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#UNNEST">UNNEST</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>UNNEST</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlUnnestOperator.html" title="class in org.apache.calcite.sql">SqlUnnestOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#UNNEST_WITH_ORDINALITY">UNNEST_WITH_ORDINALITY</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>UNNEST WITH ORDINALITY</code> operator.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#UPPER">UPPER</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#USER">USER</a></span></code></th>
 <td class="colLast">
 <div class="block">The <code>USER</code> function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#VALUES">VALUES</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#VAR_POP">VAR_POP</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>VAR_POP</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#VAR_SAMP">VAR_SAMP</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>VAR_SAMP</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#VARIANCE">VARIANCE</a></span></code></th>
 <td class="colLast">
 <div class="block"><code>VARIANCE</code> aggregate function.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#WEEK">WEEK</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>WEEK</code> operator.</div>
 </td>
 </tr>
 <tr class="altColor">
 <td class="colFirst"><code>static <a href="../SqlWithinGroupOperator.html" title="class in org.apache.calcite.sql">SqlWithinGroupOperator</a></code></td>
 <th class="colSecond" 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 performs aggregations on ordered data input.</div>
 </td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>static <a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#YEAR">YEAR</a></span></code></th>
 <td class="colLast">
 <div class="block">The SQL <code>YEAR</code> operator.</div>
 </td>
 </tr>
 </table>
 <ul class="blockList">
 <li class="blockList"><a id="fields.inherited.from.class.org.apache.calcite.sql.util.ReflectiveSqlOperatorTable">
 <!--   -->
 </a>
 <h3>Fields inherited from class&nbsp;org.apache.calcite.sql.util.<a href="../util/ReflectiveSqlOperatorTable.html" title="class in org.apache.calcite.sql.util">ReflectiveSqlOperatorTable</a></h3>
 <code><a href="../util/ReflectiveSqlOperatorTable.html#IS_NAME">IS_NAME</a></code></li>
 </ul>
 </li>
 </ul>
 </section>
 <!-- ======== CONSTRUCTOR SUMMARY ======== -->
 <section role="region">
 <ul class="blockList">
 <li class="blockList"><a id="constructor.summary">
 <!--   -->
 </a>
 <h3>Constructor Summary</h3>
 <table class="memberSummary">
 <caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
 <tr>
 <th class="colFirst" scope="col">Constructor</th>
 <th class="colLast" scope="col">Description</th>
 </tr>
 <tr class="altColor">
 <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E()">SqlStdOperatorTable</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 </table>
 </li>
 </ul>
 </section>
 <!-- ========== METHOD SUMMARY =========== -->
 <section role="region">
 <ul class="blockList">
 <li class="blockList"><a id="method.summary">
 <!--   -->
 </a>
 <h3>Method Summary</h3>
 <table class="memberSummary">
 <caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd">&nbsp;</span></span><span id="t1" class="tableTab"><span><a href="javascript:show(1);">Static Methods</a></span><span class="tabEnd">&nbsp;</span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd">&nbsp;</span></span></caption>
 <tr>
 <th class="colFirst" scope="col">Modifier and Type</th>
 <th class="colSecond" scope="col">Method</th>
 <th class="colLast" scope="col">Description</th>
 </tr>
 <tr id="i0" class="altColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#all(org.apache.calcite.sql.SqlKind)">all</a></span>&#8203;(<a href="../SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&nbsp;comparisonKind)</code></th>
 <td class="colLast">
 <div class="block">Returns the operator for <code>ALL comparisonKind</code>.</div>
 </td>
 </tr>
 <tr id="i1" class="rowColor">
 <td class="colFirst"><code>static <a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#auxiliaryToGroup(org.apache.calcite.sql.SqlKind)">auxiliaryToGroup</a></span>&#8203;(<a href="../SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&nbsp;kind)</code></th>
 <td class="colLast">
 <div class="block">Returns the group function for which a given kind is an auxiliary
  function, or null if it is not an auxiliary function.</div>
 </td>
 </tr>
 <tr id="i2" class="altColor">
 <td class="colFirst"><code>static <a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#convertAuxiliaryToGroupCall(org.apache.calcite.sql.SqlCall)">convertAuxiliaryToGroupCall</a></span>&#8203;(<a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a>&nbsp;call)</code></th>
 <td class="colLast">
 <div class="block">Converts a call to a grouped auxiliary function
  to a call to the grouped window function.</div>
 </td>
 </tr>
 <tr id="i3" class="rowColor">
 <td class="colFirst"><code>static java.util.List&lt;<a href="../../util/Pair.html" title="class in org.apache.calcite.util">Pair</a>&lt;<a href="../SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a>,&#8203;<a href="../../sql2rel/AuxiliaryConverter.html" title="interface in org.apache.calcite.sql2rel">AuxiliaryConverter</a>&gt;&gt;</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#convertGroupToAuxiliaryCalls(org.apache.calcite.sql.SqlCall)">convertGroupToAuxiliaryCalls</a></span>&#8203;(<a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a>&nbsp;call)</code></th>
 <td class="colLast">
 <div class="block">Converts a call to a grouped window function to a call to its auxiliary
  window function(s).</div>
 </td>
 </tr>
 <tr id="i4" class="altColor">
 <td class="colFirst"><code>private static <a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#copy(org.apache.calcite.sql.SqlCall,org.apache.calcite.sql.SqlOperator)">copy</a></span>&#8203;(<a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a>&nbsp;call,
     <a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a>&nbsp;operator)</code></th>
 <td class="colLast">
 <div class="block">Creates a copy of a call with a new operator.</div>
 </td>
 </tr>
 <tr id="i5" class="rowColor">
 <td class="colFirst"><code>static <a href="SqlStdOperatorTable.html" title="class in org.apache.calcite.sql.fun">SqlStdOperatorTable</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#instance()">instance</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Returns the standard operator table, creating it if necessary.</div>
 </td>
 </tr>
 <tr id="i6" class="altColor">
 <td class="colFirst"><code>static <a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#some(org.apache.calcite.sql.SqlKind)">some</a></span>&#8203;(<a href="../SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&nbsp;comparisonKind)</code></th>
 <td class="colLast">
 <div class="block">Returns the operator for <code>SOME comparisonKind</code>.</div>
 </td>
 </tr>
 </table>
 <ul class="blockList">
 <li class="blockList"><a id="methods.inherited.from.class.org.apache.calcite.sql.util.ReflectiveSqlOperatorTable">
 <!--   -->
 </a>
 <h3>Methods inherited from class&nbsp;org.apache.calcite.sql.util.<a href="../util/ReflectiveSqlOperatorTable.html" title="class in org.apache.calcite.sql.util">ReflectiveSqlOperatorTable</a></h3>
 <code><a href="../util/ReflectiveSqlOperatorTable.html#getOperatorList()">getOperatorList</a>, <a href="../util/ReflectiveSqlOperatorTable.html#init()">init</a>, <a href="../util/ReflectiveSqlOperatorTable.html#lookupOperatorOverloads(org.apache.calcite.sql.SqlIdentifier,org.apache.calcite.sql.SqlFunctionCategory,org.apache.calcite.sql.SqlSyntax,java.util.List,org.apache.calcite.sql.validate.SqlNameMatcher)">lookupOperatorOverloads</a>, <a href="../util/ReflectiveSqlOperatorTable.html#register(org.apache.calcite.sql.SqlOperator)">register</a></code></li>
 </ul>
 <ul class="blockList">
 <li class="blockList"><a id="methods.inherited.from.class.java.lang.Object">
 <!--   -->
 </a>
 <h3>Methods inherited from class&nbsp;java.lang.Object</h3>
 <code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</code></li>
 </ul>
 </li>
 </ul>
 </section>
 </li>
 </ul>
 </div>
 <div class="details">
 <ul class="blockList">
 <li class="blockList">
 <!-- ============ FIELD DETAIL =========== -->
 <section role="region">
 <ul class="blockList">
 <li class="blockList"><a id="field.detail">
 <!--   -->
 </a>
 <h3>Field Detail</h3>
 <a id="instance">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>instance</h4>
 <pre>private static&nbsp;<a href="SqlStdOperatorTable.html" title="class in org.apache.calcite.sql.fun">SqlStdOperatorTable</a> instance</pre>
 <div class="block">The standard operator table.</div>
 </li>
 </ul>
 <a id="UNION">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>UNION</h4>
 <pre>public static final&nbsp;<a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a> UNION</pre>
 </li>
 </ul>
 <a id="UNION_ALL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>UNION_ALL</h4>
 <pre>public static final&nbsp;<a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a> UNION_ALL</pre>
 </li>
 </ul>
 <a id="EXCEPT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>EXCEPT</h4>
 <pre>public static final&nbsp;<a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a> EXCEPT</pre>
 </li>
 </ul>
 <a id="EXCEPT_ALL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>EXCEPT_ALL</h4>
 <pre>public static final&nbsp;<a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a> EXCEPT_ALL</pre>
 </li>
 </ul>
 <a id="INTERSECT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>INTERSECT</h4>
 <pre>public static final&nbsp;<a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a> INTERSECT</pre>
 </li>
 </ul>
 <a id="INTERSECT_ALL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>INTERSECT_ALL</h4>
 <pre>public static final&nbsp;<a href="../SqlSetOperator.html" title="class in org.apache.calcite.sql">SqlSetOperator</a> INTERSECT_ALL</pre>
 </li>
 </ul>
 <a id="MULTISET_UNION_DISTINCT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MULTISET_UNION_DISTINCT</h4>
 <pre>public static final&nbsp;<a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a> MULTISET_UNION_DISTINCT</pre>
 <div class="block">The <code>MULTISET UNION DISTINCT</code> operator.</div>
 </li>
 </ul>
 <a id="MULTISET_UNION">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MULTISET_UNION</h4>
 <pre>public static final&nbsp;<a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a> MULTISET_UNION</pre>
 <div class="block">The <code>MULTISET UNION [ALL]</code> operator.</div>
 </li>
 </ul>
 <a id="MULTISET_EXCEPT_DISTINCT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MULTISET_EXCEPT_DISTINCT</h4>
 <pre>public static final&nbsp;<a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a> MULTISET_EXCEPT_DISTINCT</pre>
 <div class="block">The <code>MULTISET EXCEPT DISTINCT</code> operator.</div>
 </li>
 </ul>
 <a id="MULTISET_EXCEPT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MULTISET_EXCEPT</h4>
 <pre>public static final&nbsp;<a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a> MULTISET_EXCEPT</pre>
 <div class="block">The <code>MULTISET EXCEPT [ALL]</code> operator.</div>
 </li>
 </ul>
 <a id="MULTISET_INTERSECT_DISTINCT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MULTISET_INTERSECT_DISTINCT</h4>
 <pre>public static final&nbsp;<a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a> MULTISET_INTERSECT_DISTINCT</pre>
 <div class="block">The <code>MULTISET INTERSECT DISTINCT</code> operator.</div>
 </li>
 </ul>
 <a id="MULTISET_INTERSECT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MULTISET_INTERSECT</h4>
 <pre>public static final&nbsp;<a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a> MULTISET_INTERSECT</pre>
 <div class="block">The <code>MULTISET INTERSECT [ALL]</code> operator.</div>
 </li>
 </ul>
 <a id="AND">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>AND</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> AND</pre>
 <div class="block">Logical <code>AND</code> operator.</div>
 </li>
 </ul>
 <a id="AS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>AS</h4>
 <pre>public static final&nbsp;<a href="../SqlAsOperator.html" title="class in org.apache.calcite.sql">SqlAsOperator</a> AS</pre>
 <div class="block"><code>AS</code> operator associates an expression in the SELECT clause
  with an alias.</div>
 </li>
 </ul>
 <a id="ARGUMENT_ASSIGNMENT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ARGUMENT_ASSIGNMENT</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> ARGUMENT_ASSIGNMENT</pre>
 <div class="block"><code>ARGUMENT_ASSIGNMENT</code> operator (<code>=&lt;</code>)
  assigns an argument to a function call to a particular named parameter.</div>
 </li>
 </ul>
 <a id="DEFAULT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DEFAULT</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> DEFAULT</pre>
 <div class="block"><code>DEFAULT</code> operator indicates that an argument to a function call
  is to take its default value..</div>
 </li>
 </ul>
 <a id="FILTER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>FILTER</h4>
 <pre>public static final&nbsp;<a href="../SqlFilterOperator.html" title="class in org.apache.calcite.sql">SqlFilterOperator</a> FILTER</pre>
 <div class="block"><code>FILTER</code> operator filters which rows are included in an
   aggregate function.</div>
 </li>
 </ul>
 <a id="WITHIN_GROUP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>WITHIN_GROUP</h4>
 <pre>public static final&nbsp;<a href="../SqlWithinGroupOperator.html" title="class in org.apache.calcite.sql">SqlWithinGroupOperator</a> WITHIN_GROUP</pre>
 <div class="block"><code>WITHIN_GROUP</code> operator performs aggregations on ordered data input.</div>
 </li>
 </ul>
 <a id="CUBE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CUBE</h4>
 <pre>public static final&nbsp;<a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a> CUBE</pre>
 <div class="block"><code>CUBE</code> operator, occurs within <code>GROUP BY</code> clause
  or nested within a <code>GROUPING SETS</code>.</div>
 </li>
 </ul>
 <a id="ROLLUP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ROLLUP</h4>
 <pre>public static final&nbsp;<a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a> ROLLUP</pre>
 <div class="block"><code>ROLLUP</code> operator, occurs within <code>GROUP BY</code> clause
  or nested within a <code>GROUPING SETS</code>.</div>
 </li>
 </ul>
 <a id="GROUPING_SETS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>GROUPING_SETS</h4>
 <pre>public static final&nbsp;<a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a> GROUPING_SETS</pre>
 <div class="block"><code>GROUPING SETS</code> operator, occurs within <code>GROUP BY</code> clause
  or nested within a <code>GROUPING SETS</code>.</div>
 </li>
 </ul>
 <a id="GROUPING">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>GROUPING</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> GROUPING</pre>
 <div class="block"><code>GROUPING(c1 [, c2, ...])</code> function.

  <p>Occurs in similar places to an aggregate
  function (<code>SELECT</code>, <code>HAVING</code> clause, etc. of an aggregate
  query), but not technically an aggregate function.</div>
 </li>
 </ul>
 <a id="GROUP_ID">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>GROUP_ID</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> GROUP_ID</pre>
 <div class="block"><code>GROUP_ID()</code> function. (Oracle-specific.)</div>
 </li>
 </ul>
 <a id="GROUPING_ID">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>GROUPING_ID</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> GROUPING_ID</pre>
 <div class="block"><code>GROUPING_ID</code> function is a synonym for <code>GROUPING</code>.

  <p>Some history. The <code>GROUPING</code> function is in the SQL standard,
  and originally supported only one argument. <code>GROUPING_ID</code> is not
  standard (though supported in Oracle and SQL Server) and supports one or
  more arguments.

  <p>The SQL standard has changed to allow <code>GROUPING</code> to have multiple
  arguments. It is now equivalent to <code>GROUPING_ID</code>, so we made
  <code>GROUPING_ID</code> a synonym for <code>GROUPING</code>.</div>
 </li>
 </ul>
 <a id="EXTEND">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>EXTEND</h4>
 <pre>public static final&nbsp;<a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a> EXTEND</pre>
 <div class="block"><code>EXTEND</code> operator.</div>
 </li>
 </ul>
 <a id="CONCAT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CONCAT</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> CONCAT</pre>
 <div class="block">String concatenation operator, '<code>||</code>'.</div>
 </li>
 </ul>
 <a id="DIVIDE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DIVIDE</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> DIVIDE</pre>
 <div class="block">Arithmetic division operator, '<code>/</code>'.</div>
 </li>
 </ul>
 <a id="PERCENT_REMAINDER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PERCENT_REMAINDER</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> PERCENT_REMAINDER</pre>
 <div class="block">Arithmetic remainder operator, '<code>%</code>',
  an alternative to <a href="#MOD"><code>MOD</code></a> allowed if under certain conformance levels.</div>
 <dl>
 <dt><span class="seeLabel">See Also:</span></dt>
 <dd><a href="../validate/SqlConformance.html#isPercentRemainderAllowed()"><code>SqlConformance.isPercentRemainderAllowed()</code></a></dd>
 </dl>
 </li>
 </ul>
 <a id="RAND_INTEGER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>RAND_INTEGER</h4>
 <pre>public static final&nbsp;<a href="SqlRandIntegerFunction.html" title="class in org.apache.calcite.sql.fun">SqlRandIntegerFunction</a> RAND_INTEGER</pre>
 <div class="block">The <code>RAND_INTEGER([seed, ] bound)</code> function, which yields a random
  integer, optionally with seed.</div>
 </li>
 </ul>
 <a id="RAND">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>RAND</h4>
 <pre>public static final&nbsp;<a href="SqlRandFunction.html" title="class in org.apache.calcite.sql.fun">SqlRandFunction</a> RAND</pre>
 <div class="block">The <code>RAND([seed])</code> function, which yields a random double,
  optionally with seed.</div>
 </li>
 </ul>
 <a id="DIVIDE_INTEGER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DIVIDE_INTEGER</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> DIVIDE_INTEGER</pre>
 <div class="block">Internal integer arithmetic division operator, '<code>/INT</code>'. This
  is only used to adjust scale for numerics. We distinguish it from
  user-requested division since some personalities want a floating-point
  computation, whereas for the internal scaling use of division, we always
  want integer division.</div>
 </li>
 </ul>
 <a id="DOT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DOT</h4>
 <pre>public static final&nbsp;<a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a> DOT</pre>
 <div class="block">Dot operator, '<code>.</code>', used for referencing fields of records.</div>
 </li>
 </ul>
 <a id="EQUALS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>EQUALS</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> EQUALS</pre>
 <div class="block">Logical equals operator, '<code>=</code>'.</div>
 </li>
 </ul>
 <a id="GREATER_THAN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>GREATER_THAN</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> GREATER_THAN</pre>
 <div class="block">Logical greater-than operator, '<code>&gt;</code>'.</div>
 </li>
 </ul>
 <a id="IS_DISTINCT_FROM">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_DISTINCT_FROM</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> IS_DISTINCT_FROM</pre>
 <div class="block"><code>IS DISTINCT FROM</code> operator.</div>
 </li>
 </ul>
 <a id="IS_NOT_DISTINCT_FROM">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_DISTINCT_FROM</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> IS_NOT_DISTINCT_FROM</pre>
 <div class="block"><code>IS NOT DISTINCT FROM</code> operator. Is equivalent to <code>NOT(x
  IS DISTINCT FROM y)</code></div>
 </li>
 </ul>
 <a id="IS_DIFFERENT_FROM">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_DIFFERENT_FROM</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> IS_DIFFERENT_FROM</pre>
 <div class="block">The internal <code>$IS_DIFFERENT_FROM</code> operator is the same as the
  user-level <a href="#IS_DISTINCT_FROM"><code>IS_DISTINCT_FROM</code></a> in all respects except that
  the test for equality on character datatypes treats trailing spaces as
  significant.</div>
 </li>
 </ul>
 <a id="GREATER_THAN_OR_EQUAL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>GREATER_THAN_OR_EQUAL</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> GREATER_THAN_OR_EQUAL</pre>
 <div class="block">Logical greater-than-or-equal operator, '<code>&gt;=</code>'.</div>
 </li>
 </ul>
 <a id="IN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IN</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> IN</pre>
 <div class="block"><code>IN</code> operator tests for a value's membership in a sub-query or
  a list of values.</div>
 </li>
 </ul>
 <a id="NOT_IN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NOT_IN</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> NOT_IN</pre>
 <div class="block"><code>NOT IN</code> operator tests for a value's membership in a sub-query
  or a list of values.</div>
 </li>
 </ul>
 <a id="SOME_LT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SOME_LT</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> SOME_LT</pre>
 <div class="block">The <code>&lt; SOME</code> operator (synonymous with
  <code>&lt; ANY</code>).</div>
 </li>
 </ul>
 <a id="SOME_LE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SOME_LE</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> SOME_LE</pre>
 </li>
 </ul>
 <a id="SOME_GT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SOME_GT</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> SOME_GT</pre>
 </li>
 </ul>
 <a id="SOME_GE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SOME_GE</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> SOME_GE</pre>
 </li>
 </ul>
 <a id="SOME_EQ">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SOME_EQ</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> SOME_EQ</pre>
 </li>
 </ul>
 <a id="SOME_NE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SOME_NE</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> SOME_NE</pre>
 </li>
 </ul>
 <a id="ALL_LT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ALL_LT</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> ALL_LT</pre>
 <div class="block">The <code>&lt; ALL</code> operator.</div>
 </li>
 </ul>
 <a id="ALL_LE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ALL_LE</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> ALL_LE</pre>
 </li>
 </ul>
 <a id="ALL_GT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ALL_GT</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> ALL_GT</pre>
 </li>
 </ul>
 <a id="ALL_GE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ALL_GE</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> ALL_GE</pre>
 </li>
 </ul>
 <a id="ALL_EQ">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ALL_EQ</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> ALL_EQ</pre>
 </li>
 </ul>
 <a id="ALL_NE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ALL_NE</h4>
 <pre>public static final&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a> ALL_NE</pre>
 </li>
 </ul>
 <a id="LESS_THAN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LESS_THAN</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> LESS_THAN</pre>
 <div class="block">Logical less-than operator, '<code>&lt;</code>'.</div>
 </li>
 </ul>
 <a id="LESS_THAN_OR_EQUAL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LESS_THAN_OR_EQUAL</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> LESS_THAN_OR_EQUAL</pre>
 <div class="block">Logical less-than-or-equal operator, '<code>&lt;=</code>'.</div>
 </li>
 </ul>
 <a id="MINUS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MINUS</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> MINUS</pre>
 <div class="block">Infix arithmetic minus operator, '<code>-</code>'.

  <p>Its precedence is less than the prefix <a href="#UNARY_PLUS"><code>+</code></a>
  and <a href="#UNARY_MINUS"><code>-</code></a> operators.</div>
 </li>
 </ul>
 <a id="MULTIPLY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MULTIPLY</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> MULTIPLY</pre>
 <div class="block">Arithmetic multiplication operator, '<code>*</code>'.</div>
 </li>
 </ul>
 <a id="NOT_EQUALS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NOT_EQUALS</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> NOT_EQUALS</pre>
 <div class="block">Logical not-equals operator, '<code>&lt;&gt;</code>'.</div>
 </li>
 </ul>
 <a id="OR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>OR</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> OR</pre>
 <div class="block">Logical <code>OR</code> operator.</div>
 </li>
 </ul>
 <a id="PLUS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PLUS</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> PLUS</pre>
 <div class="block">Infix arithmetic plus operator, '<code>+</code>'.</div>
 </li>
 </ul>
 <a id="DATETIME_PLUS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DATETIME_PLUS</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> DATETIME_PLUS</pre>
 <div class="block">Infix datetime plus operator, '<code>DATETIME + INTERVAL</code>'.</div>
 </li>
 </ul>
 <a id="MEMBER_OF">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MEMBER_OF</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> MEMBER_OF</pre>
 <div class="block">Multiset <code>MEMBER OF</code>, which returns whether a element belongs to a
  multiset.

  <p>For example, the following returns <code>false</code>:

  <blockquote>
  <code>'green' MEMBER OF MULTISET ['red','almost green','blue']</code>
  </blockquote></div>
 </li>
 </ul>
 <a id="SUBMULTISET_OF">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SUBMULTISET_OF</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> SUBMULTISET_OF</pre>
 <div class="block">Submultiset. Checks to see if an multiset is a sub-set of another
  multiset.

  <p>For example, the following returns <code>false</code>:

  <blockquote>
  <code>MULTISET ['green'] SUBMULTISET OF
  MULTISET['red', 'almost green', 'blue']</code>
  </blockquote>

  <p>The following returns <code>true</code>, in part because multisets are
  order-independent:

  <blockquote>
  <code>MULTISET ['blue', 'red'] SUBMULTISET OF
  MULTISET ['red', 'almost green', 'blue']</code>
  </blockquote></div>
 </li>
 </ul>
 <a id="NOT_SUBMULTISET_OF">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NOT_SUBMULTISET_OF</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> NOT_SUBMULTISET_OF</pre>
 </li>
 </ul>
 <a id="DESC">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DESC</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> DESC</pre>
 </li>
 </ul>
 <a id="NULLS_FIRST">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NULLS_FIRST</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> NULLS_FIRST</pre>
 </li>
 </ul>
 <a id="NULLS_LAST">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NULLS_LAST</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> NULLS_LAST</pre>
 </li>
 </ul>
 <a id="IS_NOT_NULL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_NULL</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NOT_NULL</pre>
 </li>
 </ul>
 <a id="IS_NULL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NULL</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NULL</pre>
 </li>
 </ul>
 <a id="IS_NOT_TRUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_TRUE</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NOT_TRUE</pre>
 </li>
 </ul>
 <a id="IS_TRUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_TRUE</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_TRUE</pre>
 </li>
 </ul>
 <a id="IS_NOT_FALSE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_FALSE</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NOT_FALSE</pre>
 </li>
 </ul>
 <a id="IS_FALSE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_FALSE</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_FALSE</pre>
 </li>
 </ul>
 <a id="IS_NOT_UNKNOWN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_UNKNOWN</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NOT_UNKNOWN</pre>
 </li>
 </ul>
 <a id="IS_UNKNOWN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_UNKNOWN</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_UNKNOWN</pre>
 </li>
 </ul>
 <a id="IS_A_SET">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_A_SET</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_A_SET</pre>
 </li>
 </ul>
 <a id="IS_NOT_A_SET">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_A_SET</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NOT_A_SET</pre>
 </li>
 </ul>
 <a id="IS_EMPTY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_EMPTY</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_EMPTY</pre>
 </li>
 </ul>
 <a id="IS_NOT_EMPTY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_EMPTY</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NOT_EMPTY</pre>
 </li>
 </ul>
 <a id="IS_JSON_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_JSON_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_JSON_VALUE</pre>
 </li>
 </ul>
 <a id="IS_NOT_JSON_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_JSON_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NOT_JSON_VALUE</pre>
 </li>
 </ul>
 <a id="IS_JSON_OBJECT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_JSON_OBJECT</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_JSON_OBJECT</pre>
 </li>
 </ul>
 <a id="IS_NOT_JSON_OBJECT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_JSON_OBJECT</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NOT_JSON_OBJECT</pre>
 </li>
 </ul>
 <a id="IS_JSON_ARRAY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_JSON_ARRAY</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_JSON_ARRAY</pre>
 </li>
 </ul>
 <a id="IS_NOT_JSON_ARRAY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_JSON_ARRAY</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NOT_JSON_ARRAY</pre>
 </li>
 </ul>
 <a id="IS_JSON_SCALAR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_JSON_SCALAR</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_JSON_SCALAR</pre>
 </li>
 </ul>
 <a id="IS_NOT_JSON_SCALAR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IS_NOT_JSON_SCALAR</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> IS_NOT_JSON_SCALAR</pre>
 </li>
 </ul>
 <a id="JSON_VALUE_EXPRESSION">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_VALUE_EXPRESSION</h4>
 <pre>public static final&nbsp;<a href="../SqlPostfixOperator.html" title="class in org.apache.calcite.sql">SqlPostfixOperator</a> JSON_VALUE_EXPRESSION</pre>
 </li>
 </ul>
 <a id="EXISTS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>EXISTS</h4>
 <pre>public static final&nbsp;<a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a> EXISTS</pre>
 </li>
 </ul>
 <a id="NOT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NOT</h4>
 <pre>public static final&nbsp;<a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a> NOT</pre>
 </li>
 </ul>
 <a id="UNARY_MINUS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>UNARY_MINUS</h4>
 <pre>public static final&nbsp;<a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a> UNARY_MINUS</pre>
 <div class="block">Prefix arithmetic minus operator, '<code>-</code>'.

  <p>Its precedence is greater than the infix '<a href="#PLUS"><code>+</code></a>' and
  '<a href="#MINUS"><code>-</code></a>' operators.</div>
 </li>
 </ul>
 <a id="UNARY_PLUS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>UNARY_PLUS</h4>
 <pre>public static final&nbsp;<a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a> UNARY_PLUS</pre>
 <div class="block">Prefix arithmetic plus operator, '<code>+</code>'.

  <p>Its precedence is greater than the infix '<a href="#PLUS"><code>+</code></a>' and
  '<a href="#MINUS"><code>-</code></a>' operators.</div>
 </li>
 </ul>
 <a id="EXPLICIT_TABLE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>EXPLICIT_TABLE</h4>
 <pre>public static final&nbsp;<a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a> EXPLICIT_TABLE</pre>
 <div class="block">Keyword which allows an identifier to be explicitly flagged as a table.
  For example, <code>select * from (TABLE t)</code> or <code>TABLE
  t</code>. See also <a href="#COLLECTION_TABLE"><code>COLLECTION_TABLE</code></a>.</div>
 </li>
 </ul>
 <a id="FINAL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>FINAL</h4>
 <pre>public static final&nbsp;<a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a> FINAL</pre>
 <div class="block"><code>FINAL</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </li>
 </ul>
 <a id="RUNNING">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>RUNNING</h4>
 <pre>public static final&nbsp;<a href="../SqlPrefixOperator.html" title="class in org.apache.calcite.sql">SqlPrefixOperator</a> RUNNING</pre>
 <div class="block"><code>RUNNING</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </li>
 </ul>
 <a id="SUM">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SUM</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> SUM</pre>
 <div class="block"><code>SUM</code> aggregate function.</div>
 </li>
 </ul>
 <a id="COUNT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>COUNT</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> COUNT</pre>
 <div class="block"><code>COUNT</code> aggregate function.</div>
 </li>
 </ul>
 <a id="APPROX_COUNT_DISTINCT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>APPROX_COUNT_DISTINCT</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> APPROX_COUNT_DISTINCT</pre>
 <div class="block"><code>APPROX_COUNT_DISTINCT</code> aggregate function.</div>
 </li>
 </ul>
 <a id="MIN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MIN</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> MIN</pre>
 <div class="block"><code>MIN</code> aggregate function.</div>
 </li>
 </ul>
 <a id="MAX">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MAX</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> MAX</pre>
 <div class="block"><code>MAX</code> aggregate function.</div>
 </li>
 </ul>
 <a id="LAST_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LAST_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> LAST_VALUE</pre>
 <div class="block"><code>LAST_VALUE</code> aggregate function.</div>
 </li>
 </ul>
 <a id="ANY_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ANY_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> ANY_VALUE</pre>
 <div class="block"><code>ANY_VALUE</code> aggregate function.</div>
 </li>
 </ul>
 <a id="FIRST_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>FIRST_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> FIRST_VALUE</pre>
 <div class="block"><code>FIRST_VALUE</code> aggregate function.</div>
 </li>
 </ul>
 <a id="NTH_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NTH_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> NTH_VALUE</pre>
 <div class="block"><code>NTH_VALUE</code> aggregate function.</div>
 </li>
 </ul>
 <a id="LEAD">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LEAD</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> LEAD</pre>
 <div class="block"><code>LEAD</code> aggregate function.</div>
 </li>
 </ul>
 <a id="LAG">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LAG</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> LAG</pre>
 <div class="block"><code>LAG</code> aggregate function.</div>
 </li>
 </ul>
 <a id="NTILE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NTILE</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> NTILE</pre>
 <div class="block"><code>NTILE</code> aggregate function.</div>
 </li>
 </ul>
 <a id="SINGLE_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SINGLE_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> SINGLE_VALUE</pre>
 <div class="block"><code>SINGLE_VALUE</code> aggregate function.</div>
 </li>
 </ul>
 <a id="AVG">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>AVG</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> AVG</pre>
 <div class="block"><code>AVG</code> aggregate function.</div>
 </li>
 </ul>
 <a id="STDDEV_POP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>STDDEV_POP</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> STDDEV_POP</pre>
 <div class="block"><code>STDDEV_POP</code> aggregate function.</div>
 </li>
 </ul>
 <a id="REGR_COUNT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>REGR_COUNT</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> REGR_COUNT</pre>
 <div class="block"><code>REGR_COUNT</code> aggregate function.</div>
 </li>
 </ul>
 <a id="REGR_SXX">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>REGR_SXX</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> REGR_SXX</pre>
 <div class="block"><code>REGR_SXX</code> aggregate function.</div>
 </li>
 </ul>
 <a id="REGR_SYY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>REGR_SYY</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> REGR_SYY</pre>
 <div class="block"><code>REGR_SYY</code> aggregate function.</div>
 </li>
 </ul>
 <a id="COVAR_POP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>COVAR_POP</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> COVAR_POP</pre>
 <div class="block"><code>COVAR_POP</code> aggregate function.</div>
 </li>
 </ul>
 <a id="COVAR_SAMP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>COVAR_SAMP</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> COVAR_SAMP</pre>
 <div class="block"><code>COVAR_SAMP</code> aggregate function.</div>
 </li>
 </ul>
 <a id="STDDEV_SAMP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>STDDEV_SAMP</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> STDDEV_SAMP</pre>
 <div class="block"><code>STDDEV_SAMP</code> aggregate function.</div>
 </li>
 </ul>
 <a id="STDDEV">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>STDDEV</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> STDDEV</pre>
 <div class="block"><code>STDDEV</code> aggregate function.</div>
 </li>
 </ul>
 <a id="VAR_POP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>VAR_POP</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> VAR_POP</pre>
 <div class="block"><code>VAR_POP</code> aggregate function.</div>
 </li>
 </ul>
 <a id="VAR_SAMP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>VAR_SAMP</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> VAR_SAMP</pre>
 <div class="block"><code>VAR_SAMP</code> aggregate function.</div>
 </li>
 </ul>
 <a id="VARIANCE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>VARIANCE</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> VARIANCE</pre>
 <div class="block"><code>VARIANCE</code> aggregate function.</div>
 </li>
 </ul>
 <a id="BIT_AND">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>BIT_AND</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> BIT_AND</pre>
 <div class="block"><code>BIT_AND</code> aggregate function.</div>
 </li>
 </ul>
 <a id="BIT_OR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>BIT_OR</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> BIT_OR</pre>
 <div class="block"><code>BIT_OR</code> aggregate function.</div>
 </li>
 </ul>
 <a id="HISTOGRAM_AGG">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>HISTOGRAM_AGG</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> HISTOGRAM_AGG</pre>
 <div class="block"><code>HISTOGRAM</code> aggregate function support. Used by window
  aggregate versions of MIN/MAX</div>
 </li>
 </ul>
 <a id="HISTOGRAM_MIN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>HISTOGRAM_MIN</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> HISTOGRAM_MIN</pre>
 <div class="block"><code>HISTOGRAM_MIN</code> window aggregate function.</div>
 </li>
 </ul>
 <a id="HISTOGRAM_MAX">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>HISTOGRAM_MAX</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> HISTOGRAM_MAX</pre>
 <div class="block"><code>HISTOGRAM_MAX</code> window aggregate function.</div>
 </li>
 </ul>
 <a id="HISTOGRAM_FIRST_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>HISTOGRAM_FIRST_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> HISTOGRAM_FIRST_VALUE</pre>
 <div class="block"><code>HISTOGRAM_FIRST_VALUE</code> window aggregate function.</div>
 </li>
 </ul>
 <a id="HISTOGRAM_LAST_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>HISTOGRAM_LAST_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> HISTOGRAM_LAST_VALUE</pre>
 <div class="block"><code>HISTOGRAM_LAST_VALUE</code> window aggregate function.</div>
 </li>
 </ul>
 <a id="SUM0">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SUM0</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> SUM0</pre>
 <div class="block"><code>SUM0</code> aggregate function.</div>
 </li>
 </ul>
 <a id="CUME_DIST">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CUME_DIST</h4>
 <pre>public static final&nbsp;<a href="../SqlRankFunction.html" title="class in org.apache.calcite.sql">SqlRankFunction</a> CUME_DIST</pre>
 <div class="block"><code>CUME_DIST</code> window function.</div>
 </li>
 </ul>
 <a id="DENSE_RANK">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DENSE_RANK</h4>
 <pre>public static final&nbsp;<a href="../SqlRankFunction.html" title="class in org.apache.calcite.sql">SqlRankFunction</a> DENSE_RANK</pre>
 <div class="block"><code>DENSE_RANK</code> window function.</div>
 </li>
 </ul>
 <a id="PERCENT_RANK">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PERCENT_RANK</h4>
 <pre>public static final&nbsp;<a href="../SqlRankFunction.html" title="class in org.apache.calcite.sql">SqlRankFunction</a> PERCENT_RANK</pre>
 <div class="block"><code>PERCENT_RANK</code> window function.</div>
 </li>
 </ul>
 <a id="RANK">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>RANK</h4>
 <pre>public static final&nbsp;<a href="../SqlRankFunction.html" title="class in org.apache.calcite.sql">SqlRankFunction</a> RANK</pre>
 <div class="block"><code>RANK</code> window function.</div>
 </li>
 </ul>
 <a id="ROW_NUMBER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ROW_NUMBER</h4>
 <pre>public static final&nbsp;<a href="../SqlRankFunction.html" title="class in org.apache.calcite.sql">SqlRankFunction</a> ROW_NUMBER</pre>
 <div class="block"><code>ROW_NUMBER</code> window function.</div>
 </li>
 </ul>
 <a id="ROW">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ROW</h4>
 <pre>public static final&nbsp;<a href="SqlRowOperator.html" title="class in org.apache.calcite.sql.fun">SqlRowOperator</a> ROW</pre>
 </li>
 </ul>
 <a id="IGNORE_NULLS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IGNORE_NULLS</h4>
 <pre>public static final&nbsp;<a href="../SqlNullTreatmentOperator.html" title="class in org.apache.calcite.sql">SqlNullTreatmentOperator</a> IGNORE_NULLS</pre>
 <div class="block"><code>IGNORE NULLS</code> operator.</div>
 </li>
 </ul>
 <a id="RESPECT_NULLS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>RESPECT_NULLS</h4>
 <pre>public static final&nbsp;<a href="../SqlNullTreatmentOperator.html" title="class in org.apache.calcite.sql">SqlNullTreatmentOperator</a> RESPECT_NULLS</pre>
 <div class="block"><code>RESPECT NULLS</code> operator.</div>
 </li>
 </ul>
 <a id="MINUS_DATE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MINUS_DATE</h4>
 <pre>public static final&nbsp;<a href="SqlDatetimeSubtractionOperator.html" title="class in org.apache.calcite.sql.fun">SqlDatetimeSubtractionOperator</a> MINUS_DATE</pre>
 <div class="block">A special operator for the subtraction of two DATETIMEs. The format of
  DATETIME subtraction is:

  <blockquote><code>"(" &lt;datetime&gt; "-" &lt;datetime&gt; ")"
  &lt;interval qualifier&gt;</code></blockquote>

  <p>This operator is special since it needs to hold the
  additional interval qualifier specification.</p></div>
 </li>
 </ul>
 <a id="MULTISET_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MULTISET_VALUE</h4>
 <pre>public static final&nbsp;<a href="SqlMultisetValueConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMultisetValueConstructor</a> MULTISET_VALUE</pre>
 <div class="block">The MULTISET Value Constructor. e.g. "<code>MULTISET[1,2,3]</code>".</div>
 </li>
 </ul>
 <a id="MULTISET_QUERY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MULTISET_QUERY</h4>
 <pre>public static final&nbsp;<a href="SqlMultisetQueryConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMultisetQueryConstructor</a> MULTISET_QUERY</pre>
 <div class="block">The MULTISET Query Constructor. e.g. "<code>SELECT dname, MULTISET(SELECT
  FROM emp WHERE deptno = dept.deptno) FROM dept</code>".</div>
 </li>
 </ul>
 <a id="ARRAY_QUERY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ARRAY_QUERY</h4>
 <pre>public static final&nbsp;<a href="SqlMultisetQueryConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMultisetQueryConstructor</a> ARRAY_QUERY</pre>
 <div class="block">The ARRAY Query Constructor. e.g. "<code>SELECT dname, ARRAY(SELECT
  FROM emp WHERE deptno = dept.deptno) FROM dept</code>".</div>
 </li>
 </ul>
 <a id="MAP_QUERY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MAP_QUERY</h4>
 <pre>public static final&nbsp;<a href="SqlMultisetQueryConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMultisetQueryConstructor</a> MAP_QUERY</pre>
 <div class="block">The MAP Query Constructor. e.g. "<code>MAP(SELECT empno, deptno
  FROM emp)</code>".</div>
 </li>
 </ul>
 <a id="CURSOR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CURSOR</h4>
 <pre>public static final&nbsp;<a href="SqlCursorConstructor.html" title="class in org.apache.calcite.sql.fun">SqlCursorConstructor</a> CURSOR</pre>
 <div class="block">The CURSOR constructor. e.g. "<code>SELECT * FROM
  TABLE(DEDUP(CURSOR(SELECT * FROM EMPS), 'name'))</code>".</div>
 </li>
 </ul>
 <a id="COLUMN_LIST">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>COLUMN_LIST</h4>
 <pre>public static final&nbsp;<a href="SqlColumnListConstructor.html" title="class in org.apache.calcite.sql.fun">SqlColumnListConstructor</a> COLUMN_LIST</pre>
 <div class="block">The COLUMN_LIST constructor. e.g. the ROW() call in "<code>SELECT * FROM
  TABLE(DEDUP(CURSOR(SELECT * FROM EMPS), ROW(name, empno)))</code>".</div>
 </li>
 </ul>
 <a id="UNNEST">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>UNNEST</h4>
 <pre>public static final&nbsp;<a href="../SqlUnnestOperator.html" title="class in org.apache.calcite.sql">SqlUnnestOperator</a> UNNEST</pre>
 <div class="block">The <code>UNNEST</code> operator.</div>
 </li>
 </ul>
 <a id="UNNEST_WITH_ORDINALITY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>UNNEST_WITH_ORDINALITY</h4>
 <pre>public static final&nbsp;<a href="../SqlUnnestOperator.html" title="class in org.apache.calcite.sql">SqlUnnestOperator</a> UNNEST_WITH_ORDINALITY</pre>
 <div class="block">The <code>UNNEST WITH ORDINALITY</code> operator.</div>
 </li>
 </ul>
 <a id="LATERAL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LATERAL</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> LATERAL</pre>
 <div class="block">The <code>LATERAL</code> operator.</div>
 </li>
 </ul>
 <a id="COLLECTION_TABLE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>COLLECTION_TABLE</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> COLLECTION_TABLE</pre>
 <div class="block">The "table function derived table" operator, which a table-valued
  function into a relation, e.g. "<code>SELECT * FROM
  TABLE(ramp(5))</code>".

  <p>This operator has function syntax (with one argument), whereas
  <a href="#EXPLICIT_TABLE"><code>EXPLICIT_TABLE</code></a> is a prefix operator.</div>
 </li>
 </ul>
 <a id="OVERLAPS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>OVERLAPS</h4>
 <pre>public static final&nbsp;<a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a> OVERLAPS</pre>
 </li>
 </ul>
 <a id="CONTAINS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CONTAINS</h4>
 <pre>public static final&nbsp;<a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a> CONTAINS</pre>
 </li>
 </ul>
 <a id="PRECEDES">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PRECEDES</h4>
 <pre>public static final&nbsp;<a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a> PRECEDES</pre>
 </li>
 </ul>
 <a id="IMMEDIATELY_PRECEDES">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IMMEDIATELY_PRECEDES</h4>
 <pre>public static final&nbsp;<a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a> IMMEDIATELY_PRECEDES</pre>
 </li>
 </ul>
 <a id="SUCCEEDS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SUCCEEDS</h4>
 <pre>public static final&nbsp;<a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a> SUCCEEDS</pre>
 </li>
 </ul>
 <a id="IMMEDIATELY_SUCCEEDS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IMMEDIATELY_SUCCEEDS</h4>
 <pre>public static final&nbsp;<a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a> IMMEDIATELY_SUCCEEDS</pre>
 </li>
 </ul>
 <a id="PERIOD_EQUALS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PERIOD_EQUALS</h4>
 <pre>public static final&nbsp;<a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a> PERIOD_EQUALS</pre>
 </li>
 </ul>
 <a id="VALUES">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>VALUES</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> VALUES</pre>
 </li>
 </ul>
 <a id="LITERAL_CHAIN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LITERAL_CHAIN</h4>
 <pre>public static final&nbsp;<a href="SqlLiteralChainOperator.html" title="class in org.apache.calcite.sql.fun">SqlLiteralChainOperator</a> LITERAL_CHAIN</pre>
 </li>
 </ul>
 <a id="THROW">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>THROW</h4>
 <pre>public static final&nbsp;<a href="SqlThrowOperator.html" title="class in org.apache.calcite.sql.fun">SqlThrowOperator</a> THROW</pre>
 </li>
 </ul>
 <a id="JSON_EXISTS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_EXISTS</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_EXISTS</pre>
 </li>
 </ul>
 <a id="JSON_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_VALUE</pre>
 </li>
 </ul>
 <a id="JSON_VALUE_ANY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_VALUE_ANY</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_VALUE_ANY</pre>
 </li>
 </ul>
 <a id="JSON_QUERY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_QUERY</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_QUERY</pre>
 </li>
 </ul>
 <a id="JSON_OBJECT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_OBJECT</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_OBJECT</pre>
 </li>
 </ul>
 <a id="JSON_OBJECTAGG">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_OBJECTAGG</h4>
 <pre>public static final&nbsp;<a href="SqlJsonObjectAggAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonObjectAggAggFunction</a> JSON_OBJECTAGG</pre>
 </li>
 </ul>
 <a id="JSON_ARRAY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_ARRAY</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_ARRAY</pre>
 </li>
 </ul>
 <a id="JSON_TYPE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_TYPE</h4>
 <pre>@Deprecated
 public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_TYPE</pre>
 <div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span></div>
 </li>
 </ul>
 <a id="JSON_DEPTH">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_DEPTH</h4>
 <pre>@Deprecated
 public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_DEPTH</pre>
 <div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span></div>
 </li>
 </ul>
 <a id="JSON_LENGTH">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_LENGTH</h4>
 <pre>@Deprecated
 public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_LENGTH</pre>
 <div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span></div>
 </li>
 </ul>
 <a id="JSON_KEYS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_KEYS</h4>
 <pre>@Deprecated
 public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_KEYS</pre>
 <div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span></div>
 </li>
 </ul>
 <a id="JSON_PRETTY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_PRETTY</h4>
 <pre>@Deprecated
 public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_PRETTY</pre>
 <div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span></div>
 </li>
 </ul>
 <a id="JSON_REMOVE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_REMOVE</h4>
 <pre>@Deprecated
 public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_REMOVE</pre>
 <div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span></div>
 </li>
 </ul>
 <a id="JSON_STORAGE_SIZE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_STORAGE_SIZE</h4>
 <pre>@Deprecated
 public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_STORAGE_SIZE</pre>
 <div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span></div>
 </li>
 </ul>
 <a id="JSON_ARRAYAGG">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>JSON_ARRAYAGG</h4>
 <pre>public static final&nbsp;<a href="SqlJsonArrayAggAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonArrayAggAggFunction</a> JSON_ARRAYAGG</pre>
 </li>
 </ul>
 <a id="BETWEEN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>BETWEEN</h4>
 <pre>public static final&nbsp;<a href="SqlBetweenOperator.html" title="class in org.apache.calcite.sql.fun">SqlBetweenOperator</a> BETWEEN</pre>
 </li>
 </ul>
 <a id="SYMMETRIC_BETWEEN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SYMMETRIC_BETWEEN</h4>
 <pre>public static final&nbsp;<a href="SqlBetweenOperator.html" title="class in org.apache.calcite.sql.fun">SqlBetweenOperator</a> SYMMETRIC_BETWEEN</pre>
 </li>
 </ul>
 <a id="NOT_BETWEEN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NOT_BETWEEN</h4>
 <pre>public static final&nbsp;<a href="SqlBetweenOperator.html" title="class in org.apache.calcite.sql.fun">SqlBetweenOperator</a> NOT_BETWEEN</pre>
 </li>
 </ul>
 <a id="SYMMETRIC_NOT_BETWEEN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SYMMETRIC_NOT_BETWEEN</h4>
 <pre>public static final&nbsp;<a href="SqlBetweenOperator.html" title="class in org.apache.calcite.sql.fun">SqlBetweenOperator</a> SYMMETRIC_NOT_BETWEEN</pre>
 </li>
 </ul>
 <a id="NOT_LIKE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NOT_LIKE</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> NOT_LIKE</pre>
 </li>
 </ul>
 <a id="LIKE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LIKE</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> LIKE</pre>
 </li>
 </ul>
 <a id="NOT_SIMILAR_TO">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NOT_SIMILAR_TO</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> NOT_SIMILAR_TO</pre>
 </li>
 </ul>
 <a id="SIMILAR_TO">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SIMILAR_TO</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> SIMILAR_TO</pre>
 </li>
 </ul>
 <a id="POSIX_REGEX_CASE_SENSITIVE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>POSIX_REGEX_CASE_SENSITIVE</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> POSIX_REGEX_CASE_SENSITIVE</pre>
 </li>
 </ul>
 <a id="POSIX_REGEX_CASE_INSENSITIVE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>POSIX_REGEX_CASE_INSENSITIVE</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> POSIX_REGEX_CASE_INSENSITIVE</pre>
 </li>
 </ul>
 <a id="NEGATED_POSIX_REGEX_CASE_SENSITIVE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NEGATED_POSIX_REGEX_CASE_SENSITIVE</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> NEGATED_POSIX_REGEX_CASE_SENSITIVE</pre>
 </li>
 </ul>
 <a id="NEGATED_POSIX_REGEX_CASE_INSENSITIVE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NEGATED_POSIX_REGEX_CASE_INSENSITIVE</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> NEGATED_POSIX_REGEX_CASE_INSENSITIVE</pre>
 </li>
 </ul>
 <a id="ESCAPE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ESCAPE</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> ESCAPE</pre>
 <div class="block">Internal operator used to represent the ESCAPE clause of a LIKE or
  SIMILAR TO expression.</div>
 </li>
 </ul>
 <a id="CASE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CASE</h4>
 <pre>public static final&nbsp;<a href="SqlCaseOperator.html" title="class in org.apache.calcite.sql.fun">SqlCaseOperator</a> CASE</pre>
 </li>
 </ul>
 <a id="PROCEDURE_CALL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PROCEDURE_CALL</h4>
 <pre>public static final&nbsp;<a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a> PROCEDURE_CALL</pre>
 </li>
 </ul>
 <a id="NEW">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NEW</h4>
 <pre>public static final&nbsp;<a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a> NEW</pre>
 </li>
 </ul>
 <a id="OVER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>OVER</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> OVER</pre>
 <div class="block">The <code>OVER</code> operator, which applies an aggregate functions to a
  <a href="../SqlWindow.html" title="class in org.apache.calcite.sql"><code>window</code></a>.

  <p>Operands are as follows:

  <ol>
  <li>name of window function (<a href="../SqlCall.html" title="class in org.apache.calcite.sql"><code>SqlCall</code></a>)</li>
  <li>window name (<a href="../SqlLiteral.html" title="class in org.apache.calcite.sql"><code>SqlLiteral</code></a>) or window
  in-line specification (@link SqlWindowOperator})</li>
  </ol></div>
 </li>
 </ul>
 <a id="REINTERPRET">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>REINTERPRET</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> REINTERPRET</pre>
 <div class="block">An <code>REINTERPRET</code> operator is internal to the planner. When the
  physical storage of two types is the same, this operator may be used to
  reinterpret values of one type as the other. This operator is similar to
  a cast, except that it does not alter the data value. Like a regular cast
  it accepts one operand and stores the target type as the return type. It
  performs an overflow check if it has <i>any</i> second operand, whether
  true or not.</div>
 </li>
 </ul>
 <a id="SUBSTRING">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SUBSTRING</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SUBSTRING</pre>
 <div class="block">The character substring function: <code>SUBSTRING(string FROM start [FOR
  length])</code>.

  <p>If the length parameter is a constant, the length of the result is the
  minimum of the length of the input and that length. Otherwise it is the
  length of the input.</div>
 </li>
 </ul>
 <a id="REPLACE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>REPLACE</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> REPLACE</pre>
 <div class="block">The <code>REPLACE(string, search, replace)</code> function. Not standard SQL,
  but in Oracle and Postgres.</div>
 </li>
 </ul>
 <a id="CONVERT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CONVERT</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CONVERT</pre>
 </li>
 </ul>
 <a id="TRANSLATE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>TRANSLATE</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TRANSLATE</pre>
 <div class="block">The <code>TRANSLATE(<i>char_value</i> USING <i>translation_name</i>)</code> function
  alters the character set of a string value from one base character set to another.

  <p>It is defined in the SQL standard. See also the non-standard
  <a href="SqlLibraryOperators.html#TRANSLATE3"><code>SqlLibraryOperators.TRANSLATE3</code></a>, which has a different purpose.</div>
 </li>
 </ul>
 <a id="OVERLAY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>OVERLAY</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> OVERLAY</pre>
 </li>
 </ul>
 <a id="TRIM">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>TRIM</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TRIM</pre>
 <div class="block">The "TRIM" function.</div>
 </li>
 </ul>
 <a id="POSITION">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>POSITION</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> POSITION</pre>
 </li>
 </ul>
 <a id="CHAR_LENGTH">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CHAR_LENGTH</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CHAR_LENGTH</pre>
 </li>
 </ul>
 <a id="CHARACTER_LENGTH">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CHARACTER_LENGTH</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CHARACTER_LENGTH</pre>
 </li>
 </ul>
 <a id="UPPER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>UPPER</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> UPPER</pre>
 </li>
 </ul>
 <a id="LOWER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LOWER</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> LOWER</pre>
 </li>
 </ul>
 <a id="INITCAP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>INITCAP</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> INITCAP</pre>
 </li>
 </ul>
 <a id="ASCII">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ASCII</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> ASCII</pre>
 </li>
 </ul>
 <a id="POWER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>POWER</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> POWER</pre>
 <div class="block">Uses SqlOperatorTable.useDouble for its return type since we don't know
  what the result type will be by just looking at the operand types. For
  example POW(int, int) can return a non integer if the second operand is
  negative.</div>
 </li>
 </ul>
 <a id="SQRT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SQRT</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SQRT</pre>
 </li>
 </ul>
 <a id="MOD">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MOD</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> MOD</pre>
 <div class="block">Arithmetic remainder function <code>MOD</code>.</div>
 <dl>
 <dt><span class="seeLabel">See Also:</span></dt>
 <dd><a href="#PERCENT_REMAINDER"><code>PERCENT_REMAINDER</code></a></dd>
 </dl>
 </li>
 </ul>
 <a id="LN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LN</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> LN</pre>
 </li>
 </ul>
 <a id="LOG10">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LOG10</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> LOG10</pre>
 </li>
 </ul>
 <a id="ABS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ABS</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> ABS</pre>
 </li>
 </ul>
 <a id="ACOS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ACOS</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> ACOS</pre>
 </li>
 </ul>
 <a id="ASIN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ASIN</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> ASIN</pre>
 </li>
 </ul>
 <a id="ATAN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ATAN</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> ATAN</pre>
 </li>
 </ul>
 <a id="ATAN2">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ATAN2</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> ATAN2</pre>
 </li>
 </ul>
 <a id="COS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>COS</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> COS</pre>
 </li>
 </ul>
 <a id="COT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>COT</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> COT</pre>
 </li>
 </ul>
 <a id="DEGREES">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DEGREES</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> DEGREES</pre>
 </li>
 </ul>
 <a id="EXP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>EXP</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> EXP</pre>
 </li>
 </ul>
 <a id="RADIANS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>RADIANS</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> RADIANS</pre>
 </li>
 </ul>
 <a id="ROUND">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ROUND</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> ROUND</pre>
 </li>
 </ul>
 <a id="SIGN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SIGN</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SIGN</pre>
 </li>
 </ul>
 <a id="SIN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SIN</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SIN</pre>
 </li>
 </ul>
 <a id="TAN">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>TAN</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TAN</pre>
 </li>
 </ul>
 <a id="TRUNCATE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>TRUNCATE</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TRUNCATE</pre>
 </li>
 </ul>
 <a id="PI">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PI</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> PI</pre>
 </li>
 </ul>
 <a id="FIRST">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>FIRST</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> FIRST</pre>
 <div class="block"><code>FIRST</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </li>
 </ul>
 <a id="LAST">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LAST</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> LAST</pre>
 <div class="block"><code>LAST</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </li>
 </ul>
 <a id="PREV">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PREV</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> PREV</pre>
 <div class="block"><code>PREV</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </li>
 </ul>
 <a id="NEXT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NEXT</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> NEXT</pre>
 <div class="block"><code>NEXT</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </li>
 </ul>
 <a id="CLASSIFIER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CLASSIFIER</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CLASSIFIER</pre>
 <div class="block"><code>CLASSIFIER</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </li>
 </ul>
 <a id="MATCH_NUMBER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MATCH_NUMBER</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> MATCH_NUMBER</pre>
 <div class="block"><code>MATCH_NUMBER</code> function to be used within <code>MATCH_RECOGNIZE</code>.</div>
 </li>
 </ul>
 <a id="NULLIF">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NULLIF</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> NULLIF</pre>
 </li>
 </ul>
 <a id="COALESCE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>COALESCE</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> COALESCE</pre>
 <div class="block">The COALESCE builtin function.</div>
 </li>
 </ul>
 <a id="FLOOR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>FLOOR</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> FLOOR</pre>
 <div class="block">The <code>FLOOR</code> function.</div>
 </li>
 </ul>
 <a id="CEIL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CEIL</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CEIL</pre>
 <div class="block">The <code>CEIL</code> function.</div>
 </li>
 </ul>
 <a id="USER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>USER</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> USER</pre>
 <div class="block">The <code>USER</code> function.</div>
 </li>
 </ul>
 <a id="CURRENT_USER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CURRENT_USER</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CURRENT_USER</pre>
 <div class="block">The <code>CURRENT_USER</code> function.</div>
 </li>
 </ul>
 <a id="SESSION_USER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SESSION_USER</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SESSION_USER</pre>
 <div class="block">The <code>SESSION_USER</code> function.</div>
 </li>
 </ul>
 <a id="SYSTEM_USER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SYSTEM_USER</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SYSTEM_USER</pre>
 <div class="block">The <code>SYSTEM_USER</code> function.</div>
 </li>
 </ul>
 <a id="CURRENT_PATH">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CURRENT_PATH</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CURRENT_PATH</pre>
 <div class="block">The <code>CURRENT_PATH</code> function.</div>
 </li>
 </ul>
 <a id="CURRENT_ROLE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CURRENT_ROLE</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CURRENT_ROLE</pre>
 <div class="block">The <code>CURRENT_ROLE</code> function.</div>
 </li>
 </ul>
 <a id="CURRENT_CATALOG">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CURRENT_CATALOG</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CURRENT_CATALOG</pre>
 <div class="block">The <code>CURRENT_CATALOG</code> function.</div>
 </li>
 </ul>
 <a id="CURRENT_SCHEMA">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CURRENT_SCHEMA</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CURRENT_SCHEMA</pre>
 <div class="block">The <code>CURRENT_SCHEMA</code> function.</div>
 </li>
 </ul>
 <a id="LOCALTIME">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LOCALTIME</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> LOCALTIME</pre>
 <div class="block">The <code>LOCALTIME [(<i>precision</i>)]</code> function.</div>
 </li>
 </ul>
 <a id="LOCALTIMESTAMP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LOCALTIMESTAMP</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> LOCALTIMESTAMP</pre>
 <div class="block">The <code>LOCALTIMESTAMP [(<i>precision</i>)]</code> function.</div>
 </li>
 </ul>
 <a id="CURRENT_TIME">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CURRENT_TIME</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CURRENT_TIME</pre>
 <div class="block">The <code>CURRENT_TIME [(<i>precision</i>)]</code> function.</div>
 </li>
 </ul>
 <a id="CURRENT_TIMESTAMP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CURRENT_TIMESTAMP</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CURRENT_TIMESTAMP</pre>
 <div class="block">The <code>CURRENT_TIMESTAMP [(<i>precision</i>)]</code> function.</div>
 </li>
 </ul>
 <a id="CURRENT_DATE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CURRENT_DATE</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CURRENT_DATE</pre>
 <div class="block">The <code>CURRENT_DATE</code> function.</div>
 </li>
 </ul>
 <a id="TIMESTAMP_ADD">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>TIMESTAMP_ADD</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TIMESTAMP_ADD</pre>
 <div class="block">The <code>TIMESTAMPADD</code> function.</div>
 </li>
 </ul>
 <a id="TIMESTAMP_DIFF">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>TIMESTAMP_DIFF</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TIMESTAMP_DIFF</pre>
 <div class="block">The <code>TIMESTAMPDIFF</code> function.</div>
 </li>
 </ul>
 <a id="IN_FENNEL">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>IN_FENNEL</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> IN_FENNEL</pre>
 <div class="block">Use of the <code>IN_FENNEL</code> operator forces the argument to be
  evaluated in Fennel. Otherwise acts as identity function.</div>
 </li>
 </ul>
 <a id="CAST">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CAST</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CAST</pre>
 <div class="block">The SQL <code>CAST</code> operator.

  <p>The SQL syntax is

  <blockquote><code>CAST(<i>expression</i> AS <i>type</i>)</code>
  </blockquote>

  <p>When the CAST operator is applies as a <a href="../SqlCall.html" title="class in org.apache.calcite.sql"><code>SqlCall</code></a>, it has two
  arguments: the expression and the type. The type must not include a
  constraint, so <code>CAST(x AS INTEGER NOT NULL)</code>, for instance, is
  invalid.</p>

  <p>When the CAST operator is applied as a <code>RexCall</code>, the
  target type is simply stored as the return type, not an explicit operand.
  For example, the expression <code>CAST(1 + 2 AS DOUBLE)</code> will
  become a call to <code>CAST</code> with the expression <code>1 + 2</code>
  as its only operand.</p>

  <p>The <code>RexCall</code> form can also have a type which contains a
  <code>NOT NULL</code> constraint. When this expression is implemented, if
  the value is NULL, an exception will be thrown.</p></div>
 </li>
 </ul>
 <a id="EXTRACT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>EXTRACT</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> EXTRACT</pre>
 <div class="block">The SQL <code>EXTRACT</code> operator. Extracts a specified field value
  from a DATETIME or an INTERVAL. E.g.<br>
  <code>EXTRACT(HOUR FROM INTERVAL '364 23:59:59')</code> returns <code>
  23</code></div>
 </li>
 </ul>
 <a id="YEAR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>YEAR</h4>
 <pre>public static final&nbsp;<a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a> YEAR</pre>
 <div class="block">The SQL <code>YEAR</code> operator. Returns the Year
  from a DATETIME  E.g.<br>
  <code>YEAR(date '2008-9-23')</code> returns <code>
  2008</code></div>
 </li>
 </ul>
 <a id="QUARTER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>QUARTER</h4>
 <pre>public static final&nbsp;<a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a> QUARTER</pre>
 <div class="block">The SQL <code>QUARTER</code> operator. Returns the Quarter
  from a DATETIME  E.g.<br>
  <code>QUARTER(date '2008-9-23')</code> returns <code>
  3</code></div>
 </li>
 </ul>
 <a id="MONTH">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MONTH</h4>
 <pre>public static final&nbsp;<a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a> MONTH</pre>
 <div class="block">The SQL <code>MONTH</code> operator. Returns the Month
  from a DATETIME  E.g.<br>
  <code>MONTH(date '2008-9-23')</code> returns <code>
  9</code></div>
 </li>
 </ul>
 <a id="WEEK">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>WEEK</h4>
 <pre>public static final&nbsp;<a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a> WEEK</pre>
 <div class="block">The SQL <code>WEEK</code> operator. Returns the Week
  from a DATETIME  E.g.<br>
  <code>WEEK(date '2008-9-23')</code> returns <code>
  39</code></div>
 </li>
 </ul>
 <a id="DAYOFYEAR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DAYOFYEAR</h4>
 <pre>public static final&nbsp;<a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a> DAYOFYEAR</pre>
 <div class="block">The SQL <code>DAYOFYEAR</code> operator. Returns the DOY
  from a DATETIME  E.g.<br>
  <code>DAYOFYEAR(date '2008-9-23')</code> returns <code>
  267</code></div>
 </li>
 </ul>
 <a id="DAYOFMONTH">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DAYOFMONTH</h4>
 <pre>public static final&nbsp;<a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a> DAYOFMONTH</pre>
 <div class="block">The SQL <code>DAYOFMONTH</code> operator. Returns the Day
  from a DATETIME  E.g.<br>
  <code>DAYOFMONTH(date '2008-9-23')</code> returns <code>
  23</code></div>
 </li>
 </ul>
 <a id="DAYOFWEEK">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DAYOFWEEK</h4>
 <pre>public static final&nbsp;<a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a> DAYOFWEEK</pre>
 <div class="block">The SQL <code>DAYOFWEEK</code> operator. Returns the DOW
  from a DATETIME  E.g.<br>
  <code>DAYOFWEEK(date '2008-9-23')</code> returns <code>
  2</code></div>
 </li>
 </ul>
 <a id="HOUR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>HOUR</h4>
 <pre>public static final&nbsp;<a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a> HOUR</pre>
 <div class="block">The SQL <code>HOUR</code> operator. Returns the Hour
  from a DATETIME  E.g.<br>
  <code>HOUR(timestamp '2008-9-23 01:23:45')</code> returns <code>
  1</code></div>
 </li>
 </ul>
 <a id="MINUTE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MINUTE</h4>
 <pre>public static final&nbsp;<a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a> MINUTE</pre>
 <div class="block">The SQL <code>MINUTE</code> operator. Returns the Minute
  from a DATETIME  E.g.<br>
  <code>MINUTE(timestamp '2008-9-23 01:23:45')</code> returns <code>
  23</code></div>
 </li>
 </ul>
 <a id="SECOND">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SECOND</h4>
 <pre>public static final&nbsp;<a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a> SECOND</pre>
 <div class="block">The SQL <code>SECOND</code> operator. Returns the Second
  from a DATETIME  E.g.<br>
  <code>SECOND(timestamp '2008-9-23 01:23:45')</code> returns <code>
  45</code></div>
 </li>
 </ul>
 <a id="LAST_DAY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LAST_DAY</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> LAST_DAY</pre>
 </li>
 </ul>
 <a id="ELEMENT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ELEMENT</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> ELEMENT</pre>
 <div class="block">The ELEMENT operator, used to convert a multiset with only one item to a
  "regular" type. Example ... log(ELEMENT(MULTISET[1])) ...</div>
 </li>
 </ul>
 <a id="ITEM">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ITEM</h4>
 <pre>public static final&nbsp;<a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a> ITEM</pre>
 <div class="block">The item operator <code>[ ... ]</code>, used to access a given element of an
  array or map. For example, <code>myArray[3]</code> or <code>"myMap['foo']"</code>.

  <p>The SQL standard calls the ARRAY variant a
  &lt;array element reference&gt;. Index is 1-based. The standard says
  to raise "data exception - array element error" but we currently return
  null.</p>

  <p>MAP is not standard SQL.</p></div>
 </li>
 </ul>
 <a id="ARRAY_VALUE_CONSTRUCTOR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ARRAY_VALUE_CONSTRUCTOR</h4>
 <pre>public static final&nbsp;<a href="SqlArrayValueConstructor.html" title="class in org.apache.calcite.sql.fun">SqlArrayValueConstructor</a> ARRAY_VALUE_CONSTRUCTOR</pre>
 <div class="block">The ARRAY Value Constructor. e.g. "<code>ARRAY[1, 2, 3]</code>".</div>
 </li>
 </ul>
 <a id="MAP_VALUE_CONSTRUCTOR">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>MAP_VALUE_CONSTRUCTOR</h4>
 <pre>public static final&nbsp;<a href="SqlMapValueConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMapValueConstructor</a> MAP_VALUE_CONSTRUCTOR</pre>
 <div class="block">The MAP Value Constructor,
  e.g. "<code>MAP['washington', 1, 'obama', 44]</code>".</div>
 </li>
 </ul>
 <a id="SLICE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SLICE</h4>
 <pre>public static final&nbsp;<a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a> SLICE</pre>
 <div class="block">The internal "$SLICE" operator takes a multiset of records and returns a
  multiset of the first column of those records.

  <p>It is introduced when multisets of scalar types are created, in order
  to keep types consistent. For example, <code>MULTISET [5]</code> has type
  <code>INTEGER MULTISET</code> but is translated to an expression of type
  <code>RECORD(INTEGER EXPR$0) MULTISET</code> because in our internal
  representation of multisets, every element must be a record. Applying the
  "$SLICE" operator to this result converts the type back to an <code>
  INTEGER MULTISET</code> multiset value.

  <p><code>$SLICE</code> is often translated away when the multiset type is
  converted back to scalar values.</div>
 </li>
 </ul>
 <a id="ELEMENT_SLICE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>ELEMENT_SLICE</h4>
 <pre>public static final&nbsp;<a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a> ELEMENT_SLICE</pre>
 <div class="block">The internal "$ELEMENT_SLICE" operator returns the first field of the
  only element of a multiset.

  <p>It is introduced when multisets of scalar types are created, in order
  to keep types consistent. For example, <code>ELEMENT(MULTISET [5])</code>
  is translated to <code>$ELEMENT_SLICE(MULTISET (VALUES ROW (5
  EXPR$0))</code> It is translated away when the multiset type is converted
  back to scalar values.</p>

  <p>NOTE: jhyde, 2006/1/9: Usages of this operator are commented out, but
  I'm not deleting the operator, because some multiset tests are disabled,
  and we may need this operator to get them working!</p></div>
 </li>
 </ul>
 <a id="SCALAR_QUERY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SCALAR_QUERY</h4>
 <pre>public static final&nbsp;<a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a> SCALAR_QUERY</pre>
 <div class="block">The internal "$SCALAR_QUERY" operator returns a scalar value from a
  record type. It assumes the record type only has one field, and returns
  that field as the output.</div>
 </li>
 </ul>
 <a id="STRUCT_ACCESS">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>STRUCT_ACCESS</h4>
 <pre>public static final&nbsp;<a href="../SqlInternalOperator.html" title="class in org.apache.calcite.sql">SqlInternalOperator</a> STRUCT_ACCESS</pre>
 <div class="block">The internal <code>$STRUCT_ACCESS</code> operator is used to access a
  field of a record.

  <p>In contrast with <a href="#DOT"><code>DOT</code></a> operator, it never appears in an
  <a href="../SqlNode.html" title="class in org.apache.calcite.sql"><code>SqlNode</code></a> tree and allows to access fields by position and
  not by name.</div>
 </li>
 </ul>
 <a id="CARDINALITY">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CARDINALITY</h4>
 <pre>public static final&nbsp;<a href="../SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CARDINALITY</pre>
 <div class="block">The CARDINALITY operator, used to retrieve the number of elements in a
  MULTISET, ARRAY or MAP.</div>
 </li>
 </ul>
 <a id="COLLECT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>COLLECT</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> COLLECT</pre>
 <div class="block">The COLLECT operator. Multiset aggregator function.</div>
 </li>
 </ul>
 <a id="LISTAGG">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>LISTAGG</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> LISTAGG</pre>
 <div class="block">The LISTAGG operator. Multiset aggregator function.</div>
 </li>
 </ul>
 <a id="FUSION">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>FUSION</h4>
 <pre>public static final&nbsp;<a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql">SqlAggFunction</a> FUSION</pre>
 <div class="block">The FUSION operator. Multiset aggregator function.</div>
 </li>
 </ul>
 <a id="NEXT_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>NEXT_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a> NEXT_VALUE</pre>
 <div class="block">The sequence next value function: <code>NEXT VALUE FOR sequence</code></div>
 </li>
 </ul>
 <a id="CURRENT_VALUE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>CURRENT_VALUE</h4>
 <pre>public static final&nbsp;<a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a> CURRENT_VALUE</pre>
 <div class="block">The sequence current value function: <code>CURRENT VALUE FOR
  sequence</code></div>
 </li>
 </ul>
 <a id="TABLESAMPLE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>TABLESAMPLE</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> TABLESAMPLE</pre>
 <div class="block">The <code>TABLESAMPLE</code> operator.

  <p>Examples:

  <ul>
  <li><code>&lt;query&gt; TABLESAMPLE SUBSTITUTE('sampleName')</code>
  (non-standard)
  <li><code>&lt;query&gt; TABLESAMPLE BERNOULLI(&lt;percent&gt;)
  [REPEATABLE(&lt;seed&gt;)]</code> (standard, but not implemented for FTRS
  yet)
  <li><code>&lt;query&gt; TABLESAMPLE SYSTEM(&lt;percent&gt;)
  [REPEATABLE(&lt;seed&gt;)]</code> (standard, but not implemented for FTRS
  yet)
  </ul>

  <p>Operand #0 is a query or table; Operand #1 is a <a href="../SqlSampleSpec.html" title="class in org.apache.calcite.sql"><code>SqlSampleSpec</code></a>
  wrapped in a <a href="../SqlLiteral.html" title="class in org.apache.calcite.sql"><code>SqlLiteral</code></a>.</div>
 </li>
 </ul>
 <a id="TUMBLE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>TUMBLE</h4>
 <pre>public static final&nbsp;<a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a> TUMBLE</pre>
 <div class="block">The <code>TUMBLE</code> group function.</div>
 </li>
 </ul>
 <a id="TUMBLE_START">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>TUMBLE_START</h4>
 <pre>public static final&nbsp;<a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a> TUMBLE_START</pre>
 <div class="block">The <code>TUMBLE_START</code> auxiliary function of
  the <code>TUMBLE</code> group function.</div>
 </li>
 </ul>
 <a id="TUMBLE_END">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>TUMBLE_END</h4>
 <pre>public static final&nbsp;<a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a> TUMBLE_END</pre>
 <div class="block">The <code>TUMBLE_END</code> auxiliary function of
  the <code>TUMBLE</code> group function.</div>
 </li>
 </ul>
 <a id="HOP">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>HOP</h4>
 <pre>public static final&nbsp;<a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a> HOP</pre>
 <div class="block">The <code>HOP</code> group function.</div>
 </li>
 </ul>
 <a id="HOP_START">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>HOP_START</h4>
 <pre>public static final&nbsp;<a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a> HOP_START</pre>
 <div class="block">The <code>HOP_START</code> auxiliary function of
  the <code>HOP</code> group function.</div>
 </li>
 </ul>
 <a id="HOP_END">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>HOP_END</h4>
 <pre>public static final&nbsp;<a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a> HOP_END</pre>
 <div class="block">The <code>HOP_END</code> auxiliary function of
  the <code>HOP</code> group function.</div>
 </li>
 </ul>
 <a id="SESSION">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SESSION</h4>
 <pre>public static final&nbsp;<a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a> SESSION</pre>
 <div class="block">The <code>SESSION</code> group function.</div>
 </li>
 </ul>
 <a id="SESSION_START">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SESSION_START</h4>
 <pre>public static final&nbsp;<a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a> SESSION_START</pre>
 <div class="block">The <code>SESSION_START</code> auxiliary function of
  the <code>SESSION</code> group function.</div>
 </li>
 </ul>
 <a id="SESSION_END">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>SESSION_END</h4>
 <pre>public static final&nbsp;<a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a> SESSION_END</pre>
 <div class="block">The <code>SESSION_END</code> auxiliary function of
  the <code>SESSION</code> group function.</div>
 </li>
 </ul>
 <a id="PATTERN_ALTER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PATTERN_ALTER</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> PATTERN_ALTER</pre>
 <div class="block"><code>|</code> operator to create alternate patterns
  within <code>MATCH_RECOGNIZE</code>.

  <p>If <code>p1</code> and <code>p2</code> are patterns then <code>p1 | p2</code> is a
  pattern that matches <code>p1</code> or <code>p2</code>.</div>
 </li>
 </ul>
 <a id="PATTERN_CONCAT">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PATTERN_CONCAT</h4>
 <pre>public static final&nbsp;<a href="../SqlBinaryOperator.html" title="class in org.apache.calcite.sql">SqlBinaryOperator</a> PATTERN_CONCAT</pre>
 <div class="block">Operator to concatenate patterns within <code>MATCH_RECOGNIZE</code>.

  <p>If <code>p1</code> and <code>p2</code> are patterns then <code>p1 p2</code> is a
  pattern that matches <code>p1</code> followed by <code>p2</code>.</div>
 </li>
 </ul>
 <a id="PATTERN_QUANTIFIER">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PATTERN_QUANTIFIER</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> PATTERN_QUANTIFIER</pre>
 <div class="block">Operator to quantify patterns within <code>MATCH_RECOGNIZE</code>.

  <p>If <code>p</code> is a pattern then <code>p{3, 5}</code> is a
  pattern that matches between 3 and 5 occurrences of <code>p</code>.</div>
 </li>
 </ul>
 <a id="PATTERN_PERMUTE">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>PATTERN_PERMUTE</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> PATTERN_PERMUTE</pre>
 <div class="block"><code>PERMUTE</code> operator to combine patterns within
  <code>MATCH_RECOGNIZE</code>.

  <p>If <code>p1</code> and <code>p2</code> are patterns then <code>PERMUTE (p1, p2)</code>
  is a pattern that matches all permutations of <code>p1</code> and
  <code>p2</code>.</div>
 </li>
 </ul>
 <a id="PATTERN_EXCLUDE">
 <!--   -->
 </a>
 <ul class="blockListLast">
 <li class="blockList">
 <h4>PATTERN_EXCLUDE</h4>
 <pre>public static final&nbsp;<a href="../SqlSpecialOperator.html" title="class in org.apache.calcite.sql">SqlSpecialOperator</a> PATTERN_EXCLUDE</pre>
 <div class="block"><code>EXCLUDE</code> operator within <code>MATCH_RECOGNIZE</code>.

  <p>If <code>p</code> is a pattern then <code>{- p -} </code>} is a
  pattern that excludes <code>p</code> from the output.</div>
 </li>
 </ul>
 </li>
 </ul>
 </section>
 <!-- ========= CONSTRUCTOR DETAIL ======== -->
 <section role="region">
 <ul class="blockList">
 <li class="blockList"><a id="constructor.detail">
 <!--   -->
 </a>
 <h3>Constructor Detail</h3>
 <a id="&lt;init&gt;()">
 <!--   -->
 </a>
 <ul class="blockListLast">
 <li class="blockList">
 <h4>SqlStdOperatorTable</h4>
 <pre>public&nbsp;SqlStdOperatorTable()</pre>
 </li>
 </ul>
 </li>
 </ul>
 </section>
 <!-- ============ METHOD DETAIL ========== -->
 <section role="region">
 <ul class="blockList">
 <li class="blockList"><a id="method.detail">
 <!--   -->
 </a>
 <h3>Method Detail</h3>
 <a id="instance()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>instance</h4>
 <pre class="methodSignature">public static&nbsp;<a href="SqlStdOperatorTable.html" title="class in org.apache.calcite.sql.fun">SqlStdOperatorTable</a>&nbsp;instance()</pre>
 <div class="block">Returns the standard operator table, creating it if necessary.</div>
 </li>
 </ul>
 <a id="auxiliaryToGroup(org.apache.calcite.sql.SqlKind)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>auxiliaryToGroup</h4>
 <pre class="methodSignature">public static&nbsp;<a href="../SqlGroupedWindowFunction.html" title="class in org.apache.calcite.sql">SqlGroupedWindowFunction</a>&nbsp;auxiliaryToGroup&#8203;(<a href="../SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&nbsp;kind)</pre>
 <div class="block">Returns the group function for which a given kind is an auxiliary
  function, or null if it is not an auxiliary function.</div>
 </li>
 </ul>
 <a id="convertAuxiliaryToGroupCall(org.apache.calcite.sql.SqlCall)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>convertAuxiliaryToGroupCall</h4>
 <pre class="methodSignature">public static&nbsp;<a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a>&nbsp;convertAuxiliaryToGroupCall&#8203;(<a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a>&nbsp;call)</pre>
 <div class="block">Converts a call to a grouped auxiliary function
  to a call to the grouped window function. For other calls returns null.

  <p>For example, converts <code>TUMBLE_START(rowtime, INTERVAL '1' HOUR))</code>
  to <code>TUMBLE(rowtime, INTERVAL '1' HOUR))</code>.</div>
 </li>
 </ul>
 <a id="convertGroupToAuxiliaryCalls(org.apache.calcite.sql.SqlCall)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>convertGroupToAuxiliaryCalls</h4>
 <pre class="methodSignature">public static&nbsp;java.util.List&lt;<a href="../../util/Pair.html" title="class in org.apache.calcite.util">Pair</a>&lt;<a href="../SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a>,&#8203;<a href="../../sql2rel/AuxiliaryConverter.html" title="interface in org.apache.calcite.sql2rel">AuxiliaryConverter</a>&gt;&gt;&nbsp;convertGroupToAuxiliaryCalls&#8203;(<a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a>&nbsp;call)</pre>
 <div class="block">Converts a call to a grouped window function to a call to its auxiliary
  window function(s). For other calls returns null.

  <p>For example, converts <code>TUMBLE_START(rowtime, INTERVAL '1' HOUR))</code>
  to <code>TUMBLE(rowtime, INTERVAL '1' HOUR))</code>.</div>
 </li>
 </ul>
 <a id="copy(org.apache.calcite.sql.SqlCall,org.apache.calcite.sql.SqlOperator)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>copy</h4>
 <pre class="methodSignature">private static&nbsp;<a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a>&nbsp;copy&#8203;(<a href="../SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a>&nbsp;call,
                             <a href="../SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a>&nbsp;operator)</pre>
 <div class="block">Creates a copy of a call with a new operator.</div>
 </li>
 </ul>
 <a id="some(org.apache.calcite.sql.SqlKind)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>some</h4>
 <pre class="methodSignature">public static&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a>&nbsp;some&#8203;(<a href="../SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&nbsp;comparisonKind)</pre>
 <div class="block">Returns the operator for <code>SOME comparisonKind</code>.</div>
 </li>
 </ul>
 <a id="all(org.apache.calcite.sql.SqlKind)">
 <!--   -->
 </a>
 <ul class="blockListLast">
 <li class="blockList">
 <h4>all</h4>
 <pre class="methodSignature">public static&nbsp;<a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a>&nbsp;all&#8203;(<a href="../SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>&nbsp;comparisonKind)</pre>
 <div class="block">Returns the operator for <code>ALL comparisonKind</code>.</div>
 </li>
 </ul>
 </li>
 </ul>
 </section>
 </li>
 </ul>
 </div>
 </div>
 </main>
 <!-- ========= END OF CLASS DATA ========= -->
 <footer role="contentinfo">
 <nav role="navigation">
 <!-- ======= START OF BOTTOM NAVBAR ====== -->
 <div class="bottomNav"><a id="navbar.bottom">
 <!--   -->
 </a>
 <div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div>
 <a id="navbar.bottom.firstrow">
 <!--   -->
 </a>
 <ul class="navList" title="Navigation">
 <li><a href="../../../../../index.html">Overview</a></li>
 <li><a href="package-summary.html">Package</a></li>
 <li class="navBarCell1Rev">Class</li>
 <li><a href="class-use/SqlStdOperatorTable.html">Use</a></li>
 <li><a href="package-tree.html">Tree</a></li>
 <li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
 <li><a href="../../../../../index-all.html">Index</a></li>
 <li><a href="../../../../../help-doc.html">Help</a></li>
 </ul>
 </div>
 <div class="subNav">
 <ul class="navList" id="allclasses_navbar_bottom">
 <li><a href="../../../../../allclasses.html">All&nbsp;Classes</a></li>
 </ul>
 <div>
 <script type="text/javascript"><!--
   allClassesLink = document.getElementById("allclasses_navbar_bottom");
   if(window==top) {
     allClassesLink.style.display = "block";
   }
   else {
     allClassesLink.style.display = "none";
   }
   //-->
 </script>
 <noscript>
 <div>JavaScript is disabled on your browser.</div>
 </noscript>
 </div>
 <div>
 <ul class="subNavList">
 <li>Summary:&nbsp;</li>
 <li>Nested&nbsp;|&nbsp;</li>
 <li><a href="#field.summary">Field</a>&nbsp;|&nbsp;</li>
 <li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
 <li><a href="#method.summary">Method</a></li>
 </ul>
 <ul class="subNavList">
 <li>Detail:&nbsp;</li>
 <li><a href="#field.detail">Field</a>&nbsp;|&nbsp;</li>
 <li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
 <li><a href="#method.detail">Method</a></li>
 </ul>
 </div>
 <a id="skip.navbar.bottom">
 <!--   -->
 </a></div>
 <!-- ======== END OF BOTTOM NAVBAR ======= -->
 </nav>
 <p class="legalCopy"><small>Copyright &#169; 2012&#x2013;2019 <a href="https://www.apache.org/">The Apache Software Foundation</a>. All rights reserved.</small></p>
 </footer>
 </body>
 </html>