class SqlGroupingFunction extends SqlAbstractGroupFunction
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
.
kind, MDX_PRECEDENCE, NL
Constructor and Description |
---|
SqlGroupingFunction(java.lang.String name) |
allowsFilter, isQuantifierAllowed, validateCall
allowsNullTreatment, getParameterTypes, getReturnType, isAggregator, requiresGroupOrder, requiresOrder, requiresOver, unwrap
deriveType, getFunctionType, getNameAsId, getParamNames, getParamTypes, getSqlIdentifier, getSyntax, unparse, validateQuantifier
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
Copyright © 2012–2019 The Apache Software Foundation. All rights reserved.