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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-14
HASH_PARTIAL_GROUPBY_ROOT Operator
The HASH_PARTIAL_GROUPBY_LEAF operator has one child node. The description
field for this operator contains:
The example of the HASH_PARTIAL_GROUPBY_LEAF operator is based on:
SELECT a.ten, MAX(a.unique2)
FROM $big18a.wisc32m.abase a, $big18a.wisc32m.bbase b
WHERE a.unique2=b.unique3 AND a.onepercent = 90
GROUP BY a.ten;
? 7 . 8 hash_partial_groupby_leaf
grouping_columns: indexcol(\TESTSYS.$BIG18A.WISC32M.ABASE.TEN)
aggregates:
max(indexcol(\TESTSYS.$BIG18A.WISC32M.ABASE.UNIQUE2))
HASH_PARTIAL_GROUPBY_ROOT Operator
Groupby Group
The HASH_PARTIAL_GROUPBY_ROOT operator works together as a pair with the
HASH_PARTIAL_GROUPBY_LEAF operator. The
HASH_PARTIAL_GROUPBY_ROOT operator finalizes the group by at the ESP level.
See HASH_PARTIAL_GROUPBY_LEAF Operator on page 7-13.
The HASH_PARTIAL_GROUPBY_ROOT operator has one child node. The
description field for this operator contains:
The example of the HASH_PARTIAL_GROUPBY_ROOT operator is based on:
SELECT a.ten, MAX(a.unique2)
FROM $big18a.wisc32m.abase a, $big18a.wisc32m.bbase b
Token Followed by ... Data Type
aggregates Expression of the aggregate
functions
expr(text)
selection_predicates Expression of the having
clause
expr(text)
grouping_columns Expression of the grouping
columns
expr(text)
Token Followed by ... Data Type
aggregates Expression of the aggregate
functions
expr(text)
selection_predicates Expression of the having
clause
expr(text)
grouping_columns Expression of the grouping
columns
expr(text)