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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-7
ESP_EXCHANGE Operator
The ESP_EXCHANGE operator has one child node. The description field for this
operator contains:
The example of the ESP_EXCHANGE operator is based on:
SELECT supp_nation, cust_nation, yr, sum(volume) as revenue
FROM
(SELECT n1.n_name as supp_nation, n2.n_name as
cust_nation, extract(year from l_shipdate) as yr,
CAST(l_extendedprice*(1-l_discount) AS NUMERIC(18,2))
as volume
FROM supplier,lineitem,orders,customer, nation n1,
nation n2
WHERE s_suppkey = l_suppkey
AND o_orderkey = l_orderkey
AND c_custkey = o_custkey
AND s_nationkey = n1.n_nationkey
AND c_nationkey = n2.n_nationkey
AND ((n1.n_name = 'FRANCE' AND
n2.n_name = 'GERMANY')
OR (n1.n_name = 'GERMANY' AND
n2.n_name = 'FRANCE'))
AND l_shipdate BETWEEN DATE '1995-01-01'
AND DATE '1996-12-31') as shipping
Token Followed by ... Data Type
buffer_size Size of message buffer integer
record_length Number of bytes in the record
sent
integer
top_degree_parallelism Number of top ESPs integer
bottom_degree_parallelism Number of bottom ESPs integer
top_num_data_streams Number of top partitions integer
bottom_num__data_streams Number of bottom partitions integer
top_partitioning_function Summary partitioning
information for
top_partitioning_function
text
bottom_partitioning_function Details the type of partitioning
and contains summary
information about the parallel
plan
text
bottom_partition_input_values Internal values that identify the
part of the data the ESP will
work on
integer
partitioning_expression Expression used to partition
data
expr(text)
merged_order Expression describing sort
keys
expr(text)