SqlStdOperatorTable (flink-table 1.3.0 API)

java.lang.Object
- org.apache.calcite.sql.util.ReflectiveSqlOperatorTable
- - org.apache.calcite.sql.fun.SqlStdOperatorTable

All Implemented Interfaces:

org.apache.calcite.sql.SqlOperatorTable
```
public class SqlStdOperatorTable
extends org.apache.calcite.sql.util.ReflectiveSqlOperatorTable
```
Implementation of SqlOperatorTable containing the standard operators and functions.

Field Summary

Fields
Modifier and Type	Field and Description
`static org.apache.calcite.sql.SqlFunction`	`ABS`
`static org.apache.calcite.sql.SqlFunction`	`ACOS`
`static org.apache.calcite.sql.SqlBinaryOperator`	`AND` Logical `AND` operator.
`static org.apache.calcite.sql.SqlSpecialOperator`	`ARGUMENT_ASSIGNMENT` `ARGUMENT_ASSIGNMENT` operator (`=<`) assigns an argument to a function call to a particular named parameter.
`static org.apache.calcite.sql.fun.SqlMultisetQueryConstructor`	`ARRAY_QUERY` The ARRAY Query Constructor.
`static org.apache.calcite.sql.fun.SqlArrayValueConstructor`	`ARRAY_VALUE_CONSTRUCTOR` The ARRAY Value Constructor.
`static org.apache.calcite.sql.SqlAsOperator`	`AS` `AS` operator associates an expression in the SELECT clause with an alias.
`static org.apache.calcite.sql.SqlFunction`	`ASIN`
`static org.apache.calcite.sql.SqlFunction`	`ATAN`
`static org.apache.calcite.sql.SqlFunction`	`ATAN2`
`static org.apache.calcite.sql.SqlAggFunction`	`AVG` `AVG` aggregate function.
`static org.apache.calcite.sql.fun.SqlBetweenOperator`	`BETWEEN`
`static org.apache.calcite.sql.SqlFunction`	`CARDINALITY` The CARDINALITY operator, used to retrieve the number of elements in a MULTISET, ARRAY or MAP.
`static org.apache.calcite.sql.fun.SqlCaseOperator`	`CASE`
`static org.apache.calcite.sql.SqlFunction`	`CAST` The SQL `CAST` operator.
`static org.apache.calcite.sql.SqlFunction`	`CEIL` The `CEIL` function.
`static org.apache.calcite.sql.SqlFunction`	`CHAR_LENGTH`
`static org.apache.calcite.sql.SqlFunction`	`CHARACTER_LENGTH`
`static org.apache.calcite.sql.SqlFunction`	`COALESCE` The COALESCE builtin function.
`static org.apache.calcite.sql.SqlAggFunction`	`COLLECT` The COLLECT operator.
`static org.apache.calcite.sql.SqlSpecialOperator`	`COLLECTION_TABLE` The "table function derived table" operator, which a table-valued function into a relation, e.g.
`static org.apache.calcite.sql.fun.SqlColumnListConstructor`	`COLUMN_LIST` The COLUMN_LIST constructor.
`static org.apache.calcite.sql.SqlBinaryOperator`	`CONCAT` String concatenation operator, '`\|\|`'.
`static org.apache.calcite.sql.SqlFunction`	`CONVERT`
`static org.apache.calcite.sql.SqlFunction`	`COS`
`static org.apache.calcite.sql.SqlFunction`	`COT`
`static org.apache.calcite.sql.SqlAggFunction`	`COUNT` `COUNT` aggregate function.
`static org.apache.calcite.sql.SqlAggFunction`	`COVAR_POP` `COVAR_POP` aggregate function.
`static org.apache.calcite.sql.SqlAggFunction`	`COVAR_SAMP` `COVAR_SAMP` aggregate function.
`static org.apache.calcite.sql.SqlInternalOperator`	`CUBE` `CUBE` operator, occurs within `GROUP BY` clause or nested within a `GROUPING SETS`.
`static org.apache.calcite.sql.SqlRankFunction`	`CUME_DIST` `CUME_DIST` window function.
`static org.apache.calcite.sql.SqlFunction`	`CURRENT_CATALOG` The `CURRENT_CATALOG` function.
`static org.apache.calcite.sql.SqlFunction`	`CURRENT_DATE` The `CURRENT_DATE` function.
`static org.apache.calcite.sql.SqlFunction`	`CURRENT_PATH` The `CURRENT_PATH` function.
`static org.apache.calcite.sql.SqlFunction`	`CURRENT_ROLE` The `CURRENT_ROLE` function.
`static org.apache.calcite.sql.SqlFunction`	`CURRENT_SCHEMA` The `CURRENT_SCHEMA` function.
`static org.apache.calcite.sql.SqlFunction`	`CURRENT_TIME` The `CURRENT_TIME [(precision)]` function.
`static org.apache.calcite.sql.SqlFunction`	`CURRENT_TIMESTAMP` The `CURRENT_TIMESTAMP [(precision)]` function.
`static org.apache.calcite.sql.SqlFunction`	`CURRENT_USER` The `CURRENT_USER` function.
`static org.apache.calcite.sql.SqlOperator`	`CURRENT_VALUE` The sequence current value function: `CURRENT VALUE FOR sequence`
`static org.apache.calcite.sql.fun.SqlCursorConstructor`	`CURSOR` The CURSOR constructor.
`static org.apache.calcite.sql.SqlSpecialOperator`	`DATETIME_PLUS` Infix datetime plus operator, '`DATETIME + INTERVAL`'.
`static org.apache.calcite.sql.fun.SqlDatePartFunction`	`DAYOFMONTH` The SQL `DAYOFMONTH` operator.
`static org.apache.calcite.sql.fun.SqlDatePartFunction`	`DAYOFWEEK` The SQL `DAYOFWEEK` operator.
`static org.apache.calcite.sql.fun.SqlDatePartFunction`	`DAYOFYEAR` The SQL `DAYOFYEAR` operator.
`static org.apache.calcite.sql.SqlSpecialOperator`	`DEFAULT` `DEFAULT` operator indicates that an argument to a function call is to take its default value..
`static org.apache.calcite.sql.SqlFunction`	`DEGREES`
`static org.apache.calcite.sql.SqlRankFunction`	`DENSE_RANK` `DENSE_RANK` window function.
`static org.apache.calcite.sql.SqlPostfixOperator`	`DESC`
`static org.apache.calcite.sql.SqlBinaryOperator`	`DIVIDE` Arithmetic division operator, '`/`'.
`static org.apache.calcite.sql.SqlBinaryOperator`	`DIVIDE_INTEGER` Internal integer arithmetic division operator, '`/INT`'.
`static org.apache.calcite.sql.SqlBinaryOperator`	`DOT` Dot operator, '`.`', used for referencing fields of records.
`static org.apache.calcite.sql.SqlFunction`	`ELEMENT` The ELEMENT operator, used to convert a multiset with only one item to a "regular" type.
`static org.apache.calcite.sql.SqlInternalOperator`	`ELEMENT_SLICE` The internal "$ELEMENT_SLICE" operator returns the first field of the only element of a multiset.
`static org.apache.calcite.sql.SqlBinaryOperator`	`EQUALS` Logical equals operator, '`=`'.
`static org.apache.calcite.sql.SqlSpecialOperator`	`ESCAPE` Internal operator used to represent the ESCAPE clause of a LIKE or SIMILAR TO expression.
`static org.apache.calcite.sql.SqlSetOperator`	`EXCEPT`
`static org.apache.calcite.sql.SqlSetOperator`	`EXCEPT_ALL`
`static org.apache.calcite.sql.SqlPrefixOperator`	`EXISTS`
`static org.apache.calcite.sql.SqlFunction`	`EXP`
`static org.apache.calcite.sql.SqlPrefixOperator`	`EXPLICIT_TABLE` Keyword which allows an identifier to be explicitly flagged as a table.
`static org.apache.calcite.sql.SqlInternalOperator`	`EXTEND` `EXTEND` operator.
`static org.apache.calcite.sql.SqlFunction`	`EXTRACT` The SQL `EXTRACT` operator.
`static org.apache.calcite.sql.SqlSpecialOperator`	`EXTRACT_DATE` Internal operator that extracts time periods (year, month, date) from a date in internal format (number of days since epoch).
`static org.apache.calcite.sql.SqlFilterOperator`	`FILTER` `FILTER` operator filters which rows are included in an aggregate function.
`static org.apache.calcite.sql.SqlFunction`	`FINAL` `FINAL` function to be used within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlFunction`	`FIRST` `FIRST` function to be used within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlAggFunction`	`FIRST_VALUE` `FIRST_VALUE` aggregate function.
`static org.apache.calcite.sql.SqlFunction`	`FLOOR` The `FLOOR` function.
`static org.apache.calcite.sql.SqlFunction`	`FUSION` The FUSION operator.
`static org.apache.calcite.sql.SqlBinaryOperator`	`GREATER_THAN` Logical greater-than operator, '`>`'.
`static org.apache.calcite.sql.SqlBinaryOperator`	`GREATER_THAN_OR_EQUAL` Logical greater-than-or-equal operator, '`>=`'.
`static org.apache.calcite.sql.fun.SqlGroupIdFunction`	`GROUP_ID` `GROUP_ID` function.
`static org.apache.calcite.sql.fun.SqlGroupingFunction`	`GROUPING` `GROUPING` function.
`static org.apache.calcite.sql.fun.SqlGroupingFunction`	`GROUPING_ID` `GROUP_ID` function is a synonym for `GROUPING`.
`static org.apache.calcite.sql.SqlInternalOperator`	`GROUPING_SETS` `GROUPING SETS` operator, occurs within `GROUP BY` clause or nested within a `GROUPING SETS`.
`static org.apache.calcite.sql.SqlAggFunction`	`HISTOGRAM_AGG` `HISTOGRAM` aggregate function support.
`static org.apache.calcite.sql.SqlFunction`	`HISTOGRAM_FIRST_VALUE` `HISTOGRAM_FIRST_VALUE` window aggregate function.
`static org.apache.calcite.sql.SqlFunction`	`HISTOGRAM_LAST_VALUE` `HISTOGRAM_LAST_VALUE` window aggregate function.
`static org.apache.calcite.sql.SqlFunction`	`HISTOGRAM_MAX` `HISTOGRAM_MAX` window aggregate function.
`static org.apache.calcite.sql.SqlFunction`	`HISTOGRAM_MIN` `HISTOGRAM_MIN` window aggregate function.
`static org.apache.calcite.sql.fun.SqlGroupFunction`	`HOP` The `HOP` group function.
`static org.apache.calcite.sql.fun.SqlGroupFunction`	`HOP_END` The `HOP_END` auxiliary function of the `HOP` group function.
`static org.apache.calcite.sql.fun.SqlGroupFunction`	`HOP_START` The `HOP_START` auxiliary function of the `HOP` group function.
`static org.apache.calcite.sql.fun.SqlDatePartFunction`	`HOUR` The SQL `HOUR` operator.
`static org.apache.calcite.sql.SqlBinaryOperator`	`IN` `IN` operator tests for a value's membership in a sub-query or a list of values.
`static org.apache.calcite.sql.SqlFunction`	`IN_FENNEL` Use of the `IN_FENNEL` operator forces the argument to be evaluated in Fennel.
`static org.apache.calcite.sql.SqlFunction`	`INITCAP`
`static org.apache.calcite.sql.SqlSetOperator`	`INTERSECT`
`static org.apache.calcite.sql.SqlSetOperator`	`INTERSECT_ALL`
`static org.apache.calcite.sql.SqlPostfixOperator`	`IS_A_SET`
`static org.apache.calcite.sql.SqlBinaryOperator`	`IS_DIFFERENT_FROM` The internal `$IS_DIFFERENT_FROM` operator is the same as the user-level `IS_DISTINCT_FROM` in all respects except that the test for equality on character datatypes treats trailing spaces as significant.
`static org.apache.calcite.sql.SqlBinaryOperator`	`IS_DISTINCT_FROM` `IS DISTINCT FROM` operator.
`static org.apache.calcite.sql.SqlPostfixOperator`	`IS_FALSE`
`static org.apache.calcite.sql.SqlBinaryOperator`	`IS_NOT_DISTINCT_FROM` `IS NOT DISTINCT FROM` operator.
`static org.apache.calcite.sql.SqlPostfixOperator`	`IS_NOT_FALSE`
`static org.apache.calcite.sql.SqlPostfixOperator`	`IS_NOT_NULL`
`static org.apache.calcite.sql.SqlPostfixOperator`	`IS_NOT_TRUE`
`static org.apache.calcite.sql.SqlPostfixOperator`	`IS_NOT_UNKNOWN`
`static org.apache.calcite.sql.SqlPostfixOperator`	`IS_NULL`
`static org.apache.calcite.sql.SqlPostfixOperator`	`IS_TRUE`
`static org.apache.calcite.sql.SqlPostfixOperator`	`IS_UNKNOWN`
`static org.apache.calcite.sql.SqlOperator`	`ITEM` The item operator {@code [ ...
`static org.apache.calcite.sql.SqlAggFunction`	`LAG` `LAG` aggregate function.
`static org.apache.calcite.sql.SqlFunction`	`LAST` `LAST` function to be used within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlAggFunction`	`LAST_VALUE` `LAST_VALUE` aggregate function.
`static org.apache.calcite.sql.SqlSpecialOperator`	`LATERAL` The `LATERAL` operator.
`static org.apache.calcite.sql.SqlAggFunction`	`LEAD` `LEAD` aggregate function.
`static org.apache.calcite.sql.SqlBinaryOperator`	`LESS_THAN` Logical less-than operator, '`<`'.
`static org.apache.calcite.sql.SqlBinaryOperator`	`LESS_THAN_OR_EQUAL` Logical less-than-or-equal operator, '`<=`'.
`static org.apache.calcite.sql.SqlSpecialOperator`	`LIKE`
`static org.apache.calcite.sql.fun.SqlLiteralChainOperator`	`LITERAL_CHAIN`
`static org.apache.calcite.sql.SqlFunction`	`LN`
`static org.apache.calcite.sql.SqlFunction`	`LOCALTIME` The `LOCALTIME [(precision)]` function.
`static org.apache.calcite.sql.SqlFunction`	`LOCALTIMESTAMP` The `LOCALTIMESTAMP [(precision)]` function.
`static org.apache.calcite.sql.SqlFunction`	`LOG10`
`static org.apache.calcite.sql.SqlFunction`	`LOWER`
`static org.apache.calcite.sql.fun.SqlMultisetQueryConstructor`	`MAP_QUERY` The MAP Query Constructor.
`static org.apache.calcite.sql.fun.SqlMapValueConstructor`	`MAP_VALUE_CONSTRUCTOR` The MAP Value Constructor, e.g.
`static org.apache.calcite.sql.SqlAggFunction`	`MAX` `MAX` aggregate function.
`static org.apache.calcite.sql.SqlBinaryOperator`	`MEMBER_OF` Multiset `MEMBER OF`, which returns whether a element belongs to a multiset.
`static org.apache.calcite.sql.SqlAggFunction`	`MIN` `MIN` aggregate function.
`static org.apache.calcite.sql.SqlBinaryOperator`	`MINUS` Infix arithmetic minus operator, '`-`'.
`static org.apache.calcite.sql.fun.SqlDatetimeSubtractionOperator`	`MINUS_DATE` A special operator for the subtraction of two DATETIMEs.
`static org.apache.calcite.sql.fun.SqlDatePartFunction`	`MINUTE` The SQL `MINUTE` operator.
`static org.apache.calcite.sql.SqlFunction`	`MOD`
`static org.apache.calcite.sql.fun.SqlDatePartFunction`	`MONTH` The SQL `MONTH` operator.
`static org.apache.calcite.sql.SqlBinaryOperator`	`MULTIPLY` Arithmetic multiplication operator, '`*`'.
`static org.apache.calcite.sql.fun.SqlMultisetSetOperator`	`MULTISET_EXCEPT` The "MULTISET EXCEPT" operator.
`static org.apache.calcite.sql.fun.SqlMultisetSetOperator`	`MULTISET_EXCEPT_ALL` The "MULTISET EXCEPT ALL" operator.
`static org.apache.calcite.sql.fun.SqlMultisetSetOperator`	`MULTISET_INTERSECT` The "MULTISET INTERSECT" operator.
`static org.apache.calcite.sql.fun.SqlMultisetSetOperator`	`MULTISET_INTERSECT_ALL` The "MULTISET INTERSECT ALL" operator.
`static org.apache.calcite.sql.fun.SqlMultisetQueryConstructor`	`MULTISET_QUERY` The MULTISET Query Constructor.
`static org.apache.calcite.sql.fun.SqlMultisetSetOperator`	`MULTISET_UNION` The "MULTISET UNION" operator.
`static org.apache.calcite.sql.fun.SqlMultisetSetOperator`	`MULTISET_UNION_ALL` The "MULTISET UNION ALL" operator.
`static org.apache.calcite.sql.fun.SqlMultisetValueConstructor`	`MULTISET_VALUE` The MULTISET Value Constructor.
`static org.apache.calcite.sql.SqlOperator`	`NEW`
`static org.apache.calcite.sql.SqlFunction`	`NEXT` `NEXT` function to be used within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlOperator`	`NEXT_VALUE` The sequence next value function: `NEXT VALUE FOR sequence`
`static org.apache.calcite.sql.SqlPrefixOperator`	`NOT`
`static org.apache.calcite.sql.fun.SqlBetweenOperator`	`NOT_BETWEEN`
`static org.apache.calcite.sql.SqlBinaryOperator`	`NOT_EQUALS` Logical not-equals operator, '`<>`'.
`static org.apache.calcite.sql.SqlBinaryOperator`	`NOT_IN` `NOT IN` operator tests for a value's membership in a sub-query or a list of values.
`static org.apache.calcite.sql.SqlSpecialOperator`	`NOT_LIKE`
`static org.apache.calcite.sql.SqlSpecialOperator`	`NOT_SIMILAR_TO`
`static org.apache.calcite.sql.SqlAggFunction`	`NTILE` `NTILE` aggregate function.
`static org.apache.calcite.sql.SqlFunction`	`NULLIF`
`static org.apache.calcite.sql.SqlPostfixOperator`	`NULLS_FIRST`
`static org.apache.calcite.sql.SqlPostfixOperator`	`NULLS_LAST`
`static org.apache.calcite.sql.SqlBinaryOperator`	`OR` Logical `OR` operator.
`static org.apache.calcite.sql.SqlBinaryOperator`	`OVER` The `OVER` operator, which applies an aggregate functions to a `window`.
`static org.apache.calcite.sql.fun.SqlOverlapsOperator`	`OVERLAPS`
`static org.apache.calcite.sql.SqlFunction`	`OVERLAY`
`static org.apache.calcite.sql.SqlBinaryOperator`	`PATTERN_ALTER` `\|` operator to create alternate patterns within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlBinaryOperator`	`PATTERN_CONCAT` Operator to concatenate patterns within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlSpecialOperator`	`PATTERN_EXCLUDE` `EXCLUDE` operator within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlSpecialOperator`	`PATTERN_PERMUTE` `PERMUTE` operator to combine patterns within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlSpecialOperator`	`PATTERN_QUANTIFIER` Operator to quantify patterns within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlRankFunction`	`PERCENT_RANK` `PERCENT_RANK` window function.
`static org.apache.calcite.sql.SqlFunction`	`PI`
`static org.apache.calcite.sql.SqlBinaryOperator`	`PLUS` Infix arithmetic plus operator, '`+`'.
`static org.apache.calcite.sql.SqlFunction`	`POSITION`
`static org.apache.calcite.sql.SqlFunction`	`POWER` Uses SqlOperatorTable.useDouble for its return type since we don't know what the result type will be by just looking at the operand types.
`static org.apache.calcite.sql.SqlFunction`	`PREV` `PREV` function to be used within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlOperator`	`PROCEDURE_CALL`
`static org.apache.calcite.sql.fun.SqlDatePartFunction`	`QUARTER` The SQL `QUARTER` operator.
`static org.apache.calcite.sql.SqlFunction`	`RADIANS`
`static org.apache.calcite.sql.fun.SqlRandFunction`	`RAND` The `RAND([seed])` function, which yields a random double, optionally with seed.
`static org.apache.calcite.sql.fun.SqlRandIntegerFunction`	`RAND_INTEGER` The `RAND_INTEGER([seed, ] bound)` function, which yields a random integer, optionally with seed.
`static org.apache.calcite.sql.SqlRankFunction`	`RANK` `RANK` window function.
`static org.apache.calcite.sql.SqlAggFunction`	`REGR_SXX` `REGR_SXX` aggregate function.
`static org.apache.calcite.sql.SqlAggFunction`	`REGR_SYY` `REGR_SYY` aggregate function.
`static org.apache.calcite.sql.SqlSpecialOperator`	`REINTERPRET` An `REINTERPRET` operator is internal to the planner.
`static org.apache.calcite.sql.SqlFunction`	`REPLACE` The `REPLACE(string, search, replace)` function.
`static org.apache.calcite.sql.SqlInternalOperator`	`ROLLUP` `ROLLUP` operator, occurs within `GROUP BY` clause or nested within a `GROUPING SETS`.
`static org.apache.calcite.sql.SqlFunction`	`ROUND`
`static org.apache.calcite.sql.fun.SqlRowOperator`	`ROW`
`static org.apache.calcite.sql.SqlRankFunction`	`ROW_NUMBER` `ROW_NUMBER` window function.
`static org.apache.calcite.sql.SqlFunction`	`RUNNING` `RUNNING` function to be used within `MATCH_RECOGNIZE`.
`static org.apache.calcite.sql.SqlInternalOperator`	`SCALAR_QUERY` The internal "$SCALAR_QUERY" operator returns a scalar value from a record type.
`static org.apache.calcite.sql.fun.SqlDatePartFunction`	`SECOND` The SQL `SECOND` operator.
`static org.apache.calcite.sql.fun.SqlGroupFunction`	`SESSION` The `SESSION` group function.
`static org.apache.calcite.sql.fun.SqlGroupFunction`	`SESSION_END` The `SESSION_END` auxiliary function of the `SESSION` group function.
`static org.apache.calcite.sql.fun.SqlGroupFunction`	`SESSION_START` The `SESSION_START` auxiliary function of the `SESSION` group function.
`static org.apache.calcite.sql.SqlFunction`	`SESSION_USER` The `SESSION_USER` function.
`static org.apache.calcite.sql.SqlFunction`	`SIGN`
`static org.apache.calcite.sql.SqlSpecialOperator`	`SIMILAR_TO`
`static org.apache.calcite.sql.SqlFunction`	`SIN`
`static org.apache.calcite.sql.SqlAggFunction`	`SINGLE_VALUE` `SINGLE_VALUE` aggregate function.
`static org.apache.calcite.sql.SqlInternalOperator`	`SLICE` The internal "$SLICE" operator takes a multiset of records and returns a multiset of the first column of those records.
`static org.apache.calcite.sql.SqlFunction`	`SQRT`
`static org.apache.calcite.sql.SqlAggFunction`	`STDDEV_POP` `STDDEV_POP` aggregate function.
`static org.apache.calcite.sql.SqlAggFunction`	`STDDEV_SAMP` `STDDEV_SAMP` aggregate function.
`static org.apache.calcite.sql.SqlBinaryOperator`	`SUBMULTISET_OF` Submultiset.
`static org.apache.calcite.sql.SqlFunction`	`SUBSTRING` The character substring function: `SUBSTRING(string FROM start [FOR length])`.
`static org.apache.calcite.sql.SqlAggFunction`	`SUM` `SUM` aggregate function.
`static org.apache.calcite.sql.SqlAggFunction`	`SUM0` `SUM0` aggregate function.
`static org.apache.calcite.sql.fun.SqlBetweenOperator`	`SYMMETRIC_BETWEEN`
`static org.apache.calcite.sql.fun.SqlBetweenOperator`	`SYMMETRIC_NOT_BETWEEN`
`static org.apache.calcite.sql.SqlFunction`	`SYSTEM_USER` The `SYSTEM_USER` function.
`static org.apache.calcite.sql.SqlSpecialOperator`	`TABLESAMPLE` The `TABLESAMPLE` operator.
`static org.apache.calcite.sql.SqlFunction`	`TAN`
`static org.apache.calcite.sql.fun.SqlThrowOperator`	`THROW`
`static org.apache.calcite.sql.SqlFunction`	`TIMESTAMP_ADD` The `TIMESTAMPADD` function.
`static org.apache.calcite.sql.SqlFunction`	`TIMESTAMP_DIFF` The `TIMESTAMPDIFF` function.
`static org.apache.calcite.sql.SqlFunction`	`TRANSLATE` The `TRANSLATE(char_value USING translation_name)` function alters the character set of a string value from one base character set to another.
`static org.apache.calcite.sql.SqlFunction`	`TRIM` The "TRIM" function.
`static org.apache.calcite.sql.SqlFunction`	`TRUNCATE`
`static org.apache.calcite.sql.fun.SqlGroupFunction`	`TUMBLE` The `TUMBLE` group function.
`static org.apache.calcite.sql.fun.SqlGroupFunction`	`TUMBLE_END` The `TUMBLE_END` auxiliary function of the `TUMBLE` group function.
`static org.apache.calcite.sql.fun.SqlGroupFunction`	`TUMBLE_START` The `TUMBLE_START` auxiliary function of the `TUMBLE` group function.
`static org.apache.calcite.sql.SqlPrefixOperator`	`UNARY_MINUS` Prefix arithmetic minus operator, '`-`'.
`static org.apache.calcite.sql.SqlPrefixOperator`	`UNARY_PLUS` Prefix arithmetic plus operator, '`+`'.
`static org.apache.calcite.sql.SqlSetOperator`	`UNION`
`static org.apache.calcite.sql.SqlSetOperator`	`UNION_ALL`
`static org.apache.calcite.sql.SqlUnnestOperator`	`UNNEST` The `UNNEST` operator.
`static org.apache.calcite.sql.SqlUnnestOperator`	`UNNEST_WITH_ORDINALITY` The `UNNEST WITH ORDINALITY` operator.
`static org.apache.calcite.sql.SqlFunction`	`UPPER`
`static org.apache.calcite.sql.SqlFunction`	`USER` The `USER` function.
`static org.apache.calcite.sql.SqlSpecialOperator`	`VALUES`
`static org.apache.calcite.sql.SqlAggFunction`	`VAR_POP` `VAR_POP` aggregate function.
`static org.apache.calcite.sql.SqlAggFunction`	`VAR_SAMP` `VAR_SAMP` aggregate function.
`static org.apache.calcite.sql.fun.SqlDatePartFunction`	`WEEK` The SQL `WEEK` operator.
`static org.apache.calcite.sql.fun.SqlDatePartFunction`	`YEAR` The SQL `YEAR` operator.

Fields inherited from class org.apache.calcite.sql.util.ReflectiveSqlOperatorTable
IS_NAME

Constructor Summary

Constructors
Constructor and Description

SqlStdOperatorTable()

Constructors
Constructor and Description
`SqlStdOperatorTable()`

Method Summary

Methods
Modifier and Type	Method and Description
`static org.apache.calcite.sql.fun.SqlGroupFunction`	`auxiliaryToGroup(org.apache.calcite.sql.SqlKind kind)` Returns the group function for which a given kind is an auxiliary function, or null if it is not an auxiliary function.
`static org.apache.calcite.sql.SqlCall`	`convertAuxiliaryToGroupCall(org.apache.calcite.sql.SqlCall call)` Converts a call to a grouped auxiliary function to a call to the grouped window function.
`static List<org.apache.calcite.util.Pair<org.apache.calcite.sql.SqlNode,AuxiliaryConverter>>`	`convertGroupToAuxiliaryCalls(org.apache.calcite.sql.SqlCall call)` Converts a call to a grouped window function to a call to its auxiliary window function(s).
`static SqlStdOperatorTable`	`instance()` Returns the standard operator table, creating it if necessary.

Methods inherited from class org.apache.calcite.sql.util.ReflectiveSqlOperatorTable
getOperatorList, init, lookupOperatorOverloads, register

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - UNION
```
public static final org.apache.calcite.sql.SqlSetOperator UNION
```
  - UNION_ALL
```
public static final org.apache.calcite.sql.SqlSetOperator UNION_ALL
```
  - EXCEPT
```
public static final org.apache.calcite.sql.SqlSetOperator EXCEPT
```
  - EXCEPT_ALL
```
public static final org.apache.calcite.sql.SqlSetOperator EXCEPT_ALL
```
  - INTERSECT
```
public static final org.apache.calcite.sql.SqlSetOperator INTERSECT
```
  - INTERSECT_ALL
```
public static final org.apache.calcite.sql.SqlSetOperator INTERSECT_ALL
```
  - MULTISET_UNION
```
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_UNION
```
    The "MULTISET UNION" operator.
  - MULTISET_UNION_ALL
```
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_UNION_ALL
```
    The "MULTISET UNION ALL" operator.
  - MULTISET_EXCEPT
```
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_EXCEPT
```
    The "MULTISET EXCEPT" operator.
  - MULTISET_EXCEPT_ALL
```
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_EXCEPT_ALL
```
    The "MULTISET EXCEPT ALL" operator.
  - MULTISET_INTERSECT
```
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_INTERSECT
```
    The "MULTISET INTERSECT" operator.
  - MULTISET_INTERSECT_ALL
```
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_INTERSECT_ALL
```
    The "MULTISET INTERSECT ALL" operator.
  - AND
```
public static final org.apache.calcite.sql.SqlBinaryOperator AND
```
    Logical AND operator.
  - AS
```
public static final org.apache.calcite.sql.SqlAsOperator AS
```
    AS operator associates an expression in the SELECT clause with an alias.
  - ARGUMENT_ASSIGNMENT
```
public static final org.apache.calcite.sql.SqlSpecialOperator ARGUMENT_ASSIGNMENT
```
    ARGUMENT_ASSIGNMENT operator (=<) assigns an argument to a function call to a particular named parameter.
  - DEFAULT
```
public static final org.apache.calcite.sql.SqlSpecialOperator DEFAULT
```
    DEFAULT operator indicates that an argument to a function call is to take its default value..
  - FILTER
```
public static final org.apache.calcite.sql.SqlFilterOperator FILTER
```
    FILTER operator filters which rows are included in an aggregate function.
  - CUBE
```
public static final org.apache.calcite.sql.SqlInternalOperator CUBE
```
    CUBE operator, occurs within GROUP BY clause or nested within a GROUPING SETS.
  - ROLLUP
```
public static final org.apache.calcite.sql.SqlInternalOperator ROLLUP
```
    ROLLUP operator, occurs within GROUP BY clause or nested within a GROUPING SETS.
  - GROUPING_SETS
```
public static final org.apache.calcite.sql.SqlInternalOperator GROUPING_SETS
```
    GROUPING SETS operator, occurs within GROUP BY clause or nested within a GROUPING SETS.
  - GROUPING
```
public static final org.apache.calcite.sql.fun.SqlGroupingFunction GROUPING
```
    GROUPING function. Occurs in similar places to an aggregate function (SELECT, HAVING clause, etc. of an aggregate query), but not technically an aggregate function.
  - GROUP_ID
```
public static final org.apache.calcite.sql.fun.SqlGroupIdFunction GROUP_ID
```
    GROUP_ID function.
  - GROUPING_ID
```
public static final org.apache.calcite.sql.fun.SqlGroupingFunction GROUPING_ID
```
    GROUP_ID function is a synonym for GROUPING.
    Some history. The GROUPING function is in the SQL standard, and originally supported only one argument. The GROUP_ID is not standard (though supported in Oracle and SQL Server) and supports zero or more arguments.
    The SQL standard has changed to allow GROUPING to have multiple arguments. It is now equivalent to GROUP_ID, so we made GROUP_ID a synonym for GROUPING.
  - EXTEND
```
public static final org.apache.calcite.sql.SqlInternalOperator EXTEND
```
    EXTEND operator.
  - CONCAT
```
public static final org.apache.calcite.sql.SqlBinaryOperator CONCAT
```
    String concatenation operator, '||'.
  - DIVIDE
```
public static final org.apache.calcite.sql.SqlBinaryOperator DIVIDE
```
    Arithmetic division operator, '/'.
  - RAND_INTEGER
```
public static final org.apache.calcite.sql.fun.SqlRandIntegerFunction RAND_INTEGER
```
    The RAND_INTEGER([seed, ] bound) function, which yields a random integer, optionally with seed.
  - RAND
```
public static final org.apache.calcite.sql.fun.SqlRandFunction RAND
```
    The RAND([seed]) function, which yields a random double, optionally with seed.
  - DIVIDE_INTEGER
```
public static final org.apache.calcite.sql.SqlBinaryOperator DIVIDE_INTEGER
```
    Internal integer arithmetic division operator, '/INT'. This is only used to adjust scale for numerics. We distinguish it from user-requested division since some personalities want a floating-point computation, whereas for the internal scaling use of division, we always want integer division.
  - DOT
```
public static final org.apache.calcite.sql.SqlBinaryOperator DOT
```
    Dot operator, '.', used for referencing fields of records.
  - EQUALS
```
public static final org.apache.calcite.sql.SqlBinaryOperator EQUALS
```
    Logical equals operator, '='.
  - GREATER_THAN
```
public static final org.apache.calcite.sql.SqlBinaryOperator GREATER_THAN
```
    Logical greater-than operator, '>'.
  - IS_DISTINCT_FROM
```
public static final org.apache.calcite.sql.SqlBinaryOperator IS_DISTINCT_FROM
```
    IS DISTINCT FROM operator.
  - IS_NOT_DISTINCT_FROM
```
public static final org.apache.calcite.sql.SqlBinaryOperator IS_NOT_DISTINCT_FROM
```
    IS NOT DISTINCT FROM operator. Is equivalent to NOT(x IS DISTINCT FROM y)
  - IS_DIFFERENT_FROM
```
public static final org.apache.calcite.sql.SqlBinaryOperator IS_DIFFERENT_FROM
```
    The internal $IS_DIFFERENT_FROM operator is the same as the user-level IS_DISTINCT_FROM in all respects except that the test for equality on character datatypes treats trailing spaces as significant.
  - GREATER_THAN_OR_EQUAL
```
public static final org.apache.calcite.sql.SqlBinaryOperator GREATER_THAN_OR_EQUAL
```
    Logical greater-than-or-equal operator, '>='.
  - IN
```
public static final org.apache.calcite.sql.SqlBinaryOperator IN
```
    IN operator tests for a value's membership in a sub-query or a list of values.
  - NOT_IN
```
public static final org.apache.calcite.sql.SqlBinaryOperator NOT_IN
```
    NOT IN operator tests for a value's membership in a sub-query or a list of values.
  - LESS_THAN
```
public static final org.apache.calcite.sql.SqlBinaryOperator LESS_THAN
```
    Logical less-than operator, '<'.
  - LESS_THAN_OR_EQUAL
```
public static final org.apache.calcite.sql.SqlBinaryOperator LESS_THAN_OR_EQUAL
```
    Logical less-than-or-equal operator, '<='.
  - MINUS
```
public static final org.apache.calcite.sql.SqlBinaryOperator MINUS
```
    Infix arithmetic minus operator, '-'.
    Its precedence is less than the prefix + and - operators.
  - MULTIPLY
```
public static final org.apache.calcite.sql.SqlBinaryOperator MULTIPLY
```
    Arithmetic multiplication operator, '*'.
  - NOT_EQUALS
```
public static final org.apache.calcite.sql.SqlBinaryOperator NOT_EQUALS
```
    Logical not-equals operator, '<>'.
  - OR
```
public static final org.apache.calcite.sql.SqlBinaryOperator OR
```
    Logical OR operator.
  - PLUS
```
public static final org.apache.calcite.sql.SqlBinaryOperator PLUS
```
    Infix arithmetic plus operator, '+'.
  - DATETIME_PLUS
```
public static final org.apache.calcite.sql.SqlSpecialOperator DATETIME_PLUS
```
    Infix datetime plus operator, 'DATETIME + INTERVAL'.
  - MEMBER_OF
```
public static final org.apache.calcite.sql.SqlBinaryOperator MEMBER_OF
```
    Multiset MEMBER OF, which returns whether a element belongs to a multiset.
    For example, the following returns false:
    'green' MEMBER OF MULTISET ['red','almost green','blue']
  - SUBMULTISET_OF
```
public static final org.apache.calcite.sql.SqlBinaryOperator SUBMULTISET_OF
```
    Submultiset. Checks to see if an multiset is a sub-set of another multiset.
    For example, the following returns false:
    MULTISET ['green'] SUBMULTISET OF MULTISET['red', 'almost green', 'blue']
    
    The following returns true, in part because multisets are order-independent:
    MULTISET ['blue', 'red'] SUBMULTISET OF MULTISET ['red', 'almost green', 'blue']
  - DESC
```
public static final org.apache.calcite.sql.SqlPostfixOperator DESC
```
  - NULLS_FIRST
```
public static final org.apache.calcite.sql.SqlPostfixOperator NULLS_FIRST
```
  - NULLS_LAST
```
public static final org.apache.calcite.sql.SqlPostfixOperator NULLS_LAST
```
  - IS_NOT_NULL
```
public static final org.apache.calcite.sql.SqlPostfixOperator IS_NOT_NULL
```
  - IS_NULL
```
public static final org.apache.calcite.sql.SqlPostfixOperator IS_NULL
```
  - IS_NOT_TRUE
```
public static final org.apache.calcite.sql.SqlPostfixOperator IS_NOT_TRUE
```
  - IS_TRUE
```
public static final org.apache.calcite.sql.SqlPostfixOperator IS_TRUE
```
  - IS_NOT_FALSE
```
public static final org.apache.calcite.sql.SqlPostfixOperator IS_NOT_FALSE
```
  - IS_FALSE
```
public static final org.apache.calcite.sql.SqlPostfixOperator IS_FALSE
```
  - IS_NOT_UNKNOWN
```
public static final org.apache.calcite.sql.SqlPostfixOperator IS_NOT_UNKNOWN
```
  - IS_UNKNOWN
```
public static final org.apache.calcite.sql.SqlPostfixOperator IS_UNKNOWN
```
  - IS_A_SET
```
public static final org.apache.calcite.sql.SqlPostfixOperator IS_A_SET
```
  - EXISTS
```
public static final org.apache.calcite.sql.SqlPrefixOperator EXISTS
```
  - NOT
```
public static final org.apache.calcite.sql.SqlPrefixOperator NOT
```
  - UNARY_MINUS
```
public static final org.apache.calcite.sql.SqlPrefixOperator UNARY_MINUS
```
    Prefix arithmetic minus operator, '-'.
    Its precedence is greater than the infix '+' and '-' operators.
  - UNARY_PLUS
```
public static final org.apache.calcite.sql.SqlPrefixOperator UNARY_PLUS
```
    Prefix arithmetic plus operator, '+'.
    Its precedence is greater than the infix '+' and '-' operators.
  - EXPLICIT_TABLE
```
public static final org.apache.calcite.sql.SqlPrefixOperator EXPLICIT_TABLE
```
    Keyword which allows an identifier to be explicitly flagged as a table. For example, select * from (TABLE t) or TABLE t. See also COLLECTION_TABLE.
  - SUM
```
public static final org.apache.calcite.sql.SqlAggFunction SUM
```
    SUM aggregate function.
  - COUNT
```
public static final org.apache.calcite.sql.SqlAggFunction COUNT
```
    COUNT aggregate function.
  - MIN
```
public static final org.apache.calcite.sql.SqlAggFunction MIN
```
    MIN aggregate function.
  - MAX
```
public static final org.apache.calcite.sql.SqlAggFunction MAX
```
    MAX aggregate function.
  - LAST_VALUE
```
public static final org.apache.calcite.sql.SqlAggFunction LAST_VALUE
```
    LAST_VALUE aggregate function.
  - FIRST_VALUE
```
public static final org.apache.calcite.sql.SqlAggFunction FIRST_VALUE
```
    FIRST_VALUE aggregate function.
  - LEAD
```
public static final org.apache.calcite.sql.SqlAggFunction LEAD
```
    LEAD aggregate function.
  - LAG
```
public static final org.apache.calcite.sql.SqlAggFunction LAG
```
    LAG aggregate function.
  - NTILE
```
public static final org.apache.calcite.sql.SqlAggFunction NTILE
```
    NTILE aggregate function.
  - SINGLE_VALUE
```
public static final org.apache.calcite.sql.SqlAggFunction SINGLE_VALUE
```
    SINGLE_VALUE aggregate function.
  - AVG
```
public static final org.apache.calcite.sql.SqlAggFunction AVG
```
    AVG aggregate function.
  - STDDEV_POP
```
public static final org.apache.calcite.sql.SqlAggFunction STDDEV_POP
```
    STDDEV_POP aggregate function.
  - REGR_SXX
```
public static final org.apache.calcite.sql.SqlAggFunction REGR_SXX
```
    REGR_SXX aggregate function.
  - REGR_SYY
```
public static final org.apache.calcite.sql.SqlAggFunction REGR_SYY
```
    REGR_SYY aggregate function.
  - COVAR_POP
```
public static final org.apache.calcite.sql.SqlAggFunction COVAR_POP
```
    COVAR_POP aggregate function.
  - COVAR_SAMP
```
public static final org.apache.calcite.sql.SqlAggFunction COVAR_SAMP
```
    COVAR_SAMP aggregate function.
  - STDDEV_SAMP
```
public static final org.apache.calcite.sql.SqlAggFunction STDDEV_SAMP
```
    STDDEV_SAMP aggregate function.
  - VAR_POP
```
public static final org.apache.calcite.sql.SqlAggFunction VAR_POP
```
    VAR_POP aggregate function.
  - VAR_SAMP
```
public static final org.apache.calcite.sql.SqlAggFunction VAR_SAMP
```
    VAR_SAMP aggregate function.
  - HISTOGRAM_AGG
```
public static final org.apache.calcite.sql.SqlAggFunction HISTOGRAM_AGG
```
    HISTOGRAM aggregate function support. Used by window aggregate versions of MIN/MAX
  - HISTOGRAM_MIN
```
public static final org.apache.calcite.sql.SqlFunction HISTOGRAM_MIN
```
    HISTOGRAM_MIN window aggregate function.
  - HISTOGRAM_MAX
```
public static final org.apache.calcite.sql.SqlFunction HISTOGRAM_MAX
```
    HISTOGRAM_MAX window aggregate function.
  - HISTOGRAM_FIRST_VALUE
```
public static final org.apache.calcite.sql.SqlFunction HISTOGRAM_FIRST_VALUE
```
    HISTOGRAM_FIRST_VALUE window aggregate function.
  - HISTOGRAM_LAST_VALUE
```
public static final org.apache.calcite.sql.SqlFunction HISTOGRAM_LAST_VALUE
```
    HISTOGRAM_LAST_VALUE window aggregate function.
  - SUM0
```
public static final org.apache.calcite.sql.SqlAggFunction SUM0
```
    SUM0 aggregate function.
  - CUME_DIST
```
public static final org.apache.calcite.sql.SqlRankFunction CUME_DIST
```
    CUME_DIST window function.
  - DENSE_RANK
```
public static final org.apache.calcite.sql.SqlRankFunction DENSE_RANK
```
    DENSE_RANK window function.
  - PERCENT_RANK
```
public static final org.apache.calcite.sql.SqlRankFunction PERCENT_RANK
```
    PERCENT_RANK window function.
  - RANK
```
public static final org.apache.calcite.sql.SqlRankFunction RANK
```
    RANK window function.
  - ROW_NUMBER
```
public static final org.apache.calcite.sql.SqlRankFunction ROW_NUMBER
```
    ROW_NUMBER window function.
  - ROW
```
public static final org.apache.calcite.sql.fun.SqlRowOperator ROW
```
  - MINUS_DATE
```
public static final org.apache.calcite.sql.fun.SqlDatetimeSubtractionOperator MINUS_DATE
```
    A special operator for the subtraction of two DATETIMEs. The format of DATETIME subtraction is:
    "(" <datetime> "-" <datetime> ")" <interval qualifier>
    
    This operator is special since it needs to hold the additional interval qualifier specification.
  - MULTISET_VALUE
```
public static final org.apache.calcite.sql.fun.SqlMultisetValueConstructor MULTISET_VALUE
```
    The MULTISET Value Constructor. e.g. "MULTISET[1,2,3]".
  - MULTISET_QUERY
```
public static final org.apache.calcite.sql.fun.SqlMultisetQueryConstructor MULTISET_QUERY
```
    The MULTISET Query Constructor. e.g. "SELECT dname, MULTISET(SELECT FROM emp WHERE deptno = dept.deptno) FROM dept".
  - ARRAY_QUERY
```
public static final org.apache.calcite.sql.fun.SqlMultisetQueryConstructor ARRAY_QUERY
```
    The ARRAY Query Constructor. e.g. "SELECT dname, ARRAY(SELECT FROM emp WHERE deptno = dept.deptno) FROM dept".
  - MAP_QUERY
```
public static final org.apache.calcite.sql.fun.SqlMultisetQueryConstructor MAP_QUERY
```
    The MAP Query Constructor. e.g. "MAP(SELECT empno, deptno FROM emp)".
  - CURSOR
```
public static final org.apache.calcite.sql.fun.SqlCursorConstructor CURSOR
```
    The CURSOR constructor. e.g. "SELECT * FROM TABLE(DEDUP(CURSOR(SELECT * FROM EMPS), 'name'))".
  - COLUMN_LIST
```
public static final org.apache.calcite.sql.fun.SqlColumnListConstructor COLUMN_LIST
```
    The COLUMN_LIST constructor. e.g. the ROW() call in "SELECT * FROM TABLE(DEDUP(CURSOR(SELECT * FROM EMPS), ROW(name, empno)))".
  - UNNEST
```
public static final org.apache.calcite.sql.SqlUnnestOperator UNNEST
```
    The UNNEST operator.
  - UNNEST_WITH_ORDINALITY
```
public static final org.apache.calcite.sql.SqlUnnestOperator UNNEST_WITH_ORDINALITY
```
    The UNNEST WITH ORDINALITY operator.
  - LATERAL
```
public static final org.apache.calcite.sql.SqlSpecialOperator LATERAL
```
    The LATERAL operator.
  - COLLECTION_TABLE
```
public static final org.apache.calcite.sql.SqlSpecialOperator COLLECTION_TABLE
```
    The "table function derived table" operator, which a table-valued function into a relation, e.g. "SELECT * FROM TABLE(ramp(5))".
    This operator has function syntax (with one argument), whereas EXPLICIT_TABLE is a prefix operator.
  - OVERLAPS
```
public static final org.apache.calcite.sql.fun.SqlOverlapsOperator OVERLAPS
```
  - VALUES
```
public static final org.apache.calcite.sql.SqlSpecialOperator VALUES
```
  - LITERAL_CHAIN
```
public static final org.apache.calcite.sql.fun.SqlLiteralChainOperator LITERAL_CHAIN
```
  - THROW
```
public static final org.apache.calcite.sql.fun.SqlThrowOperator THROW
```
  - BETWEEN
```
public static final org.apache.calcite.sql.fun.SqlBetweenOperator BETWEEN
```
  - SYMMETRIC_BETWEEN
```
public static final org.apache.calcite.sql.fun.SqlBetweenOperator SYMMETRIC_BETWEEN
```
  - NOT_BETWEEN
```
public static final org.apache.calcite.sql.fun.SqlBetweenOperator NOT_BETWEEN
```
  - SYMMETRIC_NOT_BETWEEN
```
public static final org.apache.calcite.sql.fun.SqlBetweenOperator SYMMETRIC_NOT_BETWEEN
```
  - NOT_LIKE
```
public static final org.apache.calcite.sql.SqlSpecialOperator NOT_LIKE
```
  - LIKE
```
public static final org.apache.calcite.sql.SqlSpecialOperator LIKE
```
  - NOT_SIMILAR_TO
```
public static final org.apache.calcite.sql.SqlSpecialOperator NOT_SIMILAR_TO
```
  - SIMILAR_TO
```
public static final org.apache.calcite.sql.SqlSpecialOperator SIMILAR_TO
```
  - ESCAPE
```
public static final org.apache.calcite.sql.SqlSpecialOperator ESCAPE
```
    Internal operator used to represent the ESCAPE clause of a LIKE or SIMILAR TO expression.
  - CASE
```
public static final org.apache.calcite.sql.fun.SqlCaseOperator CASE
```
  - PROCEDURE_CALL
```
public static final org.apache.calcite.sql.SqlOperator PROCEDURE_CALL
```
  - NEW
```
public static final org.apache.calcite.sql.SqlOperator NEW
```
  - OVER
```
public static final org.apache.calcite.sql.SqlBinaryOperator OVER
```
    The OVER operator, which applies an aggregate functions to a window.
    Operands are as follows:
    1. name of window function (SqlCall)
    2. window name (SqlLiteral) or window in-line specification (@link SqlWindowOperator})
  - REINTERPRET
```
public static final org.apache.calcite.sql.SqlSpecialOperator REINTERPRET
```
    An REINTERPRET operator is internal to the planner. When the physical storage of two types is the same, this operator may be used to reinterpret values of one type as the other. This operator is similar to a cast, except that it does not alter the data value. Like a regular cast it accepts one operand and stores the target type as the return type. It performs an overflow check if it has any second operand, whether true or not.
  - EXTRACT_DATE
```
public static final org.apache.calcite.sql.SqlSpecialOperator EXTRACT_DATE
```
    Internal operator that extracts time periods (year, month, date) from a date in internal format (number of days since epoch).
  - SUBSTRING
```
public static final org.apache.calcite.sql.SqlFunction SUBSTRING
```
    The character substring function: SUBSTRING(string FROM start [FOR length]).
    If the length parameter is a constant, the length of the result is the minimum of the length of the input and that length. Otherwise it is the length of the input.
  - REPLACE
```
public static final org.apache.calcite.sql.SqlFunction REPLACE
```
    The REPLACE(string, search, replace) function. Not standard SQL, but in Oracle and Postgres.
  - CONVERT
```
public static final org.apache.calcite.sql.SqlFunction CONVERT
```
  - TRANSLATE
```
public static final org.apache.calcite.sql.SqlFunction TRANSLATE
```
    The TRANSLATE(char_value USING translation_name) function alters the character set of a string value from one base character set to another.
    It is defined in the SQL standard. See also non-standard OracleSqlOperatorTable.TRANSLATE3.
  - OVERLAY
```
public static final org.apache.calcite.sql.SqlFunction OVERLAY
```
  - TRIM
```
public static final org.apache.calcite.sql.SqlFunction TRIM
```
    The "TRIM" function.
  - POSITION
```
public static final org.apache.calcite.sql.SqlFunction POSITION
```
  - CHAR_LENGTH
```
public static final org.apache.calcite.sql.SqlFunction CHAR_LENGTH
```
  - CHARACTER_LENGTH
```
public static final org.apache.calcite.sql.SqlFunction CHARACTER_LENGTH
```
  - UPPER
```
public static final org.apache.calcite.sql.SqlFunction UPPER
```
  - LOWER
```
public static final org.apache.calcite.sql.SqlFunction LOWER
```
  - INITCAP
```
public static final org.apache.calcite.sql.SqlFunction INITCAP
```
  - POWER
```
public static final org.apache.calcite.sql.SqlFunction POWER
```
    Uses SqlOperatorTable.useDouble for its return type since we don't know what the result type will be by just looking at the operand types. For example POW(int, int) can return a non integer if the second operand is negative.
  - SQRT
```
public static final org.apache.calcite.sql.SqlFunction SQRT
```
  - MOD
```
public static final org.apache.calcite.sql.SqlFunction MOD
```
  - LN
```
public static final org.apache.calcite.sql.SqlFunction LN
```
  - LOG10
```
public static final org.apache.calcite.sql.SqlFunction LOG10
```
  - ABS
```
public static final org.apache.calcite.sql.SqlFunction ABS
```
  - ACOS
```
public static final org.apache.calcite.sql.SqlFunction ACOS
```
  - ASIN
```
public static final org.apache.calcite.sql.SqlFunction ASIN
```
  - ATAN
```
public static final org.apache.calcite.sql.SqlFunction ATAN
```
  - ATAN2
```
public static final org.apache.calcite.sql.SqlFunction ATAN2
```
  - COS
```
public static final org.apache.calcite.sql.SqlFunction COS
```
  - COT
```
public static final org.apache.calcite.sql.SqlFunction COT
```
  - DEGREES
```
public static final org.apache.calcite.sql.SqlFunction DEGREES
```
  - EXP
```
public static final org.apache.calcite.sql.SqlFunction EXP
```
  - RADIANS
```
public static final org.apache.calcite.sql.SqlFunction RADIANS
```
  - ROUND
```
public static final org.apache.calcite.sql.SqlFunction ROUND
```
  - SIGN
```
public static final org.apache.calcite.sql.SqlFunction SIGN
```
  - SIN
```
public static final org.apache.calcite.sql.SqlFunction SIN
```
  - TAN
```
public static final org.apache.calcite.sql.SqlFunction TAN
```
  - TRUNCATE
```
public static final org.apache.calcite.sql.SqlFunction TRUNCATE
```
  - PI
```
public static final org.apache.calcite.sql.SqlFunction PI
```
  - FINAL
```
public static final org.apache.calcite.sql.SqlFunction FINAL
```
    FINAL function to be used within MATCH_RECOGNIZE.
  - RUNNING
```
public static final org.apache.calcite.sql.SqlFunction RUNNING
```
    RUNNING function to be used within MATCH_RECOGNIZE.
  - FIRST
```
public static final org.apache.calcite.sql.SqlFunction FIRST
```
    FIRST function to be used within MATCH_RECOGNIZE.
  - LAST
```
public static final org.apache.calcite.sql.SqlFunction LAST
```
    LAST function to be used within MATCH_RECOGNIZE.
  - PREV
```
public static final org.apache.calcite.sql.SqlFunction PREV
```
    PREV function to be used within MATCH_RECOGNIZE.
  - NEXT
```
public static final org.apache.calcite.sql.SqlFunction NEXT
```
    NEXT function to be used within MATCH_RECOGNIZE.
  - NULLIF
```
public static final org.apache.calcite.sql.SqlFunction NULLIF
```
  - COALESCE
```
public static final org.apache.calcite.sql.SqlFunction COALESCE
```
    The COALESCE builtin function.
  - FLOOR
```
public static final org.apache.calcite.sql.SqlFunction FLOOR
```
    The FLOOR function.
  - CEIL
```
public static final org.apache.calcite.sql.SqlFunction CEIL
```
    The CEIL function.
  - USER
```
public static final org.apache.calcite.sql.SqlFunction USER
```
    The USER function.
  - CURRENT_USER
```
public static final org.apache.calcite.sql.SqlFunction CURRENT_USER
```
    The CURRENT_USER function.
  - SESSION_USER
```
public static final org.apache.calcite.sql.SqlFunction SESSION_USER
```
    The SESSION_USER function.
  - SYSTEM_USER
```
public static final org.apache.calcite.sql.SqlFunction SYSTEM_USER
```
    The SYSTEM_USER function.
  - CURRENT_PATH
```
public static final org.apache.calcite.sql.SqlFunction CURRENT_PATH
```
    The CURRENT_PATH function.
  - CURRENT_ROLE
```
public static final org.apache.calcite.sql.SqlFunction CURRENT_ROLE
```
    The CURRENT_ROLE function.
  - CURRENT_CATALOG
```
public static final org.apache.calcite.sql.SqlFunction CURRENT_CATALOG
```
    The CURRENT_CATALOG function.
  - CURRENT_SCHEMA
```
public static final org.apache.calcite.sql.SqlFunction CURRENT_SCHEMA
```
    The CURRENT_SCHEMA function.
  - LOCALTIME
```
public static final org.apache.calcite.sql.SqlFunction LOCALTIME
```
    The LOCALTIME [(precision)] function.
  - LOCALTIMESTAMP
```
public static final org.apache.calcite.sql.SqlFunction LOCALTIMESTAMP
```
    The LOCALTIMESTAMP [(precision)] function.
  - CURRENT_TIME
```
public static final org.apache.calcite.sql.SqlFunction CURRENT_TIME
```
    The CURRENT_TIME [(precision)] function.
  - CURRENT_TIMESTAMP
```
public static final org.apache.calcite.sql.SqlFunction CURRENT_TIMESTAMP
```
    The CURRENT_TIMESTAMP [(precision)] function.
  - CURRENT_DATE
```
public static final org.apache.calcite.sql.SqlFunction CURRENT_DATE
```
    The CURRENT_DATE function.
  - TIMESTAMP_ADD
```
public static final org.apache.calcite.sql.SqlFunction TIMESTAMP_ADD
```
    The TIMESTAMPADD function.
  - TIMESTAMP_DIFF
```
public static final org.apache.calcite.sql.SqlFunction TIMESTAMP_DIFF
```
    The TIMESTAMPDIFF function.
  - IN_FENNEL
```
public static final org.apache.calcite.sql.SqlFunction IN_FENNEL
```
    Use of the IN_FENNEL operator forces the argument to be evaluated in Fennel. Otherwise acts as identity function.
  - CAST
```
public static final org.apache.calcite.sql.SqlFunction CAST
```
    The SQL CAST operator.
    The SQL syntax is
    CAST(expression AS type)
    
    When the CAST operator is applies as a SqlCall, it has two arguments: the expression and the type. The type must not include a constraint, so CAST(x AS INTEGER NOT NULL), for instance, is invalid.
    
    When the CAST operator is applied as a RexCall, the target type is simply stored as the return type, not an explicit operand. For example, the expression CAST(1 + 2 AS DOUBLE) will become a call to CAST with the expression 1 + 2 as its only operand.
    
    The RexCall form can also have a type which contains a NOT NULL constraint. When this expression is implemented, if the value is NULL, an exception will be thrown.
  - EXTRACT
```
public static final org.apache.calcite.sql.SqlFunction EXTRACT
```
    The SQL EXTRACT operator. Extracts a specified field value from a DATETIME or an INTERVAL. E.g.
    EXTRACT(HOUR FROM INTERVAL '364 23:59:59') returns 23
  - YEAR
```
public static final org.apache.calcite.sql.fun.SqlDatePartFunction YEAR
```
    The SQL YEAR operator. Returns the Year from a DATETIME E.g.
    YEAR(date '2008-9-23') returns 2008
  - QUARTER
```
public static final org.apache.calcite.sql.fun.SqlDatePartFunction QUARTER
```
    The SQL QUARTER operator. Returns the Quarter from a DATETIME E.g.
    QUARTER(date '2008-9-23') returns 3
  - MONTH
```
public static final org.apache.calcite.sql.fun.SqlDatePartFunction MONTH
```
    The SQL MONTH operator. Returns the Month from a DATETIME E.g.
    MONTH(date '2008-9-23') returns 9
  - WEEK
```
public static final org.apache.calcite.sql.fun.SqlDatePartFunction WEEK
```
    The SQL WEEK operator. Returns the Week from a DATETIME E.g.
    WEEK(date '2008-9-23') returns 39
  - DAYOFYEAR
```
public static final org.apache.calcite.sql.fun.SqlDatePartFunction DAYOFYEAR
```
    The SQL DAYOFYEAR operator. Returns the DOY from a DATETIME E.g.
    DAYOFYEAR(date '2008-9-23') returns 267
  - DAYOFMONTH
```
public static final org.apache.calcite.sql.fun.SqlDatePartFunction DAYOFMONTH
```
    The SQL DAYOFMONTH operator. Returns the Day from a DATETIME E.g.
    DAYOFMONTH(date '2008-9-23') returns 23
  - DAYOFWEEK
```
public static final org.apache.calcite.sql.fun.SqlDatePartFunction DAYOFWEEK
```
    The SQL DAYOFWEEK operator. Returns the DOW from a DATETIME E.g.
    DAYOFWEEK(date '2008-9-23') returns 2
  - HOUR
```
public static final org.apache.calcite.sql.fun.SqlDatePartFunction HOUR
```
    The SQL HOUR operator. Returns the Hour from a DATETIME E.g.
    HOUR(timestamp '2008-9-23 01:23:45') returns 1
  - MINUTE
```
public static final org.apache.calcite.sql.fun.SqlDatePartFunction MINUTE
```
    The SQL MINUTE operator. Returns the Minute from a DATETIME E.g.
    MINUTE(timestamp '2008-9-23 01:23:45') returns 23
  - SECOND
```
public static final org.apache.calcite.sql.fun.SqlDatePartFunction SECOND
```
    The SQL SECOND operator. Returns the Second from a DATETIME E.g.
    SECOND(timestamp '2008-9-23 01:23:45') returns 45
  - ELEMENT
```
public static final org.apache.calcite.sql.SqlFunction ELEMENT
```
    The ELEMENT operator, used to convert a multiset with only one item to a "regular" type. Example ... log(ELEMENT(MULTISET[1])) ...
  - ITEM
```
public static final org.apache.calcite.sql.SqlOperator ITEM
```
    The item operator [ ... ], used to access a given element of an array or map. For example, myArray[3] or "myMap['foo']".
    The SQL standard calls the ARRAY variant a <array element reference>. Index is 1-based. The standard says to raise "data exception - array element error" but we currently return null.
    
    MAP is not standard SQL.
  - ARRAY_VALUE_CONSTRUCTOR
```
public static final org.apache.calcite.sql.fun.SqlArrayValueConstructor ARRAY_VALUE_CONSTRUCTOR
```
    The ARRAY Value Constructor. e.g. "ARRAY[1, 2, 3]".
  - MAP_VALUE_CONSTRUCTOR
```
public static final org.apache.calcite.sql.fun.SqlMapValueConstructor MAP_VALUE_CONSTRUCTOR
```
    The MAP Value Constructor, e.g. "MAP['washington', 1, 'obama', 44]".
  - SLICE
```
public static final org.apache.calcite.sql.SqlInternalOperator SLICE
```
    The internal "$SLICE" operator takes a multiset of records and returns a multiset of the first column of those records.
    It is introduced when multisets of scalar types are created, in order to keep types consistent. For example, MULTISET [5] has type INTEGER MULTISET but is translated to an expression of type RECORD(INTEGER EXPR$0) MULTISET because in our internal representation of multisets, every element must be a record. Applying the "$SLICE" operator to this result converts the type back to an INTEGER MULTISET multiset value.
    $SLICE is often translated away when the multiset type is converted back to scalar values.
  - ELEMENT_SLICE
```
public static final org.apache.calcite.sql.SqlInternalOperator ELEMENT_SLICE
```
    The internal "$ELEMENT_SLICE" operator returns the first field of the only element of a multiset.
    It is introduced when multisets of scalar types are created, in order to keep types consistent. For example, ELEMENT(MULTISET [5]) is translated to $ELEMENT_SLICE(MULTISET (VALUES ROW (5 EXPR$0)) It is translated away when the multiset type is converted back to scalar values.
    
    NOTE: jhyde, 2006/1/9: Usages of this operator are commented out, but I'm not deleting the operator, because some multiset tests are disabled, and we may need this operator to get them working!
  - SCALAR_QUERY
```
public static final org.apache.calcite.sql.SqlInternalOperator SCALAR_QUERY
```
    The internal "$SCALAR_QUERY" operator returns a scalar value from a record type. It assumes the record type only has one field, and returns that field as the output.
  - CARDINALITY
```
public static final org.apache.calcite.sql.SqlFunction CARDINALITY
```
    The CARDINALITY operator, used to retrieve the number of elements in a MULTISET, ARRAY or MAP.
  - COLLECT
```
public static final org.apache.calcite.sql.SqlAggFunction COLLECT
```
    The COLLECT operator. Multiset aggregator function.
  - FUSION
```
public static final org.apache.calcite.sql.SqlFunction FUSION
```
    The FUSION operator. Multiset aggregator function.
  - NEXT_VALUE
```
public static final org.apache.calcite.sql.SqlOperator NEXT_VALUE
```
    The sequence next value function: NEXT VALUE FOR sequence
  - CURRENT_VALUE
```
public static final org.apache.calcite.sql.SqlOperator CURRENT_VALUE
```
    The sequence current value function: CURRENT VALUE FOR sequence
  - TABLESAMPLE
```
public static final org.apache.calcite.sql.SqlSpecialOperator TABLESAMPLE
```
    The TABLESAMPLE operator.
    Examples:
    - <query> TABLESAMPLE SUBSTITUTE('sampleName') (non-standard)
    - <query> TABLESAMPLE BERNOULLI(<percent>) [REPEATABLE(<seed>)] (standard, but not implemented for FTRS yet)
    - <query> TABLESAMPLE SYSTEM(<percent>) [REPEATABLE(<seed>)] (standard, but not implemented for FTRS yet)
    Operand #0 is a query or table; Operand #1 is a SqlSampleSpec wrapped in a SqlLiteral.
  - TUMBLE
```
public static final org.apache.calcite.sql.fun.SqlGroupFunction TUMBLE
```
    The TUMBLE group function.
  - TUMBLE_START
```
public static final org.apache.calcite.sql.fun.SqlGroupFunction TUMBLE_START
```
    The TUMBLE_START auxiliary function of the TUMBLE group function.
  - TUMBLE_END
```
public static final org.apache.calcite.sql.fun.SqlGroupFunction TUMBLE_END
```
    The TUMBLE_END auxiliary function of the TUMBLE group function.
  - HOP
```
public static final org.apache.calcite.sql.fun.SqlGroupFunction HOP
```
    The HOP group function.
  - HOP_START
```
public static final org.apache.calcite.sql.fun.SqlGroupFunction HOP_START
```
    The HOP_START auxiliary function of the HOP group function.
  - HOP_END
```
public static final org.apache.calcite.sql.fun.SqlGroupFunction HOP_END
```
    The HOP_END auxiliary function of the HOP group function.
  - SESSION
```
public static final org.apache.calcite.sql.fun.SqlGroupFunction SESSION
```
    The SESSION group function.
  - SESSION_START
```
public static final org.apache.calcite.sql.fun.SqlGroupFunction SESSION_START
```
    The SESSION_START auxiliary function of the SESSION group function.
  - SESSION_END
```
public static final org.apache.calcite.sql.fun.SqlGroupFunction SESSION_END
```
    The SESSION_END auxiliary function of the SESSION group function.
  - PATTERN_ALTER
```
public static final org.apache.calcite.sql.SqlBinaryOperator PATTERN_ALTER
```
    | operator to create alternate patterns within MATCH_RECOGNIZE.
    If p1 and p2 are patterns then p1 | p2 is a pattern that matches p1 or p2.
  - PATTERN_CONCAT
```
public static final org.apache.calcite.sql.SqlBinaryOperator PATTERN_CONCAT
```
    Operator to concatenate patterns within MATCH_RECOGNIZE.
    If p1 and p2 are patterns then p1 p2 is a pattern that matches p1 followed by p2.
  - PATTERN_QUANTIFIER
```
public static final org.apache.calcite.sql.SqlSpecialOperator PATTERN_QUANTIFIER
```
    Operator to quantify patterns within MATCH_RECOGNIZE.
    If p is a pattern then p{3, 5} is a pattern that matches between 3 and 5 occurrences of p.
  - PATTERN_PERMUTE
```
public static final org.apache.calcite.sql.SqlSpecialOperator PATTERN_PERMUTE
```
    PERMUTE operator to combine patterns within MATCH_RECOGNIZE.
    If p1 and p2 are patterns then PERMUTE (p1, p2) is a pattern that matches all permutations of p1 and p2.
  - PATTERN_EXCLUDE
```
public static final org.apache.calcite.sql.SqlSpecialOperator PATTERN_EXCLUDE
```
    EXCLUDE operator within MATCH_RECOGNIZE.
    If p is a pattern then {- p -} } is a pattern that excludes p from the output.
- Constructor Detail
  - SqlStdOperatorTable
```
public SqlStdOperatorTable()
```
- Method Detail
  - instance
```
public static SqlStdOperatorTable instance()
```
    Returns the standard operator table, creating it if necessary.
  - auxiliaryToGroup
```
public static org.apache.calcite.sql.fun.SqlGroupFunction auxiliaryToGroup(org.apache.calcite.sql.SqlKind kind)
```
    Returns the group function for which a given kind is an auxiliary function, or null if it is not an auxiliary function.
  - convertAuxiliaryToGroupCall
```
public static org.apache.calcite.sql.SqlCall convertAuxiliaryToGroupCall(org.apache.calcite.sql.SqlCall call)
```
    Converts a call to a grouped auxiliary function to a call to the grouped window function. For other calls returns null.
    For example, converts TUMBLE_START(rowtime, INTERVAL '1' HOUR)) to TUMBLE(rowtime, INTERVAL '1' HOUR)).
  - convertGroupToAuxiliaryCalls
