Package org.apache.calcite.sql.fun

Class SqlGroupingFunction

java.lang.Object

org.apache.calcite.sql.SqlOperator

org.apache.calcite.sql.SqlFunction

org.apache.calcite.sql.SqlAggFunction

org.apache.calcite.sql.fun.SqlAbstractGroupFunction

org.apache.calcite.sql.fun.SqlGroupingFunction

All Implemented Interfaces:

Context, Wrapper

class SqlGroupingFunction
extends SqlAbstractGroupFunction

The GROUPING function.

Accepts 1 or more arguments. Example: GROUPING(deptno, gender) returns 3 if both deptno and gender are being grouped, 2 if only deptno is being grouped, 1 if only gender is being groped, 0 if neither deptno nor gender are being grouped.

This function is defined in the SQL standard. GROUPING_ID is a non-standard synonym.

Some examples are in agg.iq.

Field Summary

Fields inherited from class org.apache.calcite.sql.SqlOperator

kind, MDX_PRECEDENCE, NL

Constructor Summary

Constructors

Constructor	Description
SqlGroupingFunction(java.lang.String name)

Method Summary

Methods inherited from class org.apache.calcite.sql.fun.SqlAbstractGroupFunction

allowsFilter, isQuantifierAllowed, validateCall

Methods inherited from class org.apache.calcite.sql.SqlAggFunction

getParameterTypes, getReturnType, isAggregator, requiresGroupOrder, requiresOrder, requiresOver, unwrap

Methods inherited from class org.apache.calcite.sql.SqlFunction

deriveType, getFunctionType, getNameAsId, getParamNames, getParamTypes, getSqlIdentifier, getSyntax, unparse, validateQuantifier

Methods inherited from class org.apache.calcite.sql.SqlOperator

acceptCall, acceptCall, adjustType, allowsFraming, argumentMustBeScalar, checkOperandCount, checkOperandTypes, constructArgNameList, constructArgTypeList, constructOperandList, createCall, createCall, createCall, createCall, equals, getAllowedSignatures, getAllowedSignatures, getKind, getLeftPrec, getMonotonicity, getMonotonicity, getName, getOperandCountRange, getOperandTypeChecker, getOperandTypeInference, getReturnTypeInference, getRightPrec, getSignatureTemplate, hashCode, inferReturnType, inferReturnType, isDeterministic, isDynamicFunction, isGroup, isGroupAuxiliary, isName, leftPrec, preValidateCall, requiresDecimalExpansion, rewriteCall, rightPrec, toString, unparseListClause, unparseListClause, validateOperands, validRexOperands

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

SqlGroupingFunction

SqlGroupingFunction(java.lang.String name)