Page Comparison

Field Type

Description

String

Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Required. List of paths to sort on.

Sort path

Default Value: None

Example: $person $person.first_name

String/Sugesstion

Required. Paths of values in the document to sort on.

Sort order

Default value: global

Example: ascending

Dropdown list

Required. Order of sorting. The available options are:

• global

• ascending

• descending

Dropdown list

Sort the specified values in ascending or descending order.

Checkbox

If selected, null is considered greater than non-null values, and null values will be placed last when sorted in the ascending order.

• If selected and Sort order is ascending, nulls appear at the end of the list.

• If selected and Sort order is descending, nulls appear at the beginning of the list.

• If not selected and Sort order is ascending, nulls appear at the beginning of the list.

• If not selected and Sort order is descending, nulls appear at the end of the list.

Please note that an empty string is not considered as null and always smaller than non-empty strings.

Checkbox

If selected, the Snap considers the values of non-existent or incorrect sort paths as null. If unselected, the Snap validates each input document to throw errors for non-existent or incorrect sort paths. Clearing this property will result in a lower performance.

Integer

Enter the percentage of maximum used memory compared to the maximum system memory. Sort Snap uses this property value to compute the size of the internal memory buffer for the external merge sort. The minimum buffer size is set to 100MB. If multiple instances of Sort Snap might be simultaneously being executed in the same Snaplex and the system memory size is limited, it is strongly advised to keep this property value low.

Dropdown list