When dragging a SQL-MR function element into a Function Table, the following On Clause tree element is created.
To view or set the properties of the On Clause, double-click on On Clause (Partition By), or highlight it and click 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.