Sets the ordering specification for a specified input stream.
Syntax
tdr.SetLocalOrderByDef( streamno, lorderbydef )
Syntax Elements
- streamno
- Parameter type: integer
The input stream number.
- lorderbydef
- Parameter type: listA list of vectors with the following:
- Column names
- Ordering of the columns
- NULLS FIRST/NULLS LAST indicators
Usage Notes
This function is valid only if called from the contract function.
The function must run on a PE-only node.
An error is raised in the following situations:
- The function is called from the table operator.
- The LOCAL ORDER BY metadata was already set.
Example: Set the LOCAL ORDER BY Specification for an Input Stream
The following statement sets the LOCAL ORDER BY specification for input stream 0 to be col1 ASC NULLS FIRST, col3 DESC NULLS LAST.
lorderbydef <- list(c("col1","A","NF"),c("col2","D","NL"))
tdr.SetLocalOrderByDef(0, lorderbydef );