cs.sortx()

Read(148) Label: cluster cursor, sort,

Description:

Sort a cluster cursor.

Syntax:

cs.sortx(x,…;n)

 

Note:

The function sorts cluster cursor cs by expression x and returns a clustrer cursor.

Options:

@c

Won’t merge result sets returned by the nodes but return a cluster cursor segmented in the same way

Parameters:

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 uto-compute the value

Return value:

A cluster cursor

Example:

 

A

 

1

[192.168.0.110:8281,192.168.18.143:8281]

 

2

=file@0("emp.ctx", A1)

emp.ctx is a distributed composite table file

3

=A2.create()

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