| <!DOCTYPE HTML> |
| <!-- NewPage --> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc --> |
| <title>SqlKind (Apache Calcite API)</title> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style"> |
| <link rel="stylesheet" type="text/css" href="../../../../jquery/jquery-ui.css" title="Style"> |
| <script type="text/javascript" src="../../../../script.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jszip/dist/jszip.min.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jszip-utils/dist/jszip-utils.min.js"></script> |
| <!--[if IE]> |
| <script type="text/javascript" src="../../../../jquery/jszip-utils/dist/jszip-utils-ie.min.js"></script> |
| <![endif]--> |
| <script type="text/javascript" src="../../../../jquery/jquery-3.3.1.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jquery-migrate-3.0.1.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jquery-ui.js"></script> |
| </head> |
| <body> |
| <script type="text/javascript"><!-- |
| try { |
| if (location.href.indexOf('is-external=true') == -1) { |
| parent.document.title="SqlKind (Apache Calcite API)"; |
| } |
| } |
| catch(err) { |
| } |
| //--> |
| var data = {"i0":10,"i1":9,"i2":10,"i3":10,"i4":10,"i5":9,"i6":9}; |
| var tabs = {65535:["t0","All Methods"],1:["t1","Static Methods"],2:["t2","Instance Methods"],8:["t4","Concrete Methods"]}; |
| var altColor = "altColor"; |
| var rowColor = "rowColor"; |
| var tableTab = "tableTab"; |
| var activeTableTab = "activeTableTab"; |
| var pathtoroot = "../../../../"; |
| var useModuleDirectories = true; |
| loadScripts(document, 'script');</script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| <header role="banner"> |
| <nav role="navigation"> |
| <div class="fixedNav"> |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <div class="topNav"><a id="navbar.top"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div> |
| <a id="navbar.top.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../index.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="class-use/SqlKind.html">Use</a></li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../help-doc.html">Help</a></li> |
| </ul> |
| </div> |
| <div class="subNav"> |
| <ul class="navList" id="allclasses_navbar_top"> |
| <li><a href="../../../../allclasses.html">All 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: </li> |
| <li>Nested | </li> |
| <li><a href="#enum.constant.summary">Enum Constants</a> | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#enum.constant.detail">Enum Constants</a> | </li> |
| <li><a href="#field.detail">Field</a> | </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"> </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> <a href="package-summary.html">org.apache.calcite.sql</a></div> |
| <h2 title="Enum SqlKind" class="title">Enum SqlKind</h2> |
| </div> |
| <div class="contentContainer"> |
| <ul class="inheritance"> |
| <li>java.lang.Object</li> |
| <li> |
| <ul class="inheritance"> |
| <li>java.lang.Enum<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></li> |
| <li> |
| <ul class="inheritance"> |
| <li>org.apache.calcite.sql.SqlKind</li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <div class="description"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <dl> |
| <dt>All Implemented Interfaces:</dt> |
| <dd><code>java.io.Serializable</code>, <code>java.lang.Comparable<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></dd> |
| </dl> |
| <hr> |
| <pre>public enum <span class="typeNameLabel">SqlKind</span> |
| extends java.lang.Enum<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></pre> |
| <div class="block">Enumerates the possible types of <a href="SqlNode.html" title="class in org.apache.calcite.sql"><code>SqlNode</code></a>. |
| |
| <p>The values are immutable, canonical constants, so you can use Kinds to |
| find particular types of expressions quickly. To identity a call to a common |
| operator such as '=', use <a href="SqlNode.html#isA(java.util.Set)"><code>SqlNode.isA(java.util.Set<org.apache.calcite.sql.SqlKind>)</code></a>:</p> |
| |
| <blockquote> |
| exp.<a href="SqlNode.html#isA(java.util.Set)"><code>isA</code></a>(<a href="#EQUALS"><code>EQUALS</code></a>) |
| </blockquote> |
| |
| <p>Only commonly-used nodes have their own type; other nodes are of type |
| <a href="#OTHER"><code>OTHER</code></a>. Some of the values, such as <a href="#SET_QUERY"><code>SET_QUERY</code></a>, represent |
| aggregates.</p> |
| |
| <p>To quickly choose between a number of options, use a switch statement:</p> |
| |
| <blockquote> |
| <pre>switch (exp.getKind()) { |
| case <a href="#EQUALS"><code>EQUALS</code></a>: |
| ...; |
| case <a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a>: |
| ...; |
| default: |
| throw new AssertionError("unexpected"); |
| }</pre> |
| </blockquote> |
| |
| <p>Note that we do not even have to check that a <code>SqlNode</code> is a |
| <a href="SqlCall.html" title="class in org.apache.calcite.sql"><code>SqlCall</code></a>.</p> |
| |
| <p>To identify a category of expressions, use <code>SqlNode.isA</code> with |
| an aggregate SqlKind. The following expression will return <code>true</code> |
| for calls to '=' and '>=', but <code>false</code> for the constant '5', or |
| a call to '+':</p> |
| |
| <blockquote> |
| <pre>exp.isA(<a href="#COMPARISON"><code>SqlKind.COMPARISON</code></a>)</pre> |
| </blockquote> |
| |
| <p>RexNode also has a <code>getKind</code> method; <code>SqlKind</code> values are |
| preserved during translation from <code>SqlNode</code> to <code>RexNode</code>, where |
| applicable.</p> |
| |
| <p>There is no water-tight definition of "common", but that's OK. There will |
| always be operators that don't have their own kind, and for these we use the |
| <code>SqlOperator</code>. But for really the common ones, e.g. the many places |
| where we are looking for <code>AND</code>, <code>OR</code> and <code>EQUALS</code>, the enum |
| helps.</p> |
| |
| <p>(If we were using Scala, <a href="SqlOperator.html" title="class in org.apache.calcite.sql"><code>SqlOperator</code></a> would be a case |
| class, and we wouldn't need <code>SqlKind</code>. But we're not.)</p></div> |
| </li> |
| </ul> |
| </div> |
| <div class="summary"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- =========== ENUM CONSTANT SUMMARY =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="enum.constant.summary"> |
| <!-- --> |
| </a> |
| <h3>Enum Constant Summary</h3> |
| <table class="memberSummary"> |
| <caption><span>Enum Constants</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Enum Constant</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALL">ALL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "ALL" quantification operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_INDEX">ALTER_INDEX</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>ALTER INDEX</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_MATERIALIZED_VIEW">ALTER_MATERIALIZED_VIEW</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>ALTER MATERIALIZED VIEW</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_SEQUENCE">ALTER_SEQUENCE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>ALTER SEQUENCE</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_SESSION">ALTER_SESSION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>ALTER SESSION</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_TABLE">ALTER_TABLE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>ALTER TABLE</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ALTER_VIEW">ALTER_VIEW</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>ALTER VIEW</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#AND">AND</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The logical "AND" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ANY_VALUE">ANY_VALUE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>ANY_VALUE</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ARGUMENT_ASSIGNMENT">ARGUMENT_ASSIGNMENT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">ARGUMENT_ASSIGNMENT operator, <code>=></code></div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ARRAY_QUERY_CONSTRUCTOR">ARRAY_QUERY_CONSTRUCTOR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Array Query Constructor, e.g.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ARRAY_VALUE_CONSTRUCTOR">ARRAY_VALUE_CONSTRUCTOR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Array Value Constructor, e.g.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#AS">AS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">AS operator</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ATTRIBUTE_DEF">ATTRIBUTE_DEF</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Attribute definition.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#AVG">AVG</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>AVG</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#BETWEEN">BETWEEN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "BETWEEN" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#BIT_AND">BIT_AND</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>BIT_AND</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#BIT_OR">BIT_OR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>BIT_OR</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CASE">CASE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">A "CASE" expression.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CAST">CAST</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "CAST" operator, and also the PostgreSQL-style infix cast operator |
| "::".</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CEIL">CEIL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "CEIL" function</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CHECK">CHECK</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>CHECK</code> constraint.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CLASSIFIER">CLASSIFIER</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COALESCE">COALESCE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "COALESCE" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COLLECT">COLLECT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>COLLECT</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COLLECTION_TABLE">COLLECTION_TABLE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Table operator which converts user-defined transform into a relation, for |
| example, <code>select * from TABLE(udx(x, y, z))</code>.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COLUMN_DECL">COLUMN_DECL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Column declaration.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COLUMN_LIST">COLUMN_LIST</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The non-standard constructor used to pass a |
| COLUMN_LIST parameter to a user-defined transform.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COMMIT">COMMIT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>COMMIT</code> session control statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CONTAINS">CONTAINS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "CONTAINS" operator for periods.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CORREL_VARIABLE">CORREL_VARIABLE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Reference to correlation variable.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COUNT">COUNT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>COUNT</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COVAR_POP">COVAR_POP</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>COVAR_POP</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#COVAR_SAMP">COVAR_SAMP</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>COVAR_SAMP</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_FOREIGN_SCHEMA">CREATE_FOREIGN_SCHEMA</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>CREATE FOREIGN SCHEMA</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_FUNCTION">CREATE_FUNCTION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>CREATE FUNCTION</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_INDEX">CREATE_INDEX</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>CREATE INDEX</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_MATERIALIZED_VIEW">CREATE_MATERIALIZED_VIEW</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>CREATE MATERIALIZED VIEW</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_SCHEMA">CREATE_SCHEMA</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>CREATE SCHEMA</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_SEQUENCE">CREATE_SEQUENCE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>CREATE SEQUENCE</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_TABLE">CREATE_TABLE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>CREATE TABLE</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_TYPE">CREATE_TYPE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>CREATE TYPE</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CREATE_VIEW">CREATE_VIEW</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>CREATE VIEW</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CUBE">CUBE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The internal <code>CUBE</code> operator that occurs within a <code>GROUP BY</code> |
| clause.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CUME_DIST">CUME_DIST</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>ROW_NUMBER</code> window function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CURRENT_VALUE">CURRENT_VALUE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "CURRENT VALUE OF sequence" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#CURSOR">CURSOR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">CURSOR constructor, for example, <code>select * from |
| TABLE(udx(CURSOR(select ...), x, y, z))</code></div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DECODE">DECODE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "DECODE" function (Oracle).</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DEFAULT">DEFAULT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">DEFAULT operator</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DELETE">DELETE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">DELETE statement</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DENSE_RANK">DENSE_RANK</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>DENSE_RANK</code> window function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DESCENDING">DESCENDING</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">DESC in ORDER BY.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DESCRIBE_SCHEMA">DESCRIBE_SCHEMA</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">DESCRIBE SCHEMA statement</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DESCRIBE_TABLE">DESCRIBE_TABLE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">DESCRIBE TABLE statement</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DIVIDE">DIVIDE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The arithmetic division operator, "/".</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DOT">DOT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Dot</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_FUNCTION">DROP_FUNCTION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>DROP FUNCTION</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_INDEX">DROP_INDEX</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>DROP INDEX</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_MATERIALIZED_VIEW">DROP_MATERIALIZED_VIEW</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>DROP MATERIALIZED VIEW</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_SCHEMA">DROP_SCHEMA</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>DROP SCHEMA</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_SEQUENCE">DROP_SEQUENCE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>DROP SEQUENCE</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_TABLE">DROP_TABLE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>DROP TABLE</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_TYPE">DROP_TYPE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>DROP TYPE</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DROP_VIEW">DROP_VIEW</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>DROP VIEW</code> DDL statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#DYNAMIC_PARAM">DYNAMIC_PARAM</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">A dynamic parameter.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EQUALS">EQUALS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The equals operator, "=".</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ESCAPE">ESCAPE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Escape operator (always part of LIKE or SIMILAR TO expression).</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXCEPT">EXCEPT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Except</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXISTS">EXISTS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "EXISTS" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXPLAIN">EXPLAIN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">EXPLAIN statement</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXPLICIT_TABLE">EXPLICIT_TABLE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Explicit table, e.g.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXTEND">EXTEND</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The internal <code>EXTEND</code> operator that qualifies a table name in the |
| <code>FROM</code> clause.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#EXTRACT">EXTRACT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "EXTRACT" function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FIELD_ACCESS">FIELD_ACCESS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The field access operator, ".".</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FILTER">FILTER</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">FILTER operator</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FINAL">FINAL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Special functions in MATCH_RECOGNIZE.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FIRST">FIRST</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FIRST_VALUE">FIRST_VALUE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>FIRST_VALUE</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FLOOR">FLOOR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "FLOOR" function</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FOLLOWING">FOLLOWING</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "FOLLOWING" qualifier of an interval end-point in a window |
| specification.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FOREIGN_KEY">FOREIGN_KEY</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>FOREIGN KEY</code> constraint.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#FUSION">FUSION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>FUSION</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GREATER_THAN">GREATER_THAN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The greater-than operator, ">".</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GREATER_THAN_OR_EQUAL">GREATER_THAN_OR_EQUAL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The greater-than-or-equal operator, ">=".</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GREATEST">GREATEST</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "GREATEST" function (Oracle).</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GROUP_ID">GROUP_ID</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>GROUP_ID()</code> function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GROUPING">GROUPING</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>GROUPING(e, ...)</code> function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GROUPING_ID">GROUPING_ID</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">Use <a href="#GROUPING"><code>GROUPING</code></a>.</div> |
| </div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#GROUPING_SETS">GROUPING_SETS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The internal <code>GROUPING SETS</code> operator that occurs within a |
| <code>GROUP BY</code> clause.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#HOP">HOP</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>HOP</code> group function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#HOP_END">HOP_END</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>HOP_END</code> auxiliary function of |
| the <a href="#HOP"><code>HOP</code></a> group function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#HOP_START">HOP_START</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>HOP_START</code> auxiliary function of |
| the <a href="#HOP"><code>HOP</code></a> group function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IDENTIFIER">IDENTIFIER</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Identifier</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IGNORE_NULLS">IGNORE_NULLS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">IGNORE NULLS operator</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IMMEDIATELY_PRECEDES">IMMEDIATELY_PRECEDES</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "IMMEDIATELY PRECEDES" operator for periods.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IMMEDIATELY_SUCCEEDS">IMMEDIATELY_SUCCEEDS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "IMMEDIATELY SUCCEEDS" operator for periods.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IN">IN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "IN" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#INPUT_REF">INPUT_REF</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Reference to an input field.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#INSERT">INSERT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">INSERT statement</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#INTERSECT">INTERSECT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Intersect</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_DISTINCT_FROM">IS_DISTINCT_FROM</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The is-distinct-from operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_FALSE">IS_FALSE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "IS FALSE" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_DISTINCT_FROM">IS_NOT_DISTINCT_FROM</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The is-not-distinct-from operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_FALSE">IS_NOT_FALSE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "IS NOT FALSE" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_NULL">IS_NOT_NULL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "IS NOT NULL" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_NOT_TRUE">IS_NOT_TRUE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "IS NOT TRUE" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_NULL">IS_NULL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "IS NULL" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_TRUE">IS_TRUE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "IS TRUE" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#IS_UNKNOWN">IS_UNKNOWN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "IS UNKNOWN" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#JDBC_FN">JDBC_FN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Call to a function using JDBC function syntax.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#JOIN">JOIN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">JOIN operator or compound FROM clause.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#JSON_ARRAYAGG">JSON_ARRAYAGG</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>JSON_ARRAYAGG</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#JSON_OBJECTAGG">JSON_OBJECTAGG</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>JSON_OBJECTAGG</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#JSON_VALUE_EXPRESSION">JSON_VALUE_EXPRESSION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The JSON value expression.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LAG">LAG</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>LAG</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LAST">LAST</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LAST_VALUE">LAST_VALUE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>LAST_VALUE</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LATERAL">LATERAL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "LATERAL" qualifier to relations in the FROM clause.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LEAD">LEAD</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>LEAD</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LEAST">LEAST</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "LEAST" function (Oracle).</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LESS_THAN">LESS_THAN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The less-than operator, "<".</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LESS_THAN_OR_EQUAL">LESS_THAN_OR_EQUAL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The less-than-or-equal operator, "<=".</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LIKE">LIKE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "LIKE" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LISTAGG">LISTAGG</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>LISTAGG</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LITERAL">LITERAL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">A literal.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LITERAL_CHAIN">LITERAL_CHAIN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Literal chain operator (for composite string literals).</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LOCAL_REF">LOCAL_REF</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Reference to a sub-expression computed within the current relational |
| operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#LTRIM">LTRIM</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "LTRIM" function (Oracle).</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MAP_QUERY_CONSTRUCTOR">MAP_QUERY_CONSTRUCTOR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Map Query Constructor, e.g.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MAP_VALUE_CONSTRUCTOR">MAP_VALUE_CONSTRUCTOR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Map Value Constructor, e.g.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MATCH_NUMBER">MATCH_NUMBER</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MATCH_RECOGNIZE">MATCH_RECOGNIZE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">MATCH_RECOGNIZE clause</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MAX">MAX</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>MAX</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MERGE">MERGE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">MERGE statement</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MIN">MIN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>MIN</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MINUS">MINUS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The arithmetic minus operator, "-".</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MINUS_PREFIX">MINUS_PREFIX</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The unary minus operator, as in "-1".</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MOD">MOD</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The arithmetic remainder operator, "MOD" (and "%" in some dialects).</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_QUERY_CONSTRUCTOR">MULTISET_QUERY_CONSTRUCTOR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The MULTISET query constructor.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#MULTISET_VALUE_CONSTRUCTOR">MULTISET_VALUE_CONSTRUCTOR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The MULTISET value constructor.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NEW_SPECIFICATION">NEW_SPECIFICATION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">NewSpecification</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NEXT">NEXT</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NEXT_VALUE">NEXT_VALUE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "NEXT VALUE OF sequence" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NOT">NOT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The logical "NOT" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NOT_EQUALS">NOT_EQUALS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The not-equals operator, "!=" or "<>".</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NOT_IN">NOT_IN</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "NOT IN" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NTH_VALUE">NTH_VALUE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>NTH_VALUE</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NTILE">NTILE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>NTILE</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NULLIF">NULLIF</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "NULLIF" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NULLS_FIRST">NULLS_FIRST</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">NULLS FIRST clause in ORDER BY.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NULLS_LAST">NULLS_LAST</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">NULLS LAST clause in ORDER BY.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#NVL">NVL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "NVL" function (Oracle).</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OR">OR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The logical "OR" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ORDER_BY">ORDER_BY</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">ORDER BY clause.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OTHER">OTHER</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Expression not covered by any other <a href="SqlKind.html" title="enum in org.apache.calcite.sql"><code>SqlKind</code></a> value.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OTHER_DDL">OTHER_DDL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">DDL statement not handled above.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OTHER_FUNCTION">OTHER_FUNCTION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Function that is not a special function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OVER">OVER</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">OVER operator</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#OVERLAPS">OVERLAPS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "OVERLAPS" operator for periods.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_ALTER">PATTERN_ALTER</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">the alternation operator in a pattern expression within a match_recognize clause</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_CONCAT">PATTERN_CONCAT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">the concatenation operator in a pattern expression within a match_recognize clause</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_EXCLUDED">PATTERN_EXCLUDED</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The special patterns to exclude enclosing pattern from output in a |
| MATCH_RECOGNIZE clause.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_INPUT_REF">PATTERN_INPUT_REF</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Reference to an input field, with pattern var as modifier</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_PERMUTE">PATTERN_PERMUTE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The internal "permute" function in a MATCH_RECOGNIZE clause.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PATTERN_QUANTIFIER">PATTERN_QUANTIFIER</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">the repetition quantifier of a pattern factor in a match_recognize clause.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PERCENT_RANK">PERCENT_RANK</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>PERCENT_RANK</code> window function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PERIOD_EQUALS">PERIOD_EQUALS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "EQUALS" operator for periods.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PLUS">PLUS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The arithmetic plus operator, "+".</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PLUS_PREFIX">PLUS_PREFIX</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The unary plus operator, as in "+1".</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#POSITION">POSITION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">POSITION Function</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#POSIX_REGEX_CASE_INSENSITIVE">POSIX_REGEX_CASE_INSENSITIVE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "~*" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#POSIX_REGEX_CASE_SENSITIVE">POSIX_REGEX_CASE_SENSITIVE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "~" operator.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PRECEDES">PRECEDES</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "PRECEDES" operator for periods.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PRECEDING">PRECEDING</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "PRECEDING" qualifier of an interval end-point in a window |
| specification.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PREV">PREV</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PRIMARY_KEY">PRIMARY_KEY</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>PRIMARY KEY</code> constraint.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#PROCEDURE_CALL">PROCEDURE_CALL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">ProcedureCall</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#RANK">RANK</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>RANK</code> window function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REGR_COUNT">REGR_COUNT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>REGR_COUNT</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REGR_SXX">REGR_SXX</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>REGR_SXX</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REGR_SYY">REGR_SYY</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>REGR_SYY</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REINTERPRET">REINTERPRET</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The internal REINTERPRET operator (meaning a reinterpret cast).</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#RESPECT_NULLS">RESPECT_NULLS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">RESPECT NULLS operator</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#REVERSE">REVERSE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "REVERSE" function (SQL Server, MySQL).</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ROLLBACK">ROLLBACK</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>ROLLBACK</code> session control statement.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ROLLUP">ROLLUP</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The internal <code>ROLLUP</code> operator that occurs within a <code>GROUP BY</code> |
| clause.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ROW">ROW</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The row-constructor function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#ROW_NUMBER">ROW_NUMBER</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>ROW_NUMBER</code> window function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#RTRIM">RTRIM</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "RTRIM" function (Oracle).</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#RUNNING">RUNNING</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SCALAR_QUERY">SCALAR_QUERY</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Scalar query; that is, a sub-query used in an expression context, and |
| returning one row and one column.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SELECT">SELECT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">SELECT statement or sub-query.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SESSION">SESSION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>SESSION</code> group function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SESSION_END">SESSION_END</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>SESSION_END</code> auxiliary function of |
| the <a href="#SESSION"><code>SESSION</code></a> group function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SESSION_START">SESSION_START</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>SESSION_START</code> auxiliary function of |
| the <a href="#SESSION"><code>SESSION</code></a> group function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SET_OPTION">SET_OPTION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">"ALTER scope SET option = value" statement.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SIMILAR">SIMILAR</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "SIMILAR" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SINGLE_VALUE">SINGLE_VALUE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>SINGLE_VALUE</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SKIP_TO_FIRST">SKIP_TO_FIRST</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "SKIP TO FIRST" qualifier of restarting point in a MATCH_RECOGNIZE |
| clause.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SKIP_TO_LAST">SKIP_TO_LAST</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "SKIP TO LAST" qualifier of restarting point in a MATCH_RECOGNIZE |
| clause.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SNAPSHOT">SNAPSHOT</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">SNAPSHOT operator</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SOME">SOME</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "SOME" quantification operator (also called "ANY").</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#STDDEV_POP">STDDEV_POP</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>STDDEV_POP</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#STDDEV_SAMP">STDDEV_SAMP</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>STDDEV_SAMP</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SUCCEEDS">SUCCEEDS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "SUCCEEDS" operator for periods.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SUM">SUM</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>SUM</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#SUM0">SUM0</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>SUM0</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TABLE_INPUT_REF">TABLE_INPUT_REF</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Reference to an input field, with a qualified name and an identifier</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TABLESAMPLE">TABLESAMPLE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">TABLESAMPLE operator</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TIMES">TIMES</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The arithmetic multiplication operator, "*".</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TIMESTAMP_ADD">TIMESTAMP_ADD</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "TIMESTAMP_ADD" function (ODBC, SQL Server, MySQL).</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TIMESTAMP_DIFF">TIMESTAMP_DIFF</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "TIMESTAMP_DIFF" function (ODBC, SQL Server, MySQL).</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TRIM">TRIM</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "TRIM" function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TUMBLE">TUMBLE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>TUMBLE</code> group function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TUMBLE_END">TUMBLE_END</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>TUMBLE_END</code> auxiliary function of |
| the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#TUMBLE_START">TUMBLE_START</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>TUMBLE_START</code> auxiliary function of |
| the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#UNION">UNION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Union</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#UNIQUE">UNIQUE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><code>UNIQUE</code> constraint.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#UNNEST">UNNEST</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "UNNEST" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#UPDATE">UPDATE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">UPDATE statement</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#VALUES">VALUES</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The "VALUES" operator.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#VAR_POP">VAR_POP</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>VAR_POP</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#VAR_SAMP">VAR_SAMP</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">The <code>VAR_SAMP</code> aggregate function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#WINDOW">WINDOW</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Window specification</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#WITH">WITH</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">WITH clause.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#WITH_ITEM">WITH_ITEM</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Item in WITH clause.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <th class="colFirst" scope="row"><code><span class="memberNameLink"><a href="#WITHIN_GROUP">WITHIN_GROUP</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">WITHIN_GROUP operator</div> |
| </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| </section> |
| <!-- =========== FIELD SUMMARY =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="field.summary"> |
| <!-- --> |
| </a> |
| <h3>Field Summary</h3> |
| <table class="memberSummary"> |
| <caption><span>Fields</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colSecond" scope="col">Field</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#AGGREGATE">AGGREGATE</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category consisting of all built-in aggregate functions.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#AVG_AGG_FUNCTIONS">AVG_AGG_FUNCTIONS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category of SqlAvgAggFunction.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#BINARY_ARITHMETIC">BINARY_ARITHMETIC</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category of binary arithmetic.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#BINARY_COMPARISON">BINARY_COMPARISON</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category of binary comparison.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#BINARY_EQUALITY">BINARY_EQUALITY</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category of binary equality.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COMPARISON">COMPARISON</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category of comparison operators.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#COVAR_AVG_AGG_FUNCTIONS">COVAR_AVG_AGG_FUNCTIONS</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category of SqlCovarAggFunction.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DDL">DDL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category consisting of all DDL operators.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DML">DML</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category consisting of all DML operators.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#EXPRESSION">EXPRESSION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category consisting of all expression operators.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#FUNCTION">FUNCTION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category consisting of regular and special functions.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>java.lang.String</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lowerName">lowerName</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Lower-case name.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#QUERY">QUERY</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category consisting of query node types.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SET_QUERY">SET_QUERY</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category consisting of set-query node types.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>java.lang.String</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#sql">sql</a></span></code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#TOP_LEVEL">TOP_LEVEL</a></span></code></th> |
| <td class="colLast"> |
| <div class="block">Category of all SQL statement types.</div> |
| </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| </section> |
| <!-- ======== CONSTRUCTOR SUMMARY ======== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="constructor.summary"> |
| <!-- --> |
| </a> |
| <h3>Constructor Summary</h3> |
| <table class="memberSummary"> |
| <caption><span>Constructors</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier</th> |
| <th class="colSecond" scope="col">Constructor</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>private </code></td> |
| <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E()">SqlKind</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>private </code></td> |
| <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(java.lang.String)">SqlKind</a></span>​(java.lang.String sql)</code></th> |
| <td class="colLast"> </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"> </span></span><span id="t1" class="tableTab"><span><a href="javascript:show(1);">Static Methods</a></span><span class="tabEnd"> </span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd"> </span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd"> </span></span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colSecond" scope="col">Method</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr id="i0" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#belongsTo(java.util.Collection)">belongsTo</a></span>​(java.util.Collection<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> category)</code></th> |
| <td class="colLast"> |
| <div class="block">Returns whether this <code>SqlKind</code> belongs to a given category.</div> |
| </td> |
| </tr> |
| <tr id="i1" class="rowColor"> |
| <td class="colFirst"><code>private static <E extends java.lang.Enum<E>><br>java.util.EnumSet<E></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#concat(java.util.EnumSet,java.util.EnumSet...)">concat</a></span>​(java.util.EnumSet<E> set0, |
| java.util.EnumSet<E>... sets)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i2" class="altColor"> |
| <td class="colFirst"><code><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#negate()">negate</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Returns the kind that you get if you apply NOT to this kind.</div> |
| </td> |
| </tr> |
| <tr id="i3" class="rowColor"> |
| <td class="colFirst"><code><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#negateNullSafe()">negateNullSafe</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Returns the kind that you get if you negate this kind.</div> |
| </td> |
| </tr> |
| <tr id="i4" class="altColor"> |
| <td class="colFirst"><code><a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#reverse()">reverse</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Returns the kind that corresponds to this operator but in the opposite |
| direction.</div> |
| </td> |
| </tr> |
| <tr id="i5" class="rowColor"> |
| <td class="colFirst"><code>static <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#valueOf(java.lang.String)">valueOf</a></span>​(java.lang.String name)</code></th> |
| <td class="colLast"> |
| <div class="block">Returns the enum constant of this type with the specified name.</div> |
| </td> |
| </tr> |
| <tr id="i6" class="altColor"> |
| <td class="colFirst"><code>static <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>[]</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#values()">values</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Returns an array containing the constants of this enum type, in |
| the order they are declared.</div> |
| </td> |
| </tr> |
| </table> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.java.lang.Enum"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class java.lang.Enum</h3> |
| <code>clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf</code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.java.lang.Object"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class java.lang.Object</h3> |
| <code>getClass, notify, notifyAll, wait, wait, wait</code></li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| </li> |
| </ul> |
| </div> |
| <div class="details"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- ============ ENUM CONSTANT DETAIL =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="enum.constant.detail"> |
| <!-- --> |
| </a> |
| <h3>Enum Constant Detail</h3> |
| <a id="OTHER"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>OTHER</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OTHER</pre> |
| <div class="block">Expression not covered by any other <a href="SqlKind.html" title="enum in org.apache.calcite.sql"><code>SqlKind</code></a> value.</div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#OTHER_FUNCTION"><code>OTHER_FUNCTION</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="SELECT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SELECT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SELECT</pre> |
| <div class="block">SELECT statement or sub-query.</div> |
| </li> |
| </ul> |
| <a id="JOIN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JOIN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> JOIN</pre> |
| <div class="block">JOIN operator or compound FROM clause. |
| |
| <p>A FROM clause with more than one table is represented as if it were a |
| join. For example, "FROM x, y, z" is represented as |
| "JOIN(x, JOIN(x, y))".</p></div> |
| </li> |
| </ul> |
| <a id="IDENTIFIER"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IDENTIFIER</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IDENTIFIER</pre> |
| <div class="block">Identifier</div> |
| </li> |
| </ul> |
| <a id="LITERAL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LITERAL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LITERAL</pre> |
| <div class="block">A literal.</div> |
| </li> |
| </ul> |
| <a id="OTHER_FUNCTION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>OTHER_FUNCTION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OTHER_FUNCTION</pre> |
| <div class="block">Function that is not a special function.</div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#FUNCTION"><code>FUNCTION</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="POSITION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>POSITION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> POSITION</pre> |
| <div class="block">POSITION Function</div> |
| </li> |
| </ul> |
| <a id="EXPLAIN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EXPLAIN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXPLAIN</pre> |
| <div class="block">EXPLAIN statement</div> |
| </li> |
| </ul> |
| <a id="DESCRIBE_SCHEMA"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DESCRIBE_SCHEMA</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DESCRIBE_SCHEMA</pre> |
| <div class="block">DESCRIBE SCHEMA statement</div> |
| </li> |
| </ul> |
| <a id="DESCRIBE_TABLE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DESCRIBE_TABLE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DESCRIBE_TABLE</pre> |
| <div class="block">DESCRIBE TABLE statement</div> |
| </li> |
| </ul> |
| <a id="INSERT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>INSERT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> INSERT</pre> |
| <div class="block">INSERT statement</div> |
| </li> |
| </ul> |
| <a id="DELETE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DELETE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DELETE</pre> |
| <div class="block">DELETE statement</div> |
| </li> |
| </ul> |
| <a id="UPDATE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>UPDATE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> UPDATE</pre> |
| <div class="block">UPDATE statement</div> |
| </li> |
| </ul> |
| <a id="SET_OPTION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SET_OPTION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SET_OPTION</pre> |
| <div class="block">"ALTER scope SET option = value" statement.</div> |
| </li> |
| </ul> |
| <a id="DYNAMIC_PARAM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DYNAMIC_PARAM</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DYNAMIC_PARAM</pre> |
| <div class="block">A dynamic parameter.</div> |
| </li> |
| </ul> |
| <a id="ORDER_BY"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ORDER_BY</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ORDER_BY</pre> |
| <div class="block">ORDER BY clause.</div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#DESCENDING"><code>DESCENDING</code></a>, |
| <a href="#NULLS_FIRST"><code>NULLS_FIRST</code></a>, |
| <a href="#NULLS_LAST"><code>NULLS_LAST</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="WITH"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>WITH</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> WITH</pre> |
| <div class="block">WITH clause.</div> |
| </li> |
| </ul> |
| <a id="WITH_ITEM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>WITH_ITEM</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> WITH_ITEM</pre> |
| <div class="block">Item in WITH clause.</div> |
| </li> |
| </ul> |
| <a id="UNION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>UNION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> UNION</pre> |
| <div class="block">Union</div> |
| </li> |
| </ul> |
| <a id="EXCEPT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EXCEPT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXCEPT</pre> |
| <div class="block">Except</div> |
| </li> |
| </ul> |
| <a id="INTERSECT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>INTERSECT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> INTERSECT</pre> |
| <div class="block">Intersect</div> |
| </li> |
| </ul> |
| <a id="AS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>AS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> AS</pre> |
| <div class="block">AS operator</div> |
| </li> |
| </ul> |
| <a id="ARGUMENT_ASSIGNMENT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ARGUMENT_ASSIGNMENT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ARGUMENT_ASSIGNMENT</pre> |
| <div class="block">ARGUMENT_ASSIGNMENT operator, <code>=></code></div> |
| </li> |
| </ul> |
| <a id="DEFAULT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DEFAULT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DEFAULT</pre> |
| <div class="block">DEFAULT operator</div> |
| </li> |
| </ul> |
| <a id="OVER"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>OVER</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OVER</pre> |
| <div class="block">OVER operator</div> |
| </li> |
| </ul> |
| <a id="RESPECT_NULLS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>RESPECT_NULLS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> RESPECT_NULLS</pre> |
| <div class="block">RESPECT NULLS operator</div> |
| </li> |
| </ul> |
| <a id="IGNORE_NULLS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IGNORE_NULLS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IGNORE_NULLS</pre> |
| <div class="block">IGNORE NULLS operator</div> |
| </li> |
| </ul> |
| <a id="FILTER"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FILTER</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FILTER</pre> |
| <div class="block">FILTER operator</div> |
| </li> |
| </ul> |
| <a id="WITHIN_GROUP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>WITHIN_GROUP</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> WITHIN_GROUP</pre> |
| <div class="block">WITHIN_GROUP operator</div> |
| </li> |
| </ul> |
| <a id="WINDOW"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>WINDOW</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> WINDOW</pre> |
| <div class="block">Window specification</div> |
| </li> |
| </ul> |
| <a id="MERGE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MERGE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MERGE</pre> |
| <div class="block">MERGE statement</div> |
| </li> |
| </ul> |
| <a id="TABLESAMPLE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TABLESAMPLE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TABLESAMPLE</pre> |
| <div class="block">TABLESAMPLE operator</div> |
| </li> |
| </ul> |
| <a id="MATCH_RECOGNIZE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MATCH_RECOGNIZE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MATCH_RECOGNIZE</pre> |
| <div class="block">MATCH_RECOGNIZE clause</div> |
| </li> |
| </ul> |
| <a id="SNAPSHOT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SNAPSHOT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SNAPSHOT</pre> |
| <div class="block">SNAPSHOT operator</div> |
| </li> |
| </ul> |
| <a id="TIMES"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TIMES</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TIMES</pre> |
| <div class="block">The arithmetic multiplication operator, "*".</div> |
| </li> |
| </ul> |
| <a id="DIVIDE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DIVIDE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DIVIDE</pre> |
| <div class="block">The arithmetic division operator, "/".</div> |
| </li> |
| </ul> |
| <a id="MOD"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MOD</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MOD</pre> |
| <div class="block">The arithmetic remainder operator, "MOD" (and "%" in some dialects).</div> |
| </li> |
| </ul> |
| <a id="PLUS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PLUS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PLUS</pre> |
| <div class="block">The arithmetic plus operator, "+".</div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#PLUS_PREFIX"><code>PLUS_PREFIX</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="MINUS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MINUS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MINUS</pre> |
| <div class="block">The arithmetic minus operator, "-".</div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#MINUS_PREFIX"><code>MINUS_PREFIX</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="PATTERN_ALTER"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PATTERN_ALTER</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_ALTER</pre> |
| <div class="block">the alternation operator in a pattern expression within a match_recognize clause</div> |
| </li> |
| </ul> |
| <a id="PATTERN_CONCAT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PATTERN_CONCAT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_CONCAT</pre> |
| <div class="block">the concatenation operator in a pattern expression within a match_recognize clause</div> |
| </li> |
| </ul> |
| <a id="IN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IN</pre> |
| <div class="block">The "IN" operator.</div> |
| </li> |
| </ul> |
| <a id="NOT_IN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NOT_IN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NOT_IN</pre> |
| <div class="block">The "NOT IN" operator. |
| |
| <p>Only occurs in SqlNode trees. Is expanded to NOT(IN ...) before |
| entering RelNode land.</div> |
| </li> |
| </ul> |
| <a id="LESS_THAN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LESS_THAN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LESS_THAN</pre> |
| <div class="block">The less-than operator, "<".</div> |
| </li> |
| </ul> |
| <a id="GREATER_THAN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>GREATER_THAN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GREATER_THAN</pre> |
| <div class="block">The greater-than operator, ">".</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 <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LESS_THAN_OR_EQUAL</pre> |
| <div class="block">The less-than-or-equal operator, "<=".</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 <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GREATER_THAN_OR_EQUAL</pre> |
| <div class="block">The greater-than-or-equal operator, ">=".</div> |
| </li> |
| </ul> |
| <a id="EQUALS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EQUALS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EQUALS</pre> |
| <div class="block">The equals operator, "=".</div> |
| </li> |
| </ul> |
| <a id="NOT_EQUALS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NOT_EQUALS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NOT_EQUALS</pre> |
| <div class="block">The not-equals operator, "!=" or "<>". |
| The latter is standard, and preferred.</div> |
| </li> |
| </ul> |
| <a id="IS_DISTINCT_FROM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IS_DISTINCT_FROM</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_DISTINCT_FROM</pre> |
| <div class="block">The is-distinct-from 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 <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_NOT_DISTINCT_FROM</pre> |
| <div class="block">The is-not-distinct-from operator.</div> |
| </li> |
| </ul> |
| <a id="OR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>OR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OR</pre> |
| <div class="block">The logical "OR" operator.</div> |
| </li> |
| </ul> |
| <a id="AND"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>AND</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> AND</pre> |
| <div class="block">The logical "AND" operator.</div> |
| </li> |
| </ul> |
| <a id="DOT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DOT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DOT</pre> |
| <div class="block">Dot</div> |
| </li> |
| </ul> |
| <a id="OVERLAPS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>OVERLAPS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OVERLAPS</pre> |
| <div class="block">The "OVERLAPS" operator for periods.</div> |
| </li> |
| </ul> |
| <a id="CONTAINS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CONTAINS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CONTAINS</pre> |
| <div class="block">The "CONTAINS" operator for periods.</div> |
| </li> |
| </ul> |
| <a id="PRECEDES"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PRECEDES</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PRECEDES</pre> |
| <div class="block">The "PRECEDES" operator for periods.</div> |
| </li> |
| </ul> |
| <a id="IMMEDIATELY_PRECEDES"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IMMEDIATELY_PRECEDES</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IMMEDIATELY_PRECEDES</pre> |
| <div class="block">The "IMMEDIATELY PRECEDES" operator for periods.</div> |
| </li> |
| </ul> |
| <a id="SUCCEEDS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SUCCEEDS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SUCCEEDS</pre> |
| <div class="block">The "SUCCEEDS" operator for periods.</div> |
| </li> |
| </ul> |
| <a id="IMMEDIATELY_SUCCEEDS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IMMEDIATELY_SUCCEEDS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IMMEDIATELY_SUCCEEDS</pre> |
| <div class="block">The "IMMEDIATELY SUCCEEDS" operator for periods.</div> |
| </li> |
| </ul> |
| <a id="PERIOD_EQUALS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PERIOD_EQUALS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PERIOD_EQUALS</pre> |
| <div class="block">The "EQUALS" operator for periods.</div> |
| </li> |
| </ul> |
| <a id="LIKE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LIKE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LIKE</pre> |
| <div class="block">The "LIKE" operator.</div> |
| </li> |
| </ul> |
| <a id="SIMILAR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SIMILAR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SIMILAR</pre> |
| <div class="block">The "SIMILAR" operator.</div> |
| </li> |
| </ul> |
| <a id="POSIX_REGEX_CASE_SENSITIVE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>POSIX_REGEX_CASE_SENSITIVE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> POSIX_REGEX_CASE_SENSITIVE</pre> |
| <div class="block">The "~" operator.</div> |
| </li> |
| </ul> |
| <a id="POSIX_REGEX_CASE_INSENSITIVE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>POSIX_REGEX_CASE_INSENSITIVE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> POSIX_REGEX_CASE_INSENSITIVE</pre> |
| <div class="block">The "~*" operator.</div> |
| </li> |
| </ul> |
| <a id="BETWEEN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>BETWEEN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> BETWEEN</pre> |
| <div class="block">The "BETWEEN" operator.</div> |
| </li> |
| </ul> |
| <a id="CASE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CASE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CASE</pre> |
| <div class="block">A "CASE" expression.</div> |
| </li> |
| </ul> |
| <a id="NULLIF"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NULLIF</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NULLIF</pre> |
| <div class="block">The "NULLIF" operator.</div> |
| </li> |
| </ul> |
| <a id="COALESCE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COALESCE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COALESCE</pre> |
| <div class="block">The "COALESCE" operator.</div> |
| </li> |
| </ul> |
| <a id="DECODE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DECODE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DECODE</pre> |
| <div class="block">The "DECODE" function (Oracle).</div> |
| </li> |
| </ul> |
| <a id="NVL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NVL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NVL</pre> |
| <div class="block">The "NVL" function (Oracle).</div> |
| </li> |
| </ul> |
| <a id="GREATEST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>GREATEST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GREATEST</pre> |
| <div class="block">The "GREATEST" function (Oracle).</div> |
| </li> |
| </ul> |
| <a id="LEAST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LEAST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LEAST</pre> |
| <div class="block">The "LEAST" function (Oracle).</div> |
| </li> |
| </ul> |
| <a id="TIMESTAMP_ADD"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TIMESTAMP_ADD</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TIMESTAMP_ADD</pre> |
| <div class="block">The "TIMESTAMP_ADD" function (ODBC, SQL Server, MySQL).</div> |
| </li> |
| </ul> |
| <a id="TIMESTAMP_DIFF"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TIMESTAMP_DIFF</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TIMESTAMP_DIFF</pre> |
| <div class="block">The "TIMESTAMP_DIFF" function (ODBC, SQL Server, MySQL).</div> |
| </li> |
| </ul> |
| <a id="NOT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NOT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NOT</pre> |
| <div class="block">The logical "NOT" operator.</div> |
| </li> |
| </ul> |
| <a id="PLUS_PREFIX"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PLUS_PREFIX</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PLUS_PREFIX</pre> |
| <div class="block">The unary plus operator, as in "+1".</div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#PLUS"><code>PLUS</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="MINUS_PREFIX"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MINUS_PREFIX</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MINUS_PREFIX</pre> |
| <div class="block">The unary minus operator, as in "-1".</div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#MINUS"><code>MINUS</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="EXISTS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EXISTS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXISTS</pre> |
| <div class="block">The "EXISTS" operator.</div> |
| </li> |
| </ul> |
| <a id="SOME"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SOME</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SOME</pre> |
| <div class="block">The "SOME" quantification operator (also called "ANY").</div> |
| </li> |
| </ul> |
| <a id="ALL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ALL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALL</pre> |
| <div class="block">The "ALL" quantification operator.</div> |
| </li> |
| </ul> |
| <a id="VALUES"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>VALUES</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> VALUES</pre> |
| <div class="block">The "VALUES" operator.</div> |
| </li> |
| </ul> |
| <a id="EXPLICIT_TABLE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EXPLICIT_TABLE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXPLICIT_TABLE</pre> |
| <div class="block">Explicit table, e.g. <code>select * from (TABLE t)</code> or <code>TABLE |
| t</code>. See also <a href="#COLLECTION_TABLE"><code>COLLECTION_TABLE</code></a>.</div> |
| </li> |
| </ul> |
| <a id="SCALAR_QUERY"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SCALAR_QUERY</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SCALAR_QUERY</pre> |
| <div class="block">Scalar query; that is, a sub-query used in an expression context, and |
| returning one row and one column.</div> |
| </li> |
| </ul> |
| <a id="PROCEDURE_CALL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PROCEDURE_CALL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PROCEDURE_CALL</pre> |
| <div class="block">ProcedureCall</div> |
| </li> |
| </ul> |
| <a id="NEW_SPECIFICATION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NEW_SPECIFICATION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NEW_SPECIFICATION</pre> |
| <div class="block">NewSpecification</div> |
| </li> |
| </ul> |
| <a id="FINAL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FINAL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FINAL</pre> |
| <div class="block">Special functions in MATCH_RECOGNIZE.</div> |
| </li> |
| </ul> |
| <a id="RUNNING"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>RUNNING</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> RUNNING</pre> |
| </li> |
| </ul> |
| <a id="PREV"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PREV</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PREV</pre> |
| </li> |
| </ul> |
| <a id="NEXT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NEXT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NEXT</pre> |
| </li> |
| </ul> |
| <a id="FIRST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FIRST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FIRST</pre> |
| </li> |
| </ul> |
| <a id="LAST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LAST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LAST</pre> |
| </li> |
| </ul> |
| <a id="CLASSIFIER"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CLASSIFIER</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CLASSIFIER</pre> |
| </li> |
| </ul> |
| <a id="MATCH_NUMBER"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MATCH_NUMBER</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MATCH_NUMBER</pre> |
| </li> |
| </ul> |
| <a id="SKIP_TO_FIRST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SKIP_TO_FIRST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SKIP_TO_FIRST</pre> |
| <div class="block">The "SKIP TO FIRST" qualifier of restarting point in a MATCH_RECOGNIZE |
| clause.</div> |
| </li> |
| </ul> |
| <a id="SKIP_TO_LAST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SKIP_TO_LAST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SKIP_TO_LAST</pre> |
| <div class="block">The "SKIP TO LAST" qualifier of restarting point in a MATCH_RECOGNIZE |
| clause.</div> |
| </li> |
| </ul> |
| <a id="DESCENDING"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DESCENDING</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DESCENDING</pre> |
| <div class="block">DESC in ORDER BY. A parse tree, not a true expression.</div> |
| </li> |
| </ul> |
| <a id="NULLS_FIRST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NULLS_FIRST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NULLS_FIRST</pre> |
| <div class="block">NULLS FIRST clause in ORDER BY. A parse tree, not a true expression.</div> |
| </li> |
| </ul> |
| <a id="NULLS_LAST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NULLS_LAST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NULLS_LAST</pre> |
| <div class="block">NULLS LAST clause in ORDER BY. A parse tree, not a true expression.</div> |
| </li> |
| </ul> |
| <a id="IS_TRUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IS_TRUE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_TRUE</pre> |
| <div class="block">The "IS TRUE" operator.</div> |
| </li> |
| </ul> |
| <a id="IS_FALSE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IS_FALSE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_FALSE</pre> |
| <div class="block">The "IS FALSE" operator.</div> |
| </li> |
| </ul> |
| <a id="IS_NOT_TRUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IS_NOT_TRUE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_NOT_TRUE</pre> |
| <div class="block">The "IS NOT TRUE" operator.</div> |
| </li> |
| </ul> |
| <a id="IS_NOT_FALSE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IS_NOT_FALSE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_NOT_FALSE</pre> |
| <div class="block">The "IS NOT FALSE" operator.</div> |
| </li> |
| </ul> |
| <a id="IS_UNKNOWN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IS_UNKNOWN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_UNKNOWN</pre> |
| <div class="block">The "IS UNKNOWN" operator.</div> |
| </li> |
| </ul> |
| <a id="IS_NULL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IS_NULL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_NULL</pre> |
| <div class="block">The "IS NULL" operator.</div> |
| </li> |
| </ul> |
| <a id="IS_NOT_NULL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>IS_NOT_NULL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> IS_NOT_NULL</pre> |
| <div class="block">The "IS NOT NULL" operator.</div> |
| </li> |
| </ul> |
| <a id="PRECEDING"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PRECEDING</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PRECEDING</pre> |
| <div class="block">The "PRECEDING" qualifier of an interval end-point in a window |
| specification.</div> |
| </li> |
| </ul> |
| <a id="FOLLOWING"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FOLLOWING</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FOLLOWING</pre> |
| <div class="block">The "FOLLOWING" qualifier of an interval end-point in a window |
| specification.</div> |
| </li> |
| </ul> |
| <a id="FIELD_ACCESS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FIELD_ACCESS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FIELD_ACCESS</pre> |
| <div class="block">The field access operator, ".". |
| |
| <p>(Only used at the RexNode level; at |
| SqlNode level, a field-access is part of an identifier.)</p></div> |
| </li> |
| </ul> |
| <a id="INPUT_REF"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>INPUT_REF</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> INPUT_REF</pre> |
| <div class="block">Reference to an input field. |
| |
| <p>(Only used at the RexNode level.)</p></div> |
| </li> |
| </ul> |
| <a id="TABLE_INPUT_REF"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TABLE_INPUT_REF</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TABLE_INPUT_REF</pre> |
| <div class="block">Reference to an input field, with a qualified name and an identifier |
| |
| <p>(Only used at the RexNode level.)</p></div> |
| </li> |
| </ul> |
| <a id="PATTERN_INPUT_REF"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PATTERN_INPUT_REF</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_INPUT_REF</pre> |
| <div class="block">Reference to an input field, with pattern var as modifier |
| |
| <p>(Only used at the RexNode level.)</p></div> |
| </li> |
| </ul> |
| <a id="LOCAL_REF"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LOCAL_REF</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LOCAL_REF</pre> |
| <div class="block">Reference to a sub-expression computed within the current relational |
| operator. |
| |
| <p>(Only used at the RexNode level.)</p></div> |
| </li> |
| </ul> |
| <a id="CORREL_VARIABLE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CORREL_VARIABLE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CORREL_VARIABLE</pre> |
| <div class="block">Reference to correlation variable. |
| |
| <p>(Only used at the RexNode level.)</p></div> |
| </li> |
| </ul> |
| <a id="PATTERN_QUANTIFIER"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PATTERN_QUANTIFIER</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_QUANTIFIER</pre> |
| <div class="block">the repetition quantifier of a pattern factor in a match_recognize clause.</div> |
| </li> |
| </ul> |
| <a id="ROW"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ROW</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ROW</pre> |
| <div class="block">The row-constructor function. May be explicit or implicit: |
| <code>VALUES 1, ROW (2)</code>.</div> |
| </li> |
| </ul> |
| <a id="COLUMN_LIST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COLUMN_LIST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COLUMN_LIST</pre> |
| <div class="block">The non-standard constructor used to pass a |
| COLUMN_LIST parameter to a user-defined transform.</div> |
| </li> |
| </ul> |
| <a id="CAST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CAST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CAST</pre> |
| <div class="block">The "CAST" operator, and also the PostgreSQL-style infix cast operator |
| "::".</div> |
| </li> |
| </ul> |
| <a id="NEXT_VALUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NEXT_VALUE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NEXT_VALUE</pre> |
| <div class="block">The "NEXT VALUE OF sequence" operator.</div> |
| </li> |
| </ul> |
| <a id="CURRENT_VALUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CURRENT_VALUE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CURRENT_VALUE</pre> |
| <div class="block">The "CURRENT VALUE OF sequence" operator.</div> |
| </li> |
| </ul> |
| <a id="FLOOR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FLOOR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FLOOR</pre> |
| <div class="block">The "FLOOR" function</div> |
| </li> |
| </ul> |
| <a id="CEIL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CEIL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CEIL</pre> |
| <div class="block">The "CEIL" function</div> |
| </li> |
| </ul> |
| <a id="TRIM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TRIM</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TRIM</pre> |
| <div class="block">The "TRIM" function.</div> |
| </li> |
| </ul> |
| <a id="LTRIM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LTRIM</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LTRIM</pre> |
| <div class="block">The "LTRIM" function (Oracle).</div> |
| </li> |
| </ul> |
| <a id="RTRIM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>RTRIM</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> RTRIM</pre> |
| <div class="block">The "RTRIM" function (Oracle).</div> |
| </li> |
| </ul> |
| <a id="EXTRACT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EXTRACT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXTRACT</pre> |
| <div class="block">The "EXTRACT" function.</div> |
| </li> |
| </ul> |
| <a id="REVERSE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>REVERSE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> REVERSE</pre> |
| <div class="block">The "REVERSE" function (SQL Server, MySQL).</div> |
| </li> |
| </ul> |
| <a id="JDBC_FN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JDBC_FN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> JDBC_FN</pre> |
| <div class="block">Call to a function using JDBC function syntax.</div> |
| </li> |
| </ul> |
| <a id="MULTISET_VALUE_CONSTRUCTOR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MULTISET_VALUE_CONSTRUCTOR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MULTISET_VALUE_CONSTRUCTOR</pre> |
| <div class="block">The MULTISET value constructor.</div> |
| </li> |
| </ul> |
| <a id="MULTISET_QUERY_CONSTRUCTOR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MULTISET_QUERY_CONSTRUCTOR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MULTISET_QUERY_CONSTRUCTOR</pre> |
| <div class="block">The MULTISET query constructor.</div> |
| </li> |
| </ul> |
| <a id="JSON_VALUE_EXPRESSION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JSON_VALUE_EXPRESSION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> JSON_VALUE_EXPRESSION</pre> |
| <div class="block">The JSON value expression.</div> |
| </li> |
| </ul> |
| <a id="JSON_ARRAYAGG"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JSON_ARRAYAGG</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> JSON_ARRAYAGG</pre> |
| <div class="block">The <code>JSON_ARRAYAGG</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="JSON_OBJECTAGG"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JSON_OBJECTAGG</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> JSON_OBJECTAGG</pre> |
| <div class="block">The <code>JSON_OBJECTAGG</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="UNNEST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>UNNEST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> UNNEST</pre> |
| <div class="block">The "UNNEST" operator.</div> |
| </li> |
| </ul> |
| <a id="LATERAL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LATERAL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LATERAL</pre> |
| <div class="block">The "LATERAL" qualifier to relations in the FROM clause.</div> |
| </li> |
| </ul> |
| <a id="COLLECTION_TABLE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COLLECTION_TABLE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COLLECTION_TABLE</pre> |
| <div class="block">Table operator which converts user-defined transform into a relation, for |
| example, <code>select * from TABLE(udx(x, y, z))</code>. See also the |
| <a href="#EXPLICIT_TABLE"><code>EXPLICIT_TABLE</code></a> prefix operator.</div> |
| </li> |
| </ul> |
| <a id="ARRAY_VALUE_CONSTRUCTOR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ARRAY_VALUE_CONSTRUCTOR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ARRAY_VALUE_CONSTRUCTOR</pre> |
| <div class="block">Array Value Constructor, e.g. <code>Array[1, 2, 3]</code>.</div> |
| </li> |
| </ul> |
| <a id="ARRAY_QUERY_CONSTRUCTOR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ARRAY_QUERY_CONSTRUCTOR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ARRAY_QUERY_CONSTRUCTOR</pre> |
| <div class="block">Array Query Constructor, e.g. <code>Array(select deptno from dept)</code>.</div> |
| </li> |
| </ul> |
| <a id="MAP_VALUE_CONSTRUCTOR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MAP_VALUE_CONSTRUCTOR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MAP_VALUE_CONSTRUCTOR</pre> |
| <div class="block">Map Value Constructor, e.g. <code>Map['washington', 1, 'obama', 44]</code>.</div> |
| </li> |
| </ul> |
| <a id="MAP_QUERY_CONSTRUCTOR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MAP_QUERY_CONSTRUCTOR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MAP_QUERY_CONSTRUCTOR</pre> |
| <div class="block">Map Query Constructor, e.g. <code>MAP (SELECT empno, deptno FROM emp)</code>.</div> |
| </li> |
| </ul> |
| <a id="CURSOR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CURSOR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CURSOR</pre> |
| <div class="block">CURSOR constructor, for example, <code>select * from |
| TABLE(udx(CURSOR(select ...), x, y, z))</code></div> |
| </li> |
| </ul> |
| <a id="LITERAL_CHAIN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LITERAL_CHAIN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LITERAL_CHAIN</pre> |
| <div class="block">Literal chain operator (for composite string literals). |
| An internal operator that does not appear in SQL syntax.</div> |
| </li> |
| </ul> |
| <a id="ESCAPE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ESCAPE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ESCAPE</pre> |
| <div class="block">Escape operator (always part of LIKE or SIMILAR TO expression). |
| An internal operator that does not appear in SQL syntax.</div> |
| </li> |
| </ul> |
| <a id="REINTERPRET"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>REINTERPRET</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> REINTERPRET</pre> |
| <div class="block">The internal REINTERPRET operator (meaning a reinterpret cast). |
| An internal operator that does not appear in SQL syntax.</div> |
| </li> |
| </ul> |
| <a id="EXTEND"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EXTEND</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> EXTEND</pre> |
| <div class="block">The internal <code>EXTEND</code> operator that qualifies a table name in the |
| <code>FROM</code> clause.</div> |
| </li> |
| </ul> |
| <a id="CUBE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CUBE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CUBE</pre> |
| <div class="block">The internal <code>CUBE</code> operator that occurs within a <code>GROUP BY</code> |
| clause.</div> |
| </li> |
| </ul> |
| <a id="ROLLUP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ROLLUP</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ROLLUP</pre> |
| <div class="block">The internal <code>ROLLUP</code> operator that occurs within a <code>GROUP BY</code> |
| clause.</div> |
| </li> |
| </ul> |
| <a id="GROUPING_SETS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>GROUPING_SETS</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GROUPING_SETS</pre> |
| <div class="block">The internal <code>GROUPING SETS</code> operator that occurs within a |
| <code>GROUP BY</code> clause.</div> |
| </li> |
| </ul> |
| <a id="GROUPING"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>GROUPING</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GROUPING</pre> |
| <div class="block">The <code>GROUPING(e, ...)</code> function.</div> |
| </li> |
| </ul> |
| <a id="GROUPING_ID"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>GROUPING_ID</h4> |
| <pre>@Deprecated |
| public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GROUPING_ID</pre> |
| <div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">Use <a href="#GROUPING"><code>GROUPING</code></a>.</div> |
| </div> |
| </li> |
| </ul> |
| <a id="GROUP_ID"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>GROUP_ID</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> GROUP_ID</pre> |
| <div class="block">The <code>GROUP_ID()</code> function.</div> |
| </li> |
| </ul> |
| <a id="PATTERN_PERMUTE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PATTERN_PERMUTE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_PERMUTE</pre> |
| <div class="block">The internal "permute" function in a MATCH_RECOGNIZE clause.</div> |
| </li> |
| </ul> |
| <a id="PATTERN_EXCLUDED"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PATTERN_EXCLUDED</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PATTERN_EXCLUDED</pre> |
| <div class="block">The special patterns to exclude enclosing pattern from output in a |
| MATCH_RECOGNIZE clause.</div> |
| </li> |
| </ul> |
| <a id="COUNT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COUNT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COUNT</pre> |
| <div class="block">The <code>COUNT</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="SUM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SUM</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SUM</pre> |
| <div class="block">The <code>SUM</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="SUM0"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SUM0</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SUM0</pre> |
| <div class="block">The <code>SUM0</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="MIN"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MIN</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MIN</pre> |
| <div class="block">The <code>MIN</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="MAX"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MAX</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> MAX</pre> |
| <div class="block">The <code>MAX</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="LEAD"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LEAD</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LEAD</pre> |
| <div class="block">The <code>LEAD</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="LAG"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LAG</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LAG</pre> |
| <div class="block">The <code>LAG</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="FIRST_VALUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FIRST_VALUE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FIRST_VALUE</pre> |
| <div class="block">The <code>FIRST_VALUE</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="LAST_VALUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LAST_VALUE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LAST_VALUE</pre> |
| <div class="block">The <code>LAST_VALUE</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="ANY_VALUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ANY_VALUE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ANY_VALUE</pre> |
| <div class="block">The <code>ANY_VALUE</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="COVAR_POP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COVAR_POP</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COVAR_POP</pre> |
| <div class="block">The <code>COVAR_POP</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="COVAR_SAMP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COVAR_SAMP</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COVAR_SAMP</pre> |
| <div class="block">The <code>COVAR_SAMP</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="REGR_COUNT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>REGR_COUNT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> REGR_COUNT</pre> |
| <div class="block">The <code>REGR_COUNT</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="REGR_SXX"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>REGR_SXX</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> REGR_SXX</pre> |
| <div class="block">The <code>REGR_SXX</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="REGR_SYY"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>REGR_SYY</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> REGR_SYY</pre> |
| <div class="block">The <code>REGR_SYY</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="AVG"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>AVG</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> AVG</pre> |
| <div class="block">The <code>AVG</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="STDDEV_POP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>STDDEV_POP</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> STDDEV_POP</pre> |
| <div class="block">The <code>STDDEV_POP</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="STDDEV_SAMP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>STDDEV_SAMP</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> STDDEV_SAMP</pre> |
| <div class="block">The <code>STDDEV_SAMP</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="VAR_POP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>VAR_POP</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> VAR_POP</pre> |
| <div class="block">The <code>VAR_POP</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="VAR_SAMP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>VAR_SAMP</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> VAR_SAMP</pre> |
| <div class="block">The <code>VAR_SAMP</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="NTILE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NTILE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NTILE</pre> |
| <div class="block">The <code>NTILE</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="NTH_VALUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NTH_VALUE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> NTH_VALUE</pre> |
| <div class="block">The <code>NTH_VALUE</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="LISTAGG"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LISTAGG</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> LISTAGG</pre> |
| <div class="block">The <code>LISTAGG</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="COLLECT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COLLECT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COLLECT</pre> |
| <div class="block">The <code>COLLECT</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="FUSION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FUSION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FUSION</pre> |
| <div class="block">The <code>FUSION</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="SINGLE_VALUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SINGLE_VALUE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SINGLE_VALUE</pre> |
| <div class="block">The <code>SINGLE_VALUE</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="BIT_AND"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>BIT_AND</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> BIT_AND</pre> |
| <div class="block">The <code>BIT_AND</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="BIT_OR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>BIT_OR</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> BIT_OR</pre> |
| <div class="block">The <code>BIT_OR</code> aggregate function.</div> |
| </li> |
| </ul> |
| <a id="ROW_NUMBER"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ROW_NUMBER</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ROW_NUMBER</pre> |
| <div class="block">The <code>ROW_NUMBER</code> window function.</div> |
| </li> |
| </ul> |
| <a id="RANK"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>RANK</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> RANK</pre> |
| <div class="block">The <code>RANK</code> window function.</div> |
| </li> |
| </ul> |
| <a id="PERCENT_RANK"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PERCENT_RANK</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PERCENT_RANK</pre> |
| <div class="block">The <code>PERCENT_RANK</code> window function.</div> |
| </li> |
| </ul> |
| <a id="DENSE_RANK"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DENSE_RANK</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DENSE_RANK</pre> |
| <div class="block">The <code>DENSE_RANK</code> window function.</div> |
| </li> |
| </ul> |
| <a id="CUME_DIST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CUME_DIST</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CUME_DIST</pre> |
| <div class="block">The <code>ROW_NUMBER</code> window function.</div> |
| </li> |
| </ul> |
| <a id="TUMBLE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TUMBLE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TUMBLE</pre> |
| <div class="block">The <code>TUMBLE</code> group function.</div> |
| </li> |
| </ul> |
| <a id="TUMBLE_START"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TUMBLE_START</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TUMBLE_START</pre> |
| <div class="block">The <code>TUMBLE_START</code> auxiliary function of |
| the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div> |
| </li> |
| </ul> |
| <a id="TUMBLE_END"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TUMBLE_END</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> TUMBLE_END</pre> |
| <div class="block">The <code>TUMBLE_END</code> auxiliary function of |
| the <a href="#TUMBLE"><code>TUMBLE</code></a> group function.</div> |
| </li> |
| </ul> |
| <a id="HOP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>HOP</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> HOP</pre> |
| <div class="block">The <code>HOP</code> group function.</div> |
| </li> |
| </ul> |
| <a id="HOP_START"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>HOP_START</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> HOP_START</pre> |
| <div class="block">The <code>HOP_START</code> auxiliary function of |
| the <a href="#HOP"><code>HOP</code></a> group function.</div> |
| </li> |
| </ul> |
| <a id="HOP_END"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>HOP_END</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> HOP_END</pre> |
| <div class="block">The <code>HOP_END</code> auxiliary function of |
| the <a href="#HOP"><code>HOP</code></a> group function.</div> |
| </li> |
| </ul> |
| <a id="SESSION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SESSION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SESSION</pre> |
| <div class="block">The <code>SESSION</code> group function.</div> |
| </li> |
| </ul> |
| <a id="SESSION_START"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SESSION_START</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SESSION_START</pre> |
| <div class="block">The <code>SESSION_START</code> auxiliary function of |
| the <a href="#SESSION"><code>SESSION</code></a> group function.</div> |
| </li> |
| </ul> |
| <a id="SESSION_END"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SESSION_END</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> SESSION_END</pre> |
| <div class="block">The <code>SESSION_END</code> auxiliary function of |
| the <a href="#SESSION"><code>SESSION</code></a> group function.</div> |
| </li> |
| </ul> |
| <a id="COLUMN_DECL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COLUMN_DECL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COLUMN_DECL</pre> |
| <div class="block">Column declaration.</div> |
| </li> |
| </ul> |
| <a id="ATTRIBUTE_DEF"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ATTRIBUTE_DEF</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ATTRIBUTE_DEF</pre> |
| <div class="block">Attribute definition.</div> |
| </li> |
| </ul> |
| <a id="CHECK"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CHECK</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CHECK</pre> |
| <div class="block"><code>CHECK</code> constraint.</div> |
| </li> |
| </ul> |
| <a id="UNIQUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>UNIQUE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> UNIQUE</pre> |
| <div class="block"><code>UNIQUE</code> constraint.</div> |
| </li> |
| </ul> |
| <a id="PRIMARY_KEY"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PRIMARY_KEY</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> PRIMARY_KEY</pre> |
| <div class="block"><code>PRIMARY KEY</code> constraint.</div> |
| </li> |
| </ul> |
| <a id="FOREIGN_KEY"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FOREIGN_KEY</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> FOREIGN_KEY</pre> |
| <div class="block"><code>FOREIGN KEY</code> constraint.</div> |
| </li> |
| </ul> |
| <a id="COMMIT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COMMIT</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> COMMIT</pre> |
| <div class="block"><code>COMMIT</code> session control statement.</div> |
| </li> |
| </ul> |
| <a id="ROLLBACK"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ROLLBACK</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ROLLBACK</pre> |
| <div class="block"><code>ROLLBACK</code> session control statement.</div> |
| </li> |
| </ul> |
| <a id="ALTER_SESSION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ALTER_SESSION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_SESSION</pre> |
| <div class="block"><code>ALTER SESSION</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="CREATE_SCHEMA"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CREATE_SCHEMA</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_SCHEMA</pre> |
| <div class="block"><code>CREATE SCHEMA</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="CREATE_FOREIGN_SCHEMA"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CREATE_FOREIGN_SCHEMA</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_FOREIGN_SCHEMA</pre> |
| <div class="block"><code>CREATE FOREIGN SCHEMA</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="DROP_SCHEMA"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DROP_SCHEMA</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_SCHEMA</pre> |
| <div class="block"><code>DROP SCHEMA</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="CREATE_TABLE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CREATE_TABLE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_TABLE</pre> |
| <div class="block"><code>CREATE TABLE</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="ALTER_TABLE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ALTER_TABLE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_TABLE</pre> |
| <div class="block"><code>ALTER TABLE</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="DROP_TABLE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DROP_TABLE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_TABLE</pre> |
| <div class="block"><code>DROP TABLE</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="CREATE_VIEW"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CREATE_VIEW</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_VIEW</pre> |
| <div class="block"><code>CREATE VIEW</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="ALTER_VIEW"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ALTER_VIEW</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_VIEW</pre> |
| <div class="block"><code>ALTER VIEW</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="DROP_VIEW"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DROP_VIEW</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_VIEW</pre> |
| <div class="block"><code>DROP VIEW</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="CREATE_MATERIALIZED_VIEW"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CREATE_MATERIALIZED_VIEW</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_MATERIALIZED_VIEW</pre> |
| <div class="block"><code>CREATE MATERIALIZED VIEW</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="ALTER_MATERIALIZED_VIEW"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ALTER_MATERIALIZED_VIEW</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_MATERIALIZED_VIEW</pre> |
| <div class="block"><code>ALTER MATERIALIZED VIEW</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="DROP_MATERIALIZED_VIEW"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DROP_MATERIALIZED_VIEW</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_MATERIALIZED_VIEW</pre> |
| <div class="block"><code>DROP MATERIALIZED VIEW</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="CREATE_SEQUENCE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CREATE_SEQUENCE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_SEQUENCE</pre> |
| <div class="block"><code>CREATE SEQUENCE</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="ALTER_SEQUENCE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ALTER_SEQUENCE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_SEQUENCE</pre> |
| <div class="block"><code>ALTER SEQUENCE</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="DROP_SEQUENCE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DROP_SEQUENCE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_SEQUENCE</pre> |
| <div class="block"><code>DROP SEQUENCE</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="CREATE_INDEX"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CREATE_INDEX</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_INDEX</pre> |
| <div class="block"><code>CREATE INDEX</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="ALTER_INDEX"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ALTER_INDEX</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> ALTER_INDEX</pre> |
| <div class="block"><code>ALTER INDEX</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="DROP_INDEX"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DROP_INDEX</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_INDEX</pre> |
| <div class="block"><code>DROP INDEX</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="CREATE_TYPE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CREATE_TYPE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_TYPE</pre> |
| <div class="block"><code>CREATE TYPE</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="DROP_TYPE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DROP_TYPE</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_TYPE</pre> |
| <div class="block"><code>DROP TYPE</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="CREATE_FUNCTION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CREATE_FUNCTION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> CREATE_FUNCTION</pre> |
| <div class="block"><code>CREATE FUNCTION</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="DROP_FUNCTION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DROP_FUNCTION</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> DROP_FUNCTION</pre> |
| <div class="block"><code>DROP FUNCTION</code> DDL statement.</div> |
| </li> |
| </ul> |
| <a id="OTHER_DDL"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>OTHER_DDL</h4> |
| <pre>public static final <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> OTHER_DDL</pre> |
| <div class="block">DDL statement not handled above. |
| |
| <p><b>Note to other projects</b>: If you are extending Calcite's SQL parser |
| and have your own object types you no doubt want to define CREATE and DROP |
| commands for them. Use OTHER_DDL in the short term, but we are happy to add |
| new enum values for your object types. Just ask!</div> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| <!-- ============ FIELD DETAIL =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="field.detail"> |
| <!-- --> |
| </a> |
| <h3>Field Detail</h3> |
| <a id="SET_QUERY"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SET_QUERY</h4> |
| <pre>public static final java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> SET_QUERY</pre> |
| <div class="block">Category consisting of set-query node types. |
| |
| <p>Consists of: |
| <a href="#EXCEPT"><code>EXCEPT</code></a>, |
| <a href="#INTERSECT"><code>INTERSECT</code></a>, |
| <a href="#UNION"><code>UNION</code></a>.</div> |
| </li> |
| </ul> |
| <a id="AGGREGATE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>AGGREGATE</h4> |
| <pre>public static final java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> AGGREGATE</pre> |
| <div class="block">Category consisting of all built-in aggregate functions.</div> |
| </li> |
| </ul> |
| <a id="DML"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DML</h4> |
| <pre>public static final java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> DML</pre> |
| <div class="block">Category consisting of all DML operators. |
| |
| <p>Consists of: |
| <a href="#INSERT"><code>INSERT</code></a>, |
| <a href="#UPDATE"><code>UPDATE</code></a>, |
| <a href="#DELETE"><code>DELETE</code></a>, |
| <a href="#MERGE"><code>MERGE</code></a>, |
| <a href="#PROCEDURE_CALL"><code>PROCEDURE_CALL</code></a>. |
| |
| <p>NOTE jvs 1-June-2006: For now we treat procedure calls as DML; |
| this makes it easy for JDBC clients to call execute or |
| executeUpdate and not have to process dummy cursor results. If |
| in the future we support procedures which return results sets, |
| we'll need to refine this.</div> |
| </li> |
| </ul> |
| <a id="DDL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DDL</h4> |
| <pre>public static final java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> DDL</pre> |
| <div class="block">Category consisting of all DDL operators.</div> |
| </li> |
| </ul> |
| <a id="QUERY"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>QUERY</h4> |
| <pre>public static final java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> QUERY</pre> |
| <div class="block">Category consisting of query node types. |
| |
| <p>Consists of: |
| <a href="#SELECT"><code>SELECT</code></a>, |
| <a href="#EXCEPT"><code>EXCEPT</code></a>, |
| <a href="#INTERSECT"><code>INTERSECT</code></a>, |
| <a href="#UNION"><code>UNION</code></a>, |
| <a href="#VALUES"><code>VALUES</code></a>, |
| <a href="#ORDER_BY"><code>ORDER_BY</code></a>, |
| <a href="#EXPLICIT_TABLE"><code>EXPLICIT_TABLE</code></a>.</div> |
| </li> |
| </ul> |
| <a id="EXPRESSION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EXPRESSION</h4> |
| <pre>public static final java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> EXPRESSION</pre> |
| <div class="block">Category consisting of all expression operators. |
| |
| <p>A node is an expression if it is NOT one of the following: |
| <a href="#AS"><code>AS</code></a>, |
| <a href="#ARGUMENT_ASSIGNMENT"><code>ARGUMENT_ASSIGNMENT</code></a>, |
| <a href="#DEFAULT"><code>DEFAULT</code></a>, |
| <a href="#DESCENDING"><code>DESCENDING</code></a>, |
| <a href="#SELECT"><code>SELECT</code></a>, |
| <a href="#JOIN"><code>JOIN</code></a>, |
| <a href="#OTHER_FUNCTION"><code>OTHER_FUNCTION</code></a>, |
| <a href="#CAST"><code>CAST</code></a>, |
| <a href="#TRIM"><code>TRIM</code></a>, |
| <a href="#LITERAL_CHAIN"><code>LITERAL_CHAIN</code></a>, |
| <a href="#JDBC_FN"><code>JDBC_FN</code></a>, |
| <a href="#PRECEDING"><code>PRECEDING</code></a>, |
| <a href="#FOLLOWING"><code>FOLLOWING</code></a>, |
| <a href="#ORDER_BY"><code>ORDER_BY</code></a>, |
| <a href="#COLLECTION_TABLE"><code>COLLECTION_TABLE</code></a>, |
| <a href="#TABLESAMPLE"><code>TABLESAMPLE</code></a>, |
| or an aggregate function, DML or DDL.</div> |
| </li> |
| </ul> |
| <a id="TOP_LEVEL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TOP_LEVEL</h4> |
| <pre>public static final java.util.EnumSet<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> TOP_LEVEL</pre> |
| <div class="block">Category of all SQL statement types. |
| |
| <p>Consists of all types in <a href="#QUERY"><code>QUERY</code></a>, <a href="#DML"><code>DML</code></a> and <a href="#DDL"><code>DDL</code></a>.</div> |
| </li> |
| </ul> |
| <a id="FUNCTION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FUNCTION</h4> |
| <pre>public static final java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> FUNCTION</pre> |
| <div class="block">Category consisting of regular and special functions. |
| |
| <p>Consists of regular functions <a href="#OTHER_FUNCTION"><code>OTHER_FUNCTION</code></a> and special |
| functions <a href="#ROW"><code>ROW</code></a>, <a href="#TRIM"><code>TRIM</code></a>, <a href="#CAST"><code>CAST</code></a>, <a href="#REVERSE"><code>REVERSE</code></a>, <a href="#JDBC_FN"><code>JDBC_FN</code></a>.</div> |
| </li> |
| </ul> |
| <a id="AVG_AGG_FUNCTIONS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>AVG_AGG_FUNCTIONS</h4> |
| <pre>public static final java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> AVG_AGG_FUNCTIONS</pre> |
| <div class="block">Category of SqlAvgAggFunction. |
| |
| <p>Consists of <a href="#AVG"><code>AVG</code></a>, <a href="#STDDEV_POP"><code>STDDEV_POP</code></a>, <a href="#STDDEV_SAMP"><code>STDDEV_SAMP</code></a>, |
| <a href="#VAR_POP"><code>VAR_POP</code></a>, <a href="#VAR_SAMP"><code>VAR_SAMP</code></a>.</div> |
| </li> |
| </ul> |
| <a id="COVAR_AVG_AGG_FUNCTIONS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COVAR_AVG_AGG_FUNCTIONS</h4> |
| <pre>public static final java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> COVAR_AVG_AGG_FUNCTIONS</pre> |
| <div class="block">Category of SqlCovarAggFunction. |
| |
| <p>Consists of <a href="#COVAR_POP"><code>COVAR_POP</code></a>, <a href="#COVAR_SAMP"><code>COVAR_SAMP</code></a>, <a href="#REGR_SXX"><code>REGR_SXX</code></a>, |
| <a href="#REGR_SYY"><code>REGR_SYY</code></a>.</div> |
| </li> |
| </ul> |
| <a id="COMPARISON"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COMPARISON</h4> |
| <pre>public static final java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> COMPARISON</pre> |
| <div class="block">Category of comparison operators. |
| |
| <p>Consists of: |
| <a href="#IN"><code>IN</code></a>, |
| <a href="#EQUALS"><code>EQUALS</code></a>, |
| <a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a>, |
| <a href="#LESS_THAN"><code>LESS_THAN</code></a>, |
| <a href="#GREATER_THAN"><code>GREATER_THAN</code></a>, |
| <a href="#LESS_THAN_OR_EQUAL"><code>LESS_THAN_OR_EQUAL</code></a>, |
| <a href="#GREATER_THAN_OR_EQUAL"><code>GREATER_THAN_OR_EQUAL</code></a>.</div> |
| </li> |
| </ul> |
| <a id="BINARY_ARITHMETIC"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>BINARY_ARITHMETIC</h4> |
| <pre>public static final java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> BINARY_ARITHMETIC</pre> |
| <div class="block">Category of binary arithmetic. |
| |
| <p>Consists of: |
| <a href="#PLUS"><code>PLUS</code></a> |
| <a href="#MINUS"><code>MINUS</code></a> |
| <a href="#TIMES"><code>TIMES</code></a> |
| <a href="#DIVIDE"><code>DIVIDE</code></a> |
| <a href="#MOD"><code>MOD</code></a>.</div> |
| </li> |
| </ul> |
| <a id="BINARY_EQUALITY"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>BINARY_EQUALITY</h4> |
| <pre>public static final java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> BINARY_EQUALITY</pre> |
| <div class="block">Category of binary equality. |
| |
| <p>Consists of: |
| <a href="#EQUALS"><code>EQUALS</code></a> |
| <a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a></div> |
| </li> |
| </ul> |
| <a id="BINARY_COMPARISON"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>BINARY_COMPARISON</h4> |
| <pre>public static final java.util.Set<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> BINARY_COMPARISON</pre> |
| <div class="block">Category of binary comparison. |
| |
| <p>Consists of: |
| <a href="#EQUALS"><code>EQUALS</code></a> |
| <a href="#NOT_EQUALS"><code>NOT_EQUALS</code></a> |
| <a href="#GREATER_THAN"><code>GREATER_THAN</code></a> |
| <a href="#GREATER_THAN_OR_EQUAL"><code>GREATER_THAN_OR_EQUAL</code></a> |
| <a href="#LESS_THAN"><code>LESS_THAN</code></a> |
| <a href="#LESS_THAN_OR_EQUAL"><code>LESS_THAN_OR_EQUAL</code></a> |
| <a href="#IS_DISTINCT_FROM"><code>IS_DISTINCT_FROM</code></a> |
| <a href="#IS_NOT_DISTINCT_FROM"><code>IS_NOT_DISTINCT_FROM</code></a></div> |
| </li> |
| </ul> |
| <a id="lowerName"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>lowerName</h4> |
| <pre>public final java.lang.String lowerName</pre> |
| <div class="block">Lower-case name.</div> |
| </li> |
| </ul> |
| <a id="sql"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>sql</h4> |
| <pre>public final java.lang.String sql</pre> |
| </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="<init>()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SqlKind</h4> |
| <pre>private SqlKind()</pre> |
| </li> |
| </ul> |
| <a id="<init>(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>SqlKind</h4> |
| <pre>private SqlKind​(java.lang.String sql)</pre> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| <!-- ============ METHOD DETAIL ========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="method.detail"> |
| <!-- --> |
| </a> |
| <h3>Method Detail</h3> |
| <a id="values()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>values</h4> |
| <pre class="methodSignature">public static <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>[] values()</pre> |
| <div class="block">Returns an array containing the constants of this enum type, in |
| the order they are declared. This method may be used to iterate |
| over the constants as follows: |
| <pre> |
| for (SqlKind c : SqlKind.values()) |
| System.out.println(c); |
| </pre></div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>an array containing the constants of this enum type, in the order they are declared</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="valueOf(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>valueOf</h4> |
| <pre class="methodSignature">public static <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> valueOf​(java.lang.String name)</pre> |
| <div class="block">Returns the enum constant of this type with the specified name. |
| The string must match <i>exactly</i> an identifier used to declare an |
| enum constant in this type. (Extraneous whitespace characters are |
| not permitted.)</div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>name</code> - the name of the enum constant to be returned.</dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>the enum constant with the specified name</dd> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code>java.lang.IllegalArgumentException</code> - if this enum type has no constant with the specified name</dd> |
| <dd><code>java.lang.NullPointerException</code> - if the argument is null</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="reverse()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>reverse</h4> |
| <pre class="methodSignature">public <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> reverse()</pre> |
| <div class="block">Returns the kind that corresponds to this operator but in the opposite |
| direction. Or returns this, if this kind is not reversible. |
| |
| <p>For example, <code>GREATER_THAN.reverse()</code> returns <a href="#LESS_THAN"><code>LESS_THAN</code></a>.</div> |
| </li> |
| </ul> |
| <a id="negate()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>negate</h4> |
| <pre class="methodSignature">public <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> negate()</pre> |
| <div class="block">Returns the kind that you get if you apply NOT to this kind. |
| |
| <p>For example, <code>IS_NOT_NULL.negate()</code> returns <a href="#IS_NULL"><code>IS_NULL</code></a>. |
| |
| <p>For <a href="#IS_TRUE"><code>IS_TRUE</code></a>, <a href="#IS_FALSE"><code>IS_FALSE</code></a>, <a href="#IS_NOT_TRUE"><code>IS_NOT_TRUE</code></a>, |
| <a href="#IS_NOT_FALSE"><code>IS_NOT_FALSE</code></a>, nullable inputs need to be treated carefully. |
| |
| <p><code>NOT(IS_TRUE(null))</code> = <code>NOT(false)</code> = <code>true</code>, |
| while <code>IS_FALSE(null)</code> = <code>false</code>, |
| so <code>NOT(IS_TRUE(X))</code> should be <code>IS_NOT_TRUE(X)</code>. |
| On the other hand, |
| <code>IS_TRUE(NOT(null))</code> = <code>IS_TRUE(null)</code> = <code>false</code>. |
| |
| <p>This is why negate() != negateNullSafe() for these operators.</div> |
| </li> |
| </ul> |
| <a id="negateNullSafe()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>negateNullSafe</h4> |
| <pre class="methodSignature">public <a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> negateNullSafe()</pre> |
| <div class="block">Returns the kind that you get if you negate this kind. |
| To conform to null semantics, null value should not be compared. |
| |
| <p>For <a href="#IS_TRUE"><code>IS_TRUE</code></a>, <a href="#IS_FALSE"><code>IS_FALSE</code></a>, <a href="#IS_NOT_TRUE"><code>IS_NOT_TRUE</code></a> and |
| <a href="#IS_NOT_FALSE"><code>IS_NOT_FALSE</code></a>, nullable inputs need to be treated carefully: |
| |
| <ul> |
| <li>NOT(IS_TRUE(null)) = NOT(false) = true |
| <li>IS_TRUE(NOT(null)) = IS_TRUE(null) = false |
| <li>IS_FALSE(null) = false |
| <li>IS_NOT_TRUE(null) = true |
| </ul></div> |
| </li> |
| </ul> |
| <a id="belongsTo(java.util.Collection)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>belongsTo</h4> |
| <pre class="methodSignature">public final boolean belongsTo​(java.util.Collection<<a href="SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a>> category)</pre> |
| <div class="block">Returns whether this <code>SqlKind</code> belongs to a given category. |
| |
| <p>A category is a collection of kinds, not necessarily disjoint. For |
| example, QUERY is { SELECT, UNION, INTERSECT, EXCEPT, VALUES, ORDER_BY, |
| EXPLICIT_TABLE }.</div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>category</code> - Category</dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>Whether this kind belongs to the given category</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="concat(java.util.EnumSet,java.util.EnumSet...)"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>concat</h4> |
| <pre class="methodSignature">@SafeVarargs |
| private static <E extends java.lang.Enum<E>> java.util.EnumSet<E> concat​(java.util.EnumSet<E> set0, |
| java.util.EnumSet<E>... sets)</pre> |
| </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/SqlKind.html">Use</a></li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../help-doc.html">Help</a></li> |
| </ul> |
| </div> |
| <div class="subNav"> |
| <ul class="navList" id="allclasses_navbar_bottom"> |
| <li><a href="../../../../allclasses.html">All 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: </li> |
| <li>Nested | </li> |
| <li><a href="#enum.constant.summary">Enum Constants</a> | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#enum.constant.detail">Enum Constants</a> | </li> |
| <li><a href="#field.detail">Field</a> | </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 © 2012–2019 <a href="https://www.apache.org/">The Apache Software Foundation</a>. All rights reserved.</small></p> |
| </footer> |
| </body> |
| </html> |