Class SqlPivot
- All Implemented Interfaces:
Cloneable
Syntax:
SELECT *
FROM query PIVOT (agg, ... FOR axis, ... IN (in, ...)) AS alias
-
Field Summary
Fields inherited from class org.apache.calcite.sql.SqlNode
EMPTY_ARRAY, pos
-
Constructor Summary
ConstructorDescriptionSqlPivot
(SqlParserPos pos, SqlNode query, SqlNodeList aggList, SqlNodeList axisList, SqlNodeList inList) -
Method Summary
Modifier and TypeMethodDescriptionvoid
forEachAgg
(BiConsumer<@Nullable String, SqlNode> consumer) Returns the aggregate list as (alias, call) pairs.void
forEachNameValues
(BiConsumer<String, SqlNodeList> consumer) Returns the value list as (alias, node list) pairs.Returns the list of operands.void
setOperand
(int i, @Nullable SqlNode operand) Changes the value of an operand.void
Writes 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 theFOR
clause.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
-
Field Details
-
query
-
aggList
-
axisList
-
inList
-
-
Constructor Details
-
SqlPivot
public SqlPivot(SqlParserPos pos, SqlNode query, SqlNodeList aggList, SqlNodeList axisList, SqlNodeList inList)
-
-
Method Details
-
getOperator
- Specified by:
getOperator
in classSqlCall
-
getOperandList
Description copied from class:SqlCall
Returns 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.- Specified by:
getOperandList
in classSqlCall
- Returns:
- the list of call operands, never null, the operands can be null
-
setOperand
Description copied from class:SqlCall
Changes the value of an operand. Allows some rewrite bySqlValidator
; use sparingly.- Overrides:
setOperand
in classSqlCall
- Parameters:
i
- Operand indexoperand
- Operand value
-
unparse
Description copied from class:SqlNode
Writes a SQL representation of this node to a writer.The
leftPrec
andrightPrec
parameters 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.
If
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)
. -
forEachAgg
Returns the aggregate list as (alias, call) pairs. If there is no 'AS', alias is null. -
forEachNameValues
Returns the value list as (alias, node list) pairs. -
usedColumnNames
Returns the set of columns that are referenced as an argument to an aggregate function or in a column in theFOR
clause. All columns that are not used will become "GROUP BY" columns.
-