Can I have a PartitionFunction that's invoked on all rows, cluster-wide? - Aster Execution Engine

Teradata Aster® Developer Guide

Product
Aster Execution Engine
Release Number
7.00.02
Published
July 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
xnl1494366523182.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
ffu1489104705746
lifecycle
previous
Product Category
Software

Yes, you can PARTITION BY constant to place all rows on a single worker.

SELECT * FROM EXACT_MEDIAN(ON source_data PARTITION BY 1);

Be careful when using this technique. The source data specified in the ON clause must fit on a single node. Nevertheless, this formulation can be useful when a RowFunction computes per-worker summaries that are then merged into a final result.