Description:
Sort a cluster cursor.
Syntax:
cs.sortx(x,…;n)
Note:
The function sorts cluster cursor cs by expression x and returns a cluster cursor.
Option:
|
@c |
Won’t merge result sets returned by the nodes but return a cluster cursor segmented in the same way |
Parameter:
|
cs |
A cluster cursor |
|
x |
An expression by which records in a specified cluster cursor are sorted in ascending order |
|
n
|
Number of buffer rows; if the number of groups reaches n, write the grouping result to a temporary file; its value will be n times of the default if it is less than 1; by default, esProc will auto-compute the value |
Return value:
A cluster cursor
Example:
|
|
A |
|
|
1 |
[192.168.0.110:8281,192.168.18.143:8281] |
|
|
2 |
=file("emp.ctx", A1) |
|
|
3 |
=A2.open() |
Open a cluster composite table file. |
|
4 |
=A3.cursor() |
Return a cluster cursor. |
|
5 |
=A4.sortx(EID) |
Sort A4’s cluster cursor by EID and return result also as a cluster cursor. |