```
public static List<org.apache.calcite.util.Pair<org.apache.calcite.sql.SqlNode,AuxiliaryConverter>> convertGroupToAuxiliaryCalls(org.apache.calcite.sql.SqlCall call)
```
    Converts a call to a grouped window function to a call to its auxiliary window function(s). For other calls returns null.
    For example, converts TUMBLE_START(rowtime, INTERVAL '1' HOUR)) to TUMBLE(rowtime, INTERVAL '1' HOUR)).

Class SqlStdOperatorTable

Field Summary

Fields inherited from class org.apache.calcite.sql.util.ReflectiveSqlOperatorTable

Constructor Summary

Method Summary

Methods inherited from class org.apache.calcite.sql.util.ReflectiveSqlOperatorTable

Methods inherited from class java.lang.Object

Field Detail

UNION

UNION_ALL

EXCEPT

EXCEPT_ALL

INTERSECT

INTERSECT_ALL

MULTISET_UNION

MULTISET_UNION_ALL

MULTISET_EXCEPT

MULTISET_EXCEPT_ALL

MULTISET_INTERSECT

MULTISET_INTERSECT_ALL

AND

AS

ARGUMENT_ASSIGNMENT

DEFAULT

FILTER

CUBE

ROLLUP

GROUPING_SETS

GROUPING

GROUP_ID

GROUPING_ID

EXTEND

CONCAT

DIVIDE

RAND_INTEGER

RAND

DIVIDE_INTEGER

DOT

EQUALS

GREATER_THAN

IS_DISTINCT_FROM

IS_NOT_DISTINCT_FROM

IS_DIFFERENT_FROM

GREATER_THAN_OR_EQUAL

IN

NOT_IN

LESS_THAN

LESS_THAN_OR_EQUAL

MINUS

MULTIPLY

NOT_EQUALS

OR

PLUS

DATETIME_PLUS

MEMBER_OF

SUBMULTISET_OF

DESC

NULLS_FIRST

NULLS_LAST

IS_NOT_NULL

IS_NULL

IS_NOT_TRUE

IS_TRUE

IS_NOT_FALSE

IS_FALSE

IS_NOT_UNKNOWN

IS_UNKNOWN

IS_A_SET

EXISTS

NOT

UNARY_MINUS

UNARY_PLUS

EXPLICIT_TABLE

SUM

COUNT

MIN

MAX

LAST_VALUE

FIRST_VALUE

LEAD