When dragging a SQL-MR function element into a Function Table, the following On Clause tree element is created.
Variable Creation > Input > Variables: SQL Elements pane - SQL-MapReduce Functions > On Clause
To view or set the properties of the On Clause, double-click on On Clause (Partition By), or highlight it and click Properties.
Variable Creation > Input > Variables: SQL Elements pane - SQL-MapReduce Functions > On Clause Properties
Select whether to apply PARTITION BY, PARTITION BY ANY, DIMENSION, HASH BY or Other to the selected table or function. Enter any attributes to partition by in the Partition By Attributes field, and enter any attributes to order by in the Order By List field. Enter an alias name for the On Clause in the On Clause Alias field, if desired.
Column names can be selected, dragged and dropped from the Columns list in the Variable Creation window to the Partition By Attributes field or Order By List field.