SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-52
TRANSPOSE Operator
TRANSPOSE Operator
Data Mining Group
The TRANSPOSE operator occurs as a result of a TRANSPOSE clause.
The TRANSPOSE operator has one child. The description field for this operator
contains:
For more information about data mining, see the SQL/MX Data Mining Guide.
The example of the TRANSPOSE operator is based on:
INSERT INTO test1
SELECT x1, x1/2, x1/4, x1/8 FROM t TRANSPOSE
0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14,
15 as x1;
211862648363811363 3 TRANSPOSE
2 ?
1.5999999E+003 3.0645998E-003 2.0646531E-002
CPU_TIME: 0.009267 IO_TIME: 0.020647 MSG_TIME: 0
IDLETIME: 0 PROBES: 1
transpose_union_vector: ValueIdUnion(0, 1, 2, 3, 4, 5, 6, 7, 8,
9, 10, 11, 12, 13, 14, 15)
TUPLE_FLOW Operator
Join Group
The TUPLE_FLOW operator describes a portion of an execution plan that involves a
nested join. This operator enables data to flow from one child to the other.
The TUPLE_FLOW operator has two child nodes. The description field for this operator
contains:
Token Followed by... Data Type
transpose_union_vector Represents a transpose
set of the transpose
clause. If multiple
transpose sets, then
multiple instances of the
token.
ItemExpr
tree
Token Followed by ... Data Type
join_type Inner, left, natural, inner
semi, or inner anti-semi-join
text
join_method Name of join method text