public class SqlStdOperatorTable
extends org.apache.calcite.sql.util.ReflectiveSqlOperatorTable
SqlOperatorTable
containing
the standard operators and functions.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. |
Constructor and Description |
---|
SqlStdOperatorTable() |
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.
|
public static final org.apache.calcite.sql.SqlSetOperator UNION
public static final org.apache.calcite.sql.SqlSetOperator UNION_ALL
public static final org.apache.calcite.sql.SqlSetOperator EXCEPT
public static final org.apache.calcite.sql.SqlSetOperator EXCEPT_ALL
public static final org.apache.calcite.sql.SqlSetOperator INTERSECT
public static final org.apache.calcite.sql.SqlSetOperator INTERSECT_ALL
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_UNION
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_UNION_ALL
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_EXCEPT
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_EXCEPT_ALL
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_INTERSECT
public static final org.apache.calcite.sql.fun.SqlMultisetSetOperator MULTISET_INTERSECT_ALL
public static final org.apache.calcite.sql.SqlBinaryOperator AND
AND
operator.public static final org.apache.calcite.sql.SqlAsOperator AS
AS
operator associates an expression in the SELECT clause
with an alias.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.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..public static final org.apache.calcite.sql.SqlFilterOperator FILTER
FILTER
operator filters which rows are included in an
aggregate function.public static final org.apache.calcite.sql.SqlInternalOperator CUBE
CUBE
operator, occurs within GROUP BY
clause
or nested within a GROUPING SETS
.public static final org.apache.calcite.sql.SqlInternalOperator ROLLUP
ROLLUP
operator, occurs within GROUP BY
clause
or nested within a 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
.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.public static final org.apache.calcite.sql.fun.SqlGroupIdFunction GROUP_ID
GROUP_ID
function.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
.
public static final org.apache.calcite.sql.SqlInternalOperator EXTEND
EXTEND
operator.public static final org.apache.calcite.sql.SqlBinaryOperator CONCAT
||
'.public static final org.apache.calcite.sql.SqlBinaryOperator DIVIDE
/
'.public static final org.apache.calcite.sql.fun.SqlRandIntegerFunction RAND_INTEGER
RAND_INTEGER([seed, ] bound)
function, which yields a random
integer, optionally with seed.public static final org.apache.calcite.sql.fun.SqlRandFunction RAND
RAND([seed])
function, which yields a random double,
optionally with seed.public static final org.apache.calcite.sql.SqlBinaryOperator DIVIDE_INTEGER
/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.public static final org.apache.calcite.sql.SqlBinaryOperator DOT
.
', used for referencing fields of records.public static final org.apache.calcite.sql.SqlBinaryOperator EQUALS
=
'.public static final org.apache.calcite.sql.SqlBinaryOperator GREATER_THAN
>
'.public static final org.apache.calcite.sql.SqlBinaryOperator IS_DISTINCT_FROM
IS DISTINCT FROM
operator.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)
public static final org.apache.calcite.sql.SqlBinaryOperator IS_DIFFERENT_FROM
$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.public static final org.apache.calcite.sql.SqlBinaryOperator GREATER_THAN_OR_EQUAL
>=
'.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.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.public static final org.apache.calcite.sql.SqlBinaryOperator LESS_THAN
<
'.public static final org.apache.calcite.sql.SqlBinaryOperator LESS_THAN_OR_EQUAL
<=
'.public static final org.apache.calcite.sql.SqlBinaryOperator MINUS
public static final org.apache.calcite.sql.SqlBinaryOperator MULTIPLY
*
'.public static final org.apache.calcite.sql.SqlBinaryOperator NOT_EQUALS
<>
'.public static final org.apache.calcite.sql.SqlBinaryOperator OR
OR
operator.public static final org.apache.calcite.sql.SqlBinaryOperator PLUS
+
'.public static final org.apache.calcite.sql.SqlSpecialOperator DATETIME_PLUS
DATETIME + INTERVAL
'.public static final org.apache.calcite.sql.SqlBinaryOperator MEMBER_OF
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']
public static final org.apache.calcite.sql.SqlBinaryOperator SUBMULTISET_OF
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']
public static final org.apache.calcite.sql.SqlPostfixOperator DESC
public static final org.apache.calcite.sql.SqlPostfixOperator NULLS_FIRST
public static final org.apache.calcite.sql.SqlPostfixOperator NULLS_LAST
public static final org.apache.calcite.sql.SqlPostfixOperator IS_NOT_NULL
public static final org.apache.calcite.sql.SqlPostfixOperator IS_NULL
public static final org.apache.calcite.sql.SqlPostfixOperator IS_NOT_TRUE
public static final org.apache.calcite.sql.SqlPostfixOperator IS_TRUE
public static final org.apache.calcite.sql.SqlPostfixOperator IS_NOT_FALSE
public static final org.apache.calcite.sql.SqlPostfixOperator IS_FALSE
public static final org.apache.calcite.sql.SqlPostfixOperator IS_NOT_UNKNOWN
public static final org.apache.calcite.sql.SqlPostfixOperator IS_UNKNOWN
public static final org.apache.calcite.sql.SqlPostfixOperator IS_A_SET
public static final org.apache.calcite.sql.SqlPrefixOperator EXISTS
public static final org.apache.calcite.sql.SqlPrefixOperator NOT
public static final org.apache.calcite.sql.SqlPrefixOperator UNARY_MINUS
public static final org.apache.calcite.sql.SqlPrefixOperator UNARY_PLUS
public static final org.apache.calcite.sql.SqlPrefixOperator EXPLICIT_TABLE
select * from (TABLE t)
or TABLE
t
. See also COLLECTION_TABLE
.public static final org.apache.calcite.sql.SqlAggFunction SUM
SUM
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction COUNT
COUNT
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction MIN
MIN
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction MAX
MAX
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction LAST_VALUE
LAST_VALUE
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction FIRST_VALUE
FIRST_VALUE
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction LEAD
LEAD
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction LAG
LAG
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction NTILE
NTILE
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction SINGLE_VALUE
SINGLE_VALUE
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction AVG
AVG
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction STDDEV_POP
STDDEV_POP
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction REGR_SXX
REGR_SXX
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction REGR_SYY
REGR_SYY
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction COVAR_POP
COVAR_POP
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction COVAR_SAMP
COVAR_SAMP
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction STDDEV_SAMP
STDDEV_SAMP
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction VAR_POP
VAR_POP
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction VAR_SAMP
VAR_SAMP
aggregate function.public static final org.apache.calcite.sql.SqlAggFunction HISTOGRAM_AGG
HISTOGRAM
aggregate function support. Used by window
aggregate versions of MIN/MAXpublic static final org.apache.calcite.sql.SqlFunction HISTOGRAM_MIN
HISTOGRAM_MIN
window aggregate function.public static final org.apache.calcite.sql.SqlFunction HISTOGRAM_MAX
HISTOGRAM_MAX
window aggregate function.public static final org.apache.calcite.sql.SqlFunction HISTOGRAM_FIRST_VALUE
HISTOGRAM_FIRST_VALUE
window aggregate function.public static final org.apache.calcite.sql.SqlFunction HISTOGRAM_LAST_VALUE
HISTOGRAM_LAST_VALUE
window aggregate function.public static final org.apache.calcite.sql.SqlAggFunction SUM0
SUM0
aggregate function.public static final org.apache.calcite.sql.SqlRankFunction CUME_DIST
CUME_DIST
window function.public static final org.apache.calcite.sql.SqlRankFunction DENSE_RANK
DENSE_RANK
window function.public static final org.apache.calcite.sql.SqlRankFunction PERCENT_RANK
PERCENT_RANK
window function.public static final org.apache.calcite.sql.SqlRankFunction RANK
RANK
window function.public static final org.apache.calcite.sql.SqlRankFunction ROW_NUMBER
ROW_NUMBER
window function.public static final org.apache.calcite.sql.fun.SqlRowOperator ROW
public static final org.apache.calcite.sql.fun.SqlDatetimeSubtractionOperator MINUS_DATE
"(" <datetime> "-" <datetime> ")"
<interval qualifier>
This operator is special since it needs to hold the additional interval qualifier specification.
public static final org.apache.calcite.sql.fun.SqlMultisetValueConstructor MULTISET_VALUE
MULTISET[1,2,3]
".public static final org.apache.calcite.sql.fun.SqlMultisetQueryConstructor MULTISET_QUERY
SELECT dname, MULTISET(SELECT
FROM emp WHERE deptno = dept.deptno) FROM dept
".public static final org.apache.calcite.sql.fun.SqlMultisetQueryConstructor ARRAY_QUERY
SELECT dname, ARRAY(SELECT
FROM emp WHERE deptno = dept.deptno) FROM dept
".public static final org.apache.calcite.sql.fun.SqlMultisetQueryConstructor MAP_QUERY
MAP(SELECT empno, deptno
FROM emp)
".public static final org.apache.calcite.sql.fun.SqlCursorConstructor CURSOR
SELECT * FROM
TABLE(DEDUP(CURSOR(SELECT * FROM EMPS), 'name'))
".public static final org.apache.calcite.sql.fun.SqlColumnListConstructor COLUMN_LIST
SELECT * FROM
TABLE(DEDUP(CURSOR(SELECT * FROM EMPS), ROW(name, empno)))
".public static final org.apache.calcite.sql.SqlUnnestOperator UNNEST
UNNEST
operator.public static final org.apache.calcite.sql.SqlUnnestOperator UNNEST_WITH_ORDINALITY
UNNEST WITH ORDINALITY
operator.public static final org.apache.calcite.sql.SqlSpecialOperator LATERAL
LATERAL
operator.public static final org.apache.calcite.sql.SqlSpecialOperator COLLECTION_TABLE
SELECT * FROM
TABLE(ramp(5))
".
This operator has function syntax (with one argument), whereas
EXPLICIT_TABLE
is a prefix operator.
public static final org.apache.calcite.sql.fun.SqlOverlapsOperator OVERLAPS
public static final org.apache.calcite.sql.SqlSpecialOperator VALUES
public static final org.apache.calcite.sql.fun.SqlLiteralChainOperator LITERAL_CHAIN
public static final org.apache.calcite.sql.fun.SqlThrowOperator THROW
public static final org.apache.calcite.sql.fun.SqlBetweenOperator BETWEEN
public static final org.apache.calcite.sql.fun.SqlBetweenOperator SYMMETRIC_BETWEEN
public static final org.apache.calcite.sql.fun.SqlBetweenOperator NOT_BETWEEN
public static final org.apache.calcite.sql.fun.SqlBetweenOperator SYMMETRIC_NOT_BETWEEN
public static final org.apache.calcite.sql.SqlSpecialOperator NOT_LIKE
public static final org.apache.calcite.sql.SqlSpecialOperator LIKE
public static final org.apache.calcite.sql.SqlSpecialOperator NOT_SIMILAR_TO
public static final org.apache.calcite.sql.SqlSpecialOperator SIMILAR_TO
public static final org.apache.calcite.sql.SqlSpecialOperator ESCAPE
public static final org.apache.calcite.sql.fun.SqlCaseOperator CASE
public static final org.apache.calcite.sql.SqlOperator PROCEDURE_CALL
public static final org.apache.calcite.sql.SqlOperator NEW
public static final org.apache.calcite.sql.SqlBinaryOperator OVER
OVER
operator, which applies an aggregate functions to a
window
.
Operands are as follows:
SqlCall
)SqlLiteral
) or window
in-line specification (@link SqlWindowOperator})public static final org.apache.calcite.sql.SqlSpecialOperator REINTERPRET
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.public static final org.apache.calcite.sql.SqlSpecialOperator EXTRACT_DATE
public static final org.apache.calcite.sql.SqlFunction SUBSTRING
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.
public static final org.apache.calcite.sql.SqlFunction REPLACE
REPLACE(string, search, replace)
function. Not standard SQL,
but in Oracle and Postgres.public static final org.apache.calcite.sql.SqlFunction CONVERT
public static final org.apache.calcite.sql.SqlFunction TRANSLATE
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
.
public static final org.apache.calcite.sql.SqlFunction OVERLAY
public static final org.apache.calcite.sql.SqlFunction TRIM
public static final org.apache.calcite.sql.SqlFunction POSITION
public static final org.apache.calcite.sql.SqlFunction CHAR_LENGTH
public static final org.apache.calcite.sql.SqlFunction CHARACTER_LENGTH
public static final org.apache.calcite.sql.SqlFunction UPPER
public static final org.apache.calcite.sql.SqlFunction LOWER
public static final org.apache.calcite.sql.SqlFunction INITCAP
public static final org.apache.calcite.sql.SqlFunction POWER
public static final org.apache.calcite.sql.SqlFunction SQRT
public static final org.apache.calcite.sql.SqlFunction MOD
public static final org.apache.calcite.sql.SqlFunction LN
public static final org.apache.calcite.sql.SqlFunction LOG10
public static final org.apache.calcite.sql.SqlFunction ABS
public static final org.apache.calcite.sql.SqlFunction ACOS
public static final org.apache.calcite.sql.SqlFunction ASIN
public static final org.apache.calcite.sql.SqlFunction ATAN
public static final org.apache.calcite.sql.SqlFunction ATAN2
public static final org.apache.calcite.sql.SqlFunction COS
public static final org.apache.calcite.sql.SqlFunction COT
public static final org.apache.calcite.sql.SqlFunction DEGREES
public static final org.apache.calcite.sql.SqlFunction EXP
public static final org.apache.calcite.sql.SqlFunction RADIANS
public static final org.apache.calcite.sql.SqlFunction ROUND
public static final org.apache.calcite.sql.SqlFunction SIGN
public static final org.apache.calcite.sql.SqlFunction SIN
public static final org.apache.calcite.sql.SqlFunction TAN
public static final org.apache.calcite.sql.SqlFunction TRUNCATE
public static final org.apache.calcite.sql.SqlFunction PI
public static final org.apache.calcite.sql.SqlFunction FINAL
FINAL
function to be used within MATCH_RECOGNIZE
.public static final org.apache.calcite.sql.SqlFunction RUNNING
RUNNING
function to be used within MATCH_RECOGNIZE
.public static final org.apache.calcite.sql.SqlFunction FIRST
FIRST
function to be used within MATCH_RECOGNIZE
.public static final org.apache.calcite.sql.SqlFunction LAST
LAST
function to be used within MATCH_RECOGNIZE
.public static final org.apache.calcite.sql.SqlFunction PREV
PREV
function to be used within MATCH_RECOGNIZE
.public static final org.apache.calcite.sql.SqlFunction NEXT
NEXT
function to be used within MATCH_RECOGNIZE
.public static final org.apache.calcite.sql.SqlFunction NULLIF
public static final org.apache.calcite.sql.SqlFunction COALESCE
public static final org.apache.calcite.sql.SqlFunction FLOOR
FLOOR
function.public static final org.apache.calcite.sql.SqlFunction CEIL
CEIL
function.public static final org.apache.calcite.sql.SqlFunction USER
USER
function.public static final org.apache.calcite.sql.SqlFunction CURRENT_USER
CURRENT_USER
function.public static final org.apache.calcite.sql.SqlFunction SESSION_USER
SESSION_USER
function.public static final org.apache.calcite.sql.SqlFunction SYSTEM_USER
SYSTEM_USER
function.public static final org.apache.calcite.sql.SqlFunction CURRENT_PATH
CURRENT_PATH
function.public static final org.apache.calcite.sql.SqlFunction CURRENT_ROLE
CURRENT_ROLE
function.public static final org.apache.calcite.sql.SqlFunction CURRENT_CATALOG
CURRENT_CATALOG
function.public static final org.apache.calcite.sql.SqlFunction CURRENT_SCHEMA
CURRENT_SCHEMA
function.public static final org.apache.calcite.sql.SqlFunction LOCALTIME
LOCALTIME [(precision)]
function.public static final org.apache.calcite.sql.SqlFunction LOCALTIMESTAMP
LOCALTIMESTAMP [(precision)]
function.public static final org.apache.calcite.sql.SqlFunction CURRENT_TIME
CURRENT_TIME [(precision)]
function.public static final org.apache.calcite.sql.SqlFunction CURRENT_TIMESTAMP
CURRENT_TIMESTAMP [(precision)]
function.public static final org.apache.calcite.sql.SqlFunction CURRENT_DATE
CURRENT_DATE
function.public static final org.apache.calcite.sql.SqlFunction TIMESTAMP_ADD
TIMESTAMPADD
function.public static final org.apache.calcite.sql.SqlFunction TIMESTAMP_DIFF
TIMESTAMPDIFF
function.public static final org.apache.calcite.sql.SqlFunction IN_FENNEL
IN_FENNEL
operator forces the argument to be
evaluated in Fennel. Otherwise acts as identity function.public static final org.apache.calcite.sql.SqlFunction CAST
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.
public static final org.apache.calcite.sql.SqlFunction EXTRACT
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
public static final org.apache.calcite.sql.fun.SqlDatePartFunction YEAR
YEAR
operator. Returns the Year
from a DATETIME E.g.YEAR(date '2008-9-23')
returns
2008
public static final org.apache.calcite.sql.fun.SqlDatePartFunction QUARTER
QUARTER
operator. Returns the Quarter
from a DATETIME E.g.QUARTER(date '2008-9-23')
returns
3
public static final org.apache.calcite.sql.fun.SqlDatePartFunction MONTH
MONTH
operator. Returns the Month
from a DATETIME E.g.MONTH(date '2008-9-23')
returns
9
public static final org.apache.calcite.sql.fun.SqlDatePartFunction WEEK
WEEK
operator. Returns the Week
from a DATETIME E.g.WEEK(date '2008-9-23')
returns
39
public static final org.apache.calcite.sql.fun.SqlDatePartFunction DAYOFYEAR
DAYOFYEAR
operator. Returns the DOY
from a DATETIME E.g.DAYOFYEAR(date '2008-9-23')
returns
267
public static final org.apache.calcite.sql.fun.SqlDatePartFunction DAYOFMONTH
DAYOFMONTH
operator. Returns the Day
from a DATETIME E.g.DAYOFMONTH(date '2008-9-23')
returns
23
public static final org.apache.calcite.sql.fun.SqlDatePartFunction DAYOFWEEK
DAYOFWEEK
operator. Returns the DOW
from a DATETIME E.g.DAYOFWEEK(date '2008-9-23')
returns
2
public static final org.apache.calcite.sql.fun.SqlDatePartFunction HOUR
HOUR
operator. Returns the Hour
from a DATETIME E.g.HOUR(timestamp '2008-9-23 01:23:45')
returns
1
public static final org.apache.calcite.sql.fun.SqlDatePartFunction MINUTE
MINUTE
operator. Returns the Minute
from a DATETIME E.g.MINUTE(timestamp '2008-9-23 01:23:45')
returns
23
public static final org.apache.calcite.sql.fun.SqlDatePartFunction SECOND
SECOND
operator. Returns the Second
from a DATETIME E.g.SECOND(timestamp '2008-9-23 01:23:45')
returns
45
public static final org.apache.calcite.sql.SqlFunction ELEMENT
public static final org.apache.calcite.sql.SqlOperator ITEM
[ ... ]
, 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.
public static final org.apache.calcite.sql.fun.SqlArrayValueConstructor ARRAY_VALUE_CONSTRUCTOR
ARRAY[1, 2, 3]
".public static final org.apache.calcite.sql.fun.SqlMapValueConstructor MAP_VALUE_CONSTRUCTOR
MAP['washington', 1, 'obama', 44]
".public static final org.apache.calcite.sql.SqlInternalOperator SLICE
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.
public static final org.apache.calcite.sql.SqlInternalOperator ELEMENT_SLICE
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!
public static final org.apache.calcite.sql.SqlInternalOperator SCALAR_QUERY
public static final org.apache.calcite.sql.SqlFunction CARDINALITY
public static final org.apache.calcite.sql.SqlAggFunction COLLECT
public static final org.apache.calcite.sql.SqlFunction FUSION
public static final org.apache.calcite.sql.SqlOperator NEXT_VALUE
NEXT VALUE FOR sequence
public static final org.apache.calcite.sql.SqlOperator CURRENT_VALUE
CURRENT VALUE FOR
sequence
public static final org.apache.calcite.sql.SqlSpecialOperator TABLESAMPLE
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
.
public static final org.apache.calcite.sql.fun.SqlGroupFunction TUMBLE
TUMBLE
group function.public static final org.apache.calcite.sql.fun.SqlGroupFunction TUMBLE_START
TUMBLE_START
auxiliary function of
the TUMBLE
group function.public static final org.apache.calcite.sql.fun.SqlGroupFunction TUMBLE_END
TUMBLE_END
auxiliary function of
the TUMBLE
group function.public static final org.apache.calcite.sql.fun.SqlGroupFunction HOP
HOP
group function.public static final org.apache.calcite.sql.fun.SqlGroupFunction HOP_START
HOP_START
auxiliary function of
the HOP
group function.public static final org.apache.calcite.sql.fun.SqlGroupFunction HOP_END
HOP_END
auxiliary function of
the HOP
group function.public static final org.apache.calcite.sql.fun.SqlGroupFunction SESSION
SESSION
group function.public static final org.apache.calcite.sql.fun.SqlGroupFunction SESSION_START
SESSION_START
auxiliary function of
the SESSION
group function.public static final org.apache.calcite.sql.fun.SqlGroupFunction SESSION_END
SESSION_END
auxiliary function of
the SESSION
group function.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
.
public static final org.apache.calcite.sql.SqlBinaryOperator PATTERN_CONCAT
MATCH_RECOGNIZE
.
If p1
and p2
are patterns then p1 p2
is a
pattern that matches p1
followed by p2
.
public static final org.apache.calcite.sql.SqlSpecialOperator PATTERN_QUANTIFIER
MATCH_RECOGNIZE
.
If p
is a pattern then p{3, 5}
is a
pattern that matches between 3 and 5 occurrences of p
.
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
.
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.
public static SqlStdOperatorTable instance()
public static org.apache.calcite.sql.fun.SqlGroupFunction auxiliaryToGroup(org.apache.calcite.sql.SqlKind kind)
public static org.apache.calcite.sql.SqlCall convertAuxiliaryToGroupCall(org.apache.calcite.sql.SqlCall call)
For example, converts TUMBLE_START(rowtime, INTERVAL '1' HOUR))
to TUMBLE(rowtime, INTERVAL '1' HOUR))
.
public static List<org.apache.calcite.util.Pair<org.apache.calcite.sql.SqlNode,AuxiliaryConverter>> convertGroupToAuxiliaryCalls(org.apache.calcite.sql.SqlCall call)
For example, converts TUMBLE_START(rowtime, INTERVAL '1' HOUR))
to TUMBLE(rowtime, INTERVAL '1' HOUR))
.
Copyright © 2014–2018 The Apache Software Foundation. All rights reserved.