javadocAggregate/org/apache/calcite/sql/fun/package-summary.html - calcite-site - Git at Google

 <!DOCTYPE HTML>
 <html lang="en">
 <head>
 <!-- Generated by javadoc (17) -->
 <title>org.apache.calcite.sql.fun (Apache Calcite API)</title>
 <meta name="viewport" content="width=device-width, initial-scale=1">
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <meta name="description" content="declaration: package: org.apache.calcite.sql.fun">
 <meta name="generator" content="javadoc/PackageWriterImpl">
 <link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
 <link rel="stylesheet" type="text/css" href="../../../../../script-dir/jquery-ui.min.css" title="Style">
 <link rel="stylesheet" type="text/css" href="../../../../../jquery-ui.overrides.css" title="Style">
 <script type="text/javascript" src="../../../../../script.js"></script>
 <script type="text/javascript" src="../../../../../script-dir/jquery-3.5.1.min.js"></script>
 <script type="text/javascript" src="../../../../../script-dir/jquery-ui.min.js"></script>
 </head>
 <body class="package-declaration-page">
 <script type="text/javascript">var evenRowColor = "even-row-color";
 var oddRowColor = "odd-row-color";
 var tableTab = "table-tab";
 var activeTableTab = "active-table-tab";
 var pathtoroot = "../../../../../";
 loadScripts(document, 'script');</script>
 <noscript>
 <div>JavaScript is disabled on your browser.</div>
 </noscript>
 <div class="flex-box">
 <header role="banner" class="flex-header">
 <nav role="navigation">
 <!-- ========= START OF TOP NAVBAR ======= -->
 <div class="top-nav" id="navbar-top">
 <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div>
 <div class="about-language"><b>Apache Calcite</b></div>
 <ul id="navbar-top-firstrow" class="nav-list" title="Navigation">
 <li><a href="../../../../../index.html">Overview</a></li>
 <li class="nav-bar-cell1-rev">Package</li>
 <li>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#package">Help</a></li>
 </ul>
 </div>
 <div class="sub-nav">
 <div>
 <ul class="sub-nav-list">
 <li>Package:&nbsp;</li>
 <li><a href="#package-description">Description</a>&nbsp;|&nbsp;</li>
 <li><a href="#related-package-summary">Related Packages</a>&nbsp;|&nbsp;</li>
 <li><a href="#class-summary">Classes and Interfaces</a></li>
 </ul>
 </div>
 <div class="nav-list-search"><label for="search-input">SEARCH:</label>
 <input type="text" id="search-input" value="search" disabled="disabled">
 <input type="reset" id="reset-button" value="reset" disabled="disabled">
 </div>
 </div>
 <!-- ========= END OF TOP NAVBAR ========= -->
 <span class="skip-nav" id="skip-navbar-top"></span></nav>
 </header>
 <div class="flex-content">
 <main role="main">
 <div class="header">
 <h1 title="Package org.apache.calcite.sql.fun" class="title">Package org.apache.calcite.sql.fun</h1>
 </div>
 <hr>
 <div class="package-signature">package <span class="element-name">org.apache.calcite.sql.fun</span></div>
 <section class="package-description" id="package-description">
 <div class="block">Defines the set of standard SQL row-level functions and
  operators.

  <p>The standard set of row-level functions and operators are declared in
  class <a href="SqlStdOperatorTable.html" title="class in org.apache.calcite.sql.fun"><code>SqlStdOperatorTable</code></a>. Anonymous inner
  classes within that table are allowed only for specifying an operator's test
  function; if other custom code is needed for an operator, it should be
  implemented in a top-level class within this package instead.  Operators
  which are not row-level (e.g. select and join) should be defined in package
  <a href="../package-summary.html"><code>org.apache.calcite.sql</code></a> instead.</p></div>
 </section>
 <section class="summary">
 <ul class="summary-list">
 <li>
 <div id="related-package-summary">
 <div class="caption"><span>Related Packages</span></div>
 <div class="summary-table two-column-summary">
 <div class="table-header col-first">Package</div>
 <div class="table-header col-last">Description</div>
 <div class="col-first even-row-color"><a href="../package-summary.html">org.apache.calcite.sql</a></div>
 <div class="col-last even-row-color">
 <div class="block">Provides a SQL parser and object model.</div>
 </div>
 </div>
 </div>
 </li>
 <li>
 <div id="class-summary">
 <div class="table-tabs" role="tablist" aria-orientation="horizontal"><button id="class-summary-tab0" role="tab" aria-selected="true" aria-controls="class-summary.tabpanel" tabindex="0" onkeydown="switchTab(event)" onclick="show('class-summary', 'class-summary', 2)" class="active-table-tab">All Classes and Interfaces</button><button id="class-summary-tab2" role="tab" aria-selected="false" aria-controls="class-summary.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('class-summary', 'class-summary-tab2', 2)" class="table-tab">Classes</button><button id="class-summary-tab3" role="tab" aria-selected="false" aria-controls="class-summary.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('class-summary', 'class-summary-tab3', 2)" class="table-tab">Enums</button><button id="class-summary-tab7" role="tab" aria-selected="false" aria-controls="class-summary.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('class-summary', 'class-summary-tab7', 2)" class="table-tab">Annotation Types</button></div>
 <div id="class-summary.tabpanel" role="tabpanel">
 <div class="summary-table two-column-summary" aria-labelledby="class-summary-tab0">
 <div class="table-header col-first">Class</div>
 <div class="table-header col-last">Description</div>
 <div class="col-first even-row-color class-summary class-summary-tab7"><a href="LibraryOperator.html" title="annotation in org.apache.calcite.sql.fun">LibraryOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab7">
 <div class="block">An annotation that is read by <a href="SqlLibraryOperatorTableFactory.html" title="class in org.apache.calcite.sql.fun"><code>SqlLibraryOperatorTableFactory</code></a> to
  add functions and operators to a library.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="OracleSqlOperatorTable.html" title="class in org.apache.calcite.sql.fun">OracleSqlOperatorTable</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">Deprecated.
 <div class="deprecation-comment">Use
  <a href="SqlLibraryOperatorTableFactory.html#getOperatorTable(org.apache.calcite.sql.fun.SqlLibrary...)"><code>SqlLibraryOperatorTableFactory.getOperatorTable(SqlLibrary...)</code></a>
  instead, passing <a href="SqlLibrary.html#ORACLE"><code>SqlLibrary.ORACLE</code></a> as argument.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlAbstractGroupFunction.html" title="class in org.apache.calcite.sql.fun">SqlAbstractGroupFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Base class for grouping functions <code>GROUP_ID</code>, <code>GROUPING_ID</code>,
  <code>GROUPING</code>.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlAbstractTimeFunction.html" title="class in org.apache.calcite.sql.fun">SqlAbstractTimeFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Base class for time functions such as "LOCALTIME", "LOCALTIME(n)".</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlAnyValueAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlAnyValueAggFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the <code>ANY_VALUE</code> aggregate functions,
  returning any one of the values which go into it.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlArrayQueryConstructor.html" title="class in org.apache.calcite.sql.fun">SqlArrayQueryConstructor</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the SQL:2003 standard ARRAY query constructor, <code>
  ARRAY (&lt;query&gt;)</code>.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlArrayValueConstructor.html" title="class in org.apache.calcite.sql.fun">SqlArrayValueConstructor</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the SQL:2003 standard ARRAY constructor, <code>ARRAY
  [&lt;expr&gt;, ...]</code>.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlAvgAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlAvgAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block"><code>Avg</code> is an aggregator which returns the average of the values
  which go into it.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab3"><a href="SqlAvgAggFunction.Subtype.html" title="enum in org.apache.calcite.sql.fun">SqlAvgAggFunction.Subtype</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab3">Deprecated.</div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlBaseContextVariable.html" title="class in org.apache.calcite.sql.fun">SqlBaseContextVariable</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Base class for functions such as "USER", "CURRENT_ROLE", and "CURRENT_PATH".</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlBasicAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlBasicAggFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Concrete implementation of <a href="../SqlAggFunction.html" title="class in org.apache.calcite.sql"><code>SqlAggFunction</code></a>.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlBetweenOperator.html" title="class in org.apache.calcite.sql.fun">SqlBetweenOperator</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Defines the BETWEEN operator.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab3"><a href="SqlBetweenOperator.Flag.html" title="enum in org.apache.calcite.sql.fun">SqlBetweenOperator.Flag</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab3">
 <div class="block">Defines the "SYMMETRIC" and "ASYMMETRIC" keywords.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlBitOpAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlBitOpAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the <code>BIT_AND</code> and <code>BIT_OR</code> aggregate functions,
  returning the bitwise AND/OR of all non-null input values, or null if none.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlCase.html" title="class in org.apache.calcite.sql.fun">SqlCase</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">A <code>SqlCase</code> is a node of a parse tree which represents a case
  statement.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlCaseOperator.html" title="class in org.apache.calcite.sql.fun">SqlCaseOperator</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">An operator describing a <code>CASE</code>, <code>NULLIF</code> or <code>
  COALESCE</code> expression.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlCastFunction.html" title="class in org.apache.calcite.sql.fun">SqlCastFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">SqlCastFunction.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlCoalesceFunction.html" title="class in org.apache.calcite.sql.fun">SqlCoalesceFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>COALESCE</code> function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlCollectionTableOperator.html" title="class in org.apache.calcite.sql.fun">SqlCollectionTableOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">SqlCollectionTableOperator is the "table function derived table" operator.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlColumnListConstructor.html" title="class in org.apache.calcite.sql.fun">SqlColumnListConstructor</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">SqlColumnListConstructor defines the non-standard constructor used to pass a
  COLUMN_LIST parameter to a UDX.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlConvertFunction.html" title="class in org.apache.calcite.sql.fun">SqlConvertFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Common base for the <code>CONVERT</code> and <code>TRANSLATE</code>
  functions.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlCountAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlCountAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the SQL <code>COUNT</code> aggregation function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlCovarAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlCovarAggFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block"><code>Covar</code> is an aggregator which returns the Covariance of the
  values which go into it.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab3"><a href="SqlCovarAggFunction.Subtype.html" title="enum in org.apache.calcite.sql.fun">SqlCovarAggFunction.Subtype</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab3">Deprecated.</div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlCurrentDateFunction.html" title="class in org.apache.calcite.sql.fun">SqlCurrentDateFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>CURRENT_DATE</code> function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlCursorConstructor.html" title="class in org.apache.calcite.sql.fun">SqlCursorConstructor</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">SqlCursorConstructor defines the non-standard CURSOR(&lt;query&gt;)
  constructor.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlDatePartFunction.html" title="class in org.apache.calcite.sql.fun">SqlDatePartFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">SqlDatePartFunction represents the SQL:1999 standard <code>YEAR</code>,
  <code>QUARTER</code>, <code>MONTH</code> and <code>DAY</code> functions.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlDatetimePlusOperator.html" title="class in org.apache.calcite.sql.fun">SqlDatetimePlusOperator</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Operator that adds an INTERVAL to a DATETIME.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlDatetimeSubtractionOperator.html" title="class in org.apache.calcite.sql.fun">SqlDatetimeSubtractionOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">A special operator for the subtraction of two DATETIMEs.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlDotOperator.html" title="class in org.apache.calcite.sql.fun">SqlDotOperator</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The dot operator <code>.</code>, used to access a field of a
  record.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlExtractFunction.html" title="class in org.apache.calcite.sql.fun">SqlExtractFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The SQL <code>EXTRACT</code> operator.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlFirstLastValueAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlFirstLastValueAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block"><code>FIRST_VALUE</code> and <code>LAST_VALUE</code> aggregate functions
  return the first or the last value in a list of values that are input to the
  function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlFloorFunction.html" title="class in org.apache.calcite.sql.fun">SqlFloorFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the "FLOOR" and "CEIL" built-in SQL functions.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlHistogramAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlHistogramAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block"><code>HISTOGRAM</code> is the base operator that supports the Histogram
  MIN/MAX aggregate functions.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlInOperator.html" title="class in org.apache.calcite.sql.fun">SqlInOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the SQL <code>IN</code> operator, which tests for a value's
  membership in a sub-query or a list of values.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlInternalOperators.html" title="class in org.apache.calcite.sql.fun">SqlInternalOperators</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Contains internal operators.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlIntervalOperator.html" title="class in org.apache.calcite.sql.fun">SqlIntervalOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Interval expression.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlJsonArrayAggAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonArrayAggAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_OBJECTAGG</code> aggregate function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlJsonArrayFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonArrayFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_ARRAY</code> function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlJsonDepthFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonDepthFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_DEPTH</code> function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlJsonExistsFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonExistsFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_EXISTS</code> function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlJsonKeysFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonKeysFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_KEYS</code> function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlJsonLengthFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonLengthFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_LENGTH</code> function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlJsonModifyFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonModifyFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the <code>JSON_INSERT</code>, <code>JSON_REPLACE</code>
  and <code>JSON_SET</code> JSON Modify functions.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlJsonObjectAggAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonObjectAggAggFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_OBJECTAGG</code> aggregate function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlJsonObjectFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonObjectFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_OBJECT</code> function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlJsonPrettyFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonPrettyFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_TYPE</code> function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlJsonQueryFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonQueryFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_QUERY</code> function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlJsonRemoveFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonRemoveFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_REMOVE</code> function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlJsonStorageSizeFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonStorageSizeFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_STORAGE_SIZE</code> function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlJsonTypeFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonTypeFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_TYPE</code> function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlJsonValueExpressionOperator.html" title="class in org.apache.calcite.sql.fun">SqlJsonValueExpressionOperator</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The JSON value expression operator that indicates that the value expression
  should be parsed as JSON.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlJsonValueFunction.html" title="class in org.apache.calcite.sql.fun">SqlJsonValueFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>JSON_VALUE</code> function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlLeadLagAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlLeadLagAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block"><code>LEAD</code> and <code>LAG</code> aggregate functions
  return the value of given expression evaluated at given offset.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab3"><a href="SqlLibrary.html" title="enum in org.apache.calcite.sql.fun">SqlLibrary</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab3">
 <div class="block">A library is a collection of SQL functions and operators.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlLibraryOperators.html" title="class in org.apache.calcite.sql.fun">SqlLibraryOperators</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Defines functions and operators that are not part of standard SQL but
  belong to one or more other dialects of SQL.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlLibraryOperatorTableFactory.html" title="class in org.apache.calcite.sql.fun">SqlLibraryOperatorTableFactory</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Factory that creates operator tables that consist of functions and operators
  for particular named libraries.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlLikeOperator.html" title="class in org.apache.calcite.sql.fun">SqlLikeOperator</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">An operator describing the <code>LIKE</code> and <code>SIMILAR</code>
  operators.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlLiteralChainOperator.html" title="class in org.apache.calcite.sql.fun">SqlLiteralChainOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Internal operator, by which the parser represents a continued string literal.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlMapQueryConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMapQueryConstructor</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the MAP query constructor, <code>
  MAP (&lt;query&gt;)</code>.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlMapValueConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMapValueConstructor</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the MAP constructor,
  <code>MAP [&lt;key&gt;, &lt;value&gt;, ...]</code>.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlMinMaxAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlMinMaxAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the <code>MIN</code> and <code>MAX</code> aggregate functions,
  returning the returns the smallest/largest of the values which go into it.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlMonotonicBinaryOperator.html" title="class in org.apache.calcite.sql.fun">SqlMonotonicBinaryOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Base class for binary operators such as addition, subtraction, and
  multiplication which are monotonic for the patterns <code>m op c</code> and
  <code>c op m</code> where m is any monotonic expression and c is a constant.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlMonotonicUnaryFunction.html" title="class in org.apache.calcite.sql.fun">SqlMonotonicUnaryFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Base class for unary operators such as FLOOR/CEIL which are monotonic for
  monotonic inputs.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlMultisetMemberOfOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetMemberOfOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Multiset MEMBER OF.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlMultisetQueryConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMultisetQueryConstructor</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the SQL:2003 standard MULTISET query constructor, <code>
  MULTISET (&lt;query&gt;)</code>.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlMultisetSetOperator.html" title="class in org.apache.calcite.sql.fun">SqlMultisetSetOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">An operator which performs set operations on multisets, such as "MULTISET
  UNION ALL".</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlMultisetValueConstructor.html" title="class in org.apache.calcite.sql.fun">SqlMultisetValueConstructor</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the SQL:2003 standard MULTISET constructor, <code>MULTISET
  [&lt;expr&gt;, ...]</code>.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlNewOperator.html" title="class in org.apache.calcite.sql.fun">SqlNewOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">SqlNewOperator represents an SQL <code>new specification</code> such as
  <code>NEW UDT(1, 2)</code>.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlNthValueAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlNthValueAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block"><code>NTH_VALUE</code> windowed aggregate function
  returns the value of an expression evaluated at the <code>n</code>th row of the
  window frame.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlNtileAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlNtileAggFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block"><code>NTILE</code> aggregate function
  return the value of given expression evaluated at given offset.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlNullifFunction.html" title="class in org.apache.calcite.sql.fun">SqlNullifFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>NULLIF</code> function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlOverlapsOperator.html" title="class in org.apache.calcite.sql.fun">SqlOverlapsOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">SqlOverlapsOperator represents the SQL:1999 standard <code>OVERLAPS</code>
  function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlOverlayFunction.html" title="class in org.apache.calcite.sql.fun">SqlOverlayFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>OVERLAY</code> function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlPositionFunction.html" title="class in org.apache.calcite.sql.fun">SqlPositionFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>POSITION</code> function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlPosixRegexOperator.html" title="class in org.apache.calcite.sql.fun">SqlPosixRegexOperator</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">An operator describing the <code>~</code> operator.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlQuantifyOperator.html" title="class in org.apache.calcite.sql.fun">SqlQuantifyOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the SQL <code>ALL</code> and <code>SOME</code>operators.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlRandFunction.html" title="class in org.apache.calcite.sql.fun">SqlRandFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>RAND</code> function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlRandIntegerFunction.html" title="class in org.apache.calcite.sql.fun">SqlRandIntegerFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">The <code>RAND_INTEGER</code> function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlRegexpReplaceFunction.html" title="class in org.apache.calcite.sql.fun">SqlRegexpReplaceFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The REGEXP_REPLACE(source_string, pattern, replacement [, pos, occurrence, match_type])
  searches for a regular expression pattern and replaces every occurrence of the pattern
  with the specified string.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlRegrCountAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlRegrCountAggFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the SQL <code>REGR_COUNT</code> aggregation function.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlRowOperator.html" title="class in org.apache.calcite.sql.fun">SqlRowOperator</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">SqlRowOperator represents the special ROW constructor.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlSequenceValueOperator.html" title="class in org.apache.calcite.sql.fun">SqlSequenceValueOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Operator that returns the current or next value of a sequence.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlSingleValueAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlSingleValueAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block"><code>SINGLE_VALUE</code> aggregate function returns the input value if there
  is only one value in the input; Otherwise it triggers a run-time error.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlSpatialTypeFunctions.html" title="class in org.apache.calcite.sql.fun">SqlSpatialTypeFunctions</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Utilities for spatial type functions.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlSpatialTypeFunctions.ExplodeTable.html" title="class in org.apache.calcite.sql.fun">SqlSpatialTypeFunctions.ExplodeTable</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Returns the geometries of a geometry.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlSpatialTypeFunctions.GridTable.html" title="class in org.apache.calcite.sql.fun">SqlSpatialTypeFunctions.GridTable</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Returns the points or rectangles in a grid that covers a given
  geometry.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlStdOperatorTable.html" title="class in org.apache.calcite.sql.fun">SqlStdOperatorTable</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Implementation of <a href="../SqlOperatorTable.html" title="interface in org.apache.calcite.sql"><code>SqlOperatorTable</code></a> containing
  the standard operators and functions.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlStringContextVariable.html" title="class in org.apache.calcite.sql.fun">SqlStringContextVariable</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Base class for string functions such as "USER", "CURRENT_ROLE", and
  "CURRENT_PATH".</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlSubstringFunction.html" title="class in org.apache.calcite.sql.fun">SqlSubstringFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the "SUBSTRING" builtin SQL function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlSumAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlSumAggFunction</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block"><code>Sum</code> is an aggregator which returns the sum of the values which
  go into it.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlSumEmptyIsZeroAggFunction.html" title="class in org.apache.calcite.sql.fun">SqlSumEmptyIsZeroAggFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block"><code>Sum0</code> is an aggregator which returns the sum of the values which
  go into it like <code>Sum</code>.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlThrowOperator.html" title="class in org.apache.calcite.sql.fun">SqlThrowOperator</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">An internal operator that throws an exception.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlTimestampAddFunction.html" title="class in org.apache.calcite.sql.fun">SqlTimestampAddFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">The <code>TIMESTAMPADD</code> function, which adds an interval to a
  datetime (TIMESTAMP, TIME or DATE).</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SqlTranslate3Function.html" title="class in org.apache.calcite.sql.fun">SqlTranslate3Function</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the "TRANSLATE" built-in SQL function that takes 3 arguments.</div>
 </div>
 <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="SqlTrimFunction.html" title="class in org.apache.calcite.sql.fun">SqlTrimFunction</a></div>
 <div class="col-last odd-row-color class-summary class-summary-tab2">
 <div class="block">Definition of the "TRIM" builtin SQL function.</div>
 </div>
 <div class="col-first even-row-color class-summary class-summary-tab3"><a href="SqlTrimFunction.Flag.html" title="enum in org.apache.calcite.sql.fun">SqlTrimFunction.Flag</a></div>
 <div class="col-last even-row-color class-summary class-summary-tab3">
 <div class="block">Defines the enumerated values "LEADING", "TRAILING", "BOTH".</div>
 </div>
 </div>
 </div>
 </div>
 </li>
 </ul>
 </section>
 </main>
 <footer role="contentinfo">
 <hr>
 <p class="legal-copy"><small>Copyright &copy; 2012-2023 Apache Software Foundation. All Rights Reserved.</small></p>
 </footer>
 </div>
 </div>
 </body>
 </html>