Uses of Class
org.apache.calcite.sql.SqlFunction
-
Packages that use SqlFunction Package Description org.apache.calcite.rel.metadata Defines metadata interfaces and utilities for relational expressions.org.apache.calcite.rel.rules Provides a core set of planner rules.org.apache.calcite.schema.impl Utilities to help implement Calcite's SPIs.org.apache.calcite.sql Provides a SQL parser and object model.org.apache.calcite.sql.dialect SQL unparsers for JDBC dialects.org.apache.calcite.sql.fun Defines the set of standard SQL row-level functions and operators.org.apache.calcite.sql.validate SQL validation.org.apache.calcite.sql2rel Translates a SQL parse tree to relational expression. -
-
Uses of SqlFunction in org.apache.calcite.rel.metadata
Fields in org.apache.calcite.rel.metadata declared as SqlFunction Modifier and Type Field Description static SqlFunction
RelMdUtil. ARTIFICIAL_SELECTIVITY_FUNC
-
Uses of SqlFunction in org.apache.calcite.rel.rules
Methods in org.apache.calcite.rel.rules that return SqlFunction Modifier and Type Method Description protected SqlFunction
AbstractMaterializedViewRule.MaterializedViewAggregateRule. getCeilSqlFunction(org.apache.calcite.avatica.util.TimeUnitRange flag)
Get ceil function datetime.protected SqlFunction
AbstractMaterializedViewRule.MaterializedViewAggregateRule. getFloorSqlFunction(org.apache.calcite.avatica.util.TimeUnitRange flag)
Get floor function datetime. -
Uses of SqlFunction in org.apache.calcite.schema.impl
Methods in org.apache.calcite.schema.impl with parameters of type SqlFunction Modifier and Type Method Description RexNode
ModifiableViewTable.ModifiableViewTableInitializerExpressionFactory. newAttributeInitializer(RelDataType type, SqlFunction constructor, int iAttribute, java.util.List<RexNode> constructorArgs, InitializerContext context)
-
Uses of SqlFunction in org.apache.calcite.sql
Subclasses of SqlFunction in org.apache.calcite.sql Modifier and Type Class Description class
SqlAggFunction
Abstract base class for the definition of an aggregate function: an operator which aggregates sets of values into a result.class
SqlGroupedWindowFunction
SQL function that computes keys by which rows can be partitioned and aggregated.class
SqlJdbcFunctionCall
ASqlJdbcFunctionCall
is a node of a parse tree which represents a JDBC function call.class
SqlRankFunction
Operator which aggregates sets of values into a result.class
SqlUnresolvedFunction
Placeholder for an unresolved function.Method parameters in org.apache.calcite.sql with type arguments of type SqlFunction Modifier and Type Method Description private static RelDataType
SqlUtil. bestMatch(java.util.List<SqlFunction> sqlFunctions, int i, RelDataTypePrecedenceList precList)
-
Uses of SqlFunction in org.apache.calcite.sql.dialect
Fields in org.apache.calcite.sql.dialect declared as SqlFunction Modifier and Type Field Description static SqlFunction
MysqlSqlDialect. ISNULL_FUNCTION
MySQL specific function.private static SqlFunction
MssqlSqlDialect. MSSQL_SUBSTRING
-
Uses of SqlFunction in org.apache.calcite.sql.fun
Subclasses of SqlFunction in org.apache.calcite.sql.fun Modifier and Type Class Description class
SqlAbstractGroupFunction
Base class for grouping functionsGROUP_ID
,GROUPING_ID
,GROUPING
.class
SqlAbstractTimeFunction
Base class for time functions such as "LOCALTIME", "LOCALTIME(n)".class
SqlAnyValueAggFunction
Definition of theANY_VALUE
aggregate functions, returning any one of the values which go into it.class
SqlAvgAggFunction
Avg
is an aggregator which returns the average of the values which go into it.class
SqlBaseContextVariable
Base class for functions such as "PI", "USER", "CURRENT_ROLE", and "CURRENT_PATH".class
SqlCastFunction
SqlCastFunction.class
SqlCoalesceFunction
TheCOALESCE
function.class
SqlConvertFunction
Common base for theCONVERT
andTRANSLATE
functions.class
SqlCountAggFunction
Definition of the SQLCOUNT
aggregation function.class
SqlCovarAggFunction
Covar
is an aggregator which returns the Covariance of the values which go into it.class
SqlCurrentDateFunction
TheCURRENT_DATE
function.class
SqlDatePartFunction
SqlDatePartFunction represents the SQL:1999 standardYEAR
,QUARTER
,MONTH
andDAY
functions.class
SqlExtractFunction
The SQLEXTRACT
operator.class
SqlFirstLastValueAggFunction
FIRST_VALUE
andLAST_VALUE
aggregate functions return the first or the last value in a list of values that are input to the function.class
SqlFloorFunction
Definition of the "FLOOR" and "CEIL" built-in SQL functions.(package private) class
SqlGroupIdFunction
TheGROUP_ID()
function.(package private) class
SqlGroupingFunction
TheGROUPING
function.(package private) class
SqlGroupingIdFunction
Deprecated.Now thatGROUPING
has the same functionality, this function is deprecated.class
SqlHistogramAggFunction
HISTOGRAM
is the base operator that supports the Histogram MIN/MAX aggregate functions.class
SqlJsonArrayAggAggFunction
TheJSON_OBJECTAGG
aggregate function.class
SqlJsonArrayFunction
TheJSON_ARRAY
function.class
SqlJsonExistsFunction
TheJSON_EXISTS
function.class
SqlJsonObjectAggAggFunction
TheJSON_OBJECTAGG
aggregate function.class
SqlJsonObjectFunction
TheJSON_OBJECT
function.class
SqlJsonQueryFunction
TheJSON_QUERY
function.class
SqlJsonValueFunction
TheJSON_VALUE
function.class
SqlLeadLagAggFunction
LEAD
andLAG
aggregate functions return the value of given expression evaluated at given offset.class
SqlMinMaxAggFunction
Definition of theMIN
andMAX
aggregate functions, returning the returns the smallest/largest of the values which go into it.class
SqlMonotonicUnaryFunction
Base class for unary operators such as FLOOR/CEIL which are monotonic for monotonic inputs.class
SqlNthValueAggFunction
NTH_VALUE
windowed aggregate function returns the value of an expression evaluated at then
th row of the window frame.class
SqlNtileAggFunction
NTILE
aggregate function return the value of given expression evaluated at given offset.class
SqlNullifFunction
TheNULLIF
function.class
SqlOverlayFunction
TheOVERLAY
function.class
SqlPositionFunction
ThePOSITION
function.class
SqlRandFunction
TheRAND
function.class
SqlRandIntegerFunction
TheRAND_INTEGER
function.class
SqlRegrCountAggFunction
Definition of the SQLREGR_COUNT
aggregation function.class
SqlSingleValueAggFunction
SINGLE_VALUE
aggregate function returns the input value if there is only one value in the input; Otherwise it triggers a run-time error.class
SqlStringContextVariable
Base class for string functions such as "USER", "CURRENT_ROLE", and "CURRENT_PATH".class
SqlSubstringFunction
Definition of the "SUBSTRING" builtin SQL function.class
SqlSumAggFunction
Sum
is an aggregator which returns the sum of the values which go into it.class
SqlSumEmptyIsZeroAggFunction
Sum0
is an aggregator which returns the sum of the values which go into it likeSum
.class
SqlTimestampAddFunction
TheTIMESTAMPADD
function, which adds an interval to a datetime (TIMESTAMP, TIME or DATE).(package private) class
SqlTimestampDiffFunction
TheTIMESTAMPDIFF
function, which calculates the difference between two timestamps.class
SqlTranslate3Function
Definition of the "TRANSLATE" built-in SQL function that takes 3 arguments.class
SqlTrimFunction
Definition of the "TRIM" builtin SQL function.Fields in org.apache.calcite.sql.fun declared as SqlFunction Modifier and Type Field Description static SqlFunction
SqlStdOperatorTable. ABS
static SqlFunction
SqlStdOperatorTable. ACOS
static SqlFunction
SqlStdOperatorTable. ASIN
static SqlFunction
SqlStdOperatorTable. ATAN
static SqlFunction
SqlStdOperatorTable. ATAN2
static SqlFunction
SqlStdOperatorTable. CARDINALITY
The CARDINALITY operator, used to retrieve the number of elements in a MULTISET, ARRAY or MAP.static SqlFunction
SqlStdOperatorTable. CAST
The SQLCAST
operator.static SqlFunction
SqlStdOperatorTable. CEIL
TheCEIL
function.static SqlFunction
SqlStdOperatorTable. CHAR_LENGTH
static SqlFunction
SqlStdOperatorTable. CHARACTER_LENGTH
static SqlFunction
SqlStdOperatorTable. CLASSIFIER
CLASSIFIER
function to be used withinMATCH_RECOGNIZE
.static SqlFunction
SqlStdOperatorTable. COALESCE
The COALESCE builtin function.static SqlFunction
SqlStdOperatorTable. CONVERT
static SqlFunction
SqlStdOperatorTable. COS
static SqlFunction
SqlStdOperatorTable. COT
static SqlFunction
SqlStdOperatorTable. CURRENT_CATALOG
TheCURRENT_CATALOG
function.static SqlFunction
SqlStdOperatorTable. CURRENT_DATE
TheCURRENT_DATE
function.static SqlFunction
SqlStdOperatorTable. CURRENT_PATH
TheCURRENT_PATH
function.static SqlFunction
SqlStdOperatorTable. CURRENT_ROLE
TheCURRENT_ROLE
function.static SqlFunction
SqlStdOperatorTable. CURRENT_SCHEMA
TheCURRENT_SCHEMA
function.static SqlFunction
SqlStdOperatorTable. CURRENT_TIME
TheCURRENT_TIME [(precision)]
function.static SqlFunction
SqlStdOperatorTable. CURRENT_TIMESTAMP
TheCURRENT_TIMESTAMP [(precision)]
function.static SqlFunction
SqlStdOperatorTable. CURRENT_USER
TheCURRENT_USER
function.static SqlFunction
OracleSqlOperatorTable. DECODE
The "DECODE(v, v1, result1, [v2, result2, ...], resultN)" function.static SqlFunction
SqlStdOperatorTable. DEGREES
static SqlFunction
SqlStdOperatorTable. ELEMENT
The ELEMENT operator, used to convert a multiset with only one item to a "regular" type.static SqlFunction
SqlStdOperatorTable. EXP
static SqlFunction
SqlStdOperatorTable. EXTRACT
The SQLEXTRACT
operator.static SqlFunction
SqlStdOperatorTable. FIRST
FIRST
function to be used withinMATCH_RECOGNIZE
.static SqlFunction
SqlStdOperatorTable. FLOOR
TheFLOOR
function.static SqlFunction
OracleSqlOperatorTable. GREATEST
The "GREATEST(value, value)" function.static SqlFunction
SqlStdOperatorTable. HISTOGRAM_FIRST_VALUE
HISTOGRAM_FIRST_VALUE
window aggregate function.static SqlFunction
SqlStdOperatorTable. HISTOGRAM_LAST_VALUE
HISTOGRAM_LAST_VALUE
window aggregate function.static SqlFunction
SqlStdOperatorTable. HISTOGRAM_MAX
HISTOGRAM_MAX
window aggregate function.static SqlFunction
SqlStdOperatorTable. HISTOGRAM_MIN
HISTOGRAM_MIN
window aggregate function.static SqlFunction
SqlStdOperatorTable. IN_FENNEL
Use of theIN_FENNEL
operator forces the argument to be evaluated in Fennel.static SqlFunction
SqlStdOperatorTable. INITCAP
static SqlFunction
SqlStdOperatorTable. JSON_ARRAY
static SqlFunction
SqlStdOperatorTable. JSON_EXISTS
static SqlFunction
SqlStdOperatorTable. JSON_OBJECT
static SqlFunction
SqlStdOperatorTable. JSON_QUERY
static SqlFunction
SqlStdOperatorTable. JSON_VALUE
static SqlFunction
SqlStdOperatorTable. JSON_VALUE_ANY
static SqlFunction
SqlStdOperatorTable. LAST
LAST
function to be used withinMATCH_RECOGNIZE
.static SqlFunction
OracleSqlOperatorTable. LEAST
The "LEAST(value, value)" function.static SqlFunction
SqlStdOperatorTable. LN
static SqlFunction
SqlStdOperatorTable. LOCALTIME
TheLOCALTIME [(precision)]
function.static SqlFunction
SqlStdOperatorTable. LOCALTIMESTAMP
TheLOCALTIMESTAMP [(precision)]
function.static SqlFunction
SqlStdOperatorTable. LOG10
static SqlFunction
SqlStdOperatorTable. LOWER
static SqlFunction
OracleSqlOperatorTable. LTRIM
The "LTRIM(string)" function.static SqlFunction
SqlStdOperatorTable. MATCH_NUMBER
MATCH_NUMBER
function to be used withinMATCH_RECOGNIZE
.static SqlFunction
SqlStdOperatorTable. MOD
Arithmetic remainder functionMOD
.static SqlFunction
SqlStdOperatorTable. NEXT
NEXT
function to be used withinMATCH_RECOGNIZE
.static SqlFunction
SqlStdOperatorTable. NULLIF
static SqlFunction
OracleSqlOperatorTable. NVL
The "NVL(value, value)" function.static SqlFunction
SqlStdOperatorTable. OVERLAY
static SqlFunction
SqlStdOperatorTable. PI
static SqlFunction
SqlStdOperatorTable. POSITION
static SqlFunction
SqlStdOperatorTable. 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 SqlFunction
SqlStdOperatorTable. PREV
PREV
function to be used withinMATCH_RECOGNIZE
.static SqlFunction
SqlStdOperatorTable. RADIANS
static SqlFunction
SqlStdOperatorTable. REPLACE
TheREPLACE(string, search, replace)
function.static SqlFunction
SqlStdOperatorTable. ROUND
static SqlFunction
OracleSqlOperatorTable. RTRIM
The "RTRIM(string)" function.static SqlFunction
SqlStdOperatorTable. SESSION_USER
TheSESSION_USER
function.static SqlFunction
SqlStdOperatorTable. SIGN
static SqlFunction
SqlStdOperatorTable. SIN
static SqlFunction
SqlStdOperatorTable. SQRT
static SqlFunction
OracleSqlOperatorTable. SUBSTR
Oracle's "SUBSTR(string, position [, substringLength ])" function.static SqlFunction
SqlStdOperatorTable. SUBSTRING
The character substring function:SUBSTRING(string FROM start [FOR length])
.static SqlFunction
SqlStdOperatorTable. SYSTEM_USER
TheSYSTEM_USER
function.static SqlFunction
SqlStdOperatorTable. TAN
static SqlFunction
SqlStdOperatorTable. TIMESTAMP_ADD
TheTIMESTAMPADD
function.static SqlFunction
SqlStdOperatorTable. TIMESTAMP_DIFF
TheTIMESTAMPDIFF
function.static SqlFunction
SqlStdOperatorTable. TRANSLATE
TheTRANSLATE(char_value USING translation_name)
function alters the character set of a string value from one base character set to another.static SqlFunction
OracleSqlOperatorTable. TRANSLATE3
TheTRANSLATE(string_expr, search_chars, replacement_chars)
function returns string_expr with all occurrences of each character in search_chars replaced by its corresponding character in replacement_chars.static SqlFunction
SqlStdOperatorTable. TRIM
The "TRIM" function.static SqlFunction
SqlStdOperatorTable. TRUNCATE
static SqlFunction
SqlStdOperatorTable. UPPER
static SqlFunction
SqlStdOperatorTable. USER
TheUSER
function. -
Uses of SqlFunction in org.apache.calcite.sql.validate
Subclasses of SqlFunction in org.apache.calcite.sql.validate Modifier and Type Class Description class
SqlUserDefinedAggFunction
User-defined aggregate function.class
SqlUserDefinedFunction
User-defined scalar function.class
SqlUserDefinedTableFunction
User-defined table function.class
SqlUserDefinedTableMacro
User-defined table macro.Methods in org.apache.calcite.sql.validate with parameters of type SqlFunction Modifier and Type Method Description RelDataType
SqlValidator. deriveConstructorType(SqlValidatorScope scope, SqlCall call, SqlFunction unresolvedConstructor, SqlFunction resolvedConstructor, java.util.List<RelDataType> argTypes)
Derives the type of a constructor.RelDataType
SqlValidatorImpl. deriveConstructorType(SqlValidatorScope scope, SqlCall call, SqlFunction unresolvedConstructor, SqlFunction resolvedConstructor, java.util.List<RelDataType> argTypes)
CalciteException
SqlValidator. handleUnresolvedFunction(SqlCall call, SqlFunction unresolvedFunction, java.util.List<RelDataType> argTypes, java.util.List<java.lang.String> argNames)
Handles a call to a function which cannot be resolved.CalciteException
SqlValidatorImpl. handleUnresolvedFunction(SqlCall call, SqlFunction unresolvedFunction, java.util.List<RelDataType> argTypes, java.util.List<java.lang.String> argNames)
void
SqlValidator. validateColumnListParams(SqlFunction function, java.util.List<RelDataType> argTypes, java.util.List<SqlNode> operands)
Validates a COLUMN_LIST parametervoid
SqlValidatorImpl. validateColumnListParams(SqlFunction function, java.util.List<RelDataType> argTypes, java.util.List<SqlNode> operands)
-
Uses of SqlFunction in org.apache.calcite.sql2rel
Fields in org.apache.calcite.sql2rel declared as SqlFunction Modifier and Type Field Description private SqlFunction
AuxiliaryConverter.Impl. f
Methods in org.apache.calcite.sql2rel that return SqlFunction Modifier and Type Method Description (package private) SqlFunction
SqlToRelConverter.HistogramShuttle. getHistogramOp(SqlAggFunction aggFunction)
Returns the histogram operator corresponding to a given aggregate function.Methods in org.apache.calcite.sql2rel with parameters of type SqlFunction Modifier and Type Method Description RexNode
StandardConvertletTable. convertFunction(SqlRexContext cx, SqlFunction fun, SqlCall call)
private static RexNode
StandardConvertletTable. makeConstructorCall(SqlRexContext cx, SqlFunction constructor, java.util.List<RexNode> exprs)
RexNode
InitializerExpressionFactory. newAttributeInitializer(RelDataType type, SqlFunction constructor, int iAttribute, java.util.List<RexNode> constructorArgs, InitializerContext context)
Creates an expression which evaluates to the initializer expression for a particular attribute of a structured type.RexNode
NullInitializerExpressionFactory. newAttributeInitializer(RelDataType type, SqlFunction constructor, int iAttribute, java.util.List<RexNode> constructorArgs, InitializerContext context)
Constructors in org.apache.calcite.sql2rel with parameters of type SqlFunction Constructor Description Impl(SqlFunction f)
-