Class SqlStdOperatorTable
- All Implemented Interfaces:
SqlOperatorTable
SqlOperatorTable containing
the standard operators and functions.-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final SqlFunctionTheABS(numeric)function.static final SqlFunctionTheACOS(numeric)function.static final SqlQuantifyOperatorstatic final SqlQuantifyOperatorstatic final SqlQuantifyOperatorstatic final SqlQuantifyOperatorstatic final SqlQuantifyOperatorThe< ALLoperator.static final SqlQuantifyOperatorstatic final SqlBinaryOperatorLogicalANDoperator.static final SqlAggFunctionANY_VALUEaggregate function.static final SqlAggFunctionAPPROX_COUNT_DISTINCTaggregate function.static final SqlBasicAggFunctionARG_MAXaggregate function.static final SqlBasicAggFunctionARG_MINaggregate function.static final SqlSpecialOperatorARGUMENT_ASSIGNMENToperator (=<) assigns an argument to a function call to a particular named parameter.static final SqlMultisetQueryConstructorThe ARRAY Query Constructor.static final SqlArrayValueConstructorThe ARRAY Value Constructor.static final SqlAsOperatorASoperator associates an expression in the SELECT clause with an alias.static final SqlFunctionstatic final SqlFunctionTheASIN(numeric)function.static final SqlFunctionTheATAN(numeric)function.static final SqlFunctionTheATAN2(numeric, numeric)function.static final SqlAggFunctionAVGaggregate function.static final SqlBetweenOperatorstatic final SqlAggFunctionBIT_ANDaggregate function.static final SqlAggFunctionBIT_ORaggregate function.static final SqlAggFunctionBIT_XORaggregate function.static final SqlFunctionBITANDscalar function.static final SqlBasicFunctionstatic final SqlFunctionBITNOTscalar function.static final SqlFunctionBITORscalar function.static final SqlFunctionBITXORscalar function.static final SqlFunctionThe CARDINALITY operator, used to retrieve the number of elements in a MULTISET, ARRAY or MAP.static final SqlCaseOperatorstatic final SqlFunctionThe SQLCASToperator.static final SqlFunctionTheCBRT(numeric)function.static final SqlFunctionTheCEILfunction.static final SqlBasicFunctionstatic final SqlFunctionAlias forCHAR_LENGTH.static final SqlBinaryOperatorChecked version of arithmetic division operator, '/'.static final SqlBinaryOperatorChecked version of integer division.static final SqlBinaryOperatorChecked version of infix arithmetic minus operator, '-'.static final SqlBinaryOperatorChecked version of arithmetic multiplication operator, '*'.static final SqlBinaryOperatorChecked version of infix arithmetic plus operator, '+'.static final SqlPrefixOperatorChecked version of prefix arithmetic minus operator, '-'.static final SqlMatchFunctionCLASSIFIERfunction to be used withinMATCH_RECOGNIZE.static final SqlFunctionThe COALESCE builtin function.static final SqlAggFunctionThe COLLECT operator.static final SqlSpecialOperatorThe "table function derived table" operator, which a table-valued function into a relation, e.g.static final SqlColumnListConstructorThe COLUMN_LIST constructor.static final SqlBinaryOperatorString and array-to-array concatenation operator, '||'.static final SqlOverlapsOperatorstatic final SqlFunctionTheCONVERT(charValue, srcCharsetName, destCharsetName)function convertscharValuewithdestCharsetName, whose original encoding is specified bysrcCharsetName.static final SqlFunctionTheCOS(numeric)function.static final SqlFunctionTheCOT(numeric)function.static final SqlAggFunctionCOUNTaggregate function.static final SqlAggFunctionCOVAR_POPaggregate function.static final SqlAggFunctionCOVAR_SAMPaggregate function.static final SqlInternalOperatorCUBEoperator, occurs withinGROUP BYclause or nested within aGROUPING SETS.static final SqlRankFunctionCUME_DISTwindow function.static final SqlFunctionTheCURRENT_CATALOGfunction.static final SqlFunctionTheCURRENT_DATEfunction.static final SqlFunctionTheCURRENT_PATHfunction.static final SqlFunctionTheCURRENT_ROLEfunction.static final SqlFunctionTheCURRENT_SCHEMAfunction.static final SqlFunctionTheCURRENT_TIME [(precision)]function.static final SqlFunctionTheCURRENT_TIMESTAMP [(precision)]function.static final SqlFunctionTheCURRENT_USERfunction.static final SqlOperatorThe sequence current value function:CURRENT VALUE FOR sequence.static final SqlCursorConstructorThe CURSOR constructor.static final SqlSpecialOperatorInfix datetime plus operator, 'DATETIME + INTERVAL'.static final SqlDatePartFunctionThe SQLDAYOFMONTHoperator.static final SqlDatePartFunctionThe SQLDAYOFWEEKoperator.static final SqlDatePartFunctionThe SQLDAYOFYEARoperator.static final SqlSpecialOperatorDEFAULToperator indicates that an argument to a function call is to take its default value.static final SqlFunctionTheDEGREES(numeric)function.static final SqlRankFunctionDENSE_RANKwindow function.static final SqlPostfixOperatorstatic final SqlOperatorDESCRIPTOR(column_name, ...).static final SqlBinaryOperatorArithmetic division operator, '/'.static final SqlBinaryOperatorInternal integer arithmetic division operator, '/INT'.static final SqlOperatorDot operator, '.', used for referencing fields of records.static final SqlFunctionThe ELEMENT operator, used to convert a multiset with only one item to a "regular" type.static final SqlInternalOperatorThe internal "$ELEMENT_SLICE" operator returns the first field of the only element of a multiset.static final SqlBinaryOperatorLogical equals operator, '='.static final SqlSpecialOperatorInternal operator used to represent the ESCAPE clause of a LIKE or SIMILAR TO expression.static final SqlAggFunctionEVERYaggregate function.static final SqlSetOperatorstatic final SqlSetOperatorstatic final SqlPrefixOperatorstatic final SqlFunctionTheEXP(numeric)function.static final SqlPrefixOperatorKeyword which allows an identifier to be explicitly flagged as a table.static final SqlInternalOperatorEXTENDoperator.static final SqlFunctionThe SQLEXTRACToperator.static final SqlFilterOperatorFILTERoperator filters which rows are included in an aggregate function.static final SqlPrefixOperatorFINALfunction to be used withinMATCH_RECOGNIZE.static final SqlFunctionFIRSTfunction to be used withinMATCH_RECOGNIZE.static final SqlAggFunctionFIRST_VALUEaggregate function.static final SqlFunctionTheFLOORfunction.static final SqlAggFunctionThe FUSION operator.static final SqlBinaryOperatorLogical greater-than operator, '>'.static final SqlBinaryOperatorLogical greater-than-or-equal operator, '>='.static final SqlAggFunctionGROUP_ID()function.static final SqlAggFunctionGROUPING(c1 [, c2, ...])function.static final SqlAggFunctionGROUPING_IDfunction is a synonym forGROUPING.static final SqlInternalOperatorGROUPING SETSoperator, occurs withinGROUP BYclause or nested within aGROUPING SETS.static final SqlAggFunctionHISTOGRAMaggregate function support.static final SqlFunctionHISTOGRAM_FIRST_VALUEwindow aggregate function.static final SqlFunctionHISTOGRAM_LAST_VALUEwindow aggregate function.static final SqlFunctionHISTOGRAM_MAXwindow aggregate function.static final SqlFunctionHISTOGRAM_MINwindow aggregate function.static final SqlFunctionHOP as a table function.static final SqlGroupedWindowFunctionTheHOP_ENDauxiliary function of theHOPgroup function.static final SqlGroupedWindowFunctionTheHOPgroup function.static final SqlGroupedWindowFunctionTheHOP_STARTauxiliary function of theHOPgroup function.static final SqlDatePartFunctionThe SQLHOURoperator.static final SqlNullTreatmentOperatorIGNORE NULLSoperator.static final SqlOverlapsOperatorstatic final SqlOverlapsOperatorstatic final SqlBinaryOperatorINoperator tests for a value's membership in a sub-query or a list of values.static final SqlFunctionstatic final SqlSetOperatorstatic final SqlSetOperatorstatic final SqlAggFunctionThe INTERSECTION operator.static final SqlSpecialOperatorInterval expression, 'INTERVAL n timeUnit'.static final SqlPostfixOperatorstatic final SqlBinaryOperatorThe internal$IS_DIFFERENT_FROMoperator is the same as the user-levelIS_DISTINCT_FROMin all respects except that the test for equality on character datatypes treats trailing spaces as significant.static final SqlBinaryOperatorIS DISTINCT FROMoperator.static final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlBinaryOperatorIS NOT DISTINCT FROMoperator.static final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlOperatorThe item operator[ ... ], used to access a given element of an array, map or struct.static final SqlFunctionstatic final SqlJsonArrayAggAggFunctionstatic final SqlFunctionDeprecated.static final SqlFunctionstatic final SqlFunctionDeprecated.static final SqlFunctionDeprecated.static final SqlFunctionDeprecated.static final SqlFunctionstatic final SqlJsonObjectAggAggFunctionstatic final SqlFunctionDeprecated.static final SqlFunctionstatic final SqlFunctionDeprecated.static final SqlFunctionDeprecated.static final SqlFunctionDeprecated.static final SqlFunctionDeprecated.static final SqlFunctionDeprecated.static final org.apache.calcite.sql.fun.SqlJsonTypeOperatorstatic final SqlFunctionstatic final SqlPostfixOperatorstatic final SqlAggFunctionLAGaggregate function.static final SqlMatchFunctionLASTfunction to be used withinMATCH_RECOGNIZE.static final SqlFunctionTheLAST_DAY(date)function.static final SqlAggFunctionLAST_VALUEaggregate function.static final SqlSpecialOperatorTheLATERALoperator.static final SqlAggFunctionLEADaggregate function.static final SqlBinaryOperatorLogical less-than operator, '<'.static final SqlBinaryOperatorLogical less-than-or-equal operator, '<='.static final SqlSpecialOperatorstatic final SqlAggFunctionThe LISTAGG operator.static final SqlLiteralChainOperatorstatic final SqlFunctionTheLN(numeric)function.static final SqlFunctionTheLOCALTIME [(precision)]function.static final SqlFunctionTheLOCALTIMESTAMP [(precision)]function.static final SqlFunctionTheLOG10(numeric)function.static final SqlFunctionstatic final SqlMultisetQueryConstructorThe MAP Query Constructor.static final SqlMapValueConstructorThe MAP Value Constructor, e.g.static final SqlFunctionMATCH_NUMBERfunction to be used withinMATCH_RECOGNIZE.static final SqlAggFunctionMAXaggregate function.static final SqlBinaryOperatorMultisetMEMBER OF, which returns whether a element belongs to a multiset.static final SqlAggFunctionMINaggregate function.static final SqlBinaryOperatorInfix arithmetic minus operator, '-'.static final SqlDatetimeSubtractionOperatorA special operator for the subtraction of two DATETIMEs.static final SqlDatePartFunctionThe SQLMINUTEoperator.static final SqlFunctionArithmetic remainder functionMOD.static final SqlAggFunctionMODEaggregate function.static final SqlDatePartFunctionThe SQLMONTHoperator.static final SqlBinaryOperatorArithmetic multiplication operator, '*'.static final SqlMultisetSetOperatorTheMULTISET EXCEPT [ALL]operator.static final SqlMultisetSetOperatorTheMULTISET EXCEPT DISTINCToperator.static final SqlMultisetSetOperatorTheMULTISET INTERSECT [ALL]operator.static final SqlMultisetSetOperatorTheMULTISET INTERSECT DISTINCToperator.static final SqlMultisetQueryConstructorThe MULTISET Query Constructor.static final SqlMultisetSetOperatorTheMULTISET UNION [ALL]operator.static final SqlMultisetSetOperatorTheMULTISET UNION DISTINCToperator.static final SqlMultisetValueConstructorThe MULTISET Value Constructor.static final SqlBinaryOperatorstatic final SqlBinaryOperatorstatic final SqlOperatorstatic final SqlFunctionNEXTfunction to be used withinMATCH_RECOGNIZE.static final SqlOperatorThe sequence next value function:NEXT VALUE FOR sequence.static final SqlPrefixOperatorstatic final SqlBetweenOperatorstatic final SqlBinaryOperatorLogical not-equals operator, '<>'.static final SqlBinaryOperatorNOT INoperator tests for a value's membership in a sub-query or a list of values.static final SqlSpecialOperatorstatic final SqlSpecialOperatorstatic final SqlBinaryOperatorstatic final SqlAggFunctionNTH_VALUEaggregate function.static final SqlAggFunctionNTILEaggregate function.static final SqlFunctionstatic final SqlPostfixOperatorstatic final SqlPostfixOperatorstatic final SqlFunctionprotected com.google.common.collect.ImmutableMultimap<String,SqlOperator> Contains all (name, operator) pairs.static final SqlBinaryOperatorLogicalORoperator.static final SqlBinaryOperatorTheOVERoperator, which applies an aggregate functions to awindow.static final SqlOverlapsOperatorstatic final SqlFunctionstatic final SqlBinaryOperator|operator to create alternate patterns withinMATCH_RECOGNIZE.static final SqlBinaryOperatorOperator to concatenate patterns withinMATCH_RECOGNIZE.static final SqlSpecialOperatorEXCLUDEoperator withinMATCH_RECOGNIZE.static final SqlSpecialOperatorPERMUTEoperator to combine patterns withinMATCH_RECOGNIZE.static final SqlSpecialOperatorOperator to quantify patterns withinMATCH_RECOGNIZE.static final SqlRankFunctionPERCENT_RANKwindow function.static final SqlBinaryOperatorArithmetic remainder operator, '%', an alternative toMODallowed if under certain conformance levels.static final SqlAggFunctionPERCENTILE_CONTinverse distribution aggregate function.static final SqlAggFunctionPERCENTILE_DISCinverse distribution aggregate function.static final SqlOverlapsOperatorstatic final SqlFunctionThePIfunction.static final SqlBinaryOperatorInfix arithmetic plus operator, '+'.static final SqlFunctionstatic final SqlBinaryOperatorstatic final SqlBinaryOperatorstatic final SqlBasicFunctionThePOWER(numeric, numeric)function.static final SqlOverlapsOperatorstatic final SqlMatchFunctionPREVfunction to be used withinMATCH_RECOGNIZE.static final SqlOperatorstatic final List<SqlQuantifyOperator>static final SqlDatePartFunctionThe SQLQUARTERoperator.static final SqlFunctionTheRADIANS(numeric)function.static final SqlBasicFunctionTheRAND([seed])function, which yields a random double, optionally with seed.static final SqlRandIntegerFunctionTheRAND_INTEGER([seed, ] bound)function, which yields a random integer, optionally with seed.static final SqlRankFunctionRANKwindow function.static final SqlAggFunctionREGR_COUNTaggregate function.static final SqlAggFunctionREGR_SXXaggregate function.static final SqlAggFunctionREGR_SYYaggregate function.static final SqlSpecialOperatorAnREINTERPREToperator is internal to the planner.static final SqlFunctionTheREPLACE(string, search, replace)function.static final SqlNullTreatmentOperatorRESPECT NULLSoperator.static final SqlInternalOperatorROLLUPoperator, occurs withinGROUP BYclause or nested within aGROUPING SETS.static final SqlFunctionTheROUND(numeric [, integer])function.static final SqlRowOperatorstatic final SqlRankFunctionROW_NUMBERwindow function.static final SqlPrefixOperatorRUNNINGfunction to be used withinMATCH_RECOGNIZE.static final SqlInternalOperatorThe internal "$SCALAR_QUERY" operator returns a scalar value from a record type.static final SqlInternalOperatorOperator that tests whether its left operand is included in the range of values covered by search arguments.static final SqlDatePartFunctionThe SQLSECONDoperator.static final SqlFunctionSESSION as a table function.static final SqlGroupedWindowFunctionTheSESSION_ENDauxiliary function of theSESSIONgroup function.static final SqlGroupedWindowFunctionTheSESSIONgroup function.static final SqlGroupedWindowFunctionTheSESSION_STARTauxiliary function of theSESSIONgroup function.static final SqlFunctionTheSESSION_USERfunction.static final SqlInternalOperatorSetSemanticsTable represents as an input table with set semantics.static final SqlFunctionTheSIGN(numeric)function.static final SqlSpecialOperatorstatic final SqlFunctionTheSIN(numeric)function.static final SqlAggFunctionSINGLE_VALUEaggregate function.static final SqlInternalOperatorThe internal "$SLICE" operator takes a multiset of records and returns a multiset of the first column of those records.static final SqlAggFunctionSOMEaggregate function.static final SqlQuantifyOperatorstatic final SqlQuantifyOperatorstatic final SqlQuantifyOperatorstatic final SqlQuantifyOperatorstatic final SqlQuantifyOperatorThe< SOMEoperator (synonymous with< ANY).static final SqlQuantifyOperatorstatic final SqlFunctionTheSQRT(numeric)function.static final SqlAggFunctionSTDDEVaggregate function.static final SqlAggFunctionSTDDEV_POPaggregate function.static final SqlAggFunctionSTDDEV_SAMPaggregate function.static final SqlInternalOperatorThe internal$STRUCT_ACCESSoperator is used to access a field of a record.static final SqlBinaryOperatorSubmultiset.static final SqlFunctionThe character substring function:SUBSTRING(string FROM start [FOR length]).static final SqlOverlapsOperatorstatic final SqlAggFunctionSUMaggregate function.static final SqlAggFunctionSUM0aggregate function.static final SqlBetweenOperatorstatic final SqlBetweenOperatorstatic final SqlFunctionTheSYSTEM_USERfunction.static final SqlSpecialOperatorTheTABLESAMPLEoperator.static final SqlFunctionTheTAN(numeric)function.static final SqlThrowOperatorstatic final SqlFunctionTheTIMESTAMPADDfunction.static final SqlFunctionTheTIMESTAMPDIFFfunction.static final SqlFunctionTheTRANSLATE/CONVERT(char_value USING transcodingName)function alters the character set of a string value from one base character set to transcodingName.static final SqlFunctionThe "TRIM" function.static final SqlBasicFunctionTheTRUNCATE(numeric [, integer])function.static final SqlFunctionTUMBLE as a table function.static final SqlGroupedWindowFunctionTheTUMBLE_ENDauxiliary function of theTUMBLEgroup function.static final SqlGroupedWindowFunctionTheTUMBLEgroup function.static final SqlGroupedWindowFunctionTheTUMBLE_STARTauxiliary function of theTUMBLEgroup function.static final SqlFunctionTheTYPEOFfunction.static final SqlPrefixOperatorPrefix arithmetic minus operator, '-'.static final SqlPrefixOperatorPrefix arithmetic plus operator, '+'.static final SqlSetOperatorstatic final SqlSetOperatorstatic final SqlPrefixOperatorstatic final SqlUnnestOperatorTheUNNESToperator.static final SqlUnnestOperatorTheUNNEST WITH ORDINALITYoperator.static final SqlFunctionstatic final SqlFunctionTheUSERfunction.static final SqlSpecialOperatorstatic final SqlAggFunctionVAR_POPaggregate function.static final SqlAggFunctionVAR_SAMPaggregate function.static final SqlAggFunctionVARIANCEaggregate function.static final SqlFunctionTheVARIANTNULLfunction.static final SqlDatePartFunctionThe SQLWEEKoperator.static final SqlWithinDistinctOperatorWITHIN_DISTINCToperator performs aggregations on distinct data input.static final SqlWithinGroupOperatorWITHIN_GROUPoperator performs aggregations on ordered data input.static final SqlDatePartFunctionThe SQLYEARoperator.Fields inherited from class org.apache.calcite.sql.util.ReflectiveSqlOperatorTable
IS_NAME -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic SqlQuantifyOperatorReturns the operator forALL comparisonKind.static @Nullable SqlGroupedWindowFunctionauxiliaryToGroup(SqlKind kind) Returns the group function for which a given kind is an auxiliary function, or null if it is not an auxiliary function.protected static com.google.common.collect.ImmutableMultimap<String,SqlOperator> buildIndex(Iterable<? extends SqlOperator> operators) Derives a value to be assigned tooperatorsfrom a given list of operators.static @Nullable SqlCallConverts a call to a grouped auxiliary function to a call to the grouped window function.static List<Pair<SqlNode,AuxiliaryConverter>> Deprecated.static voidconvertGroupToAuxiliaryCalls(SqlCall call, BiConsumer<SqlNode, AuxiliaryConverter> consumer) Converts a call to a grouped window function to a call to its auxiliary window function(s).static SqlOperatorfloorCeil(boolean floor, SqlConformance conformance) Returns the operator forFLOORandCEILwith given floor flag and library.static SqlOperatorgetConvertFuncByConformance(SqlConformance conformance) Returns the operator for standardCONVERTand Oracle'sCONVERTwith the given library.Retrieves a list of all functions and operators in this table.static SqlStdOperatorTableinstance()Returns the standard operator table, creating it if necessary.static SqlOperatorlike(boolean negated, boolean caseSensitive) Returns the operator forLIKEwith given case-sensitivity, optionally negated.protected voidlookUpOperators(String name, boolean caseSensitive, Consumer<SqlOperator> consumer) Looks up operators, optionally matching case-sensitively.static SqlOperatorreverse(SqlOperator operator) Deprecated.protected voidsetOperators(com.google.common.collect.Multimap<String, SqlOperator> operators) static SqlQuantifyOperatorReturns the operator forSOME comparisonKind.Methods inherited from class org.apache.calcite.sql.util.ReflectiveSqlOperatorTable
init, lookupOperatorOverloads, registerMethods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitMethods inherited from interface org.apache.calcite.sql.SqlOperatorTable
getOperatorList
-
Field Details
-
UNION
-
UNION_ALL
-
EXCEPT
-
EXCEPT_ALL
-
INTERSECT
-
INTERSECT_ALL
-
MULTISET_UNION_DISTINCT
TheMULTISET UNION DISTINCToperator. -
MULTISET_UNION
TheMULTISET UNION [ALL]operator. -
MULTISET_EXCEPT_DISTINCT
TheMULTISET EXCEPT DISTINCToperator. -
MULTISET_EXCEPT
TheMULTISET EXCEPT [ALL]operator. -
MULTISET_INTERSECT_DISTINCT
TheMULTISET INTERSECT DISTINCToperator. -
MULTISET_INTERSECT
TheMULTISET INTERSECT [ALL]operator. -
AND
LogicalANDoperator. -
AS
ASoperator associates an expression in the SELECT clause with an alias. -
ARGUMENT_ASSIGNMENT
ARGUMENT_ASSIGNMENToperator (=<) assigns an argument to a function call to a particular named parameter. -
DEFAULT
DEFAULToperator indicates that an argument to a function call is to take its default value. -
FILTER
FILTERoperator filters which rows are included in an aggregate function. -
WITHIN_GROUP
WITHIN_GROUPoperator performs aggregations on ordered data input. -
WITHIN_DISTINCT
WITHIN_DISTINCToperator performs aggregations on distinct data input. -
CUBE
CUBEoperator, occurs withinGROUP BYclause or nested within aGROUPING SETS. -
ROLLUP
ROLLUPoperator, occurs withinGROUP BYclause or nested within aGROUPING SETS. -
GROUPING_SETS
GROUPING SETSoperator, occurs withinGROUP BYclause or nested within aGROUPING SETS. -
GROUPING
GROUPING(c1 [, c2, ...])function.Occurs in similar places to an aggregate function (
SELECT,HAVINGclause, etc. of an aggregate query), but not technically an aggregate function. -
GROUP_ID
GROUP_ID()function. (Oracle-specific.) -
GROUPING_ID
GROUPING_IDfunction is a synonym forGROUPING.Some history. The
GROUPINGfunction is in the SQL standard, and originally supported only one argument.GROUPING_IDis not standard (though supported in Oracle and SQL Server) and supports one or more arguments.The SQL standard has changed to allow
GROUPINGto have multiple arguments. It is now equivalent toGROUPING_ID, so we madeGROUPING_IDa synonym forGROUPING. -
EXTEND
EXTENDoperator. -
CONCAT
String and array-to-array concatenation operator, '||'.- See Also:
-
DIVIDE
Arithmetic division operator, '/'. -
CHECKED_DIVIDE
Checked version of arithmetic division operator, '/'. -
PERCENT_REMAINDER
Arithmetic remainder operator, '%', an alternative toMODallowed if under certain conformance levels. -
RAND_INTEGER
TheRAND_INTEGER([seed, ] bound)function, which yields a random integer, optionally with seed. -
RAND
TheRAND([seed])function, which yields a random double, optionally with seed. -
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. -
CHECKED_DIVIDE_INTEGER
Checked version of integer division. @see DIVIDE_INTEGER. -
DOT
Dot operator, '.', used for referencing fields of records. -
EQUALS
Logical equals operator, '='. -
GREATER_THAN
Logical greater-than operator, '>'. -
IS_DISTINCT_FROM
IS DISTINCT FROMoperator. -
IS_NOT_DISTINCT_FROM
IS NOT DISTINCT FROMoperator. Is equivalent toNOT(x IS DISTINCT FROM y) -
IS_DIFFERENT_FROM
The internal$IS_DIFFERENT_FROMoperator is the same as the user-levelIS_DISTINCT_FROMin all respects except that the test for equality on character datatypes treats trailing spaces as significant. -
GREATER_THAN_OR_EQUAL
Logical greater-than-or-equal operator, '>='. -
IN
INoperator tests for a value's membership in a sub-query or a list of values. -
NOT_IN
NOT INoperator tests for a value's membership in a sub-query or a list of values. -
SEARCH
Operator that tests whether its left operand is included in the range of values covered by search arguments. -
SOME_LT
The< SOMEoperator (synonymous with< ANY). -
SOME_LE
-
SOME_GT
-
SOME_GE
-
SOME_EQ
-
SOME_NE
-
ALL_LT
The< ALLoperator. -
ALL_LE
-
ALL_GT
-
ALL_GE
-
ALL_EQ
-
ALL_NE
-
QUANTIFY_OPERATORS
-
LESS_THAN
Logical less-than operator, '<'. -
LESS_THAN_OR_EQUAL
Logical less-than-or-equal operator, '<='. -
MINUS
-
CHECKED_MINUS
Checked version of infix arithmetic minus operator, '-'. -
MULTIPLY
Arithmetic multiplication operator, '*'. -
CHECKED_MULTIPLY
Checked version of arithmetic multiplication operator, '*'. -
NOT_EQUALS
Logical not-equals operator, '<>'. -
OR
LogicalORoperator. -
PLUS
Infix arithmetic plus operator, '+'. -
CHECKED_PLUS
Checked version of infix arithmetic plus operator, '+'. -
DATETIME_PLUS
Infix datetime plus operator, 'DATETIME + INTERVAL'. -
INTERVAL
Interval expression, 'INTERVAL n timeUnit'. -
MEMBER_OF
MultisetMEMBER 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
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'] -
NOT_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
-
IS_NOT_A_SET
-
IS_EMPTY
-
IS_NOT_EMPTY
-
IS_JSON_VALUE
-
IS_NOT_JSON_VALUE
-
IS_JSON_OBJECT
-
IS_NOT_JSON_OBJECT
-
IS_JSON_ARRAY
-
IS_NOT_JSON_ARRAY
-
IS_JSON_SCALAR
-
IS_NOT_JSON_SCALAR
-
JSON_VALUE_EXPRESSION
-
JSON_TYPE_OPERATOR
public static final org.apache.calcite.sql.fun.SqlJsonTypeOperator JSON_TYPE_OPERATOR -
EXISTS
-
UNIQUE
-
NOT
-
UNARY_MINUS
-
CHECKED_UNARY_MINUS
Checked version of prefix arithmetic minus operator, '-'. -
UNARY_PLUS
-
EXPLICIT_TABLE
Keyword which allows an identifier to be explicitly flagged as a table. For example,select * from (TABLE t)orTABLE t. See alsoCOLLECTION_TABLE. -
FINAL
FINALfunction to be used withinMATCH_RECOGNIZE. -
RUNNING
RUNNINGfunction to be used withinMATCH_RECOGNIZE. -
SUM
SUMaggregate function. -
COUNT
COUNTaggregate function. -
MODE
MODEaggregate function. -
APPROX_COUNT_DISTINCT
APPROX_COUNT_DISTINCTaggregate function. -
ARG_MAX
ARG_MAXaggregate function. -
ARG_MIN
ARG_MINaggregate function. -
MIN
MINaggregate function. -
MAX
MAXaggregate function. -
EVERY
EVERYaggregate function. -
SOME
SOMEaggregate function. -
LAST_VALUE
LAST_VALUEaggregate function. -
ANY_VALUE
ANY_VALUEaggregate function. -
FIRST_VALUE
FIRST_VALUEaggregate function. -
NTH_VALUE
NTH_VALUEaggregate function. -
LEAD
LEADaggregate function. -
LAG
LAGaggregate function. -
NTILE
NTILEaggregate function. -
SINGLE_VALUE
SINGLE_VALUEaggregate function. -
AVG
AVGaggregate function. -
STDDEV_POP
STDDEV_POPaggregate function. -
REGR_COUNT
REGR_COUNTaggregate function. -
REGR_SXX
REGR_SXXaggregate function. -
REGR_SYY
REGR_SYYaggregate function. -
COVAR_POP
COVAR_POPaggregate function. -
COVAR_SAMP
COVAR_SAMPaggregate function. -
STDDEV_SAMP
STDDEV_SAMPaggregate function. -
STDDEV
STDDEVaggregate function. -
VAR_POP
VAR_POPaggregate function. -
VAR_SAMP
VAR_SAMPaggregate function. -
VARIANCE
VARIANCEaggregate function. -
BITCOUNT
-
BITAND
BITANDscalar function. -
BITOR
BITORscalar function. -
BITXOR
BITXORscalar function. -
BITNOT
BITNOTscalar function. -
BIT_AND
BIT_ANDaggregate function. -
BIT_OR
BIT_ORaggregate function. -
BIT_XOR
BIT_XORaggregate function. -
HISTOGRAM_AGG
HISTOGRAMaggregate function support. Used by window aggregate versions of MIN/MAX -
HISTOGRAM_MIN
HISTOGRAM_MINwindow aggregate function. -
HISTOGRAM_MAX
HISTOGRAM_MAXwindow aggregate function. -
HISTOGRAM_FIRST_VALUE
HISTOGRAM_FIRST_VALUEwindow aggregate function. -
HISTOGRAM_LAST_VALUE
HISTOGRAM_LAST_VALUEwindow aggregate function. -
SUM0
SUM0aggregate function. -
CUME_DIST
CUME_DISTwindow function. -
DENSE_RANK
DENSE_RANKwindow function. -
PERCENT_RANK
PERCENT_RANKwindow function. -
RANK
RANKwindow function. -
ROW_NUMBER
ROW_NUMBERwindow function. -
ROW
-
IGNORE_NULLS
IGNORE NULLSoperator. -
RESPECT_NULLS
RESPECT NULLSoperator. -
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
The MULTISET Value Constructor. e.g. "MULTISET[1,2,3]". -
MULTISET_QUERY
The MULTISET Query Constructor. e.g. "SELECT dname, MULTISET(SELECT FROM emp WHERE deptno = dept.deptno) FROM dept". -
ARRAY_QUERY
The ARRAY Query Constructor. e.g. "SELECT dname, ARRAY(SELECT FROM emp WHERE deptno = dept.deptno) FROM dept". -
MAP_QUERY
The MAP Query Constructor. e.g. "MAP(SELECT empno, deptno FROM emp)". -
CURSOR
The CURSOR constructor. e.g. "SELECT * FROM TABLE(DEDUP(CURSOR(SELECT * FROM EMPS), 'name'))". -
COLUMN_LIST
The COLUMN_LIST constructor. e.g. the ROW() call in "SELECT * FROM TABLE(DEDUP(CURSOR(SELECT * FROM EMPS), ROW(name, empno)))". -
UNNEST
TheUNNESToperator. -
UNNEST_WITH_ORDINALITY
TheUNNEST WITH ORDINALITYoperator. -
LATERAL
TheLATERALoperator. -
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_TABLEis a prefix operator. -
OVERLAPS
-
CONTAINS
-
PRECEDES
-
IMMEDIATELY_PRECEDES
-
SUCCEEDS
-
IMMEDIATELY_SUCCEEDS
-
PERIOD_EQUALS
-
VALUES
-
LITERAL_CHAIN
-
THROW
-
JSON_EXISTS
-
JSON_VALUE
-
JSON_QUERY
-
JSON_OBJECT
-
JSON_OBJECTAGG
-
JSON_ARRAY
-
JSON_TYPE
Deprecated. -
JSON_DEPTH
Deprecated. -
JSON_LENGTH
Deprecated. -
JSON_KEYS
Deprecated. -
JSON_PRETTY
Deprecated. -
JSON_REMOVE
Deprecated. -
JSON_STORAGE_SIZE
Deprecated. -
JSON_INSERT
Deprecated. -
JSON_REPLACE
Deprecated. -
JSON_SET
Deprecated. -
JSON_ARRAYAGG
-
BETWEEN
-
SYMMETRIC_BETWEEN
-
NOT_BETWEEN
-
SYMMETRIC_NOT_BETWEEN
-
NOT_LIKE
-
LIKE
-
NOT_SIMILAR_TO
-
SIMILAR_TO
-
POSIX_REGEX_CASE_SENSITIVE
-
POSIX_REGEX_CASE_INSENSITIVE
-
NEGATED_POSIX_REGEX_CASE_SENSITIVE
-
NEGATED_POSIX_REGEX_CASE_INSENSITIVE
-
ESCAPE
Internal operator used to represent the ESCAPE clause of a LIKE or SIMILAR TO expression. -
CASE
-
PROCEDURE_CALL
-
NEW
-
OVER
TheOVERoperator, which applies an aggregate functions to awindow.Operands are as follows:
- name of window function (
SqlCall) - window name (
SqlLiteral) or window in-line specification (org.apache.calcite.sql.SqlWindow.SqlWindowOperator)
- name of window function (
-
REINTERPRET
AnREINTERPREToperator 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. -
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
TheREPLACE(string, search, replace)function. Not standard SQL, but in Oracle, PostgreSQL and Microsoft SQL Server.REPLACE behaves a little different in Microsoft SQL Server, whose search pattern is case-insensitive during matching.
For example,
REPLACE(('ciAao', 'a', 'ciao'))returns "ciAciaoo" in both Oracle and PostgreSQL, but returns "ciciaociaoo" in Microsoft SQL Server. -
CONVERT
TheCONVERT(charValue, srcCharsetName, destCharsetName)function convertscharValuewithdestCharsetName, whose original encoding is specified bysrcCharsetName.The SQL standard defines
CONVERT(charValue USING transcodingName), and MySQL implements it; Calcite supports this in the following TRANSLATE function.MySQL and Microsoft SQL Server have a
CONVERT(type, value)function; Calcite does not currently support this, either. -
TRANSLATE
TheTRANSLATE/CONVERT(char_value USING transcodingName)function alters the character set of a string value from one base character set to transcodingName.It is defined in the SQL standard. See also the non-standard
SqlLibraryOperators.TRANSLATE3, which has a different purpose. -
OVERLAY
-
TRIM
The "TRIM" function. -
POSITION
-
CHAR_LENGTH
-
CHARACTER_LENGTH
Alias forCHAR_LENGTH. -
OCTET_LENGTH
-
UPPER
-
LOWER
-
INITCAP
-
ASCII
-
POWER
ThePOWER(numeric, numeric)function.The return type is always
DOUBLEsince we don't know what the result type will be by just looking at the operand types. For examplePOWER(INTEGER, INTEGER)can return a non-INTEGER if the second operand is negative. -
SQRT
TheSQRT(numeric)function. -
MOD
Arithmetic remainder functionMOD.- See Also:
-
LN
TheLN(numeric)function. -
LOG10
TheLOG10(numeric)function. -
ABS
TheABS(numeric)function. -
ACOS
TheACOS(numeric)function. -
ASIN
TheASIN(numeric)function. -
ATAN
TheATAN(numeric)function. -
ATAN2
TheATAN2(numeric, numeric)function. -
CBRT
TheCBRT(numeric)function. -
COS
TheCOS(numeric)function. -
COT
TheCOT(numeric)function. -
DEGREES
TheDEGREES(numeric)function. -
EXP
TheEXP(numeric)function. -
RADIANS
TheRADIANS(numeric)function. -
ROUND
TheROUND(numeric [, integer])function. -
SIGN
TheSIGN(numeric)function. -
SIN
TheSIN(numeric)function. -
TAN
TheTAN(numeric)function. -
TRUNCATE
TheTRUNCATE(numeric [, integer])function. -
PI
ThePIfunction. -
TYPEOF
TheTYPEOFfunction. -
VARIANTNULL
TheVARIANTNULLfunction. -
FIRST
FIRSTfunction to be used withinMATCH_RECOGNIZE. -
LAST
LASTfunction to be used withinMATCH_RECOGNIZE. -
PREV
PREVfunction to be used withinMATCH_RECOGNIZE. -
NEXT
NEXTfunction to be used withinMATCH_RECOGNIZE. -
CLASSIFIER
CLASSIFIERfunction to be used withinMATCH_RECOGNIZE. -
MATCH_NUMBER
MATCH_NUMBERfunction to be used withinMATCH_RECOGNIZE. -
NULLIF
-
COALESCE
The COALESCE builtin function. -
FLOOR
TheFLOORfunction. -
CEIL
TheCEILfunction. -
USER
TheUSERfunction. -
CURRENT_USER
TheCURRENT_USERfunction. -
SESSION_USER
TheSESSION_USERfunction. -
SYSTEM_USER
TheSYSTEM_USERfunction. -
CURRENT_PATH
TheCURRENT_PATHfunction. -
CURRENT_ROLE
TheCURRENT_ROLEfunction. -
CURRENT_CATALOG
TheCURRENT_CATALOGfunction. -
CURRENT_SCHEMA
TheCURRENT_SCHEMAfunction. -
LOCALTIME
TheLOCALTIME [(precision)]function. -
LOCALTIMESTAMP
TheLOCALTIMESTAMP [(precision)]function. -
CURRENT_TIME
TheCURRENT_TIME [(precision)]function. -
CURRENT_TIMESTAMP
TheCURRENT_TIMESTAMP [(precision)]function. -
CURRENT_DATE
TheCURRENT_DATEfunction. -
TIMESTAMP_ADD
TheTIMESTAMPADDfunction. -
TIMESTAMP_DIFF
TheTIMESTAMPDIFFfunction. -
CAST
The SQLCASToperator.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, soCAST(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 expressionCAST(1 + 2 AS DOUBLE)will become a call toCASTwith the expression1 + 2as its only operand.The
RexCallform can also have a type which contains aNOT NULLconstraint. When this expression is implemented, if the value is NULL, an exception will be thrown. -
EXTRACT
The SQLEXTRACToperator. Extracts a specified field value from a DATETIME or an INTERVAL. E.g.
EXTRACT(HOUR FROM INTERVAL '364 23:59:59')returns23 -
YEAR
The SQLYEARoperator. Returns the Year from a DATETIME E.g.
YEAR(date '2008-9-23')returns2008 -
QUARTER
The SQLQUARTERoperator. Returns the Quarter from a DATETIME E.g.
QUARTER(date '2008-9-23')returns3 -
MONTH
The SQLMONTHoperator. Returns the Month from a DATETIME E.g.
MONTH(date '2008-9-23')returns9 -
WEEK
The SQLWEEKoperator. Returns the Week from a DATETIME E.g.
WEEK(date '2008-9-23')returns39 -
DAYOFYEAR
The SQLDAYOFYEARoperator. Returns the DOY from a DATETIME E.g.
DAYOFYEAR(date '2008-9-23')returns267 -
DAYOFMONTH
The SQLDAYOFMONTHoperator. Returns the Day from a DATETIME E.g.
DAYOFMONTH(date '2008-9-23')returns23 -
DAYOFWEEK
The SQLDAYOFWEEKoperator. Returns the DOW from a DATETIME E.g.
DAYOFWEEK(date '2008-9-23')returns2 -
HOUR
The SQLHOURoperator. Returns the Hour from a DATETIME E.g.
HOUR(timestamp '2008-9-23 01:23:45')returns1 -
MINUTE
The SQLMINUTEoperator. Returns the Minute from a DATETIME E.g.
MINUTE(timestamp '2008-9-23 01:23:45')returns23 -
SECOND
The SQLSECONDoperator. Returns the Second from a DATETIME E.g.
SECOND(timestamp '2008-9-23 01:23:45')returns45 -
LAST_DAY
TheLAST_DAY(date)function. -
ELEMENT
The ELEMENT operator, used to convert a multiset with only one item to a "regular" type. Example ... log(ELEMENT(MULTISET[1])) ... -
ITEM
The item operator[ ... ], used to access a given element of an array, map or struct. For example,myArray[3],"myMap['foo']",myStruct[2]ormyStruct['fieldName'].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
The ARRAY Value Constructor. e.g. "ARRAY[1, 2, 3]". -
MAP_VALUE_CONSTRUCTOR
The MAP Value Constructor, e.g. "MAP['washington', 1, 'obama', 44]". -
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 typeINTEGER MULTISETbut is translated to an expression of typeRECORD(INTEGER EXPR$0) MULTISETbecause in our internal representation of multisets, every element must be a record. Applying the "$SLICE" operator to this result converts the type back to anINTEGER MULTISETmultiset value.$SLICEis often translated away when the multiset type is converted back to scalar values. -
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
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. -
STRUCT_ACCESS
-
CARDINALITY
The CARDINALITY operator, used to retrieve the number of elements in a MULTISET, ARRAY or MAP. -
COLLECT
The COLLECT operator. Multiset aggregator function. -
PERCENTILE_CONT
PERCENTILE_CONTinverse distribution aggregate function.The argument must be a numeric literal in the range 0 to 1 inclusive (representing a percentage), and the return type is the type of the
ORDER BYexpression. -
PERCENTILE_DISC
PERCENTILE_DISCinverse distribution aggregate function.The argument must be a numeric literal in the range 0 to 1 inclusive (representing a percentage), and the return type is the type of the
ORDER BYexpression. -
LISTAGG
The LISTAGG operator. String aggregator function. -
FUSION
The FUSION operator. Multiset aggregator function. -
INTERSECTION
The INTERSECTION operator. Multiset aggregator function. -
NEXT_VALUE
The sequence next value function:NEXT VALUE FOR sequence. -
CURRENT_VALUE
The sequence current value function:CURRENT VALUE FOR sequence. -
TABLESAMPLE
TheTABLESAMPLEoperator.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
SqlSampleSpecwrapped in aSqlLiteral. -
DESCRIPTOR
DESCRIPTOR(column_name, ...). -
TUMBLE
TUMBLE as a table function. -
HOP
HOP as a table function. -
SESSION
SESSION as a table function. -
TUMBLE_OLD
TheTUMBLEgroup function.This operator is named "$TUMBLE" (not "TUMBLE") because it is created directly by the parser, not by looking up an operator by name.
Why did we add TUMBLE to the parser? Because we plan to support TUMBLE as a table function (see [CALCITE-3272]); "TUMBLE" as a name will only be used by the TUMBLE table function.
After the TUMBLE table function is introduced, we plan to deprecate this TUMBLE group function, and in fact all group functions. See [CALCITE-3340] for details.
-
TUMBLE_START
TheTUMBLE_STARTauxiliary function of theTUMBLEgroup function. -
TUMBLE_END
TheTUMBLE_ENDauxiliary function of theTUMBLEgroup function. -
HOP_OLD
TheHOPgroup function. -
HOP_START
TheHOP_STARTauxiliary function of theHOPgroup function. -
HOP_END
TheHOP_ENDauxiliary function of theHOPgroup function. -
SESSION_OLD
TheSESSIONgroup function. -
SESSION_START
TheSESSION_STARTauxiliary function of theSESSIONgroup function. -
SESSION_END
TheSESSION_ENDauxiliary function of theSESSIONgroup function. -
PATTERN_ALTER
|operator to create alternate patterns withinMATCH_RECOGNIZE.If
p1andp2are patterns thenp1 | p2is a pattern that matchesp1orp2. -
PATTERN_CONCAT
Operator to concatenate patterns withinMATCH_RECOGNIZE.If
p1andp2are patterns thenp1 p2is a pattern that matchesp1followed byp2. -
PATTERN_QUANTIFIER
Operator to quantify patterns withinMATCH_RECOGNIZE.If
pis a pattern thenp{3, 5}is a pattern that matches between 3 and 5 occurrences ofp. -
PATTERN_PERMUTE
PERMUTEoperator to combine patterns withinMATCH_RECOGNIZE.If
p1andp2are patterns thenPERMUTE (p1, p2)is a pattern that matches all permutations ofp1andp2. -
PATTERN_EXCLUDE
EXCLUDEoperator withinMATCH_RECOGNIZE.If
pis a pattern then{- p -}} is a pattern that excludespfrom the output. -
SET_SEMANTICS_TABLE
SetSemanticsTable represents as an input table with set semantics. -
operators
Contains all (name, operator) pairs. Effectively a sorted immutable multimap.There can be several operators with the same name (case-insensitive or case-sensitive) and these operators will lie in a contiguous range which we can find efficiently using binary search.
-
-
Constructor Details
-
SqlStdOperatorTable
public SqlStdOperatorTable()
-
-
Method Details
-
instance
Returns the standard operator table, creating it if necessary. -
lookUpOperators
Looks up operators, optionally matching case-sensitively. -
auxiliaryToGroup
Returns the group function for which a given kind is an auxiliary function, or null if it is not an auxiliary function. -
convertAuxiliaryToGroupCall
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))toTUMBLE(rowtime, INTERVAL '1' HOUR)). -
convertGroupToAuxiliaryCalls
@Deprecated public static List<Pair<SqlNode,AuxiliaryConverter>> convertGroupToAuxiliaryCalls(SqlCall call) Deprecated.Converts a call to a grouped window function to a call to its auxiliary window function(s). -
convertGroupToAuxiliaryCalls
public static void convertGroupToAuxiliaryCalls(SqlCall call, BiConsumer<SqlNode, AuxiliaryConverter> consumer) Converts a call to a grouped window function to a call to its auxiliary window function(s).For example, converts
TUMBLE_START(rowtime, INTERVAL '1' HOUR))toTUMBLE(rowtime, INTERVAL '1' HOUR)). -
some
Returns the operator forSOME comparisonKind. -
all
Returns the operator forALL comparisonKind. -
reverse
Deprecated.UseSqlOperator.reverse(), but beware that it has slightly different semanticsReturns the binary operator that corresponds to this operator but in the opposite direction. Or returns this, if its kind is not reversible.For example,
reverse(GREATER_THAN)returnsLESS_THAN. -
like
Returns the operator forLIKEwith given case-sensitivity, optionally negated. -
floorCeil
Returns the operator forFLOORandCEILwith given floor flag and library. -
getConvertFuncByConformance
Returns the operator for standardCONVERTand Oracle'sCONVERTwith the given library. -
getOperatorList
Description copied from interface:SqlOperatorTableRetrieves a list of all functions and operators in this table. Used for automated testing. Depending on the table type, may or may not be mutable.- Specified by:
getOperatorListin interfaceSqlOperatorTable- Returns:
- list of SqlOperator objects
-
setOperators
-
buildIndex
protected static com.google.common.collect.ImmutableMultimap<String,SqlOperator> buildIndex(Iterable<? extends SqlOperator> operators) Derives a value to be assigned tooperatorsfrom a given list of operators.
-
SqlOperator.reverse(), but beware that it has slightly different semantics