- All Implemented Interfaces:
SELECT * FROM query PIVOT (agg, ... FOR axis, ... IN (in, ...)) AS alias
Field SummaryModifier and TypeFieldDescription
Method SummaryModifier and TypeMethodDescription
voidReturns the aggregate list as (alias, call) pairs.
voidReturns the value list as (alias, node list) pairs.Returns the list of operands.
voidChanges the value of an operand.
voidWrites a SQL representation of this node to a writer.Returns the set of columns that are referenced as an argument to an aggregate function or in a column in the
Methods inherited from class org.apache.calcite.sql.SqlCall
accept, clone, equalsDeep, findValidOptions, getCallSignature, getFunctionQuantifier, getKind, getMonotonicity, isCountStar, isExpanded, operand, operandCount, validate
Methods inherited from class org.apache.calcite.sql.SqlNode
clone, clone, cloneArray, equalDeep, equalDeep, equalsDeep, getParserPosition, isA, toList, toList, toSqlString, toSqlString, toSqlString, toString, unparseWithParentheses, validateExpr
getOperatorpublic SqlOperator getOperator()
getOperandListDescription copied from class:
SqlCallReturns the list of operands. The set and order of operands is call-specific.
Note: the proper type would be
List<@Nullable SqlNode>, however, it would trigger too many changes to the current codebase.
setOperandpublic void setOperand
(int i, @Nullable SqlNode operand)Description copied from class:
SqlCallChanges the value of an operand. Allows some rewrite by
SqlValidator; use sparingly.
unparsepublic void unparse
(SqlWriter writer, int leftPrec, int rightPrec)Description copied from class:
SqlNodeWrites a SQL representation of this node to a writer.
rightPrecparameters give us enough context to decide whether we need to enclose the expression in parentheses. For example, we need parentheses around "2 + 3" if preceded by "5 *". This is because the precedence of the "*" operator is greater than the precedence of the "+" operator.
The algorithm handles left- and right-associative operators by giving them slightly different left- and right-precedence.
SqlWriter.isAlwaysUseParentheses()is true, we use parentheses even when they are not required by the precedence rules.
For the details of this algorithm, see
SqlCall.unparse(org.apache.calcite.sql.SqlWriter, int, int).
forEachAggReturns the aggregate list as (alias, call) pairs. If there is no 'AS', alias is null.
forEachNameValuesReturns the value list as (alias, node list) pairs.
usedColumnNamesReturns the set of columns that are referenced as an argument to an aggregate function or in a column in the
FORclause. All columns that are not used will become "GROUP BY" columns.