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