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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-46
SORT_PARTIAL_AGGR_ROOT Operator
This operator consists of a one-row aggregate without standard aggregate functions
(SUM, MIN, MAX, and so on). The leaf portion occurs in the executor portion of DAM.
The description field for this operator contains:
The example of the SORT_PARTIAL_AGGR_LEAF operator is based on:
SELECT CAST(SUM(l_extendedprice*l_discount) AS NUMERIC(18,2))
FROM $big18a.tpcd2x.lineitem
WHERE l_shipdate >= DATE '1994-01-01'
AND l_shipdate < DATE '1995-01-01'
AND l_discount BETWEEN .06 - 0.01 AND .06 + 0.01
AND l_quantity < 24;
1 . 2 sort_partial_aggr_leaf
aggregates:
sum((cast(indexcol(\TESTSYS.$BIG18A.TPCD2X.LX1.L_EXTENDEDPRICE))
* cast(indexcol(\TESTSYS.$BIG18A.TPCD2X.LX1.L_DISCOUNT))))
SORT_PARTIAL_AGGR_ROOT Operator
Groupby Group
The SORT_PARTIAL_AGGR_ROOT operator works together as a pair with the
SORT_PARTIAL_AGGR_LEAF operator. The SORT_PARTIAL_AGGR_ROOT
operator finalizes the group by at the ESP level. This operator consists of a one-row
aggregate without standard aggregate functions (SUM, MIN, MAX, and so on). The
root portion occurs in the root. The description field for this operator contains:
The example of the SORT_PARTIAL_AGGR_ROOT operator is based on:
SELECT CAST(SUM(l_extendedprice*l_discount) AS NUMERIC(18,2))
FROM $big18a.tpcd2x.lineitem
WHERE l_shipdate >= DATE '1994-01-01'
AND l_shipdate < DATE '1995-01-01'
AND l_discount BETWEEN .06 - 0.01 AND .06 + 0.01
AND l_quantity < 24;
4 . 5 sort_partial_aggr_root
aggregates:
sum(sum((cast(indexcol(\TESTSYS.$BIG18A.TPCD2X.LX1.L_EXTENDEDPRI
CE)) * cast(indexcol(\TESTSYS.$BIG18A.TPCD2X.LX1.L_DISCOUNT)))))
Token Followed by... Data Type
aggregates Expression of the
aggregate functions
expr(text)
Token Followed by... Data Type
aggregates Expression of the
aggregate functions
expr(text